dvnDb.public contains 762 columns - click on heading to sort:

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