| nettrig |
| Logical Entity Name | nettrig |
| Default Table Name | nettrig |
| Definition | Populated by trig2db module |
| nettrig Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| ntid |
NUMBER(15, 0) | NO | ||
| auth | VARCHAR2(15) | NO | ||
| subsource | VARCHAR2(8) | YES | ||
| datetime | NUMBER(25, 10) | NO | ||
| algorithm | VARCHAR2(15) | YES | ||
| loctrigid | VARCHAR2(12) | YES | ||
| ntrig | NUMBER(5, 0) | NO | ||
| allchan | NUMBER(1, 0) | NO | ||
| savestart | NUMBER(25, 10) | YES | ||
| saveend | NUMBER(25, 10) | YES | ||
| rflag | VARCHAR2(2) | YES | ||
| lddate | DATE | YES | ||
| subnet_code | VARCHAR2(20) | YES |
| nettrig Primary and Unique Keys |
| Key Name | Key Type | Keys |
| nettrigkey01 | PrimaryKey | ntid |
| nettrig 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 |
| nettrig Check Constraints |
| Check Constraint Name | CheckConstraint |
| nettrig02 | saveend >= savestart |
| nettrig03 | rflag in ('a','h','f','A','H','F') |
| nettrig01 | (allchan >= 0) and (allchan <= 1) |