Coefficients

Logical Entity Name | Coefficients
Default Table Name | Coefficients
Definition | Data associating a channel with a response

Coefficients 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
dc_key |  | NUMBER(8, 0) | YES | Response (Coefficients) key
unit_in |  | NUMBER(8, 0) | NO | A unit lookup key that refers to the Units Abbreviation Dictionary for the units of the incoming to this stage of the filter. This signal will usually be ground motion, volts, or counts, depending on where it is in the filter system
unit_out |  | NUMBER(8, 0) | NO | A unit lookup key that refers to the Units Abbreviation Dictionary for the stage’s output signal. Analog filters usually emit volts, and digital filters usually emit counts
tf_type |  | VARCHAR2(1) | YES | A single character describing the type of stage
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Coefficients Primary and Unique Keys

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

Coefficients 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 | Coe_Cha_Dat |  |  | net, sta, seedchan, location, ondate | NO | NO | NO
D_Unit | Non-Identifying | One To Zero or More | Coe_D_Uni |  |  | unit_in | NO | NO | NO
D_Unit | Non-Identifying | One To Zero or More | Coe_D_Uni2 |  |  | unit_out | NO | NO | NO
DC | Non-Identifying | Zero or One to Zero or More | Coe_DC |  |  | dc_key | NO | NO | NO

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred

Coefficients Check Constraints

Check Constraint Name | CheckConstraint
Co01 | stage_seq >= 0
Co02 | tf_type IN ('A','B','C','D','P')