Decimation 
Logical Entity Name  Decimation 
Default Table Name  Decimation 
Definition  Data associating a channel with a decimation 

Decimation Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
net(PK)(FK)    VARCHAR(8)  NO  Unique network identifier. This character string is the name of a seismic network 
sta(PK)(FK)    VARCHAR(6)  NO  Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used 
seedchan(PK)(FK)    VARCHAR(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(PK)(FK)    VARCHAR(2)  NO  Describes the individual sites on an array station, operated by the same network operator 
ondate(PK)(FK)    DATE  NO  This attribute denotes the start date 
stage_seq(PK)    NUMERIC(8, 0)  NO  This attribute denotes the stage number 
channel    VARCHAR(8)  YES  Channel name 
channelsrc    VARCHAR(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(FK)    NUMERIC(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 Keys 
Key Name  Key Type  Keys 
De00  PrimaryKey  net, sta, seedchan, location, ondate, stage_seq 

Decimation Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Channel_Data  Identifying  One To Zero or More        net, sta, seedchan, location, ondate  NO 
DM  Non-Identifying  One To Zero or More        dm_key  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

Decimation Check Constraints 
Check Constraint Name  CheckConstraint 
De01  stage_seq >= 0