Filamp

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

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