Primary Key
Program name used in sql_chanloader system. Example: AmpGen
Load date. Date and time that the record was created or last modified, in Oracle date datatype
| program |
| Logical Entity Name | program |
| Default Table Name | program |
| Definition | Maps Program Names to PROGID's (used in sql_chanloader system( |
| program 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 |
| program Keys |
| Key Name | Key Type | Keys |
| progkey01 | PrimaryKey | progid |
| program 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 |
| config_channel | Identifying | One To Zero or More | NO |
| program Check Constraints |
| Check Constraint Name | CheckConstraint |
| prog02 | progid > 0 |