Table dvnDb.public.vdc 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('vdc_id_seq'::regclass)
contactsubject.vdc_id fk_contactsubject_vdc_id R
guestbookquestionnaire.vdc_id fk_guestbookquestionnaire_vdc_id R
lockssconfig.vdc_id fk_lockssconfig_vdc_id R
rolerequest.vdc_id fk_rolerequest_vdc_id R
search_result_fields.vdc_id fk_search_result_fields_vdc_id R
study.owner_id fk_study_owner_id R
summary_fields.vdc_id fk_summary_fields_vdc_id R
template.vdc_id fk_template_vdc_id R
termsofuse.vdc_id fk_termsofuse_vdc_id R
twittercredentials.vdc_id fk_twittercredentials_vdc_id R
vdc_adv_search_fields.vdc_id fk_vdc_adv_search_fields_vdc_id R
vdc_any_search_fields.vdc_id fk_vdc_any_search_fields_vdc_id R
vdc_fileuser.vdc_id fk_vdc_fileuser_vdc_id R
vdc_fileusergroup.vdc_id fk_vdc_fileusergroup_vdc_id R
vdc_linked_collections.vdc_id fk_vdc_linked_collections_vdc_id R
vdc_usergroup.vdcs_id fk_vdc_usergroup_vdcs_id R
vdcactivity.vdc_id fk_vdcactivity_vdc_id R
vdccollection.owner_id fk_vdccollection_owner_id R
vdcgroup_vdcs.vdc_id fk_vdcgroup_vdcs_vdc_id R
vdcrole.vdc_id fk_vdcrole_vdc_id R
aboutthisdataverse text 2147483647  √  null
affiliation varchar 255  √  null
alias varchar 255  √  null
allowcontributorrequests bool 1  √  null
allowcontributorseditall bool 1  √  null
allowregistereduserstocontribute bool 1  √  null
allowstudycomments bool 1  √  null
announcements text 2147483647  √  null
contactemail varchar 255  √  null
copyright varchar 255  √  null
createddate timestamp 29,6  √  null
defaultsortorder varchar 255  √  null
termsofuse text 2147483647  √  null
deposittermsofuseenabled bool 1  √  null
description varchar 255  √  null
displayannouncements bool 1  √  null
displayinframe bool 1  √  null
displaynetworkannouncements bool 1  √  null
displaynewstudies bool 1  √  null
downloadtermsofuse text 2147483647  √  null
downloadtermsofuseenabled bool 1  √  null
dtype varchar 255  √  null
dvndescription varchar 255  √  null
filesrestricted bool 1  √  null
firstname varchar 255  √  null
footer text 2147483647  √  null
header text 2147483647  √  null
lastname varchar 255  √  null
logo varchar 255  √  null
name varchar 255  √  null
parentsite varchar 255  √  null
releasedate timestamp 29,6  √  null
restricted bool 1  √  null
termsofuseenabled bool 1  √  null
version int8 19  √  null
visibility varchar 255  √  null
creator_id int8 19  √  null
vdcuser.id fk_vdc_creator_id R
defaulttemplate_id int8 19  √  null
template.id fk_vdc_defaulttemplate_id R
reviewer_id int8 19  √  null
vdcuser.id fk_vdc_reviewer_id R
vdcnetwork_id int8 19  √  null
vdcnetwork.id fk_vdc_vdcnetwork_id R
harvestingdataverse_id int8 19  √  null
harvestingdataverse.id fk_vdc_harvestingdataverse_id R
rootcollection_id int8 19  √  null
vdccollection.id fk_vdc_rootcollection_id R

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc vdc_pkey

Close relationships  within of separation: