RelatedEquipment - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

RelatedEquipmentInformation about relationships among Equipment

PKNameData TypeNULLsA/NDefaultCommentFK

RelationIDInteger

Primary key identifier
EquipmentIDInteger Foreign key identifier for a piece of Equipment

RelationshipTypeCVVarChar(255) Controlled Vocabulary term indicating the type of relationship between two pieces of equipment

RelatedEquipmentIDInteger Foreign key identifier of the related piece of equipment

RelationshipStartDateTimeDateTime Beginning date/time of the relationship between the two pieces of equipment
RelationshipStartDateTimeUTCOffsetInteger UTCOffset of the beginning date/time
RelationshipEndDateTimeDateTime

Ending date/time of the relationship between two pieces of equipment
RelationshipEndDateTimeUTCOffsetInteger

UTCOffset of the ending date/time


NameParent TableChild TableParent ColumnsChild Columns
fk_RelatedEquipment_CV_RelationshipTypeODM2CV.CV_RelationshipTypeODM2Equipment.RelatedEquipmentNameRelationshipTypeCV
fk_RelatedEquipment_EquipmentODM2Equipment.EquipmentODM2Equipment.RelatedEquipmentEquipmentIDEquipmentID
fk_RelatedEquipment_Equipment_AreRelatedODM2Equipment.EquipmentODM2Equipment.RelatedEquipmentEquipmentIDRelatedEquipmentID


Diagram Name
ODM2Equipment