Station_Digitizer Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
sta		VARCHAR(6)	NO	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net		VARCHAR(8)	NO	Unique network identifier. This character string is the name of a seismic network
digi_nb		NUMERIC(8, 0)	NO	This attribute represents the digitizer number
ondate		DATE	NO	This attribute denotes the start date
serial_nb		VARCHAR(80)	NO	This attribute denotes a serial number of a datalogger board
nb_pri_pchannel		NUMERIC(8, 0)	NO	This attribute denotes the number of primary physical channels of a digitizer
nb_aux_pchannel		NUMERIC(8, 0)	NO	This attribute denotes the number of auxiliary physical channels of a digitizer
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_Digitizer Keys

Key Name	Key Type	Keys
StDi00	PrimaryKey	sta, net, digi_nb, ondate

Station_Digitizer Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Station	Identifying	One To Zero or More				sta, net, ondate	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Datalogger_Board	Non-Specific						NO
Station_Digitizer_PChannel	Identifying	One To Zero or More					NO

Station_Digitizer Check Constraints

Check Constraint Name	CheckConstraint
StDi01	digi_nb >= 1
StDi02	nb_aux_pchannel >= 0
StDi03	nb_pri_pchannel >= 0