| 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 |