Response Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
seqresp_id		NUMERIC(8, 0)	NO	Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
resp_nb		NUMERIC(8, 0)	NO	This attribute denotes the response number of a sequence
resp_type		VARCHAR(1)	NO	This attribute denotes the response type
resp_id		NUMERIC(8, 0)	NO	Response identifier. Each response is assigned a unique integer which identifies it in a database
unit_in		NUMERIC(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		NUMERIC(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		VARCHAR(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 Keys

Key Name	Key Type	Keys
Re00	PrimaryKey	seqresp_id, resp_nb

Response Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Filter_FIR	Non-Identifying	One To Zero or More				resp_id	NO
Response_HP	Non-Identifying	One To Zero or More				resp_id	NO
Response_LP	Non-Identifying	One To Zero or More				resp_id	NO
Response_PN	Non-Identifying	One To Zero or More				resp_id	NO
Response_PZ	Non-Specific						NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Filamp_PChannel	Non-Specific						NO
Filter	Non-Specific						NO
Sensor_Component	Non-Specific						NO

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