| 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 |
| 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 | |||||
| EquipmentTypeCV | VarChar(255) | CV term describing the equipment type (e.g., sensor, datalogger, solar panel, etc.) |
|
||||
| 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_CV_EquipmentType | ODM2CV.CV_EquipmentType | ODM2Equipment.Equipment | Name | EquipmentTypeCV |
| 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 |