ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

DatasetCitations

Relationship between DataSets and Citations

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	BridgeID	Integer				Primary key for a bridge table, enabling many-to-many joins.
	DataSetID	Integer				Foreign key identifier for a DataSet
	RelationshipTypeCV	VarChar(255)				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

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_DataSetCitations_Citations	ODM2Provenance.Citations	ODM2Provenance.DatasetCitations	CitationID	CitationID
fk_DatasetCitations_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.DatasetCitations	Name	RelationshipTypeCV
fk_DataSetCitations_DataSets	ODM2Core.Datasets	ODM2Provenance.DatasetCitations	DatasetID	DataSetID

Parent Relations (none)

Triggers (none)

Used in Diagrams

Diagram Name

ODM2OverviewSimplified

ODM2Provenance