ODMX [ODMX_DBWrench_Schema.xml]
Relationship between DataSets and Citations
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| BridgeID | Integer |
| nextval('"ODMXProvenance"."DatasetCitations_BridgeID_seq"'::regclass) | Primary key for a bridge table, enabling many-to-many joins. | ||
| DataSetID | Integer | Foreign key identifier for a DataSet |
|
||||
| RelationshipTypeCV | VarChar() | CV term describing the relationship between the DataSet and the Citation (e.g., "cites" or "isCitedBy"), largely conforming to CV used by DataCite.org. |
|
||||
| CitationID | Integer | Foreign key identifier for a Citation that is associated with the DataSet identified by DataSetID |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_DataSetCitations_Citations | ODMXProvenance.Citations | ODMXProvenance.DatasetCitations | CitationID | CitationID |
| fk_DatasetCitations_CV_RelationshipType | ODMXCV.CV_RelationshipType | ODMXProvenance.DatasetCitations | Term | RelationshipTypeCV |
| fk_DataSetCitations_DataSets | ODMXCore.Datasets | ODMXProvenance.DatasetCitations | DatasetID | DataSetID |
(none)
| Diagram Name |
| ODMXOverviewSimplified |
| ODMXProvenance |