ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

EquipmentModels

Describes models of sensors, loggers, and related equipment used in ma...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	EquipmentModelID	Integer				Primary key identifier
	ModelManufacturerID	Integer				Foreign key identifier of the model manufacturer
	ModelPartNumber	VarChar(50)				Text string for a part number for the equipment model
	ModelName	VarChar(255)				Text name of the equipment model
	ModelDescription	VarChar(5000)				Text description of the equipment model
	IsInstrument	Boolean				A boolean indication of whether the equipment is a sensor/instrument used to make observations
	ModelSpecificationsFileLink	VarChar(255)				File name, path, or URL to a specifications file for the equipment
	ModelLink	VarChar(255)				A URL to a website or file having a description of the equipment model

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_EquipmentModels_Organizations	ODM2Core.Organizations	ODM2Equipment.EquipmentModels	OrganizationID	ModelManufacturerID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Equipment_EquipmentModels	ODM2Equipment.EquipmentModels	ODM2Equipment.Equipment	EquipmentModelID	EquipmentModelID
fk_InstrumentOutputVariables_EquipmentModels	ODM2Equipment.EquipmentModels	ODM2Equipment.InstrumentOutputVariables	EquipmentModelID	ModelID

Used in Diagrams

Diagram Name

ODM2Equipment