| ODM2 [ODM2_DBWrench_Schema.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| Equipment | Descriptions of specific pieces of equipment. |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| EquipmentID | Integer |
| nextval('"ODM2Equipment"."Equipment_EquipmentID_seq"'::regclass) | Primary key identifier | ||
| EquipmentCode | VarChar(50) | A text code that identifies the piece of equipment | |||||
| EquipmentName | VarChar(255) | A text name for the piece of equipment | |||||
| EquipmentModelID | Integer | Foreign key identifier for the model of the equipment |
|
||||
| EquipmentSerialNumber | VarChar(50) |
| Manufacturer's serial number for the specific piece of equipment | ||||
| EquipmentOwnerID | Integer | Foreign key identifer for the person that owns the piece of equipment |
|
||||
| EquipmentVendorID | Integer |
| Foreign key identifier for the vendor organization for the piece of equipment |
|
|||
| EquipmentPurchaseDate | DateTime |
| Date that the piece of equipment was purchased | ||||
| EquipmentPurchaseOrderNumber | VarChar(50) |
| A text string identifying the purchase order used to purchase the piece of equipment | ||||
| EquipmentDescription | VarChar(5000) |
| Text notes about the specific piece of equipment | ||||
| EquipmentDocumentationLink | VarChar(255) |
| A file name, path, or URL to a photo of the specific piece of equipment | ||||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Equipment_EquipmentModels | ODM2Equipment.EquipmentModels | ODM2Equipment.Equipment | EquipmentModelID | EquipmentModelID |
| fk_Equipment_Organizations | ODM2Core.Organizations | ODM2Equipment.Equipment | OrganizationID | EquipmentVendorID |
| fk_Equipment_People | ODM2Core.People | ODM2Equipment.Equipment | PersonID | EquipmentOwnerID |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_EquipmentAnnotations_Equipment | ODM2Equipment.Equipment | ODM2Annotations.EquipmentAnnotations | EquipmentID | EquipmentID |
| fk_CalibrationReferenceEquipment_Equipment | ODM2Equipment.Equipment | ODM2Equipment.CalibrationReferenceEquipment | EquipmentID | EquipmentID |
| fk_EquipmentActions_Equipment | ODM2Equipment.Equipment | ODM2Equipment.EquipmentUsed | EquipmentID | EquipmentID |
| fk_RelatedEquipment_Equipment | ODM2Equipment.Equipment | ODM2Equipment.RelatedEquipment | EquipmentID | EquipmentID |
| fk_RelatedEquipment_Equipment_AreRelated | ODM2Equipment.Equipment | ODM2Equipment.RelatedEquipment | EquipmentID | RelatedEquipmentID |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| ODM2Annotations |
| ODM2Equipment |
| ODM2LabAnalyses |