appchannels

Logical Entity Name | appchannels
Default Table Name | appchannels
Definition | Associates NSCL stream codes with programs (used in Jiggle)

appchannels Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
progid |  | NUMERIC(8, 0) | NO | Keys to CONFIG_CHANNEL table
net |  | VARCHAR(8) | NO | Unique network identifier. This character string is the name of a seismic network
sta |  | VARCHAR(6) | NO | Station code. This is the common code-name of a seismic observatory. Generally only three or four characters are used
seedchan |  | VARCHAR(3) | NO | SEED channel name. The first character denotes the band code, the second for the instrument code and the third represents the component code
location |  | VARCHAR(2) | NO | Describes the individual sites on an array station, operated by the same network operator
config |  | VARCHAR(64) | YES | Misc note used by config file generation scripts. Originally intended to identify configs within a program group
ondate |  | DATE | NO | This attribute denotes the start date
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

appchannels Keys

Key Name | Key Type | Keys
config_chankey01_1 | PrimaryKey | progid, net, sta, seedchan, location, ondate

appchannels Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
applications | Identifying | One To Zero or More |  |  |  | progid | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

appchannels Check Constraints

Check Constraint Name | CheckConstraint