Station_Sensor_Component Columns

ColumnName	Domain	Datatype	NULL	Definition
sta		VARCHAR2(6)	NO	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net		VARCHAR2(8)	NO	Unique network identifier. This character string is the name of a seismic network
sensor_nb		NUMBER(8, 0)	NO	This attribute represents the sensor number
component_nb		NUMBER(8, 0)	NO	This attribute represents the component number
ondate		DATE	NO	This attribute denotes the start date
next_hard_type		VARCHAR2(1)	NO	This attribute denotes the next hardware type
next_hard_nb		NUMBER(8, 0)	NO	This attribute denotes the next hardware number
next_hard_pchannel		NUMBER(8, 0)	NO	This attribute denotes the next hardware physical channel
azimuth		BINARY_FLOAT	YES	The azimuth of the instrument from north, clockwise
dip		BINARY_FLOAT	YES	The dip of the instrument, down from horizontal
offdate		DATE	YES	This attribute denotes the end date
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

Station_Sensor_Component Primary and Unique Keys

Key Name	Key Type	Keys
StSeC00	PrimaryKey	sta, net, sensor_nb, component_nb, ondate

Station_Sensor_Component Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
Station_Sensor	Identifying	One To Zero or More	Sta_Sen_Com_Sta_Sen			sta, net, sensor_nb, ondate	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

Station_Sensor_Component Check Constraints

Check Constraint Name	CheckConstraint
StSeC01	azimuth >= 0.0 AND azimuth <= 360.0
StSeC02	component_nb >= 1
StSec03	dip >= -90.0 AND dip <= 90.0
StSec04	next_hard_nb >= 1
StSec05	next_hard_pchannel >= 1
StSec06	next_hard_type IN ('F','D')
StSec07	sensor_nb >= 1