Filter_FIR Columns

ColumnName	Domain	Datatype	NULL	Definition
fir_id		NUMBER(8, 0)	NO	FIR Filter identifier. Each FIR filter is assigned a unique integer which identifies it in a database
name		VARCHAR2(80)	YES	This attribute denotes a descriptive name for a FIR filter
symmetry		VARCHAR2(1)	NO	This attribute denotes the eventual symmetry of a response
gain		BINARY_FLOAT	YES	This attribute denotes the gain
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

Filter_FIR Primary and Unique Keys

Key Name	Key Type	Keys
FFIR00	PrimaryKey	fir_id

Filter_FIR Foreign Keys

Parent Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Supertype

Deferrable

Initially Deferred

Child Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype	Deferrable	Initially Deferred
Filter_FIR_Data	Identifying	One To Zero or More	Fil_FIR_Dat_Fil_FIR				NO	NO	NO
Response	Non-Identifying	One To Zero or More	Res_Fil_FIR				NO	NO	NO

Filter_FIR Check Constraints

Check Constraint Name	CheckConstraint
FFIR01	symmetry IN ('E','O','N')