Filamp_PChannel

Logical Entity Name | Filamp_PChannel
Default Table Name | Filamp_PChannel
Definition | Physical channel of a filter-amplifier

Filamp_PChannel 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
pchannel_nb |  | NUMBER(8, 0) | NO | This attribute denotes a physical channel
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
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

Filamp_PChannel Primary and Unique Keys

Key Name | Key Type | Keys
FiP00 | PrimaryKey | filamp_id, pchannel_nb

Filamp_PChannel Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred
Filamp | Identifying | One To Zero or More | Fil_PCh_Fil |  |  | filamp_id | NO | NO | NO

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred

Filamp_PChannel Check Constraints

Check Constraint Name | CheckConstraint
FiP01 | pchannel_nb >= 1