Simple_Response

Logical Entity Name | Simple_Response
Default Table Name | Simple_Response
Definition | Summary information on a simplified response

Simple_Response Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
seedchan |  | 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 |  | VARCHAR(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
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.)
natural_frequency |  | FLOAT | YES | Natural frequency
damping_constant |  | FLOAT | YES | This attribute denotes the damping constant of the system
gain |  | FLOAT | YES | This attribute denotes the gain of the system. The units of the gain are given by the gain_units attribute
gain_units |  | VARCHAR(20) | NO | This attribute denotes the units of the gain of the system, as given by the gain attribute
low_freq_corner |  | FLOAT | YES | Low frequency corner
high_freq_corner |  | FLOAT | YES | High frequency corner
offdate |  | DATE | YES | This attribute denotes the end date
dlogsens |  | NUMERIC(8, 0) | YES | Digitizer sensitivity
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Simple_Response Keys

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

Simple_Response 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

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

Simple_Response Check Constraints

Check Constraint Name | CheckConstraint
SiRe01 | natural_frequency >= 0.0
SiRe02 | gain_units IN ('DU/M/S','DU/M/S**2','counts/(cm/sec)','counts/(cm/sec2)')