ODMX [ODMX_DBWrench_Schema.xml]
Describes models of sensors, loggers, and related equipment used in making observations.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| EquipmentModelID | Integer |
| nextval('"ODMXEquipment"."EquipmentModels_EquipmentModelID_seq"'::regclass) | Primary key identifier | ||
| EquipmentModelManufacturerID | Integer | Foreign key identifier of the model manufacturer |
|
||||
| EquipmentModelPartNumber | VarChar() |
| Text string for a part number for the equipment model | ||||
| EquipmentModelName | VarChar() | Text name of the equipment model | |||||
| EquipmentTypeCV | VarChar() |
|
|||||
| EquipmentModelDescription | VarChar() |
| Text description of the equipment model | ||||
| IsInstrument | Boolean | A boolean indication of whether the equipment is a sensor/instrument used to make observations | |||||
| EquipmentModelSpecificationsFileLink | VarChar() |
| File name, path, or URL to a specifications file for the equipment | ||||
| EquipmentModelDescriptionURL | VarChar() |
| 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 |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_EquipmentModels_CV_EquipmentType | ODMXCV.CV_EquipmentType | ODMXEquipment.EquipmentModels | Term | EquipmentTypeCV |
| fk_EquipmentModels_Organizations | ODMXCore.Organizations | ODMXEquipment.EquipmentModels | OrganizationID | EquipmentModelManufacturerID |
(none)
| Diagram Name |
| ODMXEquipment |