Decimation Columns

ColumnName	Domain	Datatype	NULL	Definition
net		VARCHAR2(8)	NO	Unique network identifier. This character string is the name of a seismic network
sta		VARCHAR2(6)	NO	Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
seedchan		VARCHAR2(3)	NO	SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
location		VARCHAR2(2)	NO	Describes the individual sites on an array station, operated by the same network operator
ondate		DATE	NO	This attribute denotes the start date
stage_seq		NUMBER(8, 0)	NO	This attribute denotes the stage number
channel		VARCHAR2(8)	YES	Channel name
channelsrc		VARCHAR2(8)	YES	Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.)
offdate		DATE	YES	This attribute denotes the end date
dm_key		NUMBER(8, 0)	NO	Decimation key
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

Decimation Primary and Unique Keys

Key Name	Key Type	Keys
De00	PrimaryKey	net, sta, seedchan, location, ondate, stage_seq

Decimation Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
Channel_Data	Identifying	One To Zero or More	Dec_Cha_Dat			net, sta, seedchan, location, ondate	NO	NO	NO
DM	Non-Identifying	One To Zero or More	Dec_DM			dm_key	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

Decimation Check Constraints

Check Constraint Name	CheckConstraint
De01	stage_seq >= 0