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 |
Used in Diagrams |
Diagram Name |
ODM2Annotations |
ODM2Equipment |
ODM2LabAnalyses |