Filter

Filter

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

Filter Columns

ColumnName Domain Datatype NULL Definition

filter_id (PK) 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

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

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

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