request_card

Logical Entity Name | request_card
Default Table Name | request_card
Definition | List of channel time windows to be archived

request_card Columns

ColumnName | Domain | Datatype | NULL | Definition
evid |  | NUMBER(15, 0) | YES | Event identifier. Each event is assigned a unique integer which identifies it in a database
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) | NO | A second identifier to specify the system or process that derived the data. e.g., the origin's AUTH is CI, but the subsource (the solution) was computed by JIGGLE
net |  | VARCHAR2(8) | NO | Unique network identifier. This character string is the name of a seismic network
sta |  | VARCHAR2(8) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
seedchan |  | VARCHAR2(8) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
staauth |  | VARCHAR2(15) | NO | Purpose unknown (always same as subsource)
channel |  | VARCHAR2(8) | NO | Channel name
datetime_on |  | NUMBER(25, 10) | NO | Start time of time window to save
datetime_off |  | NUMBER(25, 10) | NO | End time of time window to save
request_type |  | VARCHAR2(1) | NO | Single character flag describing request type
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype
rcid |  | NUMBER(15, 0) | NO | Unique request row number. Derived from REQSEQ.
location |  | VARCHAR2(2) | NO | Describes the individual sites on an array station, operated by the same network operator
retry |  | NUMBER(38, 0) | YES | Count of attempts to retrieve this waveform
lastretry |  | DATE | YES | Time of last attempt to retrieve this waveform
priority |  | NUMBER | YES | Rows are processed in priority order, 1 is highest priority

request_card Primary and Unique Keys

Key Name | Key Type | Keys
request_cardkey01 | PrimaryKey | rcid

request_card Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable

request_card Check Constraints

Check Constraint Name | CheckConstraint
req01 | request_type in('T','C')
req02 | retry >=0