Table eprints_cchange.eprints_cchange.eprint_mmc_yr 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
eprintid int 10
eprint.eprintid Defined in XML R
pos int 10 0
mmc_yr_year smallint 5  √  null
mmc_yr_month smallint 5  √  null
mmc_yr_day smallint 5  √  null

Table contained 5,691 rows at Wed Apr 20 16:58 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
eprintid + pos Primary key Asc/Asc PRIMARY
mmc_yr_year + mmc_yr_month + mmc_yr_day Performance Asc/Asc/Asc mmc_yr_year
pos Performance Asc pos

Close relationships  within of separation: