ODMX [ODMX_DBWrench_Schema.xml]
Descriptions of specific pieces of equipment.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| EquipmentID | Integer |
| nextval('"ODMXEquipment"."Equipment_EquipmentID_seq"'::regclass) | Primary key identifier | ||
| EquipmentUUID | VarChar() | A UUID which uniquely identifies a piece of equipment | |||||
| EquipmentCode | VarChar() | A text code that identifies the equipment model - should correspond to the EquiomentModelName | |||||
| EquipmentName | VarChar() | A text name for the piece of equipment | |||||
| EquipmentModelID | Integer | Foreign key identifier for the model of the equipment |
|
||||
| EquipmentSerialNumber | VarChar() |
| Manufacturer's serial number for the specific 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() |
| A text string identifying the purchase order used to purchase the piece of equipment | ||||
| EquipmentDescription | VarChar() |
| Text notes about the specific piece of equipment | ||||
| EquipmentDocumentationLink | VarChar() |
| A file name, path, or URL to a photo of the specific piece of equipment |
| Name | Table | Columns | Unique | Clustered |
| Equipment_EquipmentUUID_Idx | ODMXEquipment.Equipment | EquipmentUUID |
|
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Equipment_EquipmentModels | ODMXEquipment.EquipmentModels | ODMXEquipment.Equipment | EquipmentModelID | EquipmentModelID |
| fk_Equipment_Organizations | ODMXCore.Organizations | ODMXEquipment.Equipment | OrganizationID | EquipmentVendorID |
(none)
| Diagram Name |
| ODMXAnnotations |
| ODMXEquipment |
| ODMXLabAnalyses |