Records of Early English Drama (REED)
Centre for Research in Early English Drama


drummer and dog

Records of Early English Drama Online
Preliminary Database Schema

Will Kemp

TABLE: DOCCODES
code varchar(8) primary key
description varchar(255)  
repository varchar(255)  
loccode varchar(12) key
location varchar(45)  
sortorder varchar(45) primary key
id int(10) primary key
TABLE: FOOTNOTES
id int(11) primary key
fnum varchar(5)  
fnote longtext key
rawtext longtext  
TABLE: NOTES
id int(11) primary key
nid varchar(8) key
num varchar(5) key
recordid int(8) key
note longtext  
rawtext longtext  
type varchar(15)  
TABLE: REED2
id int(8) primary key
paranum int(11)  
text longtext  
rawtext longtext  
docdate varchar(255)  
description varchar(255)  
repository varchar(255)  
foliation varchar(255)  
edsubhead longtext  
sourcetype varchar(255)  
volume varchar(255)  
volnum tinyint(4)  
editor varchar(255)  
doctype varchar(255)  
section varchar(255)  
docname varchar(255)  
docpage varchar(255)  
TABLE: STRUCTURE
id int(10) primary key
type varchar(255)  
name varchar(255)  
description varchar(255)  
xml varchar(255)  
runninghead varchar(255)  
extras varchar(255)  

 

BACK TO REED ONLINE DOWNLOADS

BACK TO REED HOME PAGE


These pages created and maintained by Abigail Ann Young and Gord Oxley. Original text and images copyright (C) Records of Early English Drama, 1995, 2004.

Valid HTML 4.01!