Station_Datalogger_LChannel

Logical Entity Name | Station_Datalogger_LChannel
Default Table Name | Station_Datalogger_LChannel
Definition | Summary information on a channel

Station_Datalogger_LChannel Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
data_nb |  | NUMERIC(8, 0) | NO | This attribute represents the datalogger number
pchannel_nb |  | NUMERIC(8, 0) | NO | This attribute denotes a physical channel
lchannel_nb |  | NUMERIC(8, 0) | NO | This attribute denotes a logical channel of a datalogger
ondate |  | DATE | NO | This attribute denotes the start date
seqfil_id |  | NUMERIC(8, 0) | YES | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database
seedchan |  | VARCHAR(3) | YES | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
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, ...)
location |  | VARCHAR(2) | YES | Describes the individual sites on an array station, operated by the same network operator
rgain |  | FLOAT | YES | This attribute denotes the gain at the response frequency
rfrequency |  | FLOAT | YES | The frequency (fs) at which the value in rgain is correct
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
data_format |  | VARCHAR(80) | NO | This attribute represents the data format
comp_type |  | NUMERIC(8, 0) | NO | Compression type. A lookup key that refers to the Format Dictionary
unit_signal |  | 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 |  | 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
block_size |  | NUMERIC(8, 0) | NO | The record length of the data
offdate |  | DATE | YES | This attribute denotes the end date
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
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Station_Datalogger_LChannel Keys

Key Name | Key Type | Keys
StDaL00 | PrimaryKey | sta, net, data_nb, pchannel_nb, lchannel_nb, ondate

Station_Datalogger_LChannel Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Filter_Sequence | Non-Identifying | Zero or One to Zero or More |  |  |  | seqfil_id | NO
Station_Datalogger_PChannel | Identifying | One To Zero or More |  |  |  | sta, net, data_nb, pchannel_nb, ondate | NO

Child Relationships:

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

Station_Datalogger_LChannel Check Constraints

Check Constraint Name | CheckConstraint
StDaL01 | block_size >= 256 AND block_size <= 4096
StDaL02 | clock_drift >= 0.0
StDaL03 | data_nb >= 1
StDaL04 | lchannel_nb >= 1
StDaL05 | pchannel_nb >= 1
StDaL06 | rfrequency > 0.0