Filter_FIR_Data 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
coeff_nb		NUMBER(8, 0)	NO	The numerator/denominator number
type		VARCHAR2(1)	NO	This attribute denotes whether a value is associated with a numerator/denominator
coefficient		BINARY_FLOAT	NO	The numerator/denominator coefficient value
error		BINARY_FLOAT	YES	This attributes denotes the numerator/denominator error

Filter_FIR_Data Primary and Unique Keys

Key Name	Key Type	Keys
FFD00	PrimaryKey	fir_id, coeff_nb

Filter_FIR_Data Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
Filter_FIR	Identifying	One To Zero or More	Fil_FIR_Dat_Fil_FIR			fir_id	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

Filter_FIR_Data Check Constraints

Check Constraint Name	CheckConstraint
FFD01	coeff_nb >= 1
FFD02	type IN ('N','D')