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