| assocnte |
| Logical Entity Name | assocnte |
| Default Table Name | assocnte |
| Definition | Populated by tc module -- associates an event with a network trigger |
| assocnte Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| ntid |
NUMBER(15, 0) | NO | ||
| evid |
NUMBER(15, 0) | NO | ||
| auth | VARCHAR2(15) | NO | ||
| subsource | VARCHAR2(8) | YES | ||
| rflag | VARCHAR2(2) | YES | ||
| lddate | DATE | YES | ||
| wfflag | NUMBER(1, 0) | YES |
| assocnte Primary and Unique Keys |
| Key Name | Key Type | Keys |
| assocntekey01 | PrimaryKey | ntid, evid |
| assocnte Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
| assocnte Check Constraints |
| Check Constraint Name | CheckConstraint |
| assocnte01 | rflag in ('a','h','f','A','H','F') |