Station_Digitizer_PChannel 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
digi_nb		NUMBER(8, 0)	NO	This attribute represents the digitizer number
pchannel_nb		NUMBER(8, 0)	NO	This attribute denotes a physical channel
ondate		DATE	NO	This attribute denotes the start date
data_nb		NUMBER(8, 0)	NO	This attribute represents the datalogger number
data_pchannel		NUMBER(8, 0)	NO	This attribute represents a datalogger physical channel
digi_type		VARCHAR2(3)	NO	This attribute represents the digitizer type
digi_polarity		VARCHAR2(1)	NO	This attribute represents the digitizer polarity
digi_channel		NUMBER(8, 0)	NO	This attribute represents a digitizer module on a board
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_PChannel Primary and Unique Keys

Key Name	Key Type	Keys
StDiP00	PrimaryKey	sta, net, digi_nb, pchannel_nb, ondate

Station_Digitizer_PChannel Foreign Keys

Parent Relationships:

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

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

Station_Digitizer_PChannel Check Constraints

Check Constraint Name	CheckConstraint
StDiP01	data_nb >= 1
StDiP02	data_pchannel >= 1
StDiP03	digi_nb >= 1
StDiP05	pchannel_nb >= 1