| AssocWaE |
| Owner | |
| Definition | Data associating waveforms with events |
| Note | |
| DDL Code | CREATE TABLE AssocWaE( wfid NUMBER(15, 0) NOT NULL, evid NUMBER(15, 0) NOT NULL, datetime_on NUMBER(25, 10) NOT NULL, datetime_off NUMBER(25, 10) NOT NULL, lddate DATE DEFAULT (SYSDATE) NOT NULL, CONSTRAINT AWE00 PRIMARY KEY (wfid, evid), CONSTRAINT Waveform_Event FOREIGN KEY (wfid) REFERENCES Waveform(wfid) ) TABLESPACE WF_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| wfid |
NUMBER(15, 0) | NO | Waveform identifier. The key field is a unique identifier for a segment of digital waveform data | |
| evid |
NUMBER(15, 0) | NO | Event identifier. Each event is assigned a unique integer which identifies it in a database. It is possible for several records in the Origin relation to have the same evid. This indicates there are several opinions about the location of the event. The evid does not have to be identical to the local network's event identifier, which is stored in the Origin table. This allows to merge data for a single event from multiple sources without insisting that database evid is identical to the source's local event identifier
|
|
| datetime_on | NUMBER(25, 10) | NO | Time of first datum | |
| datetime_off | NUMBER(25, 10) | NO | Time of last datum | |
| lddate | DATE | NO | Load date. Date and time that the record was created or last modified |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| AWE00 | PrimaryKey | wfid,evid |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Waveform | AssocWaE | Identifying | wfid |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | WF_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 |
| Filename |
| Owner | |
| Definition | Summary information on a waveform filenames |
| Note | |
| DDL Code | CREATE TABLE Filename( fileid NUMBER(15, 0) NOT NULL, dfile VARCHAR2(32) NOT NULL, datetime_on NUMBER(25, 10) NOT NULL, datetime_off NUMBER(25, 10) NOT NULL, nbytes NUMBER(10, 0), subdirid NUMBER(15, 0) NOT NULL, lddate DATE DEFAULT (SYSDATE) NOT NULL, CONSTRAINT Fil00 PRIMARY KEY (fileid), CONSTRAINT Filename_PartialPath FOREIGN KEY (subdirid) REFERENCES Subdir(subdirid) ) TABLESPACE WF_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| fileid |
NUMBER(15, 0) | NO | Filename identifier. The key field is a unique identifier for a physical file on a disk | |
| dfile | VARCHAR2(32) | NO | Data file. This is the file name of a disk-based waveform file | |
| datetime_on | NUMBER(25, 10) | NO | Time of first sample in the waveform file | |
| datetime_off | NUMBER(25, 10) | NO | Time of last sample in the waveform file | |
| nbytes | NUMBER(10, 0) | YES | Number of bytes. This quantity is the number of bytes in a waveform segment or a file | |
subdirid |
NUMBER(15, 0) | NO | Directory identifier. The key field is a unique identifier for a directory name on a disk | |
| lddate | DATE | NO | Load date. Date and time that the record was created or last modified |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| Fil00 | PrimaryKey | fileid |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Subdir | Filename | Non-Identifying | subdirid |
| Filename | Waveform | Non-Identifying | fileid |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | WF_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 |
| Pathname |
| Owner | |
| Definition | Summary information on possible path options of waveforms for a given network |
| Note | |
| DDL Code | CREATE TABLE Pathname( pathname VARCHAR2(255) NOT NULL, net VARCHAR2(8) NOT NULL, wave_fmt NUMBER(2, 0) NOT NULL, CONSTRAINT PKPathname PRIMARY KEY (pathname, net, wave_fmt) ) TABLESPACE WF_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| pathname |
VARCHAR2(255) | NO | Path name | |
| net |
VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network | |
| wave_fmt |
NUMBER(2, 0) | NO | Waveform type |
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | WF_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 |
| Subdir |
| Owner | |
| Definition | Summary information on a directory name |
| Note | |
| DDL Code | CREATE TABLE Subdir( subdirid NUMBER(15, 0) NOT NULL, subdirname VARCHAR2(64) NOT NULL, lddate DATE DEFAULT (SYSDATE) NOT NULL, CONSTRAINT Sub00 PRIMARY KEY (subdirid) ) TABLESPACE WF_DATA ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| subdirid |
NUMBER(15, 0) | NO | Directory identifier. The key field is a unique identifier for a directory name on a disk | |
| subdirname | VARCHAR2(64) | NO | Path name. This is the name of a disk-based directory | |
| lddate | DATE | NO | Load date. Date and time that the record was created or last modified
|
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| Sub00 | PrimaryKey | subdirid |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Subdir | Filename | Non-Identifying | subdirid |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | WF_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 |
| Waveform |
| Owner | |
| Definition | Summary information on a waveform |
| Note | |
| DDL Code | CREATE TABLE Waveform( wfid NUMBER(15, 0) NOT NULL, net VARCHAR2(8) NOT NULL, sta VARCHAR2(6) NOT NULL, auth VARCHAR2(15) NOT NULL, subsource VARCHAR2(8), channel VARCHAR2(3), channelsrc VARCHAR2(8), seedchan VARCHAR2(3) NOT NULL, location VARCHAR2(2), archive VARCHAR2(8) NOT NULL, datetime_on NUMBER(25, 10) NOT NULL, datetime_off NUMBER(25, 10) NOT NULL, samprate NUMBER(12, 8) NOT NULL, wavetype VARCHAR2(1), fileid NUMBER(15, 0) NOT NULL, foff NUMBER(12, 0), nbytes NUMBER(10, 0), traceoff NUMBER(10, 0), tracelen NUMBER(10, 0), status VARCHAR2(1) NOT NULL, wave_fmt NUMBER(2, 0), format_id NUMBER(2, 0), wordorder NUMBER(1, 0), recordsize NUMBER(5, 0), locevid VARCHAR2(12), lddate DATE DEFAULT (SYSDATE) NOT NULL, CONSTRAINT WF00 PRIMARY KEY (wfid), CONSTRAINT Waveform_Filename FOREIGN KEY (fileid) REFERENCES Filename(fileid) ) TABLESPACE WF_DATA PARTITION BY RANGE (datetime_on)( PARTITION Wf1986 VALUES LESS THAN (536457613) TABLESPACE PWF1986, PARTITION Wf1987 VALUES LESS THAN (567993614) TABLESPACE PWF1987, PARTITION Wf1988 VALUES LESS THAN (599616014) TABLESPACE PWF1988, PARTITION Wf1989 VALUES LESS THAN (631152015) TABLESPACE PWF1989, PARTITION Wf1990 VALUES LESS THAN (662688016) TABLESPACE PWF1990, PARTITION Wf1991 VALUES LESS THAN (694224016) TABLESPACE PWF1991, PARTITION Wf1992 VALUES LESS THAN (725846417) TABLESPACE PWF1992, PARTITION Wf1993 VALUES LESS THAN (757382418) TABLESPACE PWF1993, PARTITION Wf1994 VALUES LESS THAN (788918419) TABLESPACE PWF1994, PARTITION Wf1995 VALUES LESS THAN (820454420) TABLESPACE PWF1995, PARTITION Wf1996 VALUES LESS THAN (852076820) TABLESPACE PWF1996, PARTITION Wf1997 VALUES LESS THAN (883612821) TABLESPACE PWF1997, PARTITION Wf1998 VALUES LESS THAN (915148821) TABLESPACE PWF1998, PARTITION Wf1999 VALUES LESS THAN (946684821) TABLESPACE PWF1999 ) ; |
| Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| wfid |
NUMBER(15, 0) | NO | Waveform identifier. The key field is a unique identifier for a segment of digital waveform data | |
| 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 | |
| auth | VARCHAR2(15) | NO | The auth field specifies the source of the information. This may be a network identifier (FDSN or otherwise), or any other string indicating the source of the information in the record
|
|
| subsource | VARCHAR2(8) | YES | A second identifier to specify a unique source within the domain specified by auth | |
| 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.) | |
| 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) | YES | Describes the individual sites on an array station, operated by the same network operator | |
| archive | VARCHAR2(8) | NO | This field specifies the place where the seismogram is archived | |
| datetime_on | NUMBER(25, 10) | NO | Time of first datum | |
| datetime_off | NUMBER(25, 10) | NO | Time of last datum | |
| samprate | NUMBER(12, 8) | NO | Sampling rate. This attribute is the sample rate in samples/second | |
| wavetype | VARCHAR2(1) | YES | This attribute denotes the type of waveform | |
| fileid |
NUMBER(15, 0) | NO | Filename identifier. The key field is a unique identifier for a physical file on a disk | |
| foff | NUMBER(12, 0) | YES | File offset. This is the byte offset of a waveform segment within a data file | |
| nbytes | NUMBER(10, 0) | YES | Number of bytes. This quantity is the number of bytes in a waveform segment or a file | |
| traceoff | NUMBER(10, 0) | YES | File offset. This is the byte offset of the entire trace | |
| tracelen | NUMBER(10, 0) | YES | Number of bytes. This quantity represents the length of the entire trace | |
| status | VARCHAR2(1) | NO | This attribute denotes the status of the waveform in the file | |
| wave_fmt | NUMBER(2, 0) | YES | Waveform type | |
| format_id | NUMBER(2, 0) | YES | This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group | |
| wordorder | NUMBER(1, 0) | YES | Word order | |
| recordsize | NUMBER(5, 0) | YES | Record size for data. For MiniSEED, the value is the MiniSEED record size, eg. 512, 4096, etc | |
| locevid | VARCHAR2(12) | YES | Local event identifier. This attribute describes the original event identifier of the event. In combination with auth and subsource, it can be used to uniquely identify the original event identifier from that source. For example, waveforms from the original source may be associated with this identifier | |
| lddate | DATE | NO | Load date. Date and time that the record was created or last modified
|
| Primary and Unique Keys |
| Key Name | Key Type | Keys |
| WF00 | PrimaryKey | wfid |
| Foreign Keys |
| Parent Table | Child Table | Type | Foreign Keys |
| Filename | Waveform | Non-Identifying | fileid |
| Waveform | AssocWaE | Identifying | wfid |
| Storage |
| STORAGE OPTION | STORAGE VALUE |
| TABLESPACE | WF_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 |
| PARTITION NAME | Wf1986 |
| COLUMN HIGH VALUE | datetime_on:536457613 |
| TABLESPACE | PWF1986 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1987 |
| COLUMN HIGH VALUE | datetime_on:567993614 |
| TABLESPACE | PWF1987 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1988 |
| COLUMN HIGH VALUE | datetime_on:599616014 |
| TABLESPACE | PWF1988 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1989 |
| COLUMN HIGH VALUE | datetime_on:631152015 |
| TABLESPACE | PWF1989 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1990 |
| COLUMN HIGH VALUE | datetime_on:662688016 |
| TABLESPACE | PWF1990 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1991 |
| COLUMN HIGH VALUE | datetime_on:694224016 |
| TABLESPACE | PWF1991 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1992 |
| COLUMN HIGH VALUE | datetime_on:725846417 |
| TABLESPACE | PWF1992 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1993 |
| COLUMN HIGH VALUE | datetime_on:757382418 |
| TABLESPACE | PWF1993 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1994 |
| COLUMN HIGH VALUE | datetime_on:788918419 |
| TABLESPACE | PWF1994 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1995 |
| COLUMN HIGH VALUE | datetime_on:820454420 |
| TABLESPACE | PWF1995 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1996 |
| COLUMN HIGH VALUE | datetime_on:852076820 |
| TABLESPACE | PWF1996 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1997 |
| COLUMN HIGH VALUE | datetime_on:883612821 |
| TABLESPACE | PWF1997 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1998 |
| COLUMN HIGH VALUE | datetime_on:915148821 |
| TABLESPACE | PWF1998 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| PARTITION NAME | Wf1999 |
| COLUMN HIGH VALUE | datetime_on:946684821 |
| TABLESPACE | PWF1999 |
| PCTFREE | 0 |
| PCTUSED | 0 |
| PCTINCREASE | |
| MINEXTENTS | 0 |
| MAXEXTENTS | 0 |
| INITIAL | 0 |
| NEXT | 0 |
| INITRANS | 0 |
| MAXTRANS | 0 |
| LOGGING | |
| FREELISTS | |
| FREELIST GROUPS | |
| BUFFER POOL | |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |