Station_Filamp

Logical Entity Name | Station_Filamp
Default Table Name | Station_Filamp
Definition | Data associating a station with a filter-amplifier

Station_Filamp Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
filamp_nb |  | NUMERIC(8, 0) | NO | This attribute represents the filter-amplifier number
ondate |  | DATE | NO | This attribute denotes the start date
filamp_id |  | NUMERIC(8, 0) | NO | Filter-amplifier identifier. Each filter-amplifier is assigned a unique integer which identifies it in a database
nb_pchannel |  | NUMERIC(8, 0) | NO | This attribute denotes the number of physical channels of a datalogger
offdate |  | DATE | YES | This attribute denotes the end date
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

Station_Filamp Keys

Key Name | Key Type | Keys
StFi00 | PrimaryKey | sta, net, filamp_nb, ondate

Station_Filamp Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Filamp | Non-Identifying | One To Zero or More |  |  |  | filamp_id | NO
Station | Identifying | One To Zero or More |  |  |  | sta, net, ondate | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
Station_Filamp_PChannel | Identifying | One To Zero or More |  |  |  |  | NO

Station_Filamp Check Constraints

Check Constraint Name | CheckConstraint
StFi01 | filamp_nb >= 1
StFi02 | nb_pchannel >= 0