ODMX [ODMX_DBWrench_Schema.xml]
Information about relationships among Results
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| RelationID | Integer |
| nextval('"ODMXProvenance"."RelatedResults_RelationID_seq"'::regclass) | Primary key for a relationship table (i.e. named "Related..."). | ||
| ResultID | BigInt | Foreign key identifier for a Result |
|
||||
| RelationshipTypeCV | VarChar() | 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() |
| 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. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_RelatedResults_CV_RelationshipType | ODMXCV.CV_RelationshipType | ODMXProvenance.RelatedResults | Term | RelationshipTypeCV |
| fk_RelatedResults_Results | ODMXCore.Results | ODMXProvenance.RelatedResults | ResultID | ResultID |
| fk_RelatedResults_Results_AreRelated | ODMXCore.Results | ODMXProvenance.RelatedResults | ResultID | RelatedResultID |
(none)
| Diagram Name |
| ODMXProvenance |