| wfid |
| Base Table | AssocWaE |
| Datatype | NUMBER(15, 0) |
| Nullable | NO |
| Domain | |
| Definition | Waveform identifier. The key field is a unique identifier for a segment of digital waveform data |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| evid |
| Base Table | AssocWaE |
| Datatype | NUMBER(15, 0) |
| Nullable | NO |
| Domain | |
| Definition | 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
|
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| datetime_on |
| Base Table | AssocWaE |
| Datatype | NUMBER(25, 10) |
| Nullable | NO |
| Domain | |
| Definition | Time of first datum |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| datetime_off |
| Base Table | AssocWaE |
| Datatype | NUMBER(25, 10) |
| Nullable | NO |
| Domain | |
| Definition | Time of last datum |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| lddate |
| Base Table | AssocWaE |
| Datatype | DATE |
| Nullable | NO |
| Domain | |
| Definition | Load date. Date and time that the record was created or last modified |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | (SYSDATE) |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| fileid |
| Base Table | Filename |
| Datatype | NUMBER(15, 0) |
| Nullable | NO |
| Domain | |
| Definition | Filename identifier. The key field is a unique identifier for a physical file on a disk |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| dfile |
| Base Table | Filename |
| Datatype | VARCHAR2(32) |
| Nullable | NO |
| Domain | |
| Definition | Data file. This is the file name of a disk-based waveform file |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| datetime_on |
| Base Table | Filename |
| Datatype | NUMBER(25, 10) |
| Nullable | NO |
| Domain | |
| Definition | Time of first sample in the waveform file |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| datetime_off |
| Base Table | Filename |
| Datatype | NUMBER(25, 10) |
| Nullable | NO |
| Domain | |
| Definition | Time of last sample in the waveform file |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| nbytes |
| Base Table | Filename |
| Datatype | NUMBER(10, 0) |
| Nullable | YES |
| Domain | |
| Definition | Number of bytes. This quantity is the number of bytes in a waveform segment or a file |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| subdirid |
| Base Table | Filename |
| Datatype | NUMBER(15, 0) |
| Nullable | NO |
| Domain | |
| Definition | Directory identifier. The key field is a unique identifier for a directory name on a disk |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| lddate |
| Base Table | Filename |
| Datatype | DATE |
| Nullable | NO |
| Domain | |
| Definition | Load date. Date and time that the record was created or last modified |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | (SYSDATE) |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| pathname |
| Base Table | Pathname |
| Datatype | VARCHAR2(255) |
| Nullable | NO |
| Domain | |
| Definition | Path name |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| net |
| Base Table | Pathname |
| Datatype | VARCHAR2(8) |
| Nullable | NO |
| Domain | |
| Definition | Unique network identifier. This character string is the name of a seismic network |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| wave_fmt |
| Base Table | Pathname |
| Datatype | NUMBER(2, 0) |
| Nullable | NO |
| Domain | |
| Definition | Waveform type |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| subdirid |
| Base Table | Subdir |
| Datatype | NUMBER(15, 0) |
| Nullable | NO |
| Domain | |
| Definition | Directory identifier. The key field is a unique identifier for a directory name on a disk |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| subdirname |
| Base Table | Subdir |
| Datatype | VARCHAR2(64) |
| Nullable | NO |
| Domain | |
| Definition | Path name. This is the name of a disk-based directory |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| lddate |
| Base Table | Subdir |
| Datatype | DATE |
| Nullable | NO |
| Domain | |
| Definition | Load date. Date and time that the record was created or last modified
|
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | (SYSDATE) |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| wfid |
| Base Table | Waveform |
| Datatype | NUMBER(15, 0) |
| Nullable | NO |
| Domain | |
| Definition | Waveform identifier. The key field is a unique identifier for a segment of digital waveform data |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| net |
| Base Table | Waveform |
| Datatype | VARCHAR2(8) |
| Nullable | NO |
| Domain | |
| Definition | Unique network identifier. This character string is the name of a seismic network |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| sta |
| Base Table | Waveform |
| Datatype | VARCHAR2(6) |
| Nullable | NO |
| Domain | |
| Definition | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| auth |
| Base Table | Waveform |
| Datatype | VARCHAR2(15) |
| Nullable | NO |
| Domain | |
| Definition | 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
|
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| subsource |
| Base Table | Waveform |
| Datatype | VARCHAR2(8) |
| Nullable | YES |
| Domain | |
| Definition | A second identifier to specify a unique source within the domain specified by auth |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| channel |
| Base Table | Waveform |
| Datatype | VARCHAR2(3) |
| Nullable | YES |
| Domain | |
| Definition | Channel name |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| channelsrc |
| Base Table | Waveform |
| Datatype | VARCHAR2(8) |
| Nullable | YES |
| Domain | |
| Definition | Domain for channel. This specifies what naming convention is used for the channel name (i.e. SEED, USGS, etc.) |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| seedchan |
| Base Table | Waveform |
| Datatype | VARCHAR2(3) |
| Nullable | NO |
| Domain | |
| Definition | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
|
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| location |
| Base Table | Waveform |
| Datatype | VARCHAR2(2) |
| Nullable | YES |
| Domain | |
| Definition | Describes the individual sites on an array station, operated by the same network operator |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| archive |
| Base Table | Waveform |
| Datatype | VARCHAR2(8) |
| Nullable | NO |
| Domain | |
| Definition | This field specifies the place where the seismogram is archived |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| datetime_on |
| Base Table | Waveform |
| Datatype | NUMBER(25, 10) |
| Nullable | NO |
| Domain | |
| Definition | Time of first datum |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| datetime_off |
| Base Table | Waveform |
| Datatype | NUMBER(25, 10) |
| Nullable | NO |
| Domain | |
| Definition | Time of last datum |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| samprate |
| Base Table | Waveform |
| Datatype | NUMBER(12, 8) |
| Nullable | NO |
| Domain | |
| Definition | Sampling rate. This attribute is the sample rate in samples/second |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| wavetype |
| Base Table | Waveform |
| Datatype | VARCHAR2(1) |
| Nullable | YES |
| Domain | |
| Definition | This attribute denotes the type of waveform |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| fileid |
| Base Table | Waveform |
| Datatype | NUMBER(15, 0) |
| Nullable | NO |
| Domain | |
| Definition | Filename identifier. The key field is a unique identifier for a physical file on a disk |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| foff |
| Base Table | Waveform |
| Datatype | NUMBER(12, 0) |
| Nullable | YES |
| Domain | |
| Definition | File offset. This is the byte offset of a waveform segment within a data file |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| nbytes |
| Base Table | Waveform |
| Datatype | NUMBER(10, 0) |
| Nullable | YES |
| Domain | |
| Definition | Number of bytes. This quantity is the number of bytes in a waveform segment or a file |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| traceoff |
| Base Table | Waveform |
| Datatype | NUMBER(10, 0) |
| Nullable | YES |
| Domain | |
| Definition | File offset. This is the byte offset of the entire trace |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| tracelen |
| Base Table | Waveform |
| Datatype | NUMBER(10, 0) |
| Nullable | YES |
| Domain | |
| Definition | Number of bytes. This quantity represents the length of the entire trace |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| status |
| Base Table | Waveform |
| Datatype | VARCHAR2(1) |
| Nullable | NO |
| Domain | |
| Definition | This attribute denotes the status of the waveform in the file |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| wave_fmt |
| Base Table | Waveform |
| Datatype | NUMBER(2, 0) |
| Nullable | YES |
| Domain | |
| Definition | Waveform type |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| format_id |
| Base Table | Waveform |
| Datatype | NUMBER(2, 0) |
| Nullable | YES |
| Domain | |
| Definition | This attribute denotes a code indicating the encoding format. This number is assigned by the FDSN Data Exchange Working Group |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| wordorder |
| Base Table | Waveform |
| Datatype | NUMBER(1, 0) |
| Nullable | YES |
| Domain | |
| Definition | Word order |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| recordsize |
| Base Table | Waveform |
| Datatype | NUMBER(5, 0) |
| Nullable | YES |
| Domain | |
| Definition | Record size for data. For MiniSEED, the value is the MiniSEED record size, eg. 512, 4096, etc |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| locevid |
| Base Table | Waveform |
| Datatype | VARCHAR2(12) |
| Nullable | YES |
| Domain | |
| Definition | 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 |
| Character Set | BYTE |
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |
| lddate |
| Base Table | Waveform |
| Datatype | DATE |
| Nullable | NO |
| Domain | |
| Definition | Load date. Date and time that the record was created or last modified
|
| Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | (SYSDATE) |
| Bound Default |
| Attachments |
| Name | Datatype | Value Override | Default Value | Description |