Station_Datalogger 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
data_nb		NUMBER(8, 0)	NO	This attribute represents the datalogger number
ondate		DATE	NO	This attribute denotes the start date
data_id		NUMBER(8, 0)	NO	Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
nb_pchannel		NUMBER(8, 0)	NO	This attribute denotes the number of physical channels of a datalogger
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_Datalogger Primary and Unique Keys

Key Name	Key Type	Keys
StDa00	PrimaryKey	sta, net, data_nb, ondate

Station_Datalogger Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
Datalogger	Non-Identifying	One To Zero or More	Sta_Dat_Dat			data_id	NO	NO	NO
Station	Identifying	One To Zero or More	Sta_Dat_Sta			sta, net, ondate	NO	NO	NO

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable	Initially Deferred
Station_Datalogger_PChannel	Identifying	One To Zero or More	Sta_Dat_PCh_Sta_Dat				NO	NO	NO

Station_Datalogger Check Constraints

Check Constraint Name	CheckConstraint
StDa01	data_nb >= 1
StDa02	nb_pchannel >= 0