Table eprints_cchange.eprints_cchange.document Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
docid int 10
rev_number int 10  √  null
eprintid int 10  √  null
eprint.eprintid Defined in XML R
pos int 10  √  null
format varchar 255  √  null
formatdesc varchar 255  √  null
language varchar 255  √  null
security varchar 255  √  null
license varchar 255  √  null
main varchar 255  √  null
date_embargo_year smallint 5  √  null
date_embargo_month smallint 5  √  null
date_embargo_day smallint 5  √  null
content varchar 255  √  null
category varchar 255  √  null
placement int 10  √  null

Table contained 22,380 rows at Wed Apr 20 16:58 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
docid Primary key Asc PRIMARY
date_embargo_year + date_embargo_month + date_embargo_day Performance Asc/Asc/Asc date_embargo_year
category Performance Asc document_category
content Performance Asc document_content
placement Performance Asc document_placement_1
eprintid Performance Asc eprintid
format Performance Asc format
language Performance Asc language
license Performance Asc license
main Performance Asc main
pos Performance Asc pos
rev_number Performance Asc rev_number
security Performance Asc security

Close relationships  within of separation: