applications

Logical Entity Name | applications
Default Table Name | applications
Definition | Maps Program Names to PROGID's (used in Jiggle)

applications Columns

ColumnName | Domain | Datatype | NULL | Definition
progid |  | NUMBER(8, 0) | NO | Primary Key
name |  | VARCHAR2(16) | NO | Program name used in sql_chanloader system. Example: AmpGen
lddate |  | DATE | YES | Load date. Date and time that the record was created or last modified, in Oracle date datatype

applications Primary and Unique Keys

Key Name | Key Type | Keys
progkey01_1 | PrimaryKey | progid

applications Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable
appchannels | Identifying | One To Zero or More |  |  |  |  | NO | NO

applications Check Constraints

Check Constraint Name | CheckConstraint
prog02_1 | progid > 0