ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

RelatedResults

Information about relationships among Results

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	RelationID	Integer				Primary key for a relationship table (i.e. named "Related...").
	ResultID	BigInt				Foreign key identifier for a Result
	RelationshipTypeCV	VarChar(255)				Text description of the relationship between the Results from a controlled vocabulary (e.g., "isDerivedFrom")
	RelatedResultID	BigInt				Foreign key identifier for a Result that is related to the Result identified by ResultID
	VersionCode	VarChar(50)				Text version number/code that can be specified if the Result is an explicit version of another Result and where the RelationshipTypeCV = "isNewVersionOf".
	RelatedResultSequenceNumber	Integer				Integer sequence number indicating the order in which a RelatedResults appears in a DerivationEquation (i.e. 1 for x1, 2 for x2...) and where a Result "isDerivedFrom" one or more RelatedResults.

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_RelatedResults_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.RelatedResults	Name	RelationshipTypeCV
fk_RelatedResults_Results	ODM2Core.Results	ODM2Provenance.RelatedResults	ResultID	ResultID
fk_RelatedResults_Results_AreRelated	ODM2Core.Results	ODM2Provenance.RelatedResults	ResultID	RelatedResultID

Parent Relations (none)

Used in Diagrams

Diagram Name

ODM2Provenance