Table dvnDb.public.vdcnetwork 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('vdcnetwork_id_seq'::regclass)
linked_network_studies.vdcnetwork_id fk_linked_network_studies_vdcnetwork_id R
networkcontactsubject.vdcnetwork_id fk_networkcontactsubject_vdcnetwork_id R
template.vdcnetwork_id fk_template_vdcnetwork_id R
vdc.vdcnetwork_id fk_vdc_vdcnetwork_id R
vdcnetworkstats.vdcnetwork_id fk_vdcnetworkstats_vdcnetwork_id R
aboutthisdataversenetwork text 2147483647  √  null
affiliation varchar 255  √  null
allowcreaterequest bool 1  √  null
announcements text 2147483647  √  null
authority varchar 255  √  null
contactemail varchar 255  √  null
defaultdvsortcolumn varchar 255  √  null
defaultdisplaynumber int8 19  √  null
defaultvdcabouttext text 2147483647  √  null
defaultvdcannouncements text 2147483647  √  null
defaultvdcfooter text 2147483647  √  null
defaultvdcheader text 2147483647  √  null
deposittermsofuse text 2147483647  √  null
deposittermsofuseenabled bool 1  √  null
displayannouncements bool 1  √  null
displayvdcannouncements bool 1  √  null
displayvdcrecentstudies bool 1  √  null
downloadtermsofuse text 2147483647  √  null
downloadtermsofuseenabled bool 1  √  null
exportdayofweek int4 10  √  null
exporthourofday int4 10  √  null
exportperiod varchar 255  √  null
handleregistration bool 1  √  null
logo varchar 255  √  null
name varchar 255  √  null
networkcreated timestamp 29,6  √  null
networkpagefooter text 2147483647  √  null
networkpageheader text 2147483647  √  null
protocol varchar 255  √  null
requiredvaffiliation bool 1  √  null
requiredvclassification bool 1  √  null
requiredvdescription bool 1  √  null
requiredvstudiesforrelease bool 1  √  null
restrictiontext varchar 255  √  null
shortdescription varchar 255  √  null
statusnotice text 2147483647  √  null
systememail varchar 255  √  null
termsofuse text 2147483647  √  null
termsofuseenabled bool 1  √  null
termsofuseupdated timestamp 29,6  √  null
urlalias varchar 255  √  null
version int8 19  √  null
defaulttemplate_id int8 19  √  null
template.id fk_vdcnetwork_defaulttemplate_id R
creator_id int8 19  √  null
vdcuser.id fk_vdcnetwork_creator_id R
defaultnetworkadmin_id int8 19  √  null
vdcuser.id fk_vdcnetwork_defaultnetworkadmin_id R

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

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

Close relationships  within of separation: