ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

RelatedEquipment

Information about relationships among Equipment

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	RelationID	Integer				Primary key identifier
	EquipmentID	Integer				Foreign key identifier for a piece of Equipment
	RelationshipTypeCV	VarChar(255)				Controlled Vocabulary term indicating the type of relationship between two pieces of equipment
	RelatedEquipmentID	Integer				Foreign key identifier of the related piece of equipment
	RelationshipStartDateTime	DateTime				Beginning date/time of the relationship between the two pieces of equipment
	RelationshipStartDateTimeUTCOffset	Integer				UTCOffset of the beginning date/time
	RelationshipEndDateTime	DateTime				Ending date/time of the relationship between two pieces of equipment
	RelationshipEndDateTimeUTCOffset	Integer				UTCOffset of the ending date/time

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_RelatedEquipment_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Equipment.RelatedEquipment	Name	RelationshipTypeCV
fk_RelatedEquipment_Equipment	ODM2Equipment.Equipment	ODM2Equipment.RelatedEquipment	EquipmentID	EquipmentID
fk_RelatedEquipment_Equipment_AreRelated	ODM2Equipment.Equipment	ODM2Equipment.RelatedEquipment	EquipmentID	RelatedEquipmentID

Parent Relations (none)

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Equipment