Table dvnDb.public.metadata Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('metadata_id_seq'::regclass)
studyabstract.metadata_id fk_studyabstract_metadata_id R
studyauthor.metadata_id fk_studyauthor_metadata_id R
studydistributor.metadata_id fk_studydistributor_metadata_id R
studyfieldvalue.metadata_id fk_studyfieldvalue_metadata_id R
studygeobounding.metadata_id fk_studygeobounding_metadata_id R
studygrant.metadata_id fk_studygrant_metadata_id R
studykeyword.metadata_id fk_studykeyword_metadata_id R
studynote.metadata_id fk_studynote_metadata_id R
studyotherid.metadata_id fk_studyotherid_metadata_id R
studyotherref.metadata_id fk_studyotherref_metadata_id R
studyproducer.metadata_id fk_studyproducer_metadata_id R
studyrelmaterial.metadata_id fk_studyrelmaterial_metadata_id R
studyrelpublication.metadata_id fk_studyrelpublication_metadata_id R
studyrelstudy.metadata_id fk_studyrelstudy_metadata_id R
studysoftware.metadata_id fk_studysoftware_metadata_id R
studytopicclass.metadata_id fk_studytopicclass_metadata_id R
studyversion.metadata_id fk_studyversion_metadata_id R
template.metadata_id fk_template_metadata_id R
unf text 2147483647  √  null
accesstosources text 2147483647  √  null
actionstominimizeloss text 2147483647  √  null
availabilitystatus text 2147483647  √  null
characteristicofsources text 2147483647  √  null
citationrequirements text 2147483647  √  null
cleaningoperations text 2147483647  √  null
collectionmode text 2147483647  √  null
collectionsize text 2147483647  √  null
conditions text 2147483647  √  null
confidentialitydeclaration text 2147483647  √  null
contact text 2147483647  √  null
controloperations text 2147483647  √  null
country text 2147483647  √  null
datacollectionsituation text 2147483647  √  null
datacollector text 2147483647  √  null
datasources text 2147483647  √  null
dateofcollectionend text 2147483647  √  null
dateofcollectionstart text 2147483647  √  null
dateofdeposit text 2147483647  √  null
depositor text 2147483647  √  null
depositorrequirements text 2147483647  √  null
deviationsfromsampledesign text 2147483647  √  null
disclaimer text 2147483647  √  null
distributiondate text 2147483647  √  null
distributorcontact text 2147483647  √  null
distributorcontactaffiliation text 2147483647  √  null
distributorcontactemail text 2147483647  √  null
frequencyofdatacollection text 2147483647  √  null
fundingagency text 2147483647  √  null
geographiccoverage text 2147483647  √  null
geographicunit text 2147483647  √  null
harvestdvntermsofuse text 2147483647  √  null
harvestdvtermsofuse text 2147483647  √  null
harvestholdings varchar 255  √  null
kindofdata text 2147483647  √  null
originofsources text 2147483647  √  null
originalarchive text 2147483647  √  null
otherdataappraisal text 2147483647  √  null
placeofaccess text 2147483647  √  null
productiondate text 2147483647  √  null
productionplace text 2147483647  √  null
researchinstrument text 2147483647  √  null
responserate text 2147483647  √  null
restrictions text 2147483647  √  null
samplingerrorestimate text 2147483647  √  null
samplingprocedure text 2147483647  √  null
seriesinformation text 2147483647  √  null
seriesname text 2147483647  √  null
specialpermissions text 2147483647  √  null
studycompletion text 2147483647  √  null
studylevelerrornotes text 2147483647  √  null
studyversion text 2147483647  √  null
subtitle text 2147483647  √  null
timemethod text 2147483647  √  null
timeperiodcoveredend text 2147483647  √  null
timeperiodcoveredstart text 2147483647  √  null
title text 2147483647  √  null
unitofanalysis text 2147483647  √  null
universe text 2147483647  √  null
version int8 19  √  null
versiondate text 2147483647  √  null
weighting text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc metadata_pkey
id Performance Asc metadata_id_index

Close relationships  within of separation: