Table dvnDb.public.study Generated by
SchemaSpy
Legend: SourceForge.net
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
id serial 10  √  nextval('study_id_seq'::regclass)
coll_studies.study_id fk_coll_studies_study_id R
guestbookresponse.study_id fk_guestbookresponse_study_id R
linked_network_studies.study_id fk_linked_network_studies_study_id R
study_studyfield.studies_id fk_study_studyfield_studies_id R
study_usergroup.studies_id fk_study_usergroup_studies_id R
study_vdcuser.studies_id fk_study_vdcuser_studies_id R
studyaccessrequest.study_id fk_studyaccessrequest_study_id R
studydownload.study_id fk_studydownload_study_id R
studyfile.study_id fk_studyfile_study_id R
studyfileactivity.study_id fk_studyfileactivity_study_id R
studylock.study_id fk_studylock_study_id R
studyrequest.study_id fk_studyrequest_study_id R
studyversion.study_id fk_studyversion_study_id R
authority text 2147483647  √  null
createtime timestamp 29,6  √  null
harvestidentifier varchar 255  √  null
isharvested bool 1  √  null
lastexporttime timestamp 29,6  √  null
lastindextime timestamp 29,6  √  null
lastupdatetime timestamp 29,6  √  null
numberofdownloads int8 19  √  null
protocol text 2147483647  √  null
requestaccess bool 1  √  null
restricted bool 1  √  null
studyid varchar 255  √  null
version int8 19  √  null
creator_id int8 19
vdcuser.id fk_study_creator_id R
lastupdater_id int8 19  √  null
vdcuser.id fk_study_lastupdater_id R
owner_id int8 19
vdc.id fk_study_owner_id R
reviewer_id int8 19  √  null
vdcuser.id fk_study_reviewer_id R
template_id int8 19
template.id fk_study_template_id R

Table contained 4 rows at Fri May 30 15:33 MDT 2014

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc study_pkey  
id Performance Asc study_id_index  
owner_id Performance Asc study_owner_id_index  
authority + protocol + studyid Must be unique Asc/Asc/Asc unq_study_0 These unique columns are also nullable

Close relationships  within of separation: