Sensor_Component 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
component_nb		NUMBER(8, 0)	NO	This attribute represents the component number
channel_comp		VARCHAR2(2)	YES	Component channel
component_type		VARCHAR2(1)	YES	This attribute denotes the component type
sensitivity		BINARY_FLOAT	NO	This attribute denotes the sensitivity (Sd) for a sensor or a digitizer
frequency		BINARY_FLOAT	YES	The frequency (fs) at which the value in sensitivity/gain is correct
seqresp_id		NUMBER(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 Primary and Unique Keys

Key Name	Key Type	Keys
SeC00	PrimaryKey	sensor_id, component_nb

Sensor_Component Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
Sensor	Identifying	One To Zero or More	Sen_Com_Sen			sensor_id	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

Sensor_Component Check Constraints

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