ODMX [ODMX_DBWrench_Schema.xml]
Information about relationships among Equipment
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| RelationID | Integer |
| nextval('"ODMXEquipment"."RelatedEquipment_RelationID_seq"'::regclass) | Primary key identifier | ||
| EquipmentID | Integer | Foreign key identifier for a piece of Equipment |
|
||||
| RelationshipTypeCV | VarChar() |
| Controlled Vocabulary term indicating the type of relationship between two pieces of equipment |
|
|||
| RelatedEquipmentID | Integer | Foreign key identifier of the related piece of equipment |
|
||||
| RelationshipStartDateTimeUTC | BigInt | Beginning date/time of the relationship between the two pieces of equipment | |||||
| RelationshipEndDateTimeUTC | BigInt |
| Ending date/time of the relationship between two pieces of equipment |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_RelatedEquipment_CV_RelationshipType | ODMXCV.CV_RelationshipType | ODMXEquipment.RelatedEquipment | Term | RelationshipTypeCV |
| fk_RelatedEquipment_Equipment | ODMXEquipment.Equipment | ODMXEquipment.RelatedEquipment | EquipmentID | EquipmentID |
| fk_RelatedEquipment_Equipment_AreRelated | ODMXEquipment.Equipment | ODMXEquipment.RelatedEquipment | EquipmentID | RelatedEquipmentID |
(none)
| Diagram Name |
| ODMXEquipment |