| applications |
| Logical Entity Name | applications |
| Default Table Name | applications |
| Definition | Maps Program Names to PROGID's (used in Jiggle) |
| applications Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| progid |
NUMERIC(8, 0) | NO | Primary Key | |
| name | VARCHAR(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 Keys |
| Key Name | Key Type | Keys |
| progkey01_1 | PrimaryKey | progid |
| applications Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| appchannels | Identifying | One To Zero or More | NO |
| applications Check Constraints |
| Check Constraint Name | CheckConstraint |
| prog02_1 | progid > 0 |