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

Table	Column	Type	Size	Nulls	Auto	Default	Comments
studydistributor	abbreviation	varchar	255	√		null
studyproducer	abbreviation	varchar	255	√		null
vdc	aboutthisdataverse	text	2147483647	√		null
vdcnetwork	aboutthisdataversenetwork	text	2147483647	√		null
twittercredentials	accesstoken	varchar	255	√		null
twittercredentials	accesstokensecret	varchar	255	√		null
metadata	accesstosources	text	2147483647	√		null
metadata	actionstominimizeloss	text	2147483647	√		null
vdcuser	active	bool	1	√		null
filemetadatafield	advancedsearchfield	bool	1	√		null
studyfield	advancedsearchfield	bool	1	√		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
vdcuser	agreedtermsofuse	bool	1	√		null
vdc	alias	varchar	255	√		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
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
studyfield	allowmultiples	bool	1	√		null
vdc	allowregistereduserstocontribute	bool	1	√		null
lockssconfig	allowrestricted	bool	1	√		null
vdc	allowstudycomments	bool	1	√		null
vdc	announcements	text	2147483647	√		null
vdcnetwork	announcements	text	2147483647	√		null
EJB__TIMER__TBL	APPLICATIONID	int8	19	√		null
studyversion	archivenote	varchar	1000	√		null
studyversion	archivetime	timestamp	29,6	√		null
remoteaccessauth	authcred1	varchar	255	√		null
remoteaccessauth	authcred2	varchar	255	√		null
remoteaccessauth	authcred3	varchar	255	√		null
remoteaccessauth	authcred4	varchar	255	√		null
study	authority	text	2147483647	√		null
vdcnetwork	authority	varchar	255	√		null
remoteaccessauth	authtype	varchar	255	√		null
metadata	availabilitystatus	text	2147483647	√		null
filemetadatafield	basicsearchfield	bool	1	√		null
studyfield	basicsearchfield	bool	1	√		null
variablerange	beginvalue	varchar	255	√		null
variablerange	beginvaluetype_id	int8	19	√		null
EJB__TIMER__TBL	BLOB	bytea	2147483647	√		null
vdcuser	bypasstermsofuse	bool	1	√		null
datatable	casequantity	int8	19	√		null
filemetadata	category	text	2147483647	√		null
variablecategory	catorder	int4	10	√		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
studycomment	commentcreator_id	int8	19
datavariable	concept	varchar	255	√		null
metadata	conditions	text	2147483647	√		null
metadata	confidentialitydeclaration	text	2147483647	√		null
metadata	contact	text	2147483647	√		null
vdc	contactemail	varchar	255	√		null
vdcnetwork	contactemail	varchar	255	√		null
EJB__TIMER__TBL	CONTAINERID	int8	19	√		null
versioncontributor	contributor_id	int8	19
controlledvocabularyvalue	controlledvocabulary_id	int8	19
templatefield	controlledvocabulary_id	int8	19	√		null
metadata	controloperations	text	2147483647	√		null
vdc	copyright	varchar	255	√		null
metadata	country	text	2147483647	√		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
EJB__TIMER__TBL	CREATIONTIMERAW	int8	19	√		null
study	creator_id	int8	19
vdc	creator_id	int8	19	√		null
vdcnetwork	creator_id	int8	19	√		null
filemetadatafield	customfield	bool	1	√		null
studyfield	customfield	bool	1	√		null
customquestionresponse	customquestion_id	int8	19
customquestionvalue	customquestion_id	int8	19
metadata	datacollectionsituation	text	2147483647	√		null
metadata	datacollector	text	2147483647	√		null
metadata	datasources	text	2147483647	√		null
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
studyabstract	date	varchar	255	√		null
metadata	dateofcollectionend	text	2147483647	√		null
metadata	dateofcollectionstart	text	2147483647	√		null
metadata	dateofdeposit	text	2147483647	√		null
studyversion	deaccessionlink	varchar	255	√		null
visualizationdisplay	defaultdisplay	int4	10	√		null
vdcgroup	defaultdisplaynumber	int8	19	√		null
vdcnetwork	defaultdisplaynumber	int8	19	√		null
vdcnetwork	defaultdvsortcolumn	varchar	255	√		null
vdcnetwork	defaultnetworkadmin_id	int8	19	√		null
vdc	defaultsortorder	varchar	255	√		null
vdc	defaulttemplate_id	int8	19	√		null
vdcnetwork	defaulttemplate_id	int8	19	√		null
templatefield	defaultvalue	varchar	255	√		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
vdc	deposittermsofuseenabled	bool	1	√		null
vdcnetwork	deposittermsofuseenabled	bool	1	√		null
controlledvocabulary	description	text	2147483647	√		null
filemetadata	description	text	2147483647	√		null
filemetadatafield	description	text	2147483647	√		null
networkrole	description	varchar	255	√		null
oaiset	description	text	2147483647	√		null
role	description	varchar	255	√		null
studyfield	description	text	2147483647	√		null
template	description	varchar	255	√		null
usergroup	description	varchar	255	√		null
vdc	description	varchar	255	√		null
vdccollection	description	text	2147483647	√		null
vdcgroup	description	varchar	255	√		null
studylock	detail	varchar	255	√		null
metadata	deviationsfromsampledesign	text	2147483647	√		null
metadata	disclaimer	text	2147483647	√		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
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
vdcnetwork	displayvdcannouncements	bool	1	√		null
vdcnetwork	displayvdcrecentstudies	bool	1	√		null
metadata	distributiondate	text	2147483647	√		null
metadata	distributorcontact	text	2147483647	√		null
metadata	distributorcontactaffiliation	text	2147483647	√		null
metadata	distributorcontactemail	text	2147483647	√		null
captcha	domainname	varchar	255	√		null
studyfileactivity	downloadcount	int4	10	√		null
vdcnetworkstats	downloadcount	int8	19	√		null
vdc	downloadtermsofuse	text	2147483647	√		null
vdcnetwork	downloadtermsofuse	text	2147483647	√		null
vdc	downloadtermsofuseenabled	bool	1	√		null
vdcnetwork	downloadtermsofuseenabled	bool	1	√		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
guestbookquestionnaire	emailrequired	bool	1	√		null
guestbookquestionnaire	enabled	bool	1	√		null
template	enabled	bool	1	√		null
termsofuse	enabled	bool	1	√		null
vdcuser	encryptedpassword	text	2147483647	√		null
variablerange	endvalue	varchar	255	√		null
variablerange	endvaluetype_id	int8	19	√		null
vdcnetwork	exportdayofweek	int4	10	√		null
vdcnetwork	exporthourofday	int4	10	√		null
vdcnetwork	exportperiod	varchar	255	√		null
harvestingdataverse	failedstudycount	int8	19	√		null
harvestingdataverse	failedstudycountnonzero	int8	19	√		null
templatefield	fieldinputlevelstring	varchar	255	√		null
controlledvocabulary	fieldtype	varchar	255	√		null
studyfield	fieldtype	varchar	255	√		null
studyfile	fileclass	varchar	31	√		null
vdcnetworkstats	filecount	int8	19	√		null
datavariable	fileendposition	int8	19	√		null
filemetadatafield	fileformatname	varchar	255	√		null
filemetadatafieldvalue	filemetadatafield_id	int8	19
datavariable	fileorder	int4	10	√		null
vdc	filesrestricted	bool	1	√		null
datavariable	filestartposition	int8	19	√		null
studyfile	filesystemlocation	text	2147483647	√		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
guestbookquestionnaire	firstnamerequired	bool	1	√		null
vdcuser_studycomment	flaggedstudycomments_id	int8	19
vdc	footer	text	2147483647	√		null
vdcactivity	foreignstudylocaldownloadcount	int4	10
datavariable	formatcategory	varchar	255	√		null
datavariable	formatschema	varchar	255	√		null
metadataformattype	formatschema	varchar	255	√		null
datavariable	formatschemaname	varchar	255	√		null
variablecategory	frequency	float8	17,17	√		null
metadata	frequencyofdatacollection	text	2147483647	√		null
usergroup	friendlyname	varchar	255	√		null
metadata	fundingagency	text	2147483647	√		null
harvestingdataverse	generaterandomids	bool	1	√		null
metadata	geographiccoverage	text	2147483647	√		null
metadata	geographicunit	text	2147483647	√		null
harveststudy	globalid	varchar	255	√		null
group_grouptypes	group_id	int8	19
vdcgrouprelationship	group_id	int8	19
group_grouptypes	group_type_id	int8	19
vargrouping	groupingtype	varchar	255	√		null
customquestion	guestbookquestionnaire_id	int8	19
guestbookresponse	guestbookquestionnaire_id	int8	19
customquestionresponse	guestbookresponse_id	int8	19
harvestingdataverse	handleprefix_id	int8	19	√		null
vdcnetwork	handleregistration	bool	1	√		null
metadata	harvestdvntermsofuse	text	2147483647	√		null
metadata	harvestdvtermsofuse	text	2147483647	√		null
harvestingdataverse	harvestedstudycount	int8	19	√		null
harvestingdataverse	harvestedstudycountnonzero	int8	19	√		null
harvestingdataverse	harvestformattype_id	int8	19
metadata	harvestholdings	varchar	255	√		null
study	harvestidentifier	varchar	255	√		null
vdc	harvestingdataverse_id	int8	19	√		null
harvestingdataverse	harvestingnow	bool	1	√		null
harvestingdataverse	harvestingset	varchar	255	√		null
harvestingdataverse	harvestresult	varchar	255	√		null
harvestingdataverse	harvesttype	varchar	255	√		null
vdc	header	text	2147483647	√		null
customquestion	hidden	bool	1	√		null
remoteaccessauth	hostname	varchar	255	√		null
captcha	id	int8	19
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)
datafileformattype	id	int8	19
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)
harvestformattype	id	int8	19
harvestingdataverse	id	serial	10		√	nextval('harvestingdataverse_id_seq'::regclass)
harveststudy	id	serial	10		√	nextval('harveststudy_id_seq'::regclass)
keywordsearchterm	id	int8	19
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)
metadataformattype	id	int8	19
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)
summarystatistictype	id	int8	19
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)
variableformattype	id	int8	19
variableintervaltype	id	int8	19
variablerange	id	serial	10		√	nextval('variablerange_id_seq'::regclass)
variablerangeitem	id	serial	10		√	nextval('variablerangeitem_id_seq'::regclass)
variablerangetype	id	int8	19
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)
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
EJB__TIMER__TBL	INITIALEXPIRATIONRAW	int8	19	√		null
guestbookresponse	institution	varchar	255	√		null
vdcuser	institution	varchar	255	√		null
guestbookquestionnaire	institutionrequired	bool	1	√		null
EJB__TIMER__TBL	INTERVALDURATION	int8	19	√		null
lockssserver	ipaddress	varchar	255	√		null
logindomain	ipaddress	varchar	255	√		null
study	isharvested	bool	1	√		null
metadata	kindofdata	text	2147483647	√		null
datavariable	label	text	2147483647	√		null
datavariablemapping	label	varchar	255	√		null
filemetadata	label	varchar	255	√		null
variablecategory	label	varchar	255	√		null
studyfileactivity	lastdownloadtime	timestamp	29,6	√		null
EJB__TIMER__TBL	LASTEXPIRATIONRAW	int8	19	√		null
study	lastexporttime	timestamp	29,6	√		null
harvestingdataverse	lastharvesttime	timestamp	29,6	√		null
study	lastindextime	timestamp	29,6	√		null
guestbookresponse	lastname	varchar	255	√		null
vdc	lastname	varchar	255	√		null
vdcuser	lastname	varchar	255	√		null
guestbookquestionnaire	lastnamerequired	bool	1	√		null
harvestingdataverse	lastsuccessfulharvesttime	timestamp	29,6	√		null
harvestingdataverse	lastsuccessfulnonzeroharvesttime	timestamp	29,6	√		null
study	lastupdater_id	int8	19	√		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
lockssconfig	licensetext	text	2147483647	√		null
lockssconfig	licensetype_id	int8	19	√		null
licensetype	licenseurl	varchar	255	√		null
vdc_linked_collections	linked_collection_id	int8	19
vdcactivity	localstudyforeigndownloadcount	int4	10
vdcactivity	localstudylocaldownloadcount	int4	10
vdcactivity	localstudynetworkdownloadcount	int4	10
lockssserver	lockssconfig_id	int8	19
oaiset	lockssconfig_id	int8	19	√		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
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
harvestformattype	metadataprefix	varchar	255	√		null
datafileformattype	mimetype	varchar	255	√		null
metadataformattype	mimetype	varchar	255	√		null
variablecategory	missing	bool	1	√		null
controlledvocabulary	name	varchar	255	√		null
datafileformattype	name	varchar	255	√		null
datavariable	name	varchar	255	√		null
fieldinputlevel	name	varchar	255	√		null
filemetadatafield	name	text	2147483647	√		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
oaiset	name	text	2147483647	√		null
pagedef	name	varchar	255	√		null
role	name	varchar	255	√		null
studyauthor	name	varchar	255	√		null
studydistributor	name	varchar	255	√		null
studyfield	name	text	2147483647	√		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
vdcnetwork	networkcreated	timestamp	29,6	√		null
vdcnetwork	networkpagefooter	text	2147483647	√		null
vdcnetwork	networkpageheader	text	2147483647	√		null
networkrolerequest	networkrole_id	int8	19
pagedef	networkrole_id	int8	19	√		null
vdcuser	networkrole_id	int8	19	√		null
studygeobounding	northlatitude	varchar	255	√		null
studygrant	number	text	2147483647	√		null
datavariable	numberofdecimalpoints	int8	19	√		null
study	numberofdownloads	int8	19	√		null
studydownload	numberofdownloads	int4	10	√		null
datavariable	orderedfactor	bool	1	√		null
metadata	originalarchive	text	2147483647	√		null
studyfile	originalfiletype	varchar	255	√		null
metadata	originofsources	text	2147483647	√		null
metadata	otherdataappraisal	text	2147483647	√		null
studyotherid	otherid	text	2147483647	√		null
study	owner_id	int8	19
vdccollection	owner_id	int8	19	√		null
EJB__TIMER__TBL	OWNERID	varchar	255	√		null
vdcgroup	parent	int8	19	√		null
vdccollection	parentcollection_id	int8	19	√		null
vdc	parentsite	varchar	255	√		null
studyfield	parentstudyfield_id	int8	19	√		null
metadataformattype	partialexcludesupported	bool	1	√		null
metadataformattype	partialselectsupported	bool	1	√		null
pagedef	path	varchar	255	√		null
vdcuser	phonenumber	varchar	255	√		null
usergroup	pinservice	varchar	255	√		null
EJB__TIMER__TBL	PKHASHCODE	int4	10	√		null
metadata	placeofaccess	text	2147483647	√		null
guestbookresponse	position	varchar	255	√		null
vdcuser	position	varchar	255	√		null
guestbookquestionnaire	positionrequired	bool	1	√		null
handleprefix	prefix	varchar	255	√		null
filemetadatafield	prefixsearchable	bool	1	√		null
captcha	privatekey	varchar	255	√		null
metadata	productiondate	text	2147483647	√		null
metadata	productionplace	text	2147483647	√		null
study	protocol	text	2147483647	√		null
vdcnetwork	protocol	varchar	255	√		null
captcha	publickey	varchar	255	√		null
vdccollection	query	text	2147483647	√		null
customquestion	questionstring	varchar	255	√		null
datavariable	questiontext	text	2147483647	√		null
customquestion	questiontype	varchar	255	√		null
licensetype	rdfurl	varchar	255	√		null
datavariable	recordsegmentnumber	int8	19	√		null
datatable	recordspercase	int8	19	√		null
vdc	releasedate	timestamp	29,6	√		null
studyversion	releasetime	timestamp	29,6	√		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
metadata	researchinstrument	text	2147483647	√		null
customquestionresponse	response	varchar	255	√		null
metadata	responserate	text	2147483647	√		null
guestbookresponse	responsetime	timestamp	29,6	√		null
study	restricted	bool	1	√		null
studyfile	restricted	bool	1	√		null
vdc	restricted	bool	1	√		null
metadata	restrictions	text	2147483647	√		null
vdcnetwork	restrictiontext	varchar	255	√		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
metadata	samplingerrorestimate	text	2147483647	√		null
metadata	samplingprocedure	text	2147483647	√		null
EJB__TIMER__TBL	SCHEDULE	varchar	255	√		null
harvestingdataverse	scheduled	bool	1	√		null
harvestingdataverse	scheduledayofweek	int4	10	√		null
harvestingdataverse	schedulehourofday	int4	10	√		null
harvestingdataverse	scheduleperiod	varchar	255	√		null
vdccollection	scope	int4	10	√		null
filemetadatafield	searchresultfield	bool	1	√		null
studyfield	searchresultfield	bool	1	√		null
keywordsearchterm	searchterm	varchar	255	√		null
sequence	seq_count	numeric	38	√		null
sequence	seq_name	varchar	50
metadata	seriesinformation	text	2147483647	√		null
metadata	seriesname	text	2147483647	√		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
visualizationdisplay	showdatatable	bool	1	√		null
visualizationdisplay	showflashgraph	bool	1	√		null
visualizationdisplay	showimagegraph	bool	1	√		null
studysoftware	softwareversion	varchar	255	√		null
visualizationdisplay	sourceinfolabel	varchar	255	√		null
studygeobounding	southlatitude	varchar	255	√		null
oaiset	spec	text	2147483647	√		null
metadata	specialpermissions	text	2147483647	√		null
studylock	starttime	timestamp	29,6	√		null
EJB__TIMER__TBL	STATE	int4	10	√		null
studycomment	status	int4	10	√		null
vdcnetwork	statusnotice	text	2147483647	√		null
filemetadatafieldvalue	strvalue	text	2147483647	√		null
studyfieldvalue	strvalue	text	2147483647	√		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
metadata	studycompletion	text	2147483647	√		null
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
study	studyid	varchar	255	√		null
metadata	studylevelerrornotes	text	2147483647	√		null
metadata	studyversion	text	2147483647	√		null
filemetadata	studyversion_id	int8	19
guestbookresponse	studyversion_id	int8	19	√		null
studycomment	studyversion_id	int8	19
versioncontributor	studyversion_id	int8	19
harvestformattype	stylesheetfilename	varchar	255	√		null
vdcgrouprelationship	subgroup_id	int8	19
studynote	subject	varchar	255	√		null
contactsubject	subjecttext	varchar	255	√		null
networkcontactsubject	subjecttext	varchar	255	√		null
harvestingdataverse	subsetrestricted	bool	1	√		null
metadata	subtitle	text	2147483647	√		null
study_studyfield	summaryfields_id	int8	19
vdcnetwork	systememail	varchar	255	√		null
study	template_id	int8	19
templatefield	template_id	int8	19
templatefilecategory	template_id	int8	19	√		null
termsofuse	terms	text	2147483647	√		null
vdc	termsofuse	text	2147483647	√		null
vdcnetwork	termsofuse	text	2147483647	√		null
vdc	termsofuseenabled	bool	1	√		null
vdcnetwork	termsofuseenabled	bool	1	√		null
vdcnetwork	termsofuseupdated	timestamp	29,6	√		null
vdcuser	test	int4	10	√		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
EJB__TIMER__TBL	TIMERID	varchar	255
filemetadatafield	title	text	2147483647	√		null
metadata	title	text	2147483647	√		null
studyfield	title	text	2147483647	√		null
datatable	type	varchar	255	√		null
studynote	type	varchar	255	√		null
vdccollection	type	varchar	255	√		null
summarystatistic	type_id	int8	19
datatable	unf	varchar	255	√		null
datavariable	unf	varchar	255	√		null
metadata	unf	text	2147483647	√		null
studyfile	unf	varchar	255	√		null
metadata	unitofanalysis	text	2147483647	√		null
vargroup	units	varchar	255	√		null
datavariable	universe	varchar	255	√		null
metadata	universe	text	2147483647	√		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
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	username	varchar	255	√		null
vdcuser_usergroup	users_id	int8	19
controlledvocabularyvalue	value	text	2147483647	√		null
datafileformattype	value	varchar	255	√		null
studykeyword	value	text	2147483647	√		null
studytopicclass	value	text	2147483647	√		null
summarystatistic	value	varchar	255	√		null
variablecategory	value	text	2147483647	√		null
variablerangeitem	value	numeric	38	√		null
customquestionvalue	valuestring	varchar	255	√		null
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
metadata	versiondate	text	2147483647	√		null
studyversion	versionnote	varchar	1000	√		null
studyversion	versionnumber	int8	19	√		null
studyversion	versionstate	varchar	255	√		null
vdc	visibility	varchar	255	√		null
datatable	visualizationenabled	bool	1	√		null
studykeyword	vocab	varchar	255	√		null
studytopicclass	vocab	varchar	255	√		null
studykeyword	vocaburi	varchar	255	√		null
studytopicclass	vocaburi	varchar	255	√		null
datavariable	weighted	bool	1	√		null
weightedvarrelationship	weighted_variable_id	int8	19
metadata	weighting	text	2147483647	√		null
studygeobounding	westlongitude	varchar	255	√		null
datavariablemapping	x_axis	bool	1	√		null