Station_Filamp_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
filamp_nb		NUMBER(8, 0)	NO	This attribute represents the filter-amplifier number
pchannel_nb		NUMBER(8, 0)	NO	This attribute denotes a physical channel
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
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_Filamp_PChannel Primary and Unique Keys

Key Name	Key Type	Keys
StFiP00	PrimaryKey	sta, net, filamp_nb, pchannel_nb, ondate

Station_Filamp_PChannel Foreign Keys

Parent Relationships:

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

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

Station_Filamp_PChannel Check Constraints

Check Constraint Name	CheckConstraint
StFiP01	filamp_nb >= 1
StFiP02	next_hard_nb >= 1
StFiP03	next_hard_pchannel >= 1
StFiP04	next_hard_type IN ('F','D')
StFiP05	pchannel_nb >= 1