| Channel_Comment |
| Owner | |
| Definition | Comments for a channel |
| Note | |
| DDL Code | CREATE TABLE Channel_Comment( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2) NOT NULL, ondate DATE NOT NULL, comment_id NUMBER(8, 0) NOT NULL, channel VARCHAR2(3), channelsrc VARCHAR2(8), offdate DATE, comment_level NUMBER(8, 0) NOT NULL, lddate DATE DEFAULT (SYSDATE), CONSTRAINT ChC00 PRIMARY KEY (net, sta, seedchan, location, ondate, comment_id), CONSTRAINT Cha_Com_Cha_Dat FOREIGN KEY (net,sta,seedchan,location,ondate) REFERENCES Channel_Data(net,sta,seedchan,location,ondate), CONSTRAINT Cha_Com_D_Com FOREIGN KEY (comment_id) REFERENCES D_Comment(id) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| seedchan |
VARCHAR2(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code | |
| location |
VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| comment_id |
NUMBER(8, 0) | NO | The comment code key of the associated Comment Description Dictionary | |
| 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, etc.) | |
| offdate | DATE | YES | This attribute denotes the end date | |
| comment_level | NUMBER(8, 0) | NO | The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel | |
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| ChC00 | PrimaryKey | net,sta,seedchan,location,ondate,comment_id |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Channel_Data | Channel_Comment | Identifying | net,sta,seedchan,location,ondate |
| D_Comment | Channel_Comment | Identifying | comment_id |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| Channel_Data |
| Owner | |
| Definition | Summary information on a channel |
| Note | |
| DDL Code | CREATE TABLE Channel_Data( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2) NOT NULL, ondate DATE NOT NULL, channel VARCHAR2(3), channelsrc VARCHAR2(8), inid NUMBER(8, 0), remark VARCHAR2(30), unit_signal NUMBER(8, 0) NOT NULL, unit_calib NUMBER(8, 0) NOT NULL, lat DOUBLE PRECISION, lon DOUBLE PRECISION, elev DOUBLE PRECISION, edepth DOUBLE PRECISION, azimuth DOUBLE PRECISION, dip DOUBLE PRECISION, format_id NUMBER(8, 0) NOT NULL, record_length NUMBER(8, 0), samprate DOUBLE PRECISION NOT NULL, clock_drift DOUBLE PRECISION, flags VARCHAR2(27), offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT ChD01 CHECK (azimuth >= 0.0 AND azimuth <= 360.0), CONSTRAINT ChD02 CHECK (clock_drift >= 0.0), CONSTRAINT ChD03 CHECK (dip >= -90.0 AND dip <= 90.0), CONSTRAINT ChD04 CHECK (edepth >= 0.0), CONSTRAINT ChD06 CHECK (lat >= -90.0 AND lat <= 90.0), CONSTRAINT ChD07 CHECK (lon >= -180.0 AND lon <= 180.0), CONSTRAINT ChD08 CHECK (record_length >= 8 AND record_length <= 12), CONSTRAINT ChD09 CHECK (samprate >= 0.0), CONSTRAINT ChD00 PRIMARY KEY (net, sta, seedchan, location, ondate), CONSTRAINT Cha_Dat_D_Abb FOREIGN KEY (inid) REFERENCES D_Abbreviation(id), CONSTRAINT Cha_Dat_D_For FOREIGN KEY (format_id) REFERENCES D_Format(id), CONSTRAINT Cha_Dat_D_Uni FOREIGN KEY (unit_signal) REFERENCES D_Unit(id), CONSTRAINT Cha_Dat_D_Uni2 FOREIGN KEY (unit_calib) REFERENCES D_Unit(id), CONSTRAINT Cha_Dat_Sta_Dat FOREIGN KEY (net,sta,ondate) REFERENCES Station_Data(net,sta,ondate) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
seedchan |
VARCHAR2(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code | |
| location |
VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| channel | 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, etc.) | |
inid |
NUMBER(8, 0) | YES | Instrument identifier. It refers to the Generic Abbreviation Dictionary, that contains a name for this instrument | |
| 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 | |
| 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 | |
| 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 | |
| azimuth | DOUBLE PRECISION | YES | The azimuth of the instrument from north, clockwise | |
| dip | DOUBLE PRECISION | YES | The dip of the instrument, down from horizontal | |
| format_id |
NUMBER(8, 0) | NO | A data format lookup key that refers to the Data Format Dictionary that describes the format of the data in the data section for this channel | |
| record_length | NUMBER(8, 0) | YES | The exponent (as a power of two) of the record length for these data | |
| 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 | |
| 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 |
| ChD00 | PrimaryKey | net,sta,seedchan,location,ondate |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| D_Abbreviation | Channel_Data | Non-Identifying | inid |
| D_Format | Channel_Data | Non-Identifying | format_id |
| D_Unit | Channel_Data | Non-Identifying | unit_signal |
| D_Unit | Channel_Data | Non-Identifying | unit_calib |
| Station_Data | Channel_Data | Identifying | net,sta,ondate |
| Channel_Data | Channel_Comment | Identifying | net,sta,seedchan,location,ondate |
| Channel_Data | Coefficients | Identifying | net,sta,seedchan,location,ondate |
| Channel_Data | Decimation | Identifying | net,sta,seedchan,location,ondate |
| Channel_Data | Polynomial | Identifying | net,sta,seedchan,location,ondate |
| Channel_Data | Poles_Zeros | Identifying | net,sta,seedchan,location,ondate |
| Channel_Data | Sensitivity | Identifying | net,sta,seedchan,location,ondate |
| Channel_Data | Simple_Response | Identifying | net,sta,seedchan,location,ondate |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| Coefficients |
| Owner | |
| Definition | Data associating a channel with a response |
| Note | |
| DDL Code | CREATE TABLE Coefficients( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2) NOT NULL, ondate DATE NOT NULL, stage_seq NUMBER(8, 0) NOT NULL, channel VARCHAR2(3), channelsrc VARCHAR2(8), offdate DATE, dc_key NUMBER(8, 0), unit_in NUMBER(8, 0) NOT NULL, unit_out NUMBER(8, 0) NOT NULL, tf_type VARCHAR2(1), lddate DATE DEFAULT (SYSDATE), CONSTRAINT Co01 CHECK (stage_seq >= 0), CONSTRAINT Co02 CHECK (tf_type IN ('A','B','C','D','P')), CONSTRAINT Co00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq), CONSTRAINT Coe_Cha_Dat FOREIGN KEY (net,sta,seedchan,location,ondate) REFERENCES Channel_Data(net,sta,seedchan,location,ondate), CONSTRAINT Coe_D_Uni FOREIGN KEY (unit_in) REFERENCES D_Unit(id), CONSTRAINT Coe_D_Uni2 FOREIGN KEY (unit_out) REFERENCES D_Unit(id), CONSTRAINT Coe_DC FOREIGN KEY (dc_key) REFERENCES DC(key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| seedchan |
VARCHAR2(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code | |
| location |
VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| stage_seq |
NUMBER(8, 0) | NO | This attribute denotes the stage number | |
| 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, etc.) | |
| offdate | DATE | YES | This attribute denotes the end date | |
| dc_key |
NUMBER(8, 0) | YES | Response (Coefficients) key | |
| 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 | |
| tf_type | VARCHAR2(1) | YES | A single character describing the type of stage | |
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| Co00 | PrimaryKey | net,sta,seedchan,location,ondate,stage_seq |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Channel_Data | Coefficients | Identifying | net,sta,seedchan,location,ondate |
| D_Unit | Coefficients | Non-Identifying | unit_in |
| D_Unit | Coefficients | Non-Identifying | unit_out |
| DC | Coefficients | Non-Identifying | dc_key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| D_Abbreviation |
| Owner | |
| Definition | Abbreviation dictionary |
| Note | |
| DDL Code | CREATE TABLE D_Abbreviation( id NUMBER(8, 0) NOT NULL, description VARCHAR2(70), CONSTRAINT D_A00 PRIMARY KEY (id) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| id |
NUMBER(8, 0) | NO | A cross reference code to indicate this particular dictionary entry | |
| description | VARCHAR2(70) | YES | This is a description of an abbreviation |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| D_A00 | PrimaryKey | id |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| D_Abbreviation | Channel_Data | Non-Identifying | inid |
| D_Abbreviation | Station_Data | Non-Identifying | net_id |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| D_Comment |
| Owner | |
| Definition | Comment dictionary |
| Note | |
| DDL Code | CREATE TABLE D_Comment( id NUMBER(8, 0) NOT NULL, class VARCHAR2(1) NOT NULL, description VARCHAR2(70), unit NUMBER(8, 0) NOT NULL, CONSTRAINT D_C00 PRIMARY KEY (id) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| id |
NUMBER(8, 0) | NO | A cross reference code to indicate this particular dictionary entry | |
| class | VARCHAR2(1) | NO | A single letter that determines to what the code refers | |
| description | VARCHAR2(70) | YES | This is a description of a comment | |
| unit | NUMBER(8, 0) | NO | Units of comment level |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| D_C00 | PrimaryKey | id |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| D_Comment | Channel_Comment | Identifying | comment_id |
| D_Comment | Station_Comment | Identifying | comment_id |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| D_Format |
| Owner | |
| Definition | Format dictionary |
| Note | |
| DDL Code | CREATE TABLE D_Format( id NUMBER(8, 0) NOT NULL, name VARCHAR2(80), family NUMBER(8, 0) NOT NULL, ms_id NUMBER(8, 0) NOT NULL, CONSTRAINT D_F00 PRIMARY KEY (id) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| id |
NUMBER(8, 0) | NO | A cross reference code to indicate this particular dictionary entry | |
| name | VARCHAR2(80) | YES | Descriptive name | |
| family | NUMBER(8, 0) | NO | This field is used by the data decoder to describe the data family type. It tells a potential program what general algorithm to use to decode the associated data. Each algorithm requires some number of decoder keys that contain special additional information, enabling the algorithm to decode the data | |
| ms_id | NUMBER(8, 0) | NO | This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| D_F00 | PrimaryKey | id |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| D_Format | Channel_Data | Non-Identifying | format_id |
| D_Format | D_Format_Data | Identifying | id |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| D_Format_Data |
| Owner | |
| Definition | Format data |
| Note | |
| DDL Code | CREATE TABLE D_Format_Data( id NUMBER(8, 0) NOT NULL, row_id NUMBER(8, 0) NOT NULL, key_d VARCHAR2(80) NOT NULL, CONSTRAINT D_F_D01 CHECK (row_id >= 0), CONSTRAINT D_F_D00 PRIMARY KEY (id, row_id), CONSTRAINT D_For_Dat_D_For FOREIGN KEY (id) REFERENCES D_Format(id) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| id |
NUMBER(8, 0) | NO | A cross reference code to indicate this particular dictionary entry | |
| row_id |
NUMBER(8, 0) | NO | Row identifier for the decoder keys | |
| key_d | VARCHAR2(80) | NO | This attribute denotes the decoder keys used by the data family type |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| D_F_D00 | PrimaryKey | id,row_id |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| D_Format | D_Format_Data | Identifying | id |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| D_Unit |
| Owner | |
| Definition | Unit dictionary |
| Note | |
| DDL Code | CREATE TABLE D_Unit( id NUMBER(8, 0) NOT NULL, name VARCHAR2(80), description VARCHAR2(70), CONSTRAINT D_U00 PRIMARY KEY (id) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| id |
NUMBER(8, 0) | NO | A cross reference code to indicate this particular dictionary entry | |
| name | VARCHAR2(80) | YES | Descriptive name | |
| description | VARCHAR2(70) | YES | This is a description of a unit |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| D_U00 | PrimaryKey | id |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| D_Unit | Channel_Data | Non-Identifying | unit_signal |
| D_Unit | Channel_Data | Non-Identifying | unit_calib |
| D_Unit | Coefficients | Non-Identifying | unit_in |
| D_Unit | Coefficients | Non-Identifying | unit_out |
| D_Unit | Polynomial | Non-Identifying | unit_in |
| D_Unit | Polynomial | Non-Identifying | unit_out |
| D_Unit | Poles_Zeros | Non-Identifying | unit_in |
| D_Unit | Poles_Zeros | Non-Identifying | unit_out |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| DC |
| Owner | |
| Definition | Summary information on a response (Coefficients) |
| Note | |
| DDL Code | CREATE TABLE DC( key NUMBER(8, 0) NOT NULL, name VARCHAR2(80), symmetry VARCHAR2(1), storage VARCHAR2(1), lddate DATE DEFAULT (SYSDATE), CONSTRAINT DC01 CHECK (dcstorage IN ('H','F')), CONSTRAINT DC02 CHECK (symmetry IN ('E','O','N')), CONSTRAINT DC00 PRIMARY KEY (key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| key |
NUMBER(8, 0) | NO | This attribute denotes a unique identifier for a response (digital coefficients) | |
| name | VARCHAR2(80) | YES | Descriptive name | |
| symmetry | VARCHAR2(1) | YES | This attribute denotes the eventual symmetry of a response | |
| storage | VARCHAR2(1) | YES | This attribute denotes if half or all the coefficients are stored in the DC_Data table | |
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| DC00 | PrimaryKey | key |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| DC | Coefficients | Non-Identifying | dc_key |
| DC | DC_Data | Identifying | key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| DC_Data |
| Owner | |
| Definition | Coefficients of a response |
| Note | |
| DDL Code | CREATE TABLE DC_Data( key NUMBER(8, 0) NOT NULL, row_key NUMBER(8, 0) NOT NULL, type VARCHAR2(1), coefficient DOUBLE PRECISION NOT NULL, error DOUBLE PRECISION, CONSTRAINT DCD01 CHECK (row_key >= 0), CONSTRAINT DCD02 CHECK (type IN ('P','Z','N','D')), CONSTRAINT DCD00 PRIMARY KEY (key, row_key), CONSTRAINT DC_Dat_DC FOREIGN KEY (key) REFERENCES DC(key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| key |
NUMBER(8, 0) | NO | This attribute denotes a unique identifier for a response (digital coefficients) | |
| row_key |
NUMBER(8, 0) | NO | Row key for responses | |
| type | VARCHAR2(1) | YES | 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 attribute denotes the numerator/denominator error |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| DCD00 | PrimaryKey | key,row_key |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| DC | DC_Data | Identifying | key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| Decimation |
| Owner | |
| Definition | Data associating a channel with a decimation |
| Note | |
| DDL Code | CREATE TABLE Decimation( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2) NOT NULL, ondate DATE NOT NULL, stage_seq NUMBER(8, 0) NOT NULL, channel VARCHAR2(3), channelsrc VARCHAR2(8), offdate DATE, dm_key NUMBER(8, 0) NOT NULL, lddate DATE DEFAULT (SYSDATE), CONSTRAINT De01 CHECK (stage_seq >= 0), CONSTRAINT De00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq), CONSTRAINT Dec_Cha_Dat FOREIGN KEY (net,sta,seedchan,location,ondate) REFERENCES Channel_Data(net,sta,seedchan,location,ondate), CONSTRAINT Dec_DM FOREIGN KEY (dm_key) REFERENCES DM(key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| seedchan |
VARCHAR2(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code | |
| location |
VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| stage_seq |
NUMBER(8, 0) | NO | This attribute denotes the stage number | |
| 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, etc.) | |
| offdate | DATE | YES | This attribute denotes the end date | |
| dm_key |
NUMBER(8, 0) | NO | Decimation key | |
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| De00 | PrimaryKey | net,sta,seedchan,location,ondate,stage_seq |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Channel_Data | Decimation | Identifying | net,sta,seedchan,location,ondate |
| DM | Decimation | Non-Identifying | dm_key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| DM |
| Owner | |
| Definition | Summary information on a decimation |
| Note | |
| DDL Code | CREATE TABLE DM( key NUMBER(8, 0) NOT NULL, name VARCHAR2(80), samprate DOUBLE PRECISION NOT NULL, factor NUMBER(8, 0) NOT NULL, offset NUMBER(8, 0), delay DOUBLE PRECISION, correction DOUBLE PRECISION NOT NULL, lddate DATE DEFAULT (SYSDATE), CONSTRAINT DM01 CHECK (offset >= 0.0), CONSTRAINT DM02 CHECK (samprate >= 0.0), CONSTRAINT DM00 PRIMARY KEY (key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| key |
NUMBER(8, 0) | NO | This attribute denotes a unique identifier for a decimation | |
| name | VARCHAR2(80) | YES | Descriptive name | |
| samprate | DOUBLE PRECISION | NO | Sampling rate. This attribute is the sample rate in samples/second | |
| factor | NUMBER(8, 0) | NO | The decimation factor. When this number of samples are read in, one final sample comes out. The output sample rate can be calculated by dividing samprate by the decimation factor | |
| offset | 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 stage | |
| 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 | |
| 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 |
| DM00 | PrimaryKey | key |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| DM | Decimation | Non-Identifying | dm_key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| PN |
| Owner | |
| Definition | Summary information on a response (Polynomial) |
| Note | |
| DDL Code | CREATE TABLE PN( key NUMBER(8, 0) NOT NULL, name VARCHAR2(80), poly_type VARCHAR2(1), lower_bound DOUBLE PRECISION, upper_bound DOUBLE PRECISION, max_error DOUBLE PRECISION, lddate DATE DEFAULT (SYSDATE), CONSTRAINT PN01 CHECK (poly_type IN ('C','L','M')), CONSTRAINT PN00 PRIMARY KEY (key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| key |
NUMBER(8, 0) | NO | This attribute denotes a unique identifier for a response (poles & zeros) | |
| name | VARCHAR2(80) | YES | Descriptive name | |
| poly_type | VARCHAR2(1) | YES | 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 | |
| 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 |
| PN00 | PrimaryKey | key |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| PN | PN_Data | Identifying | key |
| PN | Polynomial | Non-Identifying | pn_key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| PN_Data |
| Owner | |
| Definition | Coefficients of a polynomial |
| Note | |
| DDL Code | CREATE TABLE PN_Data( key NUMBER(8, 0) NOT NULL, row_key NUMBER(8, 0) NOT NULL, pn_value DOUBLE PRECISION, CONSTRAINT PND01 CHECK (row_key >= 0), CONSTRAINT PND00 PRIMARY KEY (key, row_key), CONSTRAINT PN_Data_PN FOREIGN KEY (key) REFERENCES PN(key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| key |
NUMBER(8, 0) | NO | This attribute denotes a unique identifier for a response (poles & zeros) | |
| row_key |
NUMBER(8, 0) | NO | Row key for responses | |
| pn_value | DOUBLE PRECISION | YES | This attribute denotes the coefficient value of a polynomial |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PND00 | PrimaryKey | key,row_key |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| PN | PN_Data | Identifying | key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| Poles_Zeros |
| Owner | |
| Definition | Data associating a channel with poles & zeros |
| Note | |
| DDL Code | CREATE TABLE Poles_Zeros( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2) NOT NULL, ondate DATE NOT NULL, stage_seq NUMBER(8, 0) NOT NULL, channel VARCHAR2(3), channelsrc VARCHAR2(8), offdate DATE, pz_key NUMBER(8, 0) NOT NULL, tf_type VARCHAR2(1), unit_in NUMBER(8, 0) NOT NULL, unit_out NUMBER(8, 0) NOT NULL, AO DOUBLE PRECISION NOT NULL, AF DOUBLE PRECISION, lddate DATE DEFAULT (SYSDATE), CONSTRAINT P_Z01 CHECK (AF >= 0.0), CONSTRAINT P_Z02 CHECK (stage_seq >= 0), CONSTRAINT P_Z03 CHECK (tf_type IN ('A','B','C','D','P')), CONSTRAINT P_Z00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq), CONSTRAINT Pol_Zer_Cha_Dat FOREIGN KEY (net,sta,seedchan,location,ondate) REFERENCES Channel_Data(net,sta,seedchan,location,ondate), CONSTRAINT Pol_Zer_D_Uni FOREIGN KEY (unit_in) REFERENCES D_Unit(id), CONSTRAINT Pol_Zer_D_Uni2 FOREIGN KEY (unit_out) REFERENCES D_Unit(id), CONSTRAINT Pol_Zer_PZ FOREIGN KEY (pz_key) REFERENCES PZ(key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| seedchan |
VARCHAR2(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code | |
| location |
VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| stage_seq |
NUMBER(8, 0) | NO | This attribute denotes the stage number | |
| 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, etc.) | |
| offdate | DATE | YES | This attribute denotes the end date | |
| pz_key |
NUMBER(8, 0) | NO | Response (Poles & zeros) key | |
| tf_type | VARCHAR2(1) | YES | A single character describing the type of stage | |
| 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 | |
| AO | DOUBLE PRECISION | NO | This field is mandatory and must be set such that when the polynomial is evaluated at the reference frequency the result will be 1 | |
| AF | DOUBLE PRECISION | YES | Frequency fn, at which the value in field AO is normalized (if any) | |
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| P_Z00 | PrimaryKey | net,sta,seedchan,location,ondate,stage_seq |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Channel_Data | Poles_Zeros | Identifying | net,sta,seedchan,location,ondate |
| D_Unit | Poles_Zeros | Non-Identifying | unit_in |
| D_Unit | Poles_Zeros | Non-Identifying | unit_out |
| PZ | Poles_Zeros | Non-Identifying | pz_key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| Polynomial |
| Owner | |
| Definition | Data associating a channel with a polynomial |
| Note | |
| DDL Code | CREATE TABLE Polynomial( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2) NOT NULL, ondate DATE NOT NULL, stage_seq NUMBER(8, 0) NOT NULL, channel VARCHAR2(3), channelsrc VARCHAR2(8), offdate DATE, pn_key NUMBER(8, 0) NOT NULL, unit_in NUMBER(8, 0) NOT NULL, unit_out NUMBER(8, 0) NOT NULL, tf_type VARCHAR2(1), lddate DATE DEFAULT (SYSDATE), CONSTRAINT Po01 CHECK (stage_seq >= 0), CONSTRAINT Po02 CHECK (tf_type IN ('A','B','C','D','P')), CONSTRAINT Po00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq), CONSTRAINT Pol_Cha_Dat FOREIGN KEY (net,sta,seedchan,location,ondate) REFERENCES Channel_Data(net,sta,seedchan,location,ondate), CONSTRAINT Pol_D_Uni FOREIGN KEY (unit_in) REFERENCES D_Unit(id), CONSTRAINT Pol_D_Uni2 FOREIGN KEY (unit_out) REFERENCES D_Unit(id), CONSTRAINT Pol_PN FOREIGN KEY (pn_key) REFERENCES PN(key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| seedchan |
VARCHAR2(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code | |
| location |
VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| stage_seq |
NUMBER(8, 0) | NO | This attribute denotes the stage number | |
| 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, etc.) | |
| offdate | DATE | YES | This attribute denotes the end date | |
| pn_key |
NUMBER(8, 0) | NO | Response (Polynomial) key | |
| 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 | |
| tf_type | VARCHAR2(1) | YES | A single character describing the type of stage | |
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| Po00 | PrimaryKey | net,sta,seedchan,location,ondate,stage_seq |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Channel_Data | Polynomial | Identifying | net,sta,seedchan,location,ondate |
| D_Unit | Polynomial | Non-Identifying | unit_in |
| D_Unit | Polynomial | Non-Identifying | unit_out |
| PN | Polynomial | Non-Identifying | pn_key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| PZ |
| Owner | |
| Definition | Summary information on a response (Poles & Zeros) |
| Note | |
| DDL Code | CREATE TABLE PZ( key NUMBER(8, 0) NOT NULL, name VARCHAR2(80), lddate DATE DEFAULT (SYSDATE), CONSTRAINT PZ00 PRIMARY KEY (key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| key |
NUMBER(8, 0) | NO | This attribute denotes a unique identifier for a response (poles & zeros) | |
| name | VARCHAR2(80) | YES | Descriptive name | |
| 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 |
| PZ00 | PrimaryKey | key |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| PZ | Poles_Zeros | Non-Identifying | pz_key |
| PZ | PZ_Data | Identifying | key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| PZ_Data |
| Owner | |
| Definition | Poles & zeros of a response |
| Note | |
| DDL Code | CREATE TABLE PZ_Data( key NUMBER(8, 0) NOT NULL, row_key NUMBER(8, 0) NOT NULL, type VARCHAR2(1), r_value DOUBLE PRECISION NOT NULL, r_error DOUBLE PRECISION, i_value DOUBLE PRECISION NOT NULL, i_error DOUBLE PRECISION, CONSTRAINT PZD01 CHECK (row_key >= 0), CONSTRAINT PZD02 CHECK (type IN ('P','Z','N','D')), CONSTRAINT PZD00 PRIMARY KEY (key, row_key), CONSTRAINT PZ_Dat_PZ FOREIGN KEY (key) REFERENCES PZ(key) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| key |
NUMBER(8, 0) | NO | This attribute denotes a unique identifier for a response (poles & zeros) | |
| row_key |
NUMBER(8, 0) | NO | Row key for responses | |
| type | VARCHAR2(1) | YES | 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 |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PZD00 | PrimaryKey | key,row_key |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| PZ | PZ_Data | Identifying | key |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| Sensitivity |
| Owner | |
| Definition | Data associating a channel with a sensitivity |
| Note | |
| DDL Code | CREATE TABLE Sensitivity( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2) NOT NULL, ondate DATE NOT NULL, stage_seq NUMBER(8, 0) NOT NULL, channel VARCHAR2(3), channelsrc VARCHAR2(8), offdate DATE, sensitivity DOUBLE PRECISION NOT NULL, frequency DOUBLE PRECISION, lddate DATE DEFAULT (SYSDATE), CONSTRAINT Se01 CHECK (frequency >= 0.0), CONSTRAINT Se02 CHECK (stage_seq >= 0), CONSTRAINT Se00 PRIMARY KEY (net, sta, seedchan, location, ondate, stage_seq), CONSTRAINT Sen_Cha_Dat FOREIGN KEY (net,sta,seedchan,location,ondate) REFERENCES Channel_Data(net,sta,seedchan,location,ondate) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| seedchan |
VARCHAR2(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code | |
| location |
VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| stage_seq |
NUMBER(8, 0) | NO | This attribute denotes the stage number | |
| 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, etc.) | |
| offdate | DATE | YES | This attribute denotes the end date | |
| sensitivity | DOUBLE PRECISION | NO | The gain (Sd) at this stage, or the sensitivity (Sd) for the channel | |
| frequency | DOUBLE PRECISION | YES | The frequency (fs) at which the value in sensitivity is correct | |
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| Se00 | PrimaryKey | net,sta,seedchan,location,ondate,stage_seq |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Channel_Data | Sensitivity | Identifying | net,sta,seedchan,location,ondate |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |
| Simple_Response |
| Owner | |
| Definition | Summary information on a simplified response |
| Note | |
| DDL Code | CREATE TABLE Simple_Response( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2) NOT NULL, ondate DATE NOT NULL, channel VARCHAR2(3), channelsrc VARCHAR2(8), natural_frequency DOUBLE PRECISION, damping_constant DOUBLE PRECISION, gain DOUBLE PRECISION, gain_units VARCHAR2(20), low_freq_corner DOUBLE PRECISION, high_freq_corner DOUBLE PRECISION, offdate DATE, lddate DATE DEFAULT (SYSDATE), dlogsens NUMBER(8, 0), CONSTRAINT SiRe01 CHECK (natural_frequency >= 0.0), CONSTRAINT SiRe00 PRIMARY KEY (net, sta, seedchan, location, ondate), CONSTRAINT Sim_Res_Cha_Dat FOREIGN KEY (net,sta,seedchan,location,ondate) REFERENCES Channel_Data(net,sta,seedchan,location,ondate) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| seedchan |
VARCHAR2(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code | |
| location |
VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| channel | 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, etc.) | |
| natural_frequency | DOUBLE PRECISION | YES | Natural frequency | |
| damping_constant | DOUBLE PRECISION | YES | This attribute denotes the damping constant of the system | |
| gain | DOUBLE PRECISION | YES | This attribute denotes the gain of the system. The units of the gain are given by the gain_units attribute | |
| gain_units | VARCHAR2(20) | YES | This attribute denotes the units of the gain of the system, as given by the gain attribute | |
| low_freq_corner | DOUBLE PRECISION | YES | Low frequency corner | |
| high_freq_corner | DOUBLE PRECISION | YES | High frequency corner | |
| 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 | |
| dlogsens | NUMBER(8, 0) | YES | Digitizer sensitivity |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SiRe00 | PrimaryKey | net,sta,seedchan,location,ondate |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Channel_Data | Simple_Response | Identifying | net,sta,seedchan,location,ondate |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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_Comment |
| Owner | |
| Definition | Comments for a station |
| Note | |
| DDL Code | CREATE TABLE Station_Comment( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, ondate DATE NOT NULL, comment_id NUMBER(8, 0) NOT NULL, offdate DATE, comment_level NUMBER(8, 0), lddate DATE DEFAULT (SYSDATE), CONSTRAINT StC00 PRIMARY KEY (net, sta, ondate, comment_id), CONSTRAINT Sta_Com_D_Com FOREIGN KEY (comment_id) REFERENCES D_Comment(id), CONSTRAINT Sta_Com_Sta_Dat FOREIGN KEY (net,sta,ondate) REFERENCES Station_Data(net,sta,ondate) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| comment_id |
NUMBER(8, 0) | NO | The comment code key of the associated Comment Description Dictionary | |
| offdate | DATE | YES | This attribute denotes the end date | |
| comment_level | NUMBER(8, 0) | YES | The numeric value (if any) associated with the Units of comment level in the same Comment Description Dictionary. Together, this numeric value, its units, and the Description of comment of the associated Comment Description, all describe a comment for the station/channel | |
| lddate | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| StC00 | PrimaryKey | net,sta,ondate,comment_id |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| D_Comment | Station_Comment | Identifying | comment_id |
| Station_Data | Station_Comment | Identifying | net,sta,ondate |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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_Data |
| Owner | |
| Definition | Summary information on a station |
| Note | |
| DDL Code | CREATE TABLE Station_Data( net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, ondate DATE NOT NULL, lat DOUBLE PRECISION, lon DOUBLE PRECISION, elev DOUBLE PRECISION, staname VARCHAR2(50), net_id NUMBER(8, 0), word_32 NUMBER(8, 0) NOT NULL, word_16 NUMBER(8, 0) NOT NULL, offdate DATE, lddate DATE DEFAULT (SYSDATE), CONSTRAINT StD03 CHECK (lon >= -180.0 AND lon <= 180.0), CONSTRAINT StD02 CHECK (lat >= -90.0 AND lat <= 90.0), CONSTRAINT StD00 PRIMARY KEY (net, sta, ondate), CONSTRAINT Sta_Dat_D_Abb FOREIGN KEY (net_id) REFERENCES D_Abbreviation(id) ) TABLESPACE IR_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| sta |
VARCHAR2(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used | |
| ondate |
DATE | NO | This attribute denotes the start date | |
| 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 | |
| net_id |
NUMBER(8, 0) | YES | The abbreviation lookup code from the Generic Abbreviation Dictionary, that refers to the network to which the station belongs | |
| 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 | |
| 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 |
| StD00 | PrimaryKey | net,sta,ondate |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| D_Abbreviation | Station_Data | Non-Identifying | net_id |
| Station_Data | Channel_Data | Identifying | net,sta,ondate |
| Station_Data | Station_Comment | Identifying | net,sta,ondate |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | IR_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 |