Response

Logical Entity Name | Response
Default Table Name | Response
Definition | Summary information on a sequence of responses

Response Columns

ColumnName | Domain | Datatype | NULL | Definition
seqresp_id |  | NUMBER(8, 0) | NO | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
resp_nb |  | NUMBER(8, 0) | NO | This attribute denotes the response number of a sequence
resp_type |  | VARCHAR2(1) | NO | This attribute denotes the response type
resp_id |  | NUMBER(8, 0) | NO | Response identifier. Each response is assigned a unique integer which identifies it in a database
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
r_type |  | VARCHAR2(1) | YES | A single character describing the type of response
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Response Primary and Unique Keys

Key Name | Key Type | Keys
Re00 | PrimaryKey | seqresp_id, resp_nb

Response Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
Filter_FIR | Non-Identifying | One To Zero or More | Res_Fil_FIR |  |  | resp_id | NO | NO | NO
Response_HP | Non-Identifying | One To Zero or More | Res_Res_HP |  |  | resp_id | NO | NO | NO
Response_LP | Non-Identifying | One To Zero or More | Res_Res_LP |  |  | resp_id | NO | NO | NO
Response_PN | Non-Identifying | One To Zero or More | Res_Res_PN |  |  | resp_id | NO | NO | NO

Child Relationships:

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

Response Check Constraints

Check Constraint Name | CheckConstraint
Re01 | r_type IN ('A','B','C','D','P')
Re02 | resp_nb >= 1
Re03 | resp_type IN ('H','L','P','Z','F','N')