Filter_Sequence

Logical Entity Name | Filter_Sequence
Default Table Name | Filter_Sequence
Definition | Summary information on a sequence of filters

Filter_Sequence Columns

ColumnName | Domain | Datatype | NULL | Definition
seqfil_id |  | NUMBER(8, 0) | NO | Sequence of filters identifier. Each sequence of filters is assigned a unique integer which identifies it in a database
name |  | VARCHAR2(32) | NO | This attribute denotes a descriptive name for a chain of filters
nb_filter |  | NUMBER(8, 0) | NO | This attribute denotes the number of filters of a sequence
gain |  | BINARY_FLOAT | YES | This attribute denotes the gain
frequency |  | BINARY_FLOAT | YES | The frequency (fs) at which the value in sensitivity/gain is correct
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Filter_Sequence Primary and Unique Keys

Key Name | Key Type | Keys
FiS00 | PrimaryKey | seqfil_id

Filter_Sequence 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_Sequence_Data | Identifying | One To Zero or More | Fil_Seq_Dat_Fil_Seq |  |  |  | NO | NO | NO
Station_Datalogger_LChannel | Non-Identifying | One To Zero or More | Sta_Dat_LCh_Fil_Seq |  |  |  | NO | NO | NO

Filter_Sequence Check Constraints

Check Constraint Name | CheckConstraint
FiS01 | frequency >= 0.0
FiS02 | nb_filter >= 0