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')