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			nextval('"ODM2Equipment"."EquipmentModels_EquipmentModelID_seq"'::regclass)	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
	EquipmentTypeCV	VarChar(255)
	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
	ModelDescriptionURL	VarChar(255)				A URL to a website or file having a description of the equipment model
	IsRetired	Boolean			A Boolean which tells whether the instrument is retired

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_EquipmentModels_CV_EquipmentType	ODM2CV.CV_EquipmentType	ODM2Equipment.EquipmentModels	Term	EquipmentTypeCV
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.InstrumentOutputQuantityKind	EquipmentModelID	EquipmentModelID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Equipment