Table eprints_cchange.eprints_cchange.eprint 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
document.eprintid Defined in XML R
eprint_mmc_conp.eprintid Defined in XML R
eprint_mmc_cp.eprintid Defined in XML R
eprint_mmc_form_research_links_desc.eprintid Defined in XML R
eprint_mmc_form_research_links_href.eprintid Defined in XML R
eprint_mmc_kwm.eprintid Defined in XML R
eprint_mmc_la.eprintid Defined in XML R
eprint_mmc_mf.eprintid Defined in XML R
eprint_mmc_pretesting_links_desc.eprintid Defined in XML R
eprint_mmc_pretesting_links_href.eprintid Defined in XML R
eprint_mmc_prod.eprintid Defined in XML R
eprint_mmc_produceremail.eprintid Defined in XML R
eprint_mmc_summative_eval_links_desc.eprintid Defined in XML R
eprint_mmc_summative_eval_links_href.eprintid Defined in XML R
eprint_mmc_tgt.eprintid Defined in XML R
eprint_mmc_videoaudio_desc.eprintid Defined in XML R
eprint_mmc_videoaudio_href.eprintid Defined in XML R
eprint_mmc_website.eprintid Defined in XML R
eprint_mmc_yr.eprintid Defined in XML R
rev_number int 10  √  null
eprint_status varchar 255  √  null
userid int 10  √  null
user.userid Implied Constraint R
dir varchar 255  √  null
datestamp_year smallint 5  √  null
datestamp_month smallint 5  √  null
datestamp_day smallint 5  √  null
datestamp_hour smallint 5  √  null
datestamp_minute smallint 5  √  null
datestamp_second smallint 5  √  null
lastmod_year smallint 5  √  null
lastmod_month smallint 5  √  null
lastmod_day smallint 5  √  null
lastmod_hour smallint 5  √  null
lastmod_minute smallint 5  √  null
lastmod_second smallint 5  √  null
status_changed_year smallint 5  √  null
status_changed_month smallint 5  √  null
status_changed_day smallint 5  √  null
status_changed_hour smallint 5  √  null
status_changed_minute smallint 5  √  null
status_changed_second smallint 5  √  null
type varchar 255  √  null
succeeds int 10  √  null
commentary int 10  √  null
replacedby int 10  √  null
metadata_visibility varchar 255  √  null
contact_email varchar 255  √  null
fileinfo mediumtext 16777215  √  null
latitude float 12  √  null
longitude float 12  √  null
title mediumtext 16777215  √  null
abstract mediumtext 16777215  √  null
full_text_status varchar 255  √  null
mmc_to mediumtext 16777215  √  null
mmc_conp_name varchar 255  √  null
mmc_adp varchar 255  √  null
mmc_ctyp varchar 255  √  null
mmc_stp varchar 255  √  null
mmc_zipp varchar 255  √  null
mmc_cnp varchar 255  √  null
mmc_php varchar 255  √  null
mmc_faxp varchar 255  √  null
mmc_ed varchar 255  √  null
mmc_pd mediumtext 16777215  √  null
mmc_cat varchar 255  √  null
mmc_cost varchar 255  √  null
mmc_nt mediumtext 16777215  √  null
mmc_sn mediumtext 16777215  √  null
mmc_lo varchar 255  √  null
mmc_dist varchar 255  √  null
mmc_cond varchar 255  √  null
mmc_add varchar 255  √  null
mmc_ctyd varchar 255  √  null
mmc_std varchar 255  √  null
mmc_zipd varchar 255  √  null
mmc_cnd varchar 255  √  null
mmc_phd varchar 255  √  null
mmc_faxd varchar 255  √  null
mmc_em_year smallint 5  √  null
mmc_em_month smallint 5  √  null
mmc_em_day smallint 5  √  null
mmc_ud_year smallint 5  √  null
mmc_ud_month smallint 5  √  null
mmc_ud_day smallint 5  √  null
mmc_stat mediumtext 16777215  √  null
mmc_dupformat varchar 255  √  null
mmc_featured_year smallint 5  √  null
mmc_featured_month smallint 5  √  null
mmc_featured_day smallint 5  √  null
mmc_formative_research mediumtext 16777215  √  null
mmc_pretesting mediumtext 16777215  √  null
mmc_summative_evaluation mediumtext 16777215  √  null
importid int 10  √  null
source varchar 255  √  null
item_issues_count int 10  √  null
sword_depositor int 10  √  null
sword_slug varchar 255  √  null
edit_lock_user int 10  √  null
edit_lock_since int 10  √  null
edit_lock_until int 10  √  null

Table contained 7,798 rows at Wed Apr 20 16:58 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
eprintid Primary key Asc PRIMARY
commentary Performance Asc commentary
datestamp_year + datestamp_month + datestamp_day + datestamp_hour + datestamp_minute + datestamp_second Performance Asc/Asc/Asc/Asc/Asc/Asc datestamp_year
importid Performance Asc eprint_importid
item_issues_count Performance Asc eprint_item_issues_count
eprint_status Performance Asc eprint_status
sword_depositor Performance Asc eprint_sword_depositor
full_text_status Performance Asc full_text_status
lastmod_year + lastmod_month + lastmod_day + lastmod_hour + lastmod_minute + lastmod_second Performance Asc/Asc/Asc/Asc/Asc/Asc lastmod_year
latitude Performance Asc latitude
longitude Performance Asc longitude
metadata_visibility Performance Asc metadata_visibility
mmc_cat Performance Asc mmc_cat
mmc_em_year + mmc_em_month + mmc_em_day Performance Asc/Asc/Asc mmc_em_year
mmc_featured_year + mmc_featured_month + mmc_featured_day Performance Asc/Asc/Asc mmc_featured_year
mmc_ud_year + mmc_ud_month + mmc_ud_day Performance Asc/Asc/Asc mmc_ud_year
replacedby Performance Asc replacedby
rev_number Performance Asc rev_number
status_changed_year + status_changed_month + status_changed_day + status_changed_hour + status_changed_minute + status_changed_second Performance Asc/Asc/Asc/Asc/Asc/Asc status_changed_year
succeeds Performance Asc succeeds
type Performance Asc type
userid Performance Asc userid

Close relationships: