| nettrig |
| Logical Entity Name | nettrig |
| Default Table Name | nettrig |
| Definition | Populated by trig2db module |
| nettrig Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
NTID |
NUMERIC(15, 0) | NO | ||
| AUTH | VARCHAR(15) | NO | ||
| SUBSOURCE | VARCHAR(8) | YES | ||
| DATETIME | NUMERIC(25, 10) | NO | ||
| ALGORITHM | VARCHAR(15) | YES | ||
| LOCTRIGID | VARCHAR(12) | YES | ||
| NTRIG | NUMERIC(5, 0) | NO | ||
| ALLCHAN | NUMERIC(1, 0) | NO | ||
| SAVESTART | NUMERIC(25, 10) | YES | ||
| SAVEEND | NUMERIC(25, 10) | YES | ||
| RFLAG | VARCHAR(2) | YES | ||
| LDDATE | DATE | YES | ||
| SUBNET_CODE | VARCHAR(20) | YES |
| nettrig Keys |
| Key Name | Key Type | Keys |
| NETTRIGKEY01 | PrimaryKey | NTID |
| nettrig 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 |
| nettrig Check Constraints |
| Check Constraint Name | CheckConstraint |
| NETTRIG01 | (allchan >= 0) and (allchan <= 1) |
| NETTRIG02 | saveend >= savestart |
| NETTRIG03 | rflag in ('a','h','f','A','H','F') |