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