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(PK)    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