Filter

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

Filter Columns

ColumnName | Domain | Datatype | NULL | Definition
filter_id |  | NUMBER(8, 0) | NO | Filter identifier. Each filter is assigned a unique integer which identifies it in a database
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
in_sp_rate |  | BINARY_FLOAT | YES | Sampling rate. This attribute is the input sample rate in samples/second
out_sp_rate |  | BINARY_FLOAT | YES | Sampling rate. This attribute is the output sample rate in samples/second
offset |  | NUMBER(8, 0) | YES | This field determines which sample is chosen for use. The value of this field has to be greater than or equal to zero, but less than the decimation factor
delay |  | BINARY_FLOAT | YES | The estimated pure delay for the filter
correction |  | BINARY_FLOAT | NO | The time shift applied to the time tag due to delay at this stage of the filter; a negative number indicating the amount of time added to the former time tag. The actual delay is difficult to estimate, and the correction applied neglects dispersion. This field allows to know how much correction was used, in case a more accurate correction is to be applied later. A zero here implies no correction was done
seqresp_id |  | NUMBER(8, 0) | YES | Sequence of responses identifier. Each sequence of responses is assigned a unique integer which identifies it in a database
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Filter Primary and Unique Keys

Key Name | Key Type | Keys
Fi00 | PrimaryKey | filter_id

Filter 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 | Non-Identifying | One To Zero or More | Fil_Seq_Dat_Fil |  |  |  | NO | NO | NO

Filter Check Constraints

Check Constraint Name | CheckConstraint
Fi01 | frequency >= 0.0
Fi02 | in_sp_rate > 0.0
Fi03 | out_sp_rate > 0.0
Fi04 | offset >= 0