Channel_Comment
EntityType Dependent
Logical Table Name Channel_Comment
Owner
Definition Comments for a channel
Note

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
comment_id(PK)(FK) NUMERIC(8, 0) NO The comment code key of the associated Comment Description Dictionary
channel VARCHAR(3) 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
comment_level NUMERIC(8, 0) NO The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys
Key Name Key Type Keys
ChC00 PrimaryKey net,sta,seedchan,location,ondate,comment_id

Relationships
Parent Entity Child Entity Type Foreign Keys
Channel_Data Channel_Comment Identifying net,sta,seedchan,location,ondate
D_Comment Channel_Comment Identifying comment_id

Attachments
Name Datatype Value Override Default Value Description

Channel_Data
EntityType Dependent
Logical Table Name Channel_Data
Owner
Definition Summary information on a channel
Note

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) 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) 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
channel VARCHAR(3) 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.)
inid(FK) NUMERIC(8, 0) YES Instrument identifier. It refers to the Generic Abbreviation Dictionary, that contains a name for this instrument
remark VARCHAR(30) YES An optional comment given to the instrument. It can be anything, including a serial number or a notation of special modifications
unit_signal(FK) NUMERIC(8, 0) NO A unit lookup key that refers to the Units Abbreviation Dictionary for the signal response of the instrument – usually the ground motion response, or something else for non-seismic devices
unit_calib(FK) NUMERIC(8, 0) NO A unit lookup key that refers to the Units Abbreviation Dictionary for the units of calibration input, usually volts or amps
lat FLOAT YES Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
lon FLOAT YES Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
elev FLOAT YES Elevation. This attribute is the elevation of a seismic station relative to mean sea level
edepth FLOAT YES Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev
azimuth FLOAT YES The azimuth of the instrument from north, clockwise
dip FLOAT YES The dip of the instrument, down from horizontal
format_id(FK) NUMERIC(8, 0) NO A data format lookup key that refers to the Data Format Dictionary that describes the format of the data in the data section for this channel
record_length NUMERIC(8, 0) YES The exponent (as a power of two) of the record length for these data
samprate FLOAT NO Sampling rate. This attribute is the sample rate in samples/second
clock_drift FLOAT YES A tolerance value, measured in seconds per sample, used as a thresold for time error detection in the data. The number of samples in a record are multiplied by this value to calculate a maximum drift allowed for the time in the next record. If the difference in time is less than this drift, consider them in the same time series
flags VARCHAR(27) YES Channel flags
offdate DATE YES This attribute denotes the end date
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys
Key Name Key Type Keys
ChD00 PrimaryKey net,sta,seedchan,location,ondate

Relationships
Parent Entity Child Entity Type Foreign Keys
D_Abbreviation Channel_Data Non-Identifying inid
D_Format Channel_Data Non-Identifying format_id
D_Unit Channel_Data Non-Identifying unit_signal
D_Unit Channel_Data Non-Identifying unit_calib
Station_Data Channel_Data Identifying net,sta,ondate
Channel_Data Channel_Comment Identifying net,sta,seedchan,location,ondate
Channel_Data Coefficients Identifying net,sta,seedchan,location,ondate
Channel_Data Decimation Identifying net,sta,seedchan,location,ondate
Channel_Data Polynomial Identifying net,sta,seedchan,location,ondate
Channel_Data Poles_Zeros Identifying net,sta,seedchan,location,ondate
Channel_Data Sensitivity Identifying net,sta,seedchan,location,ondate
Channel_Data Simple_Response Identifying net,sta,seedchan,location,ondate

Attachments
Name Datatype Value Override Default Value Description

Coefficients
EntityType Dependent
Logical Table Name Coefficients
Owner
Definition Data associating a channel with a response
Note

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(3) 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
dc_key(FK) NUMERIC(8, 0) YES Response (Coefficients) key
unit_in(FK) NUMERIC(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(FK) NUMERIC(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 VARCHAR(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

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

Relationships
Parent Entity Child Entity Type Foreign Keys
Channel_Data Coefficients Identifying net,sta,seedchan,location,ondate
D_Unit Coefficients Non-Identifying unit_in
D_Unit Coefficients Non-Identifying unit_out
DC Coefficients Non-Identifying dc_key

Attachments
Name Datatype Value Override Default Value Description

D_Abbreviation
EntityType Independent
Logical Table Name D_Abbreviation
Owner
Definition Abbreviation dictionary
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
id(PK) NUMERIC(8, 0) NO A cross reference code to indicate this particular dictionary entry
description VARCHAR(70) YES This is a description of an abbreviation

Keys
Key Name Key Type Keys
D_A00 PrimaryKey id

Relationships
Parent Entity Child Entity Type Foreign Keys
D_Abbreviation Channel_Data Non-Identifying inid
D_Abbreviation Station_Data Non-Identifying net_id

Attachments
Name Datatype Value Override Default Value Description

D_Comment
EntityType Independent
Logical Table Name D_Comment
Owner
Definition Comment dictionary
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
id(PK) NUMERIC(8, 0) NO A cross reference code to indicate this particular dictionary entry
class VARCHAR(1) NO A single letter that determines to what the code refers
description VARCHAR(70) YES This is a description of a comment
unit NUMERIC(8, 0) NO Units of comment level

Keys
Key Name Key Type Keys
D_C00 PrimaryKey id

Relationships
Parent Entity Child Entity Type Foreign Keys
D_Comment Channel_Comment Identifying comment_id
D_Comment Station_Comment Identifying comment_id

Attachments
Name Datatype Value Override Default Value Description

D_Format
EntityType Independent
Logical Table Name D_Format
Owner
Definition Format dictionary
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
id(PK) NUMERIC(8, 0) NO A cross reference code to indicate this particular dictionary entry
name VARCHAR(80) YES Descriptive name
family NUMERIC(8, 0) NO This field is used by the data decoder to describe the data family type. It tells a potential program what general algorithm to use to decode the associated data. Each algorithm requires some number of decoder keys that contain special additional information, enabling the algorithm to decode the data
ms_id NUMERIC(8, 0) NO This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group

Keys
Key Name Key Type Keys
D_F00 PrimaryKey id

Relationships
Parent Entity Child Entity Type Foreign Keys
D_Format Channel_Data Non-Identifying format_id
D_Format D_Format_Data Identifying id

Attachments
Name Datatype Value Override Default Value Description

D_Format_Data
EntityType Dependent
Logical Table Name D_Format_Data
Owner
Definition Format data
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
id(PK)(FK) NUMERIC(8, 0) NO A cross reference code to indicate this particular dictionary entry
row_id(PK) NUMERIC(8, 0) NO Row identifier for the decoder keys
key_d VARCHAR(80) NO This attribute denotes the decoder keys used by the data family type

Keys
Key Name Key Type Keys
D_F_D00 PrimaryKey id,row_id

Relationships
Parent Entity Child Entity Type Foreign Keys
D_Format D_Format_Data Identifying id

Attachments
Name Datatype Value Override Default Value Description

D_Unit
EntityType Independent
Logical Table Name D_Unit
Owner
Definition Unit dictionary
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
id(PK) NUMERIC(8, 0) NO A cross reference code to indicate this particular dictionary entry
name VARCHAR(80) YES Descriptive name
description VARCHAR(70) YES This is a description of a unit

Keys
Key Name Key Type Keys
D_U00 PrimaryKey id

Relationships
Parent Entity Child Entity Type Foreign Keys
D_Unit Channel_Data Non-Identifying unit_signal
D_Unit Channel_Data Non-Identifying unit_calib
D_Unit Coefficients Non-Identifying unit_in
D_Unit Coefficients Non-Identifying unit_out
D_Unit Polynomial Non-Identifying unit_in
D_Unit Polynomial Non-Identifying unit_out
D_Unit Poles_Zeros Non-Identifying unit_in
D_Unit Poles_Zeros Non-Identifying unit_out

Attachments
Name Datatype Value Override Default Value Description

DC
EntityType Independent
Logical Table Name DC
Owner
Definition Summary information on a response (Coefficients)
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
key(PK) NUMERIC(8, 0) NO This attribute denotes a unique identifier for a response (digital coefficients)
name VARCHAR(80) YES Descriptive name
symmetry VARCHAR(1) YES This attribute denotes the eventual symmetry of a response
storage VARCHAR(1) YES This attribute denotes if half or all the coefficients are stored in the DC_Data table
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys
Key Name Key Type Keys
DC00 PrimaryKey key

Relationships
Parent Entity Child Entity Type Foreign Keys
DC Coefficients Non-Identifying dc_key
DC DC_Data Identifying key

Attachments
Name Datatype Value Override Default Value Description

DC_Data
EntityType Dependent
Logical Table Name DC_Data
Owner
Definition Coefficients of a response
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
key(PK)(FK) NUMERIC(8, 0) NO This attribute denotes a unique identifier for a response (digital coefficients)
row_key(PK) NUMERIC(8, 0) NO Row key for responses
type VARCHAR(1) YES This attribute denotes whether a value is associated with a numerator/denominator
coefficient FLOAT NO The numerator/denominator coefficient value
error FLOAT YES This attribute denotes the numerator/denominator error

Keys
Key Name Key Type Keys
DCD00 PrimaryKey key,row_key

Relationships
Parent Entity Child Entity Type Foreign Keys
DC DC_Data Identifying key

Attachments
Name Datatype Value Override Default Value Description

Decimation
EntityType Dependent
Logical Table Name Decimation
Owner
Definition Data associating a channel with a decimation
Note

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(3) 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

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

Relationships
Parent Entity Child Entity Type Foreign Keys
Channel_Data Decimation Identifying net,sta,seedchan,location,ondate
DM Decimation Non-Identifying dm_key

Attachments
Name Datatype Value Override Default Value Description

DM
EntityType Independent
Logical Table Name DM
Owner
Definition Summary information on a decimation
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
key(PK) NUMERIC(8, 0) NO This attribute denotes a unique identifier for a decimation
name VARCHAR(80) YES Descriptive name
samprate FLOAT NO Sampling rate. This attribute is the sample rate in samples/second
factor NUMERIC(8, 0) NO The decimation factor. When this number of samples are read in, one final sample comes out. The output sample rate can be calculated by dividing samprate by the decimation factor
offset NUMERIC(8, 0) YES This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor
delay FLOAT YES The estimated pure delay for the stage
correction FLOAT NO The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion.This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys
Key Name Key Type Keys
DM00 PrimaryKey key

Relationships
Parent Entity Child Entity Type Foreign Keys
DM Decimation Non-Identifying dm_key

Attachments
Name Datatype Value Override Default Value Description

PN
EntityType Independent
Logical Table Name PN
Owner
Definition Summary information on a response (Polynomial)
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
key(PK) NUMERIC(8, 0) NO This attribute denotes a unique identifier for a response (poles & zeros)
name VARCHAR(80) YES Descriptive name
poly_type VARCHAR(1) YES This attribute represents the type of polynomial approximation
lower_bound FLOAT YES This attribute denotes the polynomial lower bound
upper_bound FLOAT YES This attribute denotes the polynomial upper bound
max_error FLOAT YES This attribute represents the maximum error of polynomial approximation
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys
Key Name Key Type Keys
PN00 PrimaryKey key

Relationships
Parent Entity Child Entity Type Foreign Keys
PN PN_Data Identifying key
PN Polynomial Non-Identifying pn_key

Attachments
Name Datatype Value Override Default Value Description

PN_Data
EntityType Dependent
Logical Table Name PN_Data
Owner
Definition Coefficients of a polynomial
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
key(PK)(FK) NUMERIC(8, 0) NO This attribute denotes a unique identifier for a response (poles & zeros)
row_key(PK) NUMERIC(8, 0) NO Row key for responses
pn_value FLOAT YES This attribute denotes the coefficient value of a polynomial

Keys
Key Name Key Type Keys
PND00 PrimaryKey key,row_key

Relationships
Parent Entity Child Entity Type Foreign Keys
PN PN_Data Identifying key

Attachments
Name Datatype Value Override Default Value Description

Poles_Zeros
EntityType Dependent
Logical Table Name Poles_Zeros
Owner
Definition Data associating a channel with poles & zeros
Note

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(3) 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
pz_key(FK) NUMERIC(8, 0) NO Response (Poles & zeros) key
tf_type VARCHAR(1) YES A single character describing the type of stage
unit_in(FK) NUMERIC(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(FK) NUMERIC(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
AO FLOAT NO This field is mandatory and must be set such that when the polynomial is evaluated at the reference frequency the result will be 1
AF FLOAT YES Frequency fn, at which the value in field AO is normalized (if any)
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

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

Relationships
Parent Entity Child Entity Type Foreign Keys
Channel_Data Poles_Zeros Identifying net,sta,seedchan,location,ondate
D_Unit Poles_Zeros Non-Identifying unit_in
D_Unit Poles_Zeros Non-Identifying unit_out
PZ Poles_Zeros Non-Identifying pz_key

Attachments
Name Datatype Value Override Default Value Description

Polynomial
EntityType Dependent
Logical Table Name Polynomial
Owner
Definition Data associating a channel with a polynomial
Note

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(3) 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
pn_key(FK) NUMERIC(8, 0) NO Response (Polynomial) key
unit_in(FK) NUMERIC(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(FK) NUMERIC(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 VARCHAR(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

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

Relationships
Parent Entity Child Entity Type Foreign Keys
Channel_Data Polynomial Identifying net,sta,seedchan,location,ondate
D_Unit Polynomial Non-Identifying unit_in
D_Unit Polynomial Non-Identifying unit_out
PN Polynomial Non-Identifying pn_key

Attachments
Name Datatype Value Override Default Value Description

PZ
EntityType Independent
Logical Table Name PZ
Owner
Definition Summary information on a response (Poles & Zeros)
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
key(PK) NUMERIC(8, 0) NO This attribute denotes a unique identifier for a response (poles & zeros)
name VARCHAR(80) YES Descriptive name
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys
Key Name Key Type Keys
PZ00 PrimaryKey key

Relationships
Parent Entity Child Entity Type Foreign Keys
PZ Poles_Zeros Non-Identifying pz_key
PZ PZ_Data Identifying key

Attachments
Name Datatype Value Override Default Value Description

PZ_Data
EntityType Dependent
Logical Table Name PZ_Data
Owner
Definition Poles & zeros of a response
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
key(PK)(FK) NUMERIC(8, 0) NO This attribute denotes a unique identifier for a response (poles & zeros)
row_key(PK) NUMERIC(8, 0) NO Row key for responses
type VARCHAR(1) YES This attribute denotes whether a value is associated with a pole/zero
r_value FLOAT NO The real portion of a complex pole/zero
r_error FLOAT YES The error value for the real portion of a complex pole/zero
i_value FLOAT NO The imaginary portion of a complex pole/zero
i_error FLOAT YES The error value for the imaginary portion of a complex pole/zero

Keys
Key Name Key Type Keys
PZD00 PrimaryKey key,row_key

Relationships
Parent Entity Child Entity Type Foreign Keys
PZ PZ_Data Identifying key

Attachments
Name Datatype Value Override Default Value Description

Sensitivity
EntityType Dependent
Logical Table Name Sensitivity
Owner
Definition Data associating a channel with a sensitivity
Note

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(3) 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
sensitivity FLOAT NO The gain (Sd) at this stage, or the sensitivity (Sd) for the channel
frequency 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

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

Relationships
Parent Entity Child Entity Type Foreign Keys
Channel_Data Sensitivity Identifying net,sta,seedchan,location,ondate

Attachments
Name Datatype Value Override Default Value Description

Simple_Response
EntityType Dependent
Logical Table Name Simple_Response
Owner
Definition Summary information on a simplified response
Note

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
channel VARCHAR(3) 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) YES 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

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

Relationships
Parent Entity Child Entity Type Foreign Keys
Channel_Data Simple_Response Identifying net,sta,seedchan,location,ondate

Attachments
Name Datatype Value Override Default Value Description

Station_Comment
EntityType Dependent
Logical Table Name Station_Comment
Owner
Definition Comments for a station
Note

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
ondate(PK)(FK) DATE NO This attribute denotes the start date
comment_id(PK)(FK) NUMERIC(8, 0) NO The comment code key of the associated Comment Description Dictionary
offdate DATE YES This attribute denotes the end date
comment_level NUMERIC(8, 0) YES The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys
Key Name Key Type Keys
StC00 PrimaryKey net,sta,ondate,comment_id

Relationships
Parent Entity Child Entity Type Foreign Keys
D_Comment Station_Comment Identifying comment_id
Station_Data Station_Comment Identifying net,sta,ondate

Attachments
Name Datatype Value Override Default Value Description

Station_Data
EntityType Independent
Logical Table Name Station_Data
Owner
Definition Summary information on a station
Note

Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
net(PK) VARCHAR(8) NO Unique network identifier. This character string is the name of a seismic network
sta(PK) VARCHAR(6) NO Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
ondate(PK) DATE NO This attribute denotes the start date
lat FLOAT YES Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
lon FLOAT YES Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
elev FLOAT YES Elevation. This attribute is the elevation of a seismic station relative to mean sea level
staname VARCHAR(50) YES Station name/description. This is the full name of the station whose code-name is in sta
net_id(FK) NUMERIC(8, 0) YES The abbreviation lookup code from the Generic Abbreviation Dictionary, that refers to the network to which the station belongs
word_32 NUMERIC(8, 0) NO The swap order in which 32-bit quantities are specified in the data headers
word_16 NUMERIC(8, 0) NO 16-bit quantity byte swapping order, for the data headers only
offdate DATE YES This attribute denotes the end date
lddate DATE YES Load date. Date and time that the record was created or last modified, in Oracle date datatype

Keys
Key Name Key Type Keys
StD00 PrimaryKey net,sta,ondate

Relationships
Parent Entity Child Entity Type Foreign Keys
D_Abbreviation Station_Data Non-Identifying net_id
Station_Data Channel_Data Identifying net,sta,ondate
Station_Data Station_Comment Identifying net,sta,ondate

Attachments
Name Datatype Value Override Default Value Description