Datalogger

Owner |
Definition | Summary information on a datalogger
Note | ``
DDL Code | CREATE TABLE Datalogger( `data_id NUMBER(8, 0) NOT NULL,` `data_type VARCHAR2(80),` `serial_nb VARCHAR2(80),` `firmware_nb VARCHAR2(80),` `software VARCHAR2(80),` `software_nb VARCHAR2(80),` `ondate DATE NOT NULL,` `offdate DATE,` `nb_board NUMBER(8, 0),` `word_32 NUMBER(8, 0) NOT NULL,` `word_16 NUMBER(8, 0) NOT NULL,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT Da01 CHECK (nb_board >= 0),` `CONSTRAINT Da00 PRIMARY KEY (data_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
data_id |  | NUMBER(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
data_type |  | VARCHAR2(80) | YES | This attribute represents a datalogger type
serial_nb |  | VARCHAR2(80) | YES | This attribute denotes a serial number of a datalogger
firmware_nb |  | VARCHAR2(80) | YES | This attribute describes the firmware number of a datalogger
software |  | VARCHAR2(80) | YES | Datalogger’s software (mshear, ushear, ...)
software_nb |  | VARCHAR2(80) | YES | Datalogger’s software version number
ondate |  | DATE | NO | This attribute denotes the start date
offdate |  | DATE | YES | This attribute denotes the end date
nb_board |  | NUMBER(8, 0) | YES | This attribute denotes the number of boards of a datalogger
word_32 |  | NUMBER(8, 0) | NO | The swap order in which 32-bit quantities are specified in the data headers
word_16 |  | NUMBER(8, 0) | NO | 16-bit quantity byte swapping order, for the data headers only
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
Da00 | PrimaryKey | data_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Datalogger | Datalogger_Board | Identifying | data_id
Datalogger | Station_Datalogger | Non-Identifying | data_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION | Heap
CACHE | NO
LOGGING | Logged
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS | FreeLists
FREELIST GROUPS | FreeList Groups
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Datalogger_Board

Owner |
Definition | Board of a datalogger
Note | ``
DDL Code | CREATE TABLE Datalogger_Board( `data_id NUMBER(8, 0) NOT NULL,` `board_nb NUMBER(8, 0) NOT NULL,` `serial_nb VARCHAR2(80),` `nb_module NUMBER(8, 0) NOT NULL,` `firmware_nb VARCHAR2(80),` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT DaB01 CHECK (board_nb >= 1),` `CONSTRAINT DaB02 CHECK (nb_module >= 0),` `CONSTRAINT DaB00 PRIMARY KEY (data_id, board_nb),` `CONSTRAINT Dat_Boa_Dat FOREIGN KEY (data_id)` `REFERENCES Datalogger(data_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
data_id |  | NUMBER(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
board_nb |  | NUMBER(8, 0) | NO | This attribute denotes the number of boards of a datalogger
serial_nb |  | VARCHAR2(80) | YES | This attribute denotes a serial number of a datalogger board
nb_module |  | NUMBER(8, 0) | NO | This attribute denotes the number of modules of a datalogger’s board
firmware_nb |  | VARCHAR2(80) | YES | This attribute describes the firmware number of a datalogger
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
DaB00 | PrimaryKey | data_id,board_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Datalogger | Datalogger_Board | Identifying | data_id
Datalogger_Board | Datalogger_Module | Identifying | data_id,board_nb

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Datalogger_Module

Owner |
Definition | Module of a datalogger’s board
Note | ``
DDL Code | CREATE TABLE Datalogger_Module( `data_id NUMBER(8, 0) NOT NULL,` `board_nb NUMBER(8, 0) NOT NULL,` `module_nb NUMBER(8, 0) NOT NULL,` `serial_nb VARCHAR2(80),` `firmware_nb VARCHAR2(80),` `sensitivity DOUBLE PRECISION,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT DaM01 CHECK (board_nb >= 1),` `CONSTRAINT DaM02 CHECK (module_nb >= 1),` `CONSTRAINT DaM00 PRIMARY KEY (data_id, board_nb, module_nb),` `CONSTRAINT Dat_Mod_Dat_Boa FOREIGN KEY (data_id,board_nb)` `REFERENCES Datalogger_Board(data_id,board_nb)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
data_id |  | NUMBER(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
board_nb |  | NUMBER(8, 0) | NO | This attribute denotes the number of boards of a datalogger
module_nb |  | NUMBER(8, 0) | NO | This attribute represents the module number of a datalogger’s board
serial_nb |  | VARCHAR2(80) | YES | This attribute denotes a serial number of a datalogger module
firmware_nb |  | VARCHAR2(80) | YES | This attribute describes the firmware number of a datalogger
sensitivity |  | DOUBLE PRECISION | YES | This attribute denotes the sensitivity (Sd) for a sensor or a digitizer
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
DaM00 | PrimaryKey | data_id,board_nb,module_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Datalogger_Board | Datalogger_Module | Identifying | data_id,board_nb

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Filamp

Owner |
Definition | Summary information on a filter-amplifier
Note | ``
DDL Code | CREATE TABLE Filamp( `filamp_id NUMBER(8, 0) NOT NULL,` `name VARCHAR2(80),` `serial_nb VARCHAR2(80),` `ondate DATE NOT NULL,` `offdate DATE,` `nb_pchannel NUMBER(8, 0) NOT NULL,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT Filamp01 CHECK (nb_pchannel >= 0),` `CONSTRAINT Filamp00 PRIMARY KEY (filamp_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
filamp_id |  | NUMBER(8, 0) | NO | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
name |  | VARCHAR2(80) | YES | This attribute denotes a descriptive name for a filter-amplifier
serial_nb |  | VARCHAR2(80) | YES | This attribute denotes a serial number of a filter-amplifier
ondate |  | DATE | NO | This attribute denotes the start date
offdate |  | DATE | YES | This attribute denotes the end date
nb_pchannel |  | NUMBER(8, 0) | NO | This attribute denotes the number of physical channels of a datalogger
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
Filamp00 | PrimaryKey | filamp_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filamp | Filamp_PChannel | Identifying | filamp_id
Filamp | Station_Filamp | Non-Identifying | filamp_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Filamp_PChannel

Owner |
Definition | Physical channel of a filter-amplifier
Note | ``
DDL Code | CREATE TABLE Filamp_PChannel( `filamp_id NUMBER(8, 0) NOT NULL,` `pchannel_nb NUMBER(8, 0) NOT NULL,` `gain DOUBLE PRECISION,` `frequency DOUBLE PRECISION,` `seqresp_id NUMBER(8, 0),` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT FiP01 CHECK (pchannel_nb >= 1),` `CONSTRAINT FiP00 PRIMARY KEY (filamp_id, pchannel_nb),` `CONSTRAINT Fil_PCh_Fil FOREIGN KEY (filamp_id)` `REFERENCES Filamp(filamp_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
filamp_id |  | NUMBER(8, 0) | NO | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
pchannel_nb |  | NUMBER(8, 0) | NO | This attribute denotes a physical channel
gain |  | DOUBLE PRECISION | YES | This attribute denotes the gain
frequency |  | DOUBLE PRECISION | YES | The frequency (fs) at which the value in sensitivity/gain is correct
seqresp_id |  | NUMBER(8, 0) | YES | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
FiP00 | PrimaryKey | filamp_id,pchannel_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filamp | Filamp_PChannel | Identifying | filamp_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter

Owner |
Definition | Summary information on a filter
Note | ``
DDL Code | CREATE TABLE Filter( `filter_id NUMBER(8, 0) NOT NULL,` `gain DOUBLE PRECISION,` `frequency DOUBLE PRECISION,` `in_sp_rate DOUBLE PRECISION,` `out_sp_rate DOUBLE PRECISION,` `offset NUMBER(8, 0),` `delay DOUBLE PRECISION,` `correction DOUBLE PRECISION NOT NULL,` `seqresp_id NUMBER(8, 0),` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT Fi01 CHECK (frequency >= 0.0),` `CONSTRAINT Fi02 CHECK (in_sp_rate > 0.0),` `CONSTRAINT Fi03 CHECK (out_sp_rate > 0.0),` `CONSTRAINT Fi04 CHECK (offset >= 0),` `CONSTRAINT Fi00 PRIMARY KEY (filter_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
filter_id |  | NUMBER(8, 0) | NO | Filter identifier. Each filter is assigned a unique integer which identifies it in a database
gain |  | DOUBLE PRECISION | YES | This attribute denotes the gain
frequency |  | DOUBLE PRECISION | YES | The frequency (fs) at which the value in sensitivity/gain is correct
in_sp_rate |  | DOUBLE PRECISION | YES | Sampling rate. This attribute is the input sample rate in samples/second
out_sp_rate |  | DOUBLE PRECISION | YES | Sampling rate. This attribute is the output sample rate in samples/second
offset |  | NUMBER(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 |  | DOUBLE PRECISION | YES | The estimated pure delay for the filter
correction |  | DOUBLE PRECISION | 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
seqresp_id |  | NUMBER(8, 0) | YES | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
Fi00 | PrimaryKey | filter_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filter | Filter_Sequence_Data | Non-Identifying | filter_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter_FIR

Owner |
Definition | Summary information on a FIR filter
Note | ``
DDL Code | CREATE TABLE Filter_FIR( `fir_id NUMBER(8, 0) NOT NULL,` `name VARCHAR2(80),` `symmetry VARCHAR2(1) NOT NULL,` `gain DOUBLE PRECISION,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT FFIR01 CHECK (symmetry IN ('E','O','N')),` `CONSTRAINT FFIR00 PRIMARY KEY (fir_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
fir_id |  | NUMBER(8, 0) | NO | FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database
name |  | VARCHAR2(80) | YES | This attribute denotes a descriptive name for a FIR filter
symmetry |  | VARCHAR2(1) | NO | This attribute denotes the eventual symmetry of a response
gain |  | DOUBLE PRECISION | YES | This attribute denotes the gain
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
FFIR00 | PrimaryKey | fir_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filter_FIR | Filter_FIR_Data | Identifying | fir_id
Filter_FIR | Response | Non-Identifying | resp_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter_FIR_Data

Owner |
Definition | Coefficients of a FIR filter
Note | ``
DDL Code | CREATE TABLE Filter_FIR_Data( `fir_id NUMBER(8, 0) NOT NULL,` `coeff_nb NUMBER(8, 0) NOT NULL,` `type VARCHAR2(1) NOT NULL,` `coefficient DOUBLE PRECISION NOT NULL,` `error DOUBLE PRECISION,` `CONSTRAINT FFD01 CHECK (coeff_nb >= 1),` `CONSTRAINT FFD02 CHECK (type IN ('N','D')),` `CONSTRAINT FFD00 PRIMARY KEY (fir_id, coeff_nb),` `CONSTRAINT Fil_FIR_Dat_Fil_FIR FOREIGN KEY (fir_id)` `REFERENCES Filter_FIR(fir_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
fir_id |  | NUMBER(8, 0) | NO | FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database
coeff_nb |  | NUMBER(8, 0) | NO | The numerator/denominator number
type |  | VARCHAR2(1) | NO | This attribute denotes whether a value is associated with a numerator/denominator
coefficient |  | DOUBLE PRECISION | NO | The numerator/denominator coefficient value
error |  | DOUBLE PRECISION | YES | This attributes denotes the numerator/denominator error

Primary and Unique Keys

Key Name | Key Type | Keys
FFD00 | PrimaryKey | fir_id,coeff_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filter_FIR | Filter_FIR_Data | Identifying | fir_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter_Sequence

Owner |
Definition | Summary information on a sequence of filters
Note | ``
DDL Code | CREATE TABLE Filter_Sequence( `seqfil_id NUMBER(8, 0) NOT NULL,` `name VARCHAR2(32) NOT NULL,` `nb_filter NUMBER(8, 0) NOT NULL,` `gain DOUBLE PRECISION,` `frequency DOUBLE PRECISION,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT FiS01 CHECK (frequency >= 0.0),` `CONSTRAINT FiS02 CHECK (nb_filter >= 0),` `CONSTRAINT FiS00 PRIMARY KEY (seqfil_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
seqfil_id |  | NUMBER(8, 0) | NO | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database
name |  | VARCHAR2(32) | NO | This attribute denotes a descriptive name for a chain of filters
nb_filter |  | NUMBER(8, 0) | NO | This attribute denotes the number of filters of a sequence
gain |  | DOUBLE PRECISION | YES | This attribute denotes the gain
frequency |  | DOUBLE PRECISION | YES | The frequency (fs) at which the value in sensitivity/gain is correct
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
FiS00 | PrimaryKey | seqfil_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filter_Sequence | Filter_Sequence_Data | Identifying | seqfil_id
Filter_Sequence | Station_Datalogger_LChannel | Non-Identifying | seqfil_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Filter_Sequence_Data

Owner |
Definition | Filter of a sequence
Note | ``
DDL Code | CREATE TABLE Filter_Sequence_Data( `seqfil_id NUMBER(8, 0) NOT NULL,` `filter_nb NUMBER(8, 0) NOT NULL,` `filter_id NUMBER(8, 0) NOT NULL,` `CONSTRAINT FiSeD01 CHECK (filter_nb >= 1),` `CONSTRAINT FiSeD00 PRIMARY KEY (seqfil_id, filter_nb),` `CONSTRAINT Fil_Seq_Dat_Fil FOREIGN KEY (filter_id)` `REFERENCES Filter(filter_id),` `CONSTRAINT Fil_Seq_Dat_Fil_Seq FOREIGN KEY (seqfil_id)` `REFERENCES Filter_Sequence(seqfil_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
seqfil_id |  | NUMBER(8, 0) | NO | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database
filter_nb |  | NUMBER(8, 0) | NO | This attribute represents the filter number in a sequence
filter_id |  | NUMBER(8, 0) | NO | Filter identifier. Each filter is assigned a unique integer which identifies it in a database

Primary and Unique Keys

Key Name | Key Type | Keys
FiSeD00 | PrimaryKey | seqfil_id,filter_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filter | Filter_Sequence_Data | Non-Identifying | filter_id
Filter_Sequence | Filter_Sequence_Data | Identifying | seqfil_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Response

Owner |
Definition | Summary information on a sequence of responses
Note | ``
DDL Code | CREATE TABLE Response( `seqresp_id NUMBER(8, 0) NOT NULL,` `resp_nb NUMBER(8, 0) NOT NULL,` `resp_type VARCHAR2(1) NOT NULL,` `resp_id NUMBER(8, 0) NOT NULL,` `unit_in NUMBER(8, 0) NOT NULL,` `unit_out NUMBER(8, 0) NOT NULL,` `r_type VARCHAR2(1),` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT Re01 CHECK (r_type IN ('A','B','C','D','P')),` `CONSTRAINT Re02 CHECK (resp_nb >= 1),` `CONSTRAINT Re03 CHECK (resp_type IN ('H','L','P','Z','F','N')),` `CONSTRAINT Re00 PRIMARY KEY (seqresp_id, resp_nb),` `CONSTRAINT Res_Fil_FIR FOREIGN KEY (resp_id)` `REFERENCES Filter_FIR(fir_id),` `CONSTRAINT Res_Res_HP FOREIGN KEY (resp_id)` `REFERENCES Response_HP(hp_id),` `CONSTRAINT Res_Res_LP FOREIGN KEY (resp_id)` `REFERENCES Response_LP(lp_id),` `CONSTRAINT Res_Res_PN FOREIGN KEY (resp_id)` `REFERENCES Response_PN(pn_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
seqresp_id |  | NUMBER(8, 0) | NO | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
resp_nb |  | NUMBER(8, 0) | NO | This attribute denotes the response number of a sequence
resp_type |  | VARCHAR2(1) | NO | This attribute denotes the response type
resp_id |  | NUMBER(8, 0) | NO | Response identifier. Each response is assigned a unique integer which identifies it in a database
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
r_type |  | VARCHAR2(1) | YES | A single character describing the type of response
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
Re00 | PrimaryKey | seqresp_id,resp_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filter_FIR | Response | Non-Identifying | resp_id
Response_HP | Response | Non-Identifying | resp_id
Response_LP | Response | Non-Identifying | resp_id
Response_PN | Response | Non-Identifying | resp_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION | Heap
CACHE | NO
LOGGING | Logged
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS | FreeLists
FREELIST GROUPS | FreeList Groups
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_HP

Owner |
Definition | Summary information on a high-pass filter
Note | ``
DDL Code | CREATE TABLE Response_HP( `hp_id NUMBER(8, 0) NOT NULL,` `filter_type VARCHAR2(2) NOT NULL,` `nb_pole NUMBER(8, 0) NOT NULL,` `corner_freq DOUBLE PRECISION NOT NULL,` `damping_value DOUBLE PRECISION NOT NULL,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT RHP01 CHECK (filter_type IN ('BW','DG','ND')),` `CONSTRAINT RHP02 CHECK (nb_pole > 0),` `CONSTRAINT RHP00 PRIMARY KEY (hp_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
hp_id |  | NUMBER(8, 0) | NO | High-pass filter identifier. Each high-pass filter is assigned a unique integer which identifies it in a database
filter_type |  | VARCHAR2(2) | NO | This attribute denotes the type of a high-pass filter
nb_pole |  | NUMBER(8, 0) | NO | This attribute denotes the number of poles of a high-pass filter
corner_freq |  | DOUBLE PRECISION | NO | This attribute represents the corner frequency of a high-pass filter
damping_value |  | DOUBLE PRECISION | NO | This attribute represents the fraction of critical damping of a high-pass filter
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
RHP00 | PrimaryKey | hp_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Response_HP | Response | Non-Identifying | resp_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_LP

Owner |
Definition | Summary information on a low-pass filter
Note | ``
DDL Code | CREATE TABLE Response_LP( `lp_id NUMBER(8, 0) NOT NULL,` `filter_type VARCHAR2(2),` `nb_pole NUMBER(8, 0),` `corner_freq DOUBLE PRECISION NOT NULL,` `damping_value DOUBLE PRECISION NOT NULL,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT RLP01 CHECK (filter_type IN ('BW','DG','ND')),` `CONSTRAINT RLP02 CHECK (nb_pole > 0),` `CONSTRAINT RLP00 PRIMARY KEY (lp_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
lp_id |  | NUMBER(8, 0) | NO | Low-pass filter identifier. Each low-pass filter is assigned a unique integer which identifies it in a database
filter_type |  | VARCHAR2(2) | YES | This attribute denotes the type of a low-pass filter
nb_pole |  | NUMBER(8, 0) | YES | This attribute denotes the number of poles of a low-pass filter
corner_freq |  | DOUBLE PRECISION | NO | This attribute represents the corner frequency of a low-pass filter
damping_value |  | DOUBLE PRECISION | NO | This attribute represents the fraction of critical damping of a low-pass filter
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
RLP00 | PrimaryKey | lp_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Response_LP | Response | Non-Identifying | resp_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_PN

Owner |
Definition | Summary information on a polynomial
Note | ``
DDL Code | CREATE TABLE Response_PN( `pn_id NUMBER(8, 0) NOT NULL,` `name VARCHAR2(80),` `poly_type VARCHAR2(1) NOT NULL,` `lower_bound DOUBLE PRECISION,` `upper_bound DOUBLE PRECISION,` `max_error DOUBLE PRECISION,` `nb_coeff NUMBER(8, 0),` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT RPN01 CHECK (nb_coeff >= 0),` `CONSTRAINT RPN02 CHECK (poly_type IN ('C','L','M')),` `CONSTRAINT RPN00 PRIMARY KEY (pn_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
pn_id |  | NUMBER(8, 0) | NO | Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database
name |  | VARCHAR2(80) | YES | This attribute denotes a descriptive name for a polynomial
poly_type |  | VARCHAR2(1) | NO | This attribute represents the type of polynomial approximation
lower_bound |  | DOUBLE PRECISION | YES | This attribute denotes the polynomial lower bound
upper_bound |  | DOUBLE PRECISION | YES | This attribute denotes the polynomial upper bound
max_error |  | DOUBLE PRECISION | YES | This attribute represents the maximum error of polynomial approximation
nb_coeff |  | NUMBER(8, 0) | YES | This attribute denotes the number of polynomial coefficients
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
RPN00 | PrimaryKey | pn_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Response_PN | Response_PN_Data | Identifying | pn_id
Response_PN | Response | Non-Identifying | resp_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_PN_Data

Owner |
Definition | Coefficients of a polynomial
Note | ``
DDL Code | CREATE TABLE Response_PN_Data( `pn_id NUMBER(8, 0) NOT NULL,` `pn_nb NUMBER(8, 0) NOT NULL,` `pn_value DOUBLE PRECISION NOT NULL,` `CONSTRAINT RPND01 CHECK (pn_nb >= 1),` `CONSTRAINT RPND00 PRIMARY KEY (pn_id, pn_nb),` `CONSTRAINT Res_PN_Dat_Res_PN FOREIGN KEY (pn_id)` `REFERENCES Response_PN(pn_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
pn_id |  | NUMBER(8, 0) | NO | Polynomial identifier. Each polynomial is assigned a unique integer which identifies it in a database
pn_nb |  | NUMBER(8, 0) | NO | This attribute denotes the coefficient number of a polynomial
pn_value |  | DOUBLE PRECISION | NO | This attribute denotes the coefficient value of a polynomial

Primary and Unique Keys

Key Name | Key Type | Keys
RPND00 | PrimaryKey | pn_id,pn_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Response_PN | Response_PN_Data | Identifying | pn_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Response_PZ

Owner |
Definition | Summary information on poles & zeros
Note | ``
DDL Code | CREATE TABLE Response_PZ( `pz_id NUMBER(8, 0) NOT NULL,` `pz_nb NUMBER(8, 0) NOT NULL,` `type VARCHAR2(1) NOT NULL,` `r_value DOUBLE PRECISION NOT NULL,` `r_error DOUBLE PRECISION,` `i_value DOUBLE PRECISION NOT NULL,` `i_error DOUBLE PRECISION,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT RPZ01 CHECK (pz_nb >= 1),` `CONSTRAINT RPZ02 CHECK (type IN ('P','Z')),` `CONSTRAINT RPZ00 PRIMARY KEY (pz_id, pz_nb)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
pz_id |  | NUMBER(8, 0) | NO | Poles & zeros set identifier. Each poles & zeros set is assigned a unique integer which identifies it in a database
pz_nb |  | NUMBER(8, 0) | NO | This attribute denotes the pole/zero number of a response
type |  | VARCHAR2(1) | NO | This attribute denotes whether a value is associated with a pole/zero
r_value |  | DOUBLE PRECISION | NO | The real portion of a complex pole/zero
r_error |  | DOUBLE PRECISION | YES | The error value for the real portion of a complex pole/zero
i_value |  | DOUBLE PRECISION | NO | The imaginary portion of a complex pole/zero
i_error |  | DOUBLE PRECISION | YES | The error value for the imaginary portion of a complex pole/zero
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
RPZ00 | PrimaryKey | pz_id,pz_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Sensor

Owner |
Definition | Summary information on a sensor
Note | ``
DDL Code | CREATE TABLE Sensor( `sensor_id NUMBER(8, 0) NOT NULL,` `name VARCHAR2(80),` `serial_nb VARCHAR2(80),` `ondate DATE NOT NULL,` `offdate DATE,` `nb_component NUMBER(8, 0) NOT NULL,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT Sensor01 CHECK (nb_component >= 0),` `CONSTRAINT Sensor00 PRIMARY KEY (sensor_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sensor_id |  | NUMBER(8, 0) | NO | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
name |  | VARCHAR2(80) | YES | This attribute denotes a descriptive name for a sensor
serial_nb |  | VARCHAR2(80) | YES | This attribute denotes a serial number of a sensor
ondate |  | DATE | NO | This attribute denotes the start date
offdate |  | DATE | YES | This attribute denotes the end date
nb_component |  | NUMBER(8, 0) | NO | This attribute denotes the number of components of a sensor
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
Sensor00 | PrimaryKey | sensor_id

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Sensor | Sensor_Component | Identifying | sensor_id
Sensor | Station_Sensor | Non-Identifying | sensor_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Sensor_Component

Owner |
Definition | Component of a sensor
Note | ``
DDL Code | CREATE TABLE Sensor_Component( `sensor_id NUMBER(8, 0) NOT NULL,` `component_nb NUMBER(8, 0) NOT NULL,` `channel_comp VARCHAR2(2),` `component_type VARCHAR2(1),` `sensitivity DOUBLE PRECISION NOT NULL,` `frequency DOUBLE PRECISION,` `seqresp_id NUMBER(8, 0),` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT SeC01 CHECK (component_nb >= 1),` `CONSTRAINT SeC02 CHECK (frequency >= 0.0),` `CONSTRAINT SeC00 PRIMARY KEY (sensor_id, component_nb),` `CONSTRAINT Sen_Com_Sen FOREIGN KEY (sensor_id)` `REFERENCES Sensor(sensor_id)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sensor_id |  | NUMBER(8, 0) | NO | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
component_nb |  | NUMBER(8, 0) | NO | This attribute represents the component number
channel_comp |  | VARCHAR2(2) | YES | Component channel
component_type |  | VARCHAR2(1) | YES | This attribute denotes the component type
sensitivity |  | DOUBLE PRECISION | NO | This attribute denotes the sensitivity (Sd) for a sensor or a digitizer
frequency |  | DOUBLE PRECISION | YES | The frequency (fs) at which the value in sensitivity/gain is correct
seqresp_id |  | NUMBER(8, 0) | YES | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Primary and Unique Keys

Key Name | Key Type | Keys
SeC00 | PrimaryKey | sensor_id,component_nb

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Sensor | Sensor_Component | Identifying | sensor_id

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION | Heap
CACHE | NO
LOGGING | Logged
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS | FreeLists
FREELIST GROUPS | FreeList Groups
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station

Owner |
Definition | Summary information on a station
Note | ``
DDL Code | CREATE TABLE Station( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `lat DOUBLE PRECISION,` `lon DOUBLE PRECISION,` `elev DOUBLE PRECISION,` `staname VARCHAR2(50),` `nb_sensor NUMBER(8, 0),` `nb_filamp NUMBER(8, 0),` `nb_digi NUMBER(8, 0) NOT NULL,` `nb_data NUMBER(8, 0) NOT NULL,` `datumhor VARCHAR2(8),` `datumver VARCHAR2(8),` `ondate DATE NOT NULL,` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT St03 CHECK (elev >= -5000.0 AND elev <= 5000.0),` `CONSTRAINT St04 CHECK (lat >= -90.0 AND lat <= 90.0),` `CONSTRAINT St05 CHECK (lon >= -180.0 AND lon <= 180.0),` `CONSTRAINT St06 CHECK (nb_data >= 0),` `CONSTRAINT St07 CHECK (nb_digi >= 0),` `CONSTRAINT St08 CHECK (nb_filamp >= 0),` `CONSTRAINT St09 CHECK (nb_sensor >= 0),` `CONSTRAINT St01 CHECK (datumhor IN ('NAD27','WGS84')),` `CONSTRAINT St02 CHECK (datumver IN ('NAD27','WGS84','AVERAGE')),` `CONSTRAINT St00 PRIMARY KEY (sta, net, ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
lat |  | DOUBLE PRECISION | YES | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
lon |  | DOUBLE PRECISION | YES | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
elev |  | DOUBLE PRECISION | YES | Elevation. This attribute is the elevation of a seismic station relative to mean sea level
staname |  | VARCHAR2(50) | YES | Station name/description. This is the full name of the station whose code-name is in sta
nb_sensor |  | NUMBER(8, 0) | YES | This attribute denotes the number of sensors of a station
nb_filamp |  | NUMBER(8, 0) | YES | This attribute denotes the number of filter-amplifiers of a station
nb_digi |  | NUMBER(8, 0) | NO | This attribute denotes the number of digitizers of a station
nb_data |  | NUMBER(8, 0) | NO | This attribute denotes the number of dataloggers of a station
datumhor |  | VARCHAR2(8) | YES | Datum type for horizontal (latitude and longitude) coordinates
datumver |  | VARCHAR2(8) | YES | Datum type for depth or elevation
ondate |  | DATE | NO | This attribute denotes the start date
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

Primary and Unique Keys

Key Name | Key Type | Keys
St00 | PrimaryKey | sta,net,ondate

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Station | Station_Datalogger | Identifying | sta,net,ondate
Station | Station_Digitizer | Identifying | sta,net,ondate
Station | Station_Filamp | Identifying | sta,net,ondate
Station | Station_Sensor | Identifying | sta,net,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Datalogger

Owner |
Definition | Data associating a station with a datalogger
Note | ``
DDL Code | CREATE TABLE Station_Datalogger( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `data_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `data_id NUMBER(8, 0) NOT NULL,` `nb_pchannel NUMBER(8, 0) NOT NULL,` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StDa01 CHECK (data_nb >= 1),` `CONSTRAINT StDa02 CHECK (nb_pchannel >= 0),` `CONSTRAINT StDa00 PRIMARY KEY (sta, net, data_nb, ondate),` `CONSTRAINT Sta_Dat_Dat FOREIGN KEY (data_id)` `REFERENCES Datalogger(data_id),` `CONSTRAINT Sta_Dat_Sta FOREIGN KEY (sta,net,ondate)` `REFERENCES Station(sta,net,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
data_nb |  | NUMBER(8, 0) | NO | This attribute represents the datalogger number
ondate |  | DATE | NO | This attribute denotes the start date
data_id |  | NUMBER(8, 0) | NO | Datalogger identifier. Each datalogger is assigned a unique integer which identifies it in a database
nb_pchannel |  | NUMBER(8, 0) | NO | This attribute denotes the number of physical channels of a datalogger
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

Primary and Unique Keys

Key Name | Key Type | Keys
StDa00 | PrimaryKey | sta,net,data_nb,ondate

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Datalogger | Station_Datalogger | Non-Identifying | data_id
Station | Station_Datalogger | Identifying | sta,net,ondate
Station_Datalogger | Station_Datalogger_PChannel | Identifying | sta,net,data_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Datalogger_LChannel

Owner |
Definition | Summary information on a channel
Note | ``
DDL Code | CREATE TABLE Station_Datalogger_LChannel( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `data_nb NUMBER(8, 0) NOT NULL,` `pchannel_nb NUMBER(8, 0) NOT NULL,` `lchannel_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `seqfil_id NUMBER(8, 0),` `seedchan VARCHAR2(3),` `channel VARCHAR2(3),` `channelsrc VARCHAR2(8),` `location VARCHAR2(2),` `rgain DOUBLE PRECISION,` `rfrequency DOUBLE PRECISION,` `samprate DOUBLE PRECISION NOT NULL,` `clock_drift DOUBLE PRECISION,` `flags VARCHAR2(27),` `data_format VARCHAR2(80) NOT NULL,` `comp_type NUMBER(8, 0) NOT NULL,` `unit_signal NUMBER(8, 0) NOT NULL,` `unit_calib NUMBER(8, 0) NOT NULL,` `block_size NUMBER(8, 0) NOT NULL,` `offdate DATE,` `remark VARCHAR2(30),` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StDaL01 CHECK (block_size >= 256 AND block_size <= 4096),` `CONSTRAINT StDaL02 CHECK (clock_drift >= 0.0),` `CONSTRAINT StDaL03 CHECK (data_nb >= 1),` `CONSTRAINT StDaL04 CHECK (lchannel_nb >= 1),` `CONSTRAINT StDaL05 CHECK (pchannel_nb >= 1),` `CONSTRAINT StDaL06 CHECK (rfrequency > 0.0),` `CONSTRAINT StDaL00 PRIMARY KEY (sta, net, data_nb, pchannel_nb, lchannel_nb, ondate),` `CONSTRAINT Sta_Dat_LCh_Fil_Seq FOREIGN KEY (seqfil_id)` `REFERENCES Filter_Sequence(seqfil_id),` `CONSTRAINT Sta_Dat_LCh_Sta_Dat_PCh FOREIGN KEY (sta,net,data_nb,pchannel_nb,ondate)` `REFERENCES Station_Datalogger_PChannel(sta,net,data_nb,pchannel_nb,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
data_nb |  | NUMBER(8, 0) | NO | This attribute represents the datalogger number
pchannel_nb |  | NUMBER(8, 0) | NO | This attribute denotes a physical channel
lchannel_nb |  | NUMBER(8, 0) | NO | This attribute denotes a logical channel of a datalogger
ondate |  | DATE | NO | This attribute denotes the start date
seqfil_id |  | NUMBER(8, 0) | YES | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database
seedchan |  | VARCHAR2(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 |  | VARCHAR2(3) | 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, ...)
location |  | VARCHAR2(2) | YES | Describes the individual sites on an array station, operated by the same network operator
rgain |  | DOUBLE PRECISION | YES | This attribute denotes the gain at the response frequency
rfrequency |  | DOUBLE PRECISION | YES | The frequency (fs) at which the value in rgain is correct
samprate |  | DOUBLE PRECISION | NO | Sampling rate. This attribute is the sample rate in samples/second
clock_drift |  | DOUBLE PRECISION | 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 |  | VARCHAR2(27) | YES | Channel flags
data_format |  | VARCHAR2(80) | NO | This attribute represents the data format
comp_type |  | NUMBER(8, 0) | NO | Compression type. A lookup key that refers to the Format Dictionary
unit_signal |  | NUMBER(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 |  | NUMBER(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 |  | NUMBER(8, 0) | NO | The record length of the data
offdate |  | DATE | YES | This attribute denotes the end date
remark |  | VARCHAR2(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

Primary and Unique Keys

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

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filter_Sequence | Station_Datalogger_LChannel | Non-Identifying | seqfil_id
Station_Datalogger_PChannel | Station_Datalogger_LChannel | Identifying | sta,net,data_nb,pchannel_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Datalogger_PChannel

Owner |
Definition | Data associating channels
Note | ``
DDL Code | CREATE TABLE Station_Datalogger_PChannel( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `data_nb NUMBER(8, 0) NOT NULL,` `pchannel_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `board_type VARCHAR2(1) NOT NULL,` `channel_type VARCHAR2(1) NOT NULL,` `seed_io VARCHAR2(2) NOT NULL,` `nb_lchannel NUMBER(8, 0) NOT NULL,` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StDaP01 CHECK (data_nb >= 1),` `CONSTRAINT StDaP02 CHECK (nb_lchannel >= 1),` `CONSTRAINT StDaP03 CHECK (pchannel_nb >= 1),` `CONSTRAINT StDaP04 CHECK (board_type IN ('P', 'A', 'E', 'D')),` `CONSTRAINT StDaP05 CHECK (channel_type IN ('P', 'S')),` `CONSTRAINT StDaP00 PRIMARY KEY (sta, net, data_nb, pchannel_nb, ondate),` `CONSTRAINT Sta_Dat_PCh_Sta_Dat FOREIGN KEY (sta,net,data_nb,ondate)` `REFERENCES Station_Datalogger(sta,net,data_nb,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
data_nb |  | NUMBER(8, 0) | NO | This attribute represents the datalogger number
pchannel_nb |  | NUMBER(8, 0) | NO | This attribute denotes a physical channel
ondate |  | DATE | NO | This attribute denotes the start date
board_type |  | VARCHAR2(1) | NO | This attribute describes the board type on the datalogger where the physical channel resides. Regular seismic channels are usually on a primary board. Auxiliary channels (internal temperature, external power, …) are usually on an auxiliary board. A value of external is used to represent a digitizer that is not part of the datalogger (for example an embedded digitizer in a digital pressure sensor). A digital board is used to represent truly digital sensors which don’t actually have any digitizing stage from Volts to Counts (for example a rainfall sensor that uses a digital counter)
channel_type |  | VARCHAR2(1) | NO | This attribute describes the type of the input channel. An input channel is usually classified as physical when the data is digitized (velocity, acceleration, ...). An input channel is defined as synthetic when the data is not derived directly from a sensor (clock frequency, available telemetry buffer channel, clock quality, ...)
seed_io |  | VARCHAR2(2) | NO | This attribute represents the SEED instrument and orientation
nb_lchannel |  | NUMBER(8, 0) | NO | This attribute denotes the number of logical channels of a datalogger
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

Primary and Unique Keys

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

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Station_Datalogger | Station_Datalogger_PChannel | Identifying | sta,net,data_nb,ondate
Station_Datalogger_PChannel | Station_Datalogger_LChannel | Identifying | sta,net,data_nb,pchannel_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Digitizer

Owner |
Definition | Data associating a station with a digitizer
Note | ``
DDL Code | CREATE TABLE Station_Digitizer( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `digi_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `serial_nb VARCHAR2(80) NOT NULL,` `nb_pri_pchannel NUMBER(8, 0) NOT NULL,` `nb_aux_pchannel NUMBER(8, 0) NOT NULL,` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StDi01 CHECK (digi_nb >= 1),` `CONSTRAINT StDi02 CHECK (nb_aux_pchannel >= 0),` `CONSTRAINT StDi03 CHECK (nb_pri_pchannel >= 0),` `CONSTRAINT StDi00 PRIMARY KEY (sta, net, digi_nb, ondate),` `CONSTRAINT Sta_Dig_Sta FOREIGN KEY (sta,net,ondate)` `REFERENCES Station(sta,net,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
digi_nb |  | NUMBER(8, 0) | NO | This attribute represents the digitizer number
ondate |  | DATE | NO | This attribute denotes the start date
serial_nb |  | VARCHAR2(80) | NO | This attribute denotes a serial number of a datalogger board
nb_pri_pchannel |  | NUMBER(8, 0) | NO | This attribute denotes the number of primary physical channels of a digitizer
nb_aux_pchannel |  | NUMBER(8, 0) | NO | This attribute denotes the number of auxiliary physical channels of a digitizer
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

Primary and Unique Keys

Key Name | Key Type | Keys
StDi00 | PrimaryKey | sta,net,digi_nb,ondate

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Station | Station_Digitizer | Identifying | sta,net,ondate
Station_Digitizer | Station_Digitizer_PChannel | Identifying | sta,net,digi_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Digitizer_PChannel

Owner |
Definition | Data associating physical channels
Note | ``
DDL Code | CREATE TABLE Station_Digitizer_PChannel( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `digi_nb NUMBER(8, 0) NOT NULL,` `pchannel_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `data_nb NUMBER(8, 0) NOT NULL,` `data_pchannel NUMBER(8, 0) NOT NULL,` `digi_type VARCHAR2(3) NOT NULL,` `digi_polarity VARCHAR2(1) NOT NULL,` `digi_channel NUMBER(8, 0) NOT NULL,` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StDiP01 CHECK (data_nb >= 1),` `CONSTRAINT StDiP02 CHECK (data_pchannel >= 1),` `CONSTRAINT StDiP03 CHECK (digi_nb >= 1),` `CONSTRAINT StDiP05 CHECK (pchannel_nb >= 1),` `CONSTRAINT StDiP00 PRIMARY KEY (sta, net, digi_nb, pchannel_nb, ondate),` `CONSTRAINT Sta_Dig_PCh_Sta_Dig FOREIGN KEY (sta,net,digi_nb,ondate)` `REFERENCES Station_Digitizer(sta,net,digi_nb,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
digi_nb |  | NUMBER(8, 0) | NO | This attribute represents the digitizer number
pchannel_nb |  | NUMBER(8, 0) | NO | This attribute denotes a physical channel
ondate |  | DATE | NO | This attribute denotes the start date
data_nb |  | NUMBER(8, 0) | NO | This attribute represents the datalogger number
data_pchannel |  | NUMBER(8, 0) | NO | This attribute represents a datalogger physical channel
digi_type |  | VARCHAR2(3) | NO | This attribute represents the digitizer type
digi_polarity |  | VARCHAR2(1) | NO | This attribute represents the digitizer polarity
digi_channel |  | NUMBER(8, 0) | NO | This attribute represents a digitizer module on a board
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

Primary and Unique Keys

Key Name | Key Type | Keys
StDiP00 | PrimaryKey | sta,net,digi_nb,pchannel_nb,ondate

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Station_Digitizer | Station_Digitizer_PChannel | Identifying | sta,net,digi_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Filamp

Owner |
Definition | Data associating a station with a filter-amplifier
Note | ``
DDL Code | CREATE TABLE Station_Filamp( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `filamp_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `filamp_id NUMBER(8, 0) NOT NULL,` `nb_pchannel NUMBER(8, 0) NOT NULL,` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StFi01 CHECK (filamp_nb >= 1),` `CONSTRAINT StFi02 CHECK (nb_pchannel >= 0),` `CONSTRAINT StFi00 PRIMARY KEY (sta, net, filamp_nb, ondate),` `CONSTRAINT Sta_Fil_Fil FOREIGN KEY (filamp_id)` `REFERENCES Filamp(filamp_id),` `CONSTRAINT Sta_Fil_Sta FOREIGN KEY (sta,net,ondate)` `REFERENCES Station(sta,net,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
filamp_nb |  | NUMBER(8, 0) | NO | This attribute represents the filter-amplifier number
ondate |  | DATE | NO | This attribute denotes the start date
filamp_id |  | NUMBER(8, 0) | NO | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
nb_pchannel |  | NUMBER(8, 0) | NO | This attribute denotes the number of physical channels of a datalogger
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

Primary and Unique Keys

Key Name | Key Type | Keys
StFi00 | PrimaryKey | sta,net,filamp_nb,ondate

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Filamp | Station_Filamp | Non-Identifying | filamp_id
Station | Station_Filamp | Identifying | sta,net,ondate
Station_Filamp | Station_Filamp_PChannel | Identifying | sta,net,filamp_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Filamp_PChannel

Owner |
Definition | Data associating physical channels
Note | ``
DDL Code | CREATE TABLE Station_Filamp_PChannel( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `filamp_nb NUMBER(8, 0) NOT NULL,` `pchannel_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `next_hard_type VARCHAR2(1) NOT NULL,` `next_hard_nb NUMBER(8, 0) NOT NULL,` `next_hard_pchannel NUMBER(8, 0) NOT NULL,` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StFiP01 CHECK (filamp_nb >= 1),` `CONSTRAINT StFiP02 CHECK (next_hard_nb >= 1),` `CONSTRAINT StFiP03 CHECK (next_hard_pchannel >= 1),` `CONSTRAINT StFiP04 CHECK (next_hard_type IN ('F','D')),` `CONSTRAINT StFiP05 CHECK (pchannel_nb >= 1),` `CONSTRAINT StFiP00 PRIMARY KEY (sta, net, filamp_nb, pchannel_nb, ondate),` `CONSTRAINT Sta_Fil_PCh_Sta_Fil FOREIGN KEY (sta,net,filamp_nb,ondate)` `REFERENCES Station_Filamp(sta,net,filamp_nb,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
filamp_nb |  | NUMBER(8, 0) | NO | This attribute represents the filter-amplifier number
pchannel_nb |  | NUMBER(8, 0) | NO | This attribute denotes a physical channel
ondate |  | DATE | NO | This attribute denotes the start date
next_hard_type |  | VARCHAR2(1) | NO | This attribute denotes the next hardware type
next_hard_nb |  | NUMBER(8, 0) | NO | This attribute denotes the next hardware number
next_hard_pchannel |  | NUMBER(8, 0) | NO | This attribute denotes the next hardware physical channel
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

Primary and Unique Keys

Key Name | Key Type | Keys
StFiP00 | PrimaryKey | sta,net,filamp_nb,pchannel_nb,ondate

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Station_Filamp | Station_Filamp_PChannel | Identifying | sta,net,filamp_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Sensor

Owner |
Definition | Data associating a station with a sensor
Note | ``
DDL Code | CREATE TABLE Station_Sensor( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `sensor_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `sensor_id NUMBER(8, 0) NOT NULL,` `lat DOUBLE PRECISION,` `lon DOUBLE PRECISION,` `elev DOUBLE PRECISION,` `edepth DOUBLE PRECISION,` `nb_component NUMBER(8, 0) NOT NULL,` `datumhor VARCHAR2(8),` `datumver VARCHAR2(8),` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StSe01 CHECK (datumhor IN ('NAD27','WGS84')),` `CONSTRAINT StSe02 CHECK (datumver IN ('NAD27','WGS84','AVERAGE')),` `CONSTRAINT StSe03 CHECK (edepth >= 0.0),` `CONSTRAINT StSe04 CHECK (elev >= -5000.0 AND elev <= 5000.0),` `CONSTRAINT StSe05 CHECK (lat >= -90.0 AND lat <= 90.0),` `CONSTRAINT StSe06 CHECK (lon >= -180.0 AND lon <= 180.0),` `CONSTRAINT StSe07 CHECK (nb_component >= 0),` `CONSTRAINT StSe08 CHECK (sensor_nb >= 1),` `CONSTRAINT StSe00 PRIMARY KEY (sta, net, sensor_nb, ondate),` `CONSTRAINT Sta_Sen_Sen FOREIGN KEY (sensor_id)` `REFERENCES Sensor(sensor_id),` `CONSTRAINT Sta_Sen_Sta FOREIGN KEY (sta,net,ondate)` `REFERENCES Station(sta,net,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
sensor_nb |  | NUMBER(8, 0) | NO | This attribute represents the sensor number
ondate |  | DATE | NO | This attribute denotes the start date
sensor_id |  | NUMBER(8, 0) | NO | Sensor identifier. Each sensor is assigned a unique integer which identifies it in a database
lat |  | DOUBLE PRECISION | YES | Latitude. This attribute is the geographic latitude. Locations north of the equator have positive latitudes
lon |  | DOUBLE PRECISION | YES | Longitude. This attribute is the geographic longitude. Longitudes are measured positive east of the Greenwich meridian
elev |  | DOUBLE PRECISION | YES | Elevation. This attribute is the elevation of a seismic station relative to mean sea level
edepth |  | DOUBLE PRECISION | YES | Emplacement depth. This attribute gives the depth at which the instrument is positioned, relative to the value of elev
nb_component |  | NUMBER(8, 0) | NO | This attribute denotes the number of components of a sensor
datumhor |  | VARCHAR2(8) | YES | Datum type for horizontal (latitude and longitude) coordinates
datumver |  | VARCHAR2(8) | YES | Datum type for depth or elevation
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

Primary and Unique Keys

Key Name | Key Type | Keys
StSe00 | PrimaryKey | sta,net,sensor_nb,ondate

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Sensor | Station_Sensor | Non-Identifying | sensor_id
Station | Station_Sensor | Identifying | sta,net,ondate
Station_Sensor | Station_Sensor_Component | Identifying | sta,net,sensor_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description

Station_Sensor_Component

Owner |
Definition | Data associating physical channels
Note | ``
DDL Code | CREATE TABLE Station_Sensor_Component( `sta VARCHAR2(6) NOT NULL,` `net VARCHAR2(8) NOT NULL,` `sensor_nb NUMBER(8, 0) NOT NULL,` `component_nb NUMBER(8, 0) NOT NULL,` `ondate DATE NOT NULL,` `next_hard_type VARCHAR2(1) NOT NULL,` `next_hard_nb NUMBER(8, 0) NOT NULL,` `next_hard_pchannel NUMBER(8, 0) NOT NULL,` `azimuth DOUBLE PRECISION,` `dip DOUBLE PRECISION,` `offdate DATE,` `lddate DATE DEFAULT (SYSDATE),` `CONSTRAINT StSeC01 CHECK (azimuth >= 0.0 AND azimuth <= 360.0),` `CONSTRAINT StSeC02 CHECK (component_nb >= 1),` `CONSTRAINT StSec03 CHECK (dip >= -90.0 AND dip <= 90.0),` `CONSTRAINT StSec04 CHECK (next_hard_nb >= 1),` `CONSTRAINT StSec05 CHECK (next_hard_pchannel >= 1),` `CONSTRAINT StSec06 CHECK (next_hard_type IN ('F','D')),` `CONSTRAINT StSec07 CHECK (sensor_nb >= 1),` `CONSTRAINT StSeC00 PRIMARY KEY (sta, net, sensor_nb, component_nb, ondate),` `CONSTRAINT Sta_Sen_Com_Sta_Sen FOREIGN KEY (sta,net,sensor_nb,ondate)` `REFERENCES Station_Sensor(sta,net,sensor_nb,ondate)` `)` `TABLESPACE HT_DATA` `;` `` `` ``

Columns

ColumnName | Domain | Datatype | NULL | Definition
sta |  | VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
sensor_nb |  | NUMBER(8, 0) | NO | This attribute represents the sensor number
component_nb |  | NUMBER(8, 0) | NO | This attribute represents the component number
ondate |  | DATE | NO | This attribute denotes the start date
next_hard_type |  | VARCHAR2(1) | NO | This attribute denotes the next hardware type
next_hard_nb |  | NUMBER(8, 0) | NO | This attribute denotes the next hardware number
next_hard_pchannel |  | NUMBER(8, 0) | NO | This attribute denotes the next hardware physical channel
azimuth |  | DOUBLE PRECISION | YES | The azimuth of the instrument from north, clockwise
dip |  | DOUBLE PRECISION | YES | The dip of the instrument, down from horizontal
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

Primary and Unique Keys

Key Name | Key Type | Keys
StSeC00 | PrimaryKey | sta,net,sensor_nb,component_nb,ondate

Foreign Keys

Parent Table | Child Table | Type | Foreign Keys
Station_Sensor | Station_Sensor_Component | Identifying | sta,net,sensor_nb,ondate

Storage

STORAGE OPTION | STORAGE VALUE
TABLESPACE | HT_DATA
PCTFREE |
PCTUSED |
MINEXTENTS |
MAXEXTENTS |
INITIAL |
NEXT |
PCTINCREASE |
INITRANS |
MAXTRANS |
ORGANIZATION |
CACHE | NO
LOGGING |
PARALLEL | NO
PARALLEL DEGREES |
PARALLEL INSTANCES |
FREELISTS |
FREELIST GROUPS |
BUFFER POOL |

Partitions

Attachments

Name | Datatype | Value Override | Default Value | Description