SchemaSpy Analysis of dvnDb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri May 30 15:33 MDT 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

dvnDb.public contains 762 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
captcha domainname varchar 255  √  null
captcha id int8 19
captcha privatekey varchar 255  √  null
captcha publickey varchar 255  √  null
coll_adv_search_fields study_field_id int8 19
coll_adv_search_fields vdc_collection_id int8 19
coll_any_search_fields study_field_id int8 19
coll_any_search_fields vdc_collection_id int8 19
coll_search_result_fields study_field_id int8 19
coll_search_result_fields vdc_collection_id int8 19
coll_studies study_id int8 19
coll_studies vdc_collection_id int8 19
contactsubject id serial 10  √  nextval('contactsubject_id_seq'::regclass)
contactsubject subjecttext varchar 255  √  null
contactsubject vdc_id int8 19  √  null
controlledvocabulary description text 2147483647  √  null
controlledvocabulary fieldtype varchar 255  √  null
controlledvocabulary id serial 10  √  nextval('controlledvocabulary_id_seq'::regclass)
controlledvocabulary name varchar 255  √  null
controlledvocabularyvalue controlledvocabulary_id int8 19
controlledvocabularyvalue id serial 10  √  nextval('controlledvocabularyvalue_id_seq'::regclass)
controlledvocabularyvalue value text 2147483647  √  null
customquestion guestbookquestionnaire_id int8 19
customquestion hidden bool 1  √  null
customquestion id serial 10  √  nextval('customquestion_id_seq'::regclass)
customquestion questionstring varchar 255  √  null
customquestion questiontype varchar 255  √  null
customquestion required bool 1  √  null
customquestionresponse customquestion_id int8 19
customquestionresponse guestbookresponse_id int8 19
customquestionresponse id serial 10  √  nextval('customquestionresponse_id_seq'::regclass)
customquestionresponse response varchar 255  √  null
customquestionvalue customquestion_id int8 19
customquestionvalue id serial 10  √  nextval('customquestionvalue_id_seq'::regclass)
customquestionvalue valuestring varchar 255  √  null
datafileformattype id int8 19
datafileformattype mimetype varchar 255  √  null
datafileformattype name varchar 255  √  null
datafileformattype value varchar 255  √  null
datatable casequantity int8 19  √  null
datatable id serial 10  √  nextval('datatable_id_seq'::regclass)
datatable recordspercase int8 19  √  null
datatable studyfile_id int8 19
datatable type varchar 255  √  null
datatable unf varchar 255  √  null
datatable varquantity int8 19  √  null
datatable version int8 19  √  null
datatable visualizationenabled bool 1  √  null
datavariable concept varchar 255  √  null
datavariable datatable_id int8 19
datavariable fileendposition int8 19  √  null
datavariable fileorder int4 10  √  null
datavariable filestartposition int8 19  √  null
datavariable formatcategory varchar 255  √  null
datavariable formatschema varchar 255  √  null
datavariable formatschemaname varchar 255  √  null
datavariable id serial 10  √  nextval('datavariable_id_seq'::regclass)
datavariable label text 2147483647  √  null
datavariable name varchar 255  √  null
datavariable numberofdecimalpoints int8 19  √  null
datavariable orderedfactor bool 1  √  null
datavariable questiontext text 2147483647  √  null
datavariable recordsegmentnumber int8 19  √  null
datavariable unf varchar 255  √  null
datavariable universe varchar 255  √  null
datavariable variableformattype_id int8 19
datavariable variableintervaltype_id int8 19  √  null
datavariable version int8 19  √  null
datavariable weighted bool 1  √  null
datavariablemapping datatable_id int8 19
datavariablemapping datavariable_id int8 19
datavariablemapping id serial 10  √  nextval('datavariablemapping_id_seq'::regclass)
datavariablemapping label varchar 255  √  null
datavariablemapping vargroup_id int8 19  √  null
datavariablemapping vargrouping_id int8 19  √  null
datavariablemapping x_axis bool 1  √  null
EJB__TIMER__TBL APPLICATIONID int8 19  √  null
EJB__TIMER__TBL BLOB bytea 2147483647  √  null
EJB__TIMER__TBL CONTAINERID int8 19  √  null
EJB__TIMER__TBL CREATIONTIMERAW int8 19  √  null
EJB__TIMER__TBL INITIALEXPIRATIONRAW int8 19  √  null
EJB__TIMER__TBL INTERVALDURATION int8 19  √  null
EJB__TIMER__TBL LASTEXPIRATIONRAW int8 19  √  null
EJB__TIMER__TBL OWNERID varchar 255  √  null
EJB__TIMER__TBL PKHASHCODE int4 10  √  null
EJB__TIMER__TBL SCHEDULE varchar 255  √  null
EJB__TIMER__TBL STATE int4 10  √  null
EJB__TIMER__TBL TIMERID varchar 255
fieldinputlevel id serial 10  √  nextval('fieldinputlevel_id_seq'::regclass)
fieldinputlevel name varchar 255  √  null
filemetadata category text 2147483647  √  null
filemetadata description text 2147483647  √  null
filemetadata id serial 10  √  nextval('filemetadata_id_seq'::regclass)
filemetadata label varchar 255  √  null
filemetadata studyfile_id int8 19
filemetadata studyversion_id int8 19
filemetadata version int8 19  √  null
filemetadatafield advancedsearchfield bool 1  √  null
filemetadatafield basicsearchfield bool 1  √  null
filemetadatafield customfield bool 1  √  null
filemetadatafield description text 2147483647  √  null
filemetadatafield displayorder int4 10  √  null
filemetadatafield fileformatname varchar 255  √  null
filemetadatafield id serial 10  √  nextval('filemetadatafield_id_seq'::regclass)
filemetadatafield name text 2147483647  √  null
filemetadatafield prefixsearchable bool 1  √  null
filemetadatafield searchresultfield bool 1  √  null
filemetadatafield title text 2147483647  √  null
filemetadatafieldvalue displayorder int4 10  √  null
filemetadatafieldvalue filemetadatafield_id int8 19
filemetadatafieldvalue id serial 10  √  nextval('filemetadatafieldvalue_id_seq'::regclass)
filemetadatafieldvalue strvalue text 2147483647  √  null
filemetadatafieldvalue studyfile_id int8 19
flagged_study_comments study_comment_id int8 19
flagged_study_comments user_id int8 19
group_grouptypes group_id int8 19
group_grouptypes group_type_id int8 19
guestbookquestionnaire emailrequired bool 1  √  null
guestbookquestionnaire enabled bool 1  √  null
guestbookquestionnaire firstnamerequired bool 1  √  null
guestbookquestionnaire id serial 10  √  nextval('guestbookquestionnaire_id_seq'::regclass)
guestbookquestionnaire institutionrequired bool 1  √  null
guestbookquestionnaire lastnamerequired bool 1  √  null
guestbookquestionnaire positionrequired bool 1  √  null
guestbookquestionnaire vdc_id int8 19  √  null
guestbookresponse downloadtype varchar 255  √  null
guestbookresponse email varchar 255  √  null
guestbookresponse firstname varchar 255  √  null
guestbookresponse guestbookquestionnaire_id int8 19
guestbookresponse id serial 10  √  nextval('guestbookresponse_id_seq'::regclass)
guestbookresponse institution varchar 255  √  null
guestbookresponse lastname varchar 255  √  null
guestbookresponse position varchar 255  √  null
guestbookresponse responsetime timestamp 29,6  √  null
guestbookresponse sessionid varchar 255  √  null
guestbookresponse study_id int8 19
guestbookresponse studyfile_id int8 19
guestbookresponse studyversion_id int8 19  √  null
guestbookresponse vdcuser_id int8 19  √  null
handleprefix id serial 10  √  nextval('handleprefix_id_seq'::regclass)
handleprefix prefix varchar 255  √  null
harvestformattype id int8 19
harvestformattype metadataprefix varchar 255  √  null
harvestformattype name varchar 255  √  null
harvestformattype stylesheetfilename varchar 255  √  null
harvestingdataverse failedstudycount int8 19  √  null
harvestingdataverse failedstudycountnonzero int8 19  √  null
harvestingdataverse generaterandomids bool 1  √  null
harvestingdataverse handleprefix_id int8 19  √  null
harvestingdataverse harvestedstudycount int8 19  √  null
harvestingdataverse harvestedstudycountnonzero int8 19  √  null
harvestingdataverse harvestformattype_id int8 19
harvestingdataverse harvestingnow bool 1  √  null
harvestingdataverse harvestingset varchar 255  √  null
harvestingdataverse harvestresult varchar 255  √  null
harvestingdataverse harvesttype varchar 255  √  null
harvestingdataverse id serial 10  √  nextval('harvestingdataverse_id_seq'::regclass)
harvestingdataverse lastharvesttime timestamp 29,6  √  null
harvestingdataverse lastsuccessfulharvesttime timestamp 29,6  √  null
harvestingdataverse lastsuccessfulnonzeroharvesttime timestamp 29,6  √  null
harvestingdataverse scheduled bool 1  √  null
harvestingdataverse scheduledayofweek int4 10  √  null
harvestingdataverse schedulehourofday int4 10  √  null
harvestingdataverse scheduleperiod varchar 255  √  null
harvestingdataverse serverurl varchar 255  √  null
harvestingdataverse subsetrestricted bool 1  √  null
harvestingdataverse version int8 19  √  null
harveststudy globalid varchar 255  √  null
harveststudy id serial 10  √  nextval('harveststudy_id_seq'::regclass)
harveststudy lastupdatetime timestamp 29,6  √  null
harveststudy removed bool 1  √  null
harveststudy setname varchar 255  √  null
keywordsearchterm id int8 19
keywordsearchterm searchterm varchar 255  √  null
licensetype id serial 10  √  nextval('licensetype_id_seq'::regclass)
licensetype imageurl varchar 255  √  null
licensetype licenseurl varchar 255  √  null
licensetype name varchar 255  √  null
licensetype rdfurl varchar 255  √  null
licensetype shortname varchar 255  √  null
linked_network_studies study_id int8 19
linked_network_studies vdcnetwork_id int8 19
lockssconfig allowrestricted bool 1  √  null
lockssconfig id serial 10  √  nextval('lockssconfig_id_seq'::regclass)
lockssconfig licensetext text 2147483647  √  null
lockssconfig licensetype_id int8 19  √  null
lockssconfig serveraccess varchar 255  √  null
lockssconfig vdc_id int8 19  √  null
lockssserver id serial 10  √  nextval('lockssserver_id_seq'::regclass)
lockssserver ipaddress varchar 255  √  null
lockssserver lockssconfig_id int8 19
lockssserver version int8 19  √  null
loginaffiliate id serial 10  √  nextval('loginaffiliate_id_seq'::regclass)
loginaffiliate name varchar 255  √  null
loginaffiliate url varchar 255  √  null
loginaffiliate usergroup_id int8 19
loginaffiliate version int8 19  √  null
logindomain id serial 10  √  nextval('logindomain_id_seq'::regclass)
logindomain ipaddress varchar 255  √  null
logindomain usergroup_id int8 19
logindomain version int8 19  √  null
metadata accesstosources text 2147483647  √  null
metadata actionstominimizeloss text 2147483647  √  null
metadata availabilitystatus text 2147483647  √  null
metadata characteristicofsources text 2147483647  √  null
metadata citationrequirements text 2147483647  √  null
metadata cleaningoperations text 2147483647  √  null
metadata collectionmode text 2147483647  √  null
metadata collectionsize text 2147483647  √  null
metadata conditions text 2147483647  √  null
metadata confidentialitydeclaration text 2147483647  √  null
metadata contact text 2147483647  √  null
metadata controloperations text 2147483647  √  null
metadata country text 2147483647  √  null
metadata datacollectionsituation text 2147483647  √  null
metadata datacollector text 2147483647  √  null
metadata datasources text 2147483647  √  null
metadata dateofcollectionend text 2147483647  √  null
metadata dateofcollectionstart text 2147483647  √  null
metadata dateofdeposit text 2147483647  √  null
metadata depositor text 2147483647  √  null
metadata depositorrequirements text 2147483647  √  null
metadata deviationsfromsampledesign text 2147483647  √  null
metadata disclaimer text 2147483647  √  null
metadata distributiondate text 2147483647  √  null
metadata distributorcontact text 2147483647  √  null
metadata distributorcontactaffiliation text 2147483647  √  null
metadata distributorcontactemail text 2147483647  √  null
metadata frequencyofdatacollection text 2147483647  √  null
metadata fundingagency text 2147483647  √  null
metadata geographiccoverage text 2147483647  √  null
metadata geographicunit text 2147483647  √  null
metadata harvestdvntermsofuse text 2147483647  √  null
metadata harvestdvtermsofuse text 2147483647  √  null
metadata harvestholdings varchar 255  √  null
metadata id serial 10  √  nextval('metadata_id_seq'::regclass)
metadata kindofdata text 2147483647  √  null
metadata originalarchive text 2147483647  √  null
metadata originofsources text 2147483647  √  null
metadata otherdataappraisal text 2147483647  √  null
metadata placeofaccess text 2147483647  √  null
metadata productiondate text 2147483647  √  null
metadata productionplace text 2147483647  √  null
metadata researchinstrument text 2147483647  √  null
metadata responserate text 2147483647  √  null
metadata restrictions text 2147483647  √  null
metadata samplingerrorestimate text 2147483647  √  null
metadata samplingprocedure text 2147483647  √  null
metadata seriesinformation text 2147483647  √  null
metadata seriesname text 2147483647  √  null
metadata specialpermissions text 2147483647  √  null
metadata studycompletion text 2147483647  √  null
metadata studylevelerrornotes text 2147483647  √  null
metadata studyversion text 2147483647  √  null
metadata subtitle text 2147483647  √  null
metadata timemethod text 2147483647  √  null
metadata timeperiodcoveredend text 2147483647  √  null
metadata timeperiodcoveredstart text 2147483647  √  null
metadata title text 2147483647  √  null
metadata unf text 2147483647  √  null
metadata unitofanalysis text 2147483647  √  null
metadata universe text 2147483647  √  null
metadata version int8 19  √  null
metadata versiondate text 2147483647  √  null
metadata weighting text 2147483647  √  null
metadataformattype formatschema varchar 255  √  null
metadataformattype id int8 19
metadataformattype mimetype varchar 255  √  null
metadataformattype name varchar 255  √  null
metadataformattype namespace varchar 255  √  null
metadataformattype partialexcludesupported bool 1  √  null
metadataformattype partialselectsupported bool 1  √  null
networkcontactsubject id serial 10  √  nextval('networkcontactsubject_id_seq'::regclass)
networkcontactsubject subjecttext varchar 255  √  null
networkcontactsubject vdcnetwork_id int8 19  √  null
networkrole description varchar 255  √  null
networkrole id serial 10  √  nextval('networkrole_id_seq'::regclass)
networkrole name varchar 255  √  null
networkrolerequest id serial 10  √  nextval('networkrolerequest_id_seq'::regclass)
networkrolerequest networkrole_id int8 19
networkrolerequest vdcuser_id int8 19
oaiset definition text 2147483647  √  null
oaiset description text 2147483647  √  null
oaiset id serial 10  √  nextval('oaiset_id_seq'::regclass)
oaiset lockssconfig_id int8 19  √  null
oaiset name text 2147483647  √  null
oaiset spec text 2147483647  √  null
oaiset version int8 19  √  null
pagedef id serial 10  √  nextval('pagedef_id_seq'::regclass)
pagedef name varchar 255  √  null
pagedef networkrole_id int8 19  √  null
pagedef path varchar 255  √  null
pagedef role_id int8 19  √  null
pagedef version int8 19  √  null
remoteaccessauth authcred1 varchar 255  √  null
remoteaccessauth authcred2 varchar 255  √  null
remoteaccessauth authcred3 varchar 255  √  null
remoteaccessauth authcred4 varchar 255  √  null
remoteaccessauth authtype varchar 255  √  null
remoteaccessauth hostname varchar 255  √  null
remoteaccessauth id serial 10  √  nextval('remoteaccessauth_id_seq'::regclass)
role description varchar 255  √  null
role id serial 10  √  nextval('role_id_seq'::regclass)
role name varchar 255  √  null
rolerequest id serial 10  √  nextval('rolerequest_id_seq'::regclass)
rolerequest role_id int8 19
rolerequest vdc_id int8 19
rolerequest vdcuser_id int8 19
search_result_fields study_field_id int8 19
search_result_fields vdc_id int8 19
sequence seq_count numeric 38  √  null
sequence seq_name varchar 50
study authority text 2147483647  √  null
study createtime timestamp 29,6  √  null
study creator_id int8 19
study harvestidentifier varchar 255  √  null
study id serial 10  √  nextval('study_id_seq'::regclass)
study isharvested bool 1  √  null
study lastexporttime timestamp 29,6  √  null
study lastindextime timestamp 29,6  √  null
study lastupdater_id int8 19  √  null
study lastupdatetime timestamp 29,6  √  null
study numberofdownloads int8 19  √  null
study owner_id int8 19
study protocol text 2147483647  √  null
study requestaccess bool 1  √  null
study restricted bool 1  √  null
study reviewer_id int8 19  √  null
study studyid varchar 255  √  null
study template_id int8 19
study version int8 19  √  null
study_studyfield studies_id int8 19
study_studyfield summaryfields_id int8 19
study_usergroup allowedgroups_id int8 19
study_usergroup studies_id int8 19
study_vdcuser allowedusers_id int8 19
study_vdcuser studies_id int8 19
studyabstract date varchar 255  √  null
studyabstract displayorder int4 10  √  null
studyabstract id serial 10  √  nextval('studyabstract_id_seq'::regclass)
studyabstract metadata_id int8 19
studyabstract text text 2147483647  √  null
studyabstract version int8 19  √  null
studyaccessrequest id serial 10  √  nextval('studyaccessrequest_id_seq'::regclass)
studyaccessrequest study_id int8 19
studyaccessrequest studyfile_id int8 19
studyaccessrequest vdcuser_id int8 19
studyauthor affiliation varchar 255  √  null
studyauthor displayorder int4 10  √  null
studyauthor id serial 10  √  nextval('studyauthor_id_seq'::regclass)
studyauthor idtype varchar 255  √  null
studyauthor idvalue varchar 255  √  null
studyauthor metadata_id int8 19
studyauthor name varchar 255  √  null
studyauthor version int8 19  √  null
studycomment comment text 2147483647  √  null
studycomment commentcreator_id int8 19
studycomment createtime timestamp 29,6  √  null
studycomment id serial 10  √  nextval('studycomment_id_seq'::regclass)
studycomment status int4 10  √  null
studycomment studyversion_id int8 19
studydistributor abbreviation varchar 255  √  null
studydistributor affiliation varchar 255  √  null
studydistributor displayorder int4 10  √  null
studydistributor id serial 10  √  nextval('studydistributor_id_seq'::regclass)
studydistributor logo varchar 255  √  null
studydistributor metadata_id int8 19
studydistributor name varchar 255  √  null
studydistributor url varchar 255  √  null
studydistributor version int8 19  √  null
studydownload id serial 10  √  nextval('studydownload_id_seq'::regclass)
studydownload numberofdownloads int4 10  √  null
studydownload study_id int8 19  √  null
studyfield advancedsearchfield bool 1  √  null
studyfield allowcontrolledvocabulary bool 1  √  null
studyfield allowmultiples bool 1  √  null
studyfield basicsearchfield bool 1  √  null
studyfield customfield bool 1  √  null
studyfield description text 2147483647  √  null
studyfield displayorder int4 10  √  null
studyfield fieldtype varchar 255  √  null
studyfield id serial 10  √  nextval('studyfield_id_seq'::regclass)
studyfield name text 2147483647  √  null
studyfield parentstudyfield_id int8 19  √  null
studyfield searchresultfield bool 1  √  null
studyfield title text 2147483647  √  null
studyfieldvalue displayorder int4 10  √  null
studyfieldvalue id serial 10  √  nextval('studyfieldvalue_id_seq'::regclass)
studyfieldvalue metadata_id int8 19
studyfieldvalue strvalue text 2147483647  √  null
studyfieldvalue studyfield_id int8 19
studyfile allowaccessrequest bool 1  √  null
studyfile displayorder int4 10  √  null
studyfile fileclass varchar 31  √  null
studyfile filesystemlocation text 2147483647  √  null
studyfile filesystemname varchar 255  √  null
studyfile filetype varchar 255  √  null
studyfile id serial 10  √  nextval('studyfile_id_seq'::regclass)
studyfile md5 varchar 255  √  null
studyfile originalfiletype varchar 255  √  null
studyfile requestaccess bool 1  √  null
studyfile restricted bool 1  √  null
studyfile study_id int8 19
studyfile unf varchar 255  √  null
studyfile version int8 19  √  null
studyfile_usergroup allowedgroups_id int8 19
studyfile_usergroup studyfiles_id int8 19
studyfile_vdcuser allowedusers_id int8 19
studyfile_vdcuser studyfiles_id int8 19
studyfileactivity downloadcount int4 10  √  null
studyfileactivity id serial 10  √  nextval('studyfileactivity_id_seq'::regclass)
studyfileactivity lastdownloadtime timestamp 29,6  √  null
studyfileactivity study_id int8 19
studyfileactivity studyfile_id int8 19
studygeobounding displayorder int4 10  √  null
studygeobounding eastlongitude varchar 255  √  null
studygeobounding id serial 10  √  nextval('studygeobounding_id_seq'::regclass)
studygeobounding metadata_id int8 19
studygeobounding northlatitude varchar 255  √  null
studygeobounding southlatitude varchar 255  √  null
studygeobounding version int8 19  √  null
studygeobounding westlongitude varchar 255  √  null
studygrant agency varchar 255  √  null
studygrant displayorder int4 10  √  null
studygrant id serial 10  √  nextval('studygrant_id_seq'::regclass)
studygrant metadata_id int8 19
studygrant number text 2147483647  √  null
studygrant version int8 19  √  null
studykeyword displayorder int4 10  √  null
studykeyword id serial 10  √  nextval('studykeyword_id_seq'::regclass)
studykeyword metadata_id int8 19
studykeyword value text 2147483647  √  null
studykeyword version int8 19  √  null
studykeyword vocab varchar 255  √  null
studykeyword vocaburi varchar 255  √  null
studylock detail varchar 255  √  null
studylock id serial 10  √  nextval('studylock_id_seq'::regclass)
studylock starttime timestamp 29,6  √  null
studylock study_id int8 19
studylock user_id int8 19
studynote displayorder int4 10  √  null
studynote id serial 10  √  nextval('studynote_id_seq'::regclass)
studynote metadata_id int8 19
studynote subject varchar 255  √  null
studynote text text 2147483647  √  null
studynote type varchar 255  √  null
studynote version int8 19  √  null
studyotherid agency varchar 255  √  null
studyotherid displayorder int4 10  √  null
studyotherid id serial 10  √  nextval('studyotherid_id_seq'::regclass)
studyotherid metadata_id int8 19
studyotherid otherid text 2147483647  √  null
studyotherid version int8 19  √  null
studyotherref displayorder int4 10  √  null
studyotherref id serial 10  √  nextval('studyotherref_id_seq'::regclass)
studyotherref metadata_id int8 19
studyotherref text text 2147483647  √  null
studyotherref version int8 19  √  null
studyproducer abbreviation varchar 255  √  null
studyproducer affiliation varchar 255  √  null
studyproducer displayorder int4 10  √  null
studyproducer id serial 10  √  nextval('studyproducer_id_seq'::regclass)
studyproducer logo varchar 255  √  null
studyproducer metadata_id int8 19
studyproducer name varchar 255  √  null
studyproducer url varchar 255  √  null
studyproducer version int8 19  √  null
studyrelmaterial displayorder int4 10  √  null
studyrelmaterial id serial 10  √  nextval('studyrelmaterial_id_seq'::regclass)
studyrelmaterial metadata_id int8 19
studyrelmaterial text text 2147483647  √  null
studyrelmaterial version int8 19  √  null
studyrelpublication displayorder int4 10  √  null
studyrelpublication id serial 10  √  nextval('studyrelpublication_id_seq'::regclass)
studyrelpublication idnumber varchar 255  √  null
studyrelpublication idtype varchar 255  √  null
studyrelpublication metadata_id int8 19
studyrelpublication replicationdata bool 1  √  null
studyrelpublication text text 2147483647  √  null
studyrelpublication url varchar 255  √  null
studyrelpublication version int8 19  √  null
studyrelstudy displayorder int4 10  √  null
studyrelstudy id serial 10  √  nextval('studyrelstudy_id_seq'::regclass)
studyrelstudy metadata_id int8 19
studyrelstudy text text 2147483647  √  null
studyrelstudy version int8 19  √  null
studyrequest id serial 10  √  nextval('studyrequest_id_seq'::regclass)
studyrequest study_id int8 19
studyrequest vdcuser_id int8 19
studysoftware displayorder int4 10  √  null
studysoftware id serial 10  √  nextval('studysoftware_id_seq'::regclass)
studysoftware metadata_id int8 19
studysoftware name varchar 255  √  null
studysoftware softwareversion varchar 255  √  null
studysoftware version int8 19  √  null
studytopicclass displayorder int4 10  √  null
studytopicclass id serial 10  √  nextval('studytopicclass_id_seq'::regclass)
studytopicclass metadata_id int8 19
studytopicclass value text 2147483647  √  null
studytopicclass version int8 19  √  null
studytopicclass vocab varchar 255  √  null
studytopicclass vocaburi varchar 255  √  null
studyversion archivenote varchar 1000  √  null
studyversion archivetime timestamp 29,6  √  null
studyversion createtime timestamp 29,6  √  null
studyversion deaccessionlink varchar 255  √  null
studyversion id serial 10  √  nextval('studyversion_id_seq'::regclass)
studyversion lastupdatetime timestamp 29,6  √  null
studyversion metadata_id int8 19
studyversion releasetime timestamp 29,6  √  null
studyversion study_id int8 19
studyversion version int8 19  √  null
studyversion versionnote varchar 1000  √  null
studyversion versionnumber int8 19  √  null
studyversion versionstate varchar 255  √  null
summary_fields study_field_id int8 19
summary_fields vdc_id int8 19
summarystatistic datavariable_id int8 19
summarystatistic id serial 10  √  nextval('summarystatistic_id_seq'::regclass)
summarystatistic type_id int8 19
summarystatistic value varchar 255  √  null
summarystatistictype id int8 19
summarystatistictype name varchar 255  √  null
template description varchar 255  √  null
template enabled bool 1  √  null
template id serial 10  √  nextval('template_id_seq'::regclass)
template metadata_id int8 19  √  null
template name varchar 255  √  null
template vdc_id int8 19  √  null
template vdcnetwork_id int8 19  √  null
template version int8 19  √  null
templatefield controlledvocabulary_id int8 19  √  null
templatefield defaultvalue varchar 255  √  null
templatefield displayorder int4 10  √  null
templatefield fieldinputlevelstring varchar 255  √  null
templatefield id serial 10  √  nextval('templatefield_id_seq'::regclass)
templatefield studyfield_id int8 19
templatefield template_id int8 19
templatefield version int8 19  √  null
templatefilecategory displayorder int4 10  √  null
templatefilecategory id serial 10  √  nextval('templatefilecategory_id_seq'::regclass)
templatefilecategory name varchar 255  √  null
templatefilecategory template_id int8 19  √  null
termsofuse createtime timestamp 29,6  √  null
termsofuse enabled bool 1  √  null
termsofuse id serial 10  √  nextval('termsofuse_id_seq'::regclass)
termsofuse terms text 2147483647  √  null
termsofuse vdc_id int8 19
twittercredentials accesstoken varchar 255  √  null
twittercredentials accesstokensecret varchar 255  √  null
twittercredentials id serial 10  √  nextval('twittercredentials_id_seq'::regclass)
twittercredentials vdc_id int8 19  √  null
usergroup description varchar 255  √  null
usergroup friendlyname varchar 255  √  null
usergroup id serial 10  √  nextval('usergroup_id_seq'::regclass)
usergroup name varchar 255  √  null
usergroup pinservice varchar 255  √  null
usergroup version int8 19  √  null
vargroup id serial 10  √  nextval('vargroup_id_seq'::regclass)
vargroup name varchar 255  √  null
vargroup units varchar 255  √  null
vargroup vargrouping_id int8 19
vargrouping datatable_id int8 19
vargrouping groupingtype varchar 255  √  null
vargrouping id serial 10  √  nextval('vargrouping_id_seq'::regclass)
vargrouping name varchar 255  √  null
vargrouptype id serial 10  √  nextval('vargrouptype_id_seq'::regclass)
vargrouptype name varchar 255  √  null
vargrouptype vargrouping_id int8 19
variablecategory catorder int4 10  √  null
variablecategory datavariable_id int8 19
variablecategory frequency float8 17,17  √  null
variablecategory id serial 10  √  nextval('variablecategory_id_seq'::regclass)
variablecategory label varchar 255  √  null
variablecategory missing bool 1  √  null
variablecategory value text 2147483647  √  null
variableformattype id int8 19
variableformattype name varchar 255  √  null
variableintervaltype id int8 19
variableintervaltype name varchar 255  √  null
variablerange beginvalue varchar 255  √  null
variablerange beginvaluetype_id int8 19  √  null
variablerange datavariable_id int8 19
variablerange endvalue varchar 255  √  null
variablerange endvaluetype_id int8 19  √  null
variablerange id serial 10  √  nextval('variablerange_id_seq'::regclass)
variablerangeitem datavariable_id int8 19
variablerangeitem id serial 10  √  nextval('variablerangeitem_id_seq'::regclass)
variablerangeitem value numeric 38  √  null
variablerangetype id int8 19
variablerangetype name varchar 255  √  null
vdc aboutthisdataverse text 2147483647  √  null
vdc affiliation varchar 255  √  null
vdc alias varchar 255  √  null
vdc allowcontributorrequests bool 1  √  null
vdc allowcontributorseditall bool 1  √  null
vdc allowregistereduserstocontribute bool 1  √  null
vdc allowstudycomments bool 1  √  null
vdc announcements text 2147483647  √  null
vdc contactemail varchar 255  √  null
vdc copyright varchar 255  √  null
vdc createddate timestamp 29,6  √  null
vdc creator_id int8 19  √  null
vdc defaultsortorder varchar 255  √  null
vdc defaulttemplate_id int8 19  √  null
vdc deposittermsofuseenabled bool 1  √  null
vdc description varchar 255  √  null
vdc displayannouncements bool 1  √  null
vdc displayinframe bool 1  √  null
vdc displaynetworkannouncements bool 1  √  null
vdc displaynewstudies bool 1  √  null
vdc downloadtermsofuse text 2147483647  √  null
vdc downloadtermsofuseenabled bool 1  √  null
vdc dtype varchar 255  √  null
vdc dvndescription varchar 255  √  null
vdc filesrestricted bool 1  √  null
vdc firstname varchar 255  √  null
vdc footer text 2147483647  √  null
vdc harvestingdataverse_id int8 19  √  null
vdc header text 2147483647  √  null
vdc id serial 10  √  nextval('vdc_id_seq'::regclass)
vdc lastname varchar 255  √  null
vdc logo varchar 255  √  null
vdc name varchar 255  √  null
vdc parentsite varchar 255  √  null
vdc releasedate timestamp 29,6  √  null
vdc restricted bool 1  √  null
vdc reviewer_id int8 19  √  null
vdc rootcollection_id int8 19  √  null
vdc termsofuse text 2147483647  √  null
vdc termsofuseenabled bool 1  √  null
vdc vdcnetwork_id int8 19  √  null
vdc version int8 19  √  null
vdc visibility varchar 255  √  null
vdc_adv_search_fields study_field_id int8 19
vdc_adv_search_fields vdc_id int8 19
vdc_any_search_fields study_field_id int8 19
vdc_any_search_fields vdc_id int8 19
vdc_fileuser allowedfileusers_id int8 19
vdc_fileuser vdc_id int8 19
vdc_fileusergroup allowedfilegroups_id int8 19
vdc_fileusergroup vdc_id int8 19
vdc_linked_collections linked_collection_id int8 19
vdc_linked_collections vdc_id int8 19
vdc_usergroup allowedgroups_id int8 19
vdc_usergroup vdcs_id int8 19
vdcactivity foreignstudylocaldownloadcount int4 10
vdcactivity id serial 10  √  nextval('vdcactivity_id_seq'::regclass)
vdcactivity localstudyforeigndownloadcount int4 10
vdcactivity localstudylocaldownloadcount int4 10
vdcactivity localstudynetworkdownloadcount int4 10
vdcactivity vdc_id int8 19  √  null
vdccollection description text 2147483647  √  null
vdccollection displayorder int4 10  √  null
vdccollection id serial 10  √  nextval('vdccollection_id_seq'::regclass)
vdccollection name varchar 255  √  null
vdccollection owner_id int8 19  √  null
vdccollection parentcollection_id int8 19  √  null
vdccollection query text 2147483647  √  null
vdccollection scope int4 10  √  null
vdccollection type varchar 255  √  null
vdccollection version int8 19  √  null
vdcgroup defaultdisplaynumber int8 19  √  null
vdcgroup description varchar 255  √  null
vdcgroup displayorder int4 10  √  null
vdcgroup id serial 10  √  nextval('vdcgroup_id_seq'::regclass)
vdcgroup name varchar 255  √  null
vdcgroup parent int8 19  √  null
vdcgroup version int8 19  √  null
vdcgroup_vdcs vdc_id int8 19
vdcgroup_vdcs vdcgroup_id int8 19
vdcgrouprelationship group_id int8 19
vdcgrouprelationship subgroup_id int8 19
vdcnetwork aboutthisdataversenetwork text 2147483647  √  null
vdcnetwork affiliation varchar 255  √  null
vdcnetwork allowcreaterequest bool 1  √  null
vdcnetwork announcements text 2147483647  √  null
vdcnetwork authority varchar 255  √  null
vdcnetwork contactemail varchar 255  √  null
vdcnetwork creator_id int8 19  √  null
vdcnetwork defaultdisplaynumber int8 19  √  null
vdcnetwork defaultdvsortcolumn varchar 255  √  null
vdcnetwork defaultnetworkadmin_id int8 19  √  null
vdcnetwork defaulttemplate_id int8 19  √  null
vdcnetwork defaultvdcabouttext text 2147483647  √  null
vdcnetwork defaultvdcannouncements text 2147483647  √  null
vdcnetwork defaultvdcfooter text 2147483647  √  null
vdcnetwork defaultvdcheader text 2147483647  √  null
vdcnetwork deposittermsofuse text 2147483647  √  null
vdcnetwork deposittermsofuseenabled bool 1  √  null
vdcnetwork displayannouncements bool 1  √  null
vdcnetwork displayvdcannouncements bool 1  √  null
vdcnetwork displayvdcrecentstudies bool 1  √  null
vdcnetwork downloadtermsofuse text 2147483647  √  null
vdcnetwork downloadtermsofuseenabled bool 1  √  null
vdcnetwork exportdayofweek int4 10  √  null
vdcnetwork exporthourofday int4 10  √  null
vdcnetwork exportperiod varchar 255  √  null
vdcnetwork handleregistration bool 1  √  null
vdcnetwork id serial 10  √  nextval('vdcnetwork_id_seq'::regclass)
vdcnetwork logo varchar 255  √  null
vdcnetwork name varchar 255  √  null
vdcnetwork networkcreated timestamp 29,6  √  null
vdcnetwork networkpagefooter text 2147483647  √  null
vdcnetwork networkpageheader text 2147483647  √  null
vdcnetwork protocol varchar 255  √  null
vdcnetwork requiredvaffiliation bool 1  √  null
vdcnetwork requiredvclassification bool 1  √  null
vdcnetwork requiredvdescription bool 1  √  null
vdcnetwork requiredvstudiesforrelease bool 1  √  null
vdcnetwork restrictiontext varchar 255  √  null
vdcnetwork shortdescription varchar 255  √  null
vdcnetwork statusnotice text 2147483647  √  null
vdcnetwork systememail varchar 255  √  null
vdcnetwork termsofuse text 2147483647  √  null
vdcnetwork termsofuseenabled bool 1  √  null
vdcnetwork termsofuseupdated timestamp 29,6  √  null
vdcnetwork urlalias varchar 255  √  null
vdcnetwork version int8 19  √  null
vdcnetworkstats downloadcount int8 19  √  null
vdcnetworkstats filecount int8 19  √  null
vdcnetworkstats id serial 10  √  nextval('vdcnetworkstats_id_seq'::regclass)
vdcnetworkstats studycount int8 19  √  null
vdcnetworkstats vdcnetwork_id int8 19  √  null
vdcrole id serial 10  √  nextval('vdcrole_id_seq'::regclass)
vdcrole role_id int8 19
vdcrole vdc_id int8 19
vdcrole vdcuser_id int8 19
vdcuser active bool 1  √  null
vdcuser agreedtermsofuse bool 1  √  null
vdcuser bypasstermsofuse bool 1  √  null
vdcuser email varchar 255  √  null
vdcuser encryptedpassword text 2147483647  √  null
vdcuser firstname varchar 255  √  null
vdcuser id serial 10  √  nextval('vdcuser_id_seq'::regclass)
vdcuser institution varchar 255  √  null
vdcuser lastname varchar 255  √  null
vdcuser networkrole_id int8 19  √  null
vdcuser phonenumber varchar 255  √  null
vdcuser position varchar 255  √  null
vdcuser test int4 10  √  null
vdcuser username varchar 255  √  null
vdcuser version int8 19  √  null
vdcuser_studycomment flaggedstudycomments_id int8 19
vdcuser_studycomment vdcuser_id int8 19
vdcuser_usergroup usergroups_id int8 19
vdcuser_usergroup users_id int8 19
versioncontributor contributor_id int8 19
versioncontributor id serial 10  √  nextval('versioncontributor_id_seq'::regclass)
versioncontributor lastupdatetime timestamp 29,6  √  null
versioncontributor studyversion_id int8 19
versioncontributor version int8 19  √  null
visualizationdisplay datatable_id int8 19
visualizationdisplay defaultdisplay int4 10  √  null
visualizationdisplay id serial 10  √  nextval('visualizationdisplay_id_seq'::regclass)
visualizationdisplay measuretypelabel varchar 255  √  null
visualizationdisplay showdatatable bool 1  √  null
visualizationdisplay showflashgraph bool 1  √  null
visualizationdisplay showimagegraph bool 1  √  null
visualizationdisplay sourceinfolabel varchar 255  √  null
weightedvarrelationship variable_id int8 19
weightedvarrelationship weighted_variable_id int8 19