Sensor_Component

Logical Entity Name | Sensor_Component
Default Table Name | Sensor_Component
Definition | Component of a sensor

Sensor_Component Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sensor_id |  | NUMERIC(8, 0) | NO | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
component_nb |  | NUMERIC(8, 0) | NO | This attribute represents the component number
channel_comp |  | VARCHAR(2) | YES | Component channel
component_type |  | VARCHAR(1) | YES | This attribute denotes the component type
sensitivity |  | FLOAT | NO | This attribute denotes the sensitivity (Sd) for a sensor or a digitizer
frequency |  | FLOAT | YES | The frequency (fs) at which the value in sensitivity/gain is correct
seqresp_id |  | NUMERIC(8, 0) | YES | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Sensor_Component Keys

Key Name | Key Type | Keys
SeC00 | PrimaryKey | sensor_id, component_nb

Sensor_Component Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Response | Non-Specific |  |  |  |  |  | NO
Sensor | Identifying | One To Zero or More |  |  |  | sensor_id | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

Sensor_Component Check Constraints

Check Constraint Name | CheckConstraint
SeC01 | component_nb >= 1
SeC02 | frequency >= 0.0