Equipment - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

EquipmentDescriptions of specific pieces of equipment.

PKNameData TypeNULLsA/NDefaultCommentFK

EquipmentIDInteger

Primary key identifier
EquipmentCodeVarChar(50) A text code that identifies the piece of equipment
EquipmentNameVarChar(255) A text name for the piece of equipment
EquipmentTypeCVVarChar(255) CV term describing the equipment type (e.g., sensor, datalogger, solar panel, etc.)

EquipmentModelIDInteger Foreign key identifier for the model of the equipment

EquipmentSerialNumberVarChar(50) Manufacturer's serial number for the specific piece of equipment
EquipmentOwnerIDInteger Foreign key identifer for the person that owns the piece of equipment

EquipmentVendorIDInteger Foreign key identifier for the vendor organization for the piece of equipment

EquipmentPurchaseDateDateTime Date that the piece of equipment was purchased
EquipmentPurchaseOrderNumberVarChar(50)

A text string identifying the purchase order used to purchase the piece of equipment
EquipmentDescriptionVarChar(5000)

Text notes about the specific piece of equipment
EquipmentDocumentationLinkVarChar(255)

A file name, path, or URL to a photo of the specific piece of equipment


NameParent TableChild TableParent ColumnsChild Columns
fk_Equipment_CV_EquipmentTypeODM2CV.CV_EquipmentTypeODM2Equipment.EquipmentNameEquipmentTypeCV
fk_Equipment_EquipmentModelsODM2Equipment.EquipmentModelsODM2Equipment.EquipmentEquipmentModelIDEquipmentModelID
fk_Equipment_OrganizationsODM2Core.OrganizationsODM2Equipment.EquipmentOrganizationIDEquipmentVendorID
fk_Equipment_PeopleODM2Core.PeopleODM2Equipment.EquipmentPersonIDEquipmentOwnerID

NameParent TableChild TableParent ColumnsChild Columns
fk_EquipmentAnnotations_EquipmentODM2Equipment.EquipmentODM2Annotations.EquipmentAnnotationsEquipmentIDEquipmentID
fk_CalibrationReferenceEquipment_EquipmentODM2Equipment.EquipmentODM2Equipment.CalibrationReferenceEquipmentEquipmentIDEquipmentID
fk_EquipmentActions_EquipmentODM2Equipment.EquipmentODM2Equipment.EquipmentUsedEquipmentIDEquipmentID
fk_RelatedEquipment_EquipmentODM2Equipment.EquipmentODM2Equipment.RelatedEquipmentEquipmentIDEquipmentID
fk_RelatedEquipment_Equipment_AreRelatedODM2Equipment.EquipmentODM2Equipment.RelatedEquipmentEquipmentIDRelatedEquipmentID

Diagram Name
ODM2Annotations
ODM2Equipment
ODM2LabAnalyses