Filamp Columns

ColumnName	Domain	Datatype	NULL	Definition
filamp_id		NUMBER(8, 0)	NO	Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
name		VARCHAR2(80)	YES	This attribute denotes a descriptive name for a filter-amplifier
serial_nb		VARCHAR2(80)	YES	This attribute denotes a serial number of a filter-amplifier
ondate		DATE	NO	This attribute denotes the start date
offdate		DATE	YES	This attribute denotes the end date
nb_pchannel		NUMBER(8, 0)	NO	This attribute denotes the number of physical channels of a datalogger
lddate		DATE	YES	Load date. Date and time that the record was created or last modified, in Oracle date datatype

Filamp Primary and Unique Keys

Key Name	Key Type	Keys
Filamp00	PrimaryKey	filamp_id

Filamp 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
Filamp_PChannel	Identifying	One To Zero or More	Fil_PCh_Fil				NO	NO	NO
Station_Filamp	Non-Identifying	One To Zero or More	Sta_Fil_Fil				NO	NO	NO

Filamp Check Constraints

Check Constraint Name	CheckConstraint
Filamp01	nb_pchannel >= 0