 |
Records of Early English Drama Online
Preliminary Database Schema
|
 |
|
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) |
|
|