Sensitivity

Logical Entity Name | Sensitivity
Default Table Name | Sensitivity
Definition | Data associating a channel with a sensitivity

Sensitivity 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
sensitivity |  | BINARY_FLOAT | NO | The gain (Sd) at this stage, or the sensitivity (Sd) for the channel
frequency |  | BINARY_FLOAT | YES | The frequency (fs) at which the value in sensitivity is correct
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Sensitivity Primary and Unique Keys

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

Sensitivity 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 | Sen_Cha_Dat |  |  | net, sta, seedchan, location, ondate | NO | NO | NO

Child Relationships:

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

Sensitivity Check Constraints

Check Constraint Name | CheckConstraint
Se01 | frequency >= 0.0
Se02 | stage_seq >= 0