Filamp 
Logical Entity Name  Filamp 
Default Table Name  Filamp 
Definition  Summary information on a filter-amplifier 

Filamp Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
filamp_id(PK)    NUMERIC(8, 0)  NO  Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database 
name    VARCHAR(80)  YES  This attribute denotes a descriptive name for a filter-amplifier 
serial_nb    VARCHAR(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    NUMERIC(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 Keys 
Key Name  Key Type  Keys 
Filamp00  PrimaryKey  filamp_id 

Filamp Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Filamp_PChannel  Identifying  One To Zero or More          NO 
Station_Filamp  Non-Identifying  One To Zero or More          NO 

Filamp Check Constraints 
Check Constraint Name  CheckConstraint 
Filamp01  nb_pchannel >= 0