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		DOUBLE PRECISION	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

Child Relationships:

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

Filter_FIR Check Constraints

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