RelatedDatasets - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: RelatedDatasets

Information about relationships among DataSets

Columns

PKNameData TypeNULLAutoDefaultCommentFK

RelationIDInteger

nextval('"ODMXProvenance"."RelatedDatasets_RelationID_seq"'::regclass)Primary key for a relationship table (i.e. named "Related...").
DataSetIDInteger Foreign key identifier for a DataSet

RelationshipTypeCVVarChar() CV term describing the relationship between DataSets (e.g., "IsNewVersionOf" or "Continues"), largely conforming to CV used by DataCite.org.

RelatedDatasetIDInteger Foreign key identifier for a DataSet related to the DataSet identified by DataSetID

VersionCodeVarChar()

Text version number/code that can be specified if the DataSet is an explicit version of another DataSet and where the RelationshipTypeCV = "isNewVersionOf".

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_RelatedDatasets_CV_RelationshipTypeODMXCV.CV_RelationshipTypeODMXProvenance.RelatedDatasetsTermRelationshipTypeCV
fk_RelatedDatasets_DataSetsODMXCore.DatasetsODMXProvenance.RelatedDatasetsDatasetIDDataSetID
fk_RelatedDatasets_DataSets_AreRelatedODMXCore.DatasetsODMXProvenance.RelatedDatasetsDatasetIDRelatedDatasetID

Triggers

(none)


Used in Diagrams

Diagram Name
ODMXProvenance
ODMXSimulation