ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

RelatedDatasets

Information about relationships among DataSets

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	RelationID	Integer				Primary key for a relationship table (i.e. named "Related...").
	DataSetID	Integer				Foreign key identifier for a DataSet
	RelationshipTypeCV	VarChar(255)				CV term describing the relationship between DataSets (e.g., "IsNewVersionOf" or "Continues"), largely conforming to CV used by DataCite.org.
	RelatedDatasetID	Integer				Foreign key identifier for a DataSet related to the DataSet identified by DataSetID
	VersionCode	VarChar(50)				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
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_RelatedDatasets_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.RelatedDatasets	Name	RelationshipTypeCV
fk_RelatedDatasets_DataSets	ODM2Core.Datasets	ODM2Provenance.RelatedDatasets	DatasetID	DataSetID
fk_RelatedDatasets_DataSets_AreRelated	ODM2Core.Datasets	ODM2Provenance.RelatedDatasets	DatasetID	RelatedDatasetID

Parent Relations (none)

Used in Diagrams

Diagram Name

ODM2Provenance

ODM2Simulation