Filter_FIR

Logical Entity Name | Filter_FIR
Default Table Name | Filter_FIR
Definition | Summary information on a FIR filter

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