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

Filter Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
filter_id(PK)    NUMERIC(8, 0)  NO  Filter identifier. Each filter is assigned a unique integer which identifies it in a database 
gain    FLOAT  YES  This attribute denotes the gain 
frequency    FLOAT  YES  The frequency (fs) at which the value in sensitivity/gain is correct 
in_sp_rate    FLOAT  YES  Sampling rate. This attribute is the input sample rate in samples/second 
out_sp_rate    FLOAT  YES  Sampling rate. This attribute is the output sample rate in samples/second 
offset    NUMERIC(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    FLOAT  YES  The estimated pure delay for the filter 
correction    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    NUMERIC(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 Keys 
Key Name  Key Type  Keys 
Fi00  PrimaryKey  filter_id 

Filter Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Response  Non-Specific            NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Filter_Sequence_Data  Non-Identifying  One To Zero or More          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