id |
serial |
10 |
|
√ |
nextval('vdcnetwork_id_seq'::regclass) |
|
|
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 |
|