Table mob_odm2.odm2.datasets 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
datasetid serial 10  √  nextval('odm2.datasets_datasetid_seq'::regclass)
datasetcitations.datasetid fk_datasetcitations_datasets C
datasetsresults.datasetid fk_datasetsresults_datasets C
relateddatasets.datasetid fk_relateddatasets_datasets C
relateddatasets.relateddatasetid fk_relateddatasets_datasets_arerelated C
datasetuuid uuid 2147483647
datasettypecv varchar 255
cv_datasettype.name fk_datasets_cv_datasettypecv C
datasetcode varchar 50
datasettitle varchar 255
datasetabstract varchar 5000

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
datasetid Primary key Asc datasets_pkey
datasetcode Must be unique Asc datasets_datasetcode_key

Close relationships  within of separation: