Sensor

Logical Entity Name | Sensor
Default Table Name | Sensor
Definition | Summary information on a sensor

Sensor Columns

ColumnName | Domain | Datatype | NULL | Definition
sensor_id |  | NUMBER(8, 0) | NO | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
name |  | VARCHAR2(80) | YES | This attribute denotes a descriptive name for a sensor
serial_nb |  | VARCHAR2(80) | YES | This attribute denotes a serial number of a sensor
ondate |  | DATE | NO | This attribute denotes the start date
offdate |  | DATE | YES | This attribute denotes the end date
nb_component |  | NUMBER(8, 0) | NO | This attribute denotes the number of components of a sensor
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Sensor Primary and Unique Keys

Key Name | Key Type | Keys
Sensor00 | PrimaryKey | sensor_id

Sensor Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred
Sensor_Component | Identifying | One To Zero or More | Sen_Com_Sen |  |  |  | NO | NO | NO
Station_Sensor | Non-Identifying | One To Zero or More | Sta_Sen_Sen |  |  |  | NO | NO | NO

Sensor Check Constraints

Check Constraint Name | CheckConstraint
Sensor01 | nb_component >= 0