| 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 |