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