| trig_channel |
| Logical Entity Name | trig_channel |
| Default Table Name | trig_channel |
| Definition | Populated by trig2db |
| trig_channel Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| trigid |
NUMBER(15, 0) | NO | ||
| ntid | NUMBER(15, 0) | NO | ||
| auth | VARCHAR2(15) | NO | ||
| subsource | VARCHAR2(8) | YES | ||
| sta | VARCHAR2(6) | NO | ||
| net | VARCHAR2(8) | YES | ||
| channel | VARCHAR2(8) | YES | ||
| channelsrc | VARCHAR2(8) | YES | ||
| seedchan | VARCHAR2(3) | YES | ||
| location | VARCHAR2(2) | YES | ||
| trigflag | VARCHAR2(1) | YES | ||
| datetime | NUMBER(25, 10) | NO | ||
| savestart | NUMBER(25, 10) | NO | ||
| saveend | NUMBER(25, 10) | NO | ||
| rflag | VARCHAR2(2) | YES | ||
| lddate | DATE | YES |
| trig_channel Primary and Unique Keys |
| Key Name | Key Type | Keys |
| trigchankey01 | PrimaryKey | trigid |
| trig_channel 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 |
| trig_channel Check Constraints |
| Check Constraint Name | CheckConstraint |
| trigchan02 | rflag in ('a','h','f','A','H','F') |
| trigchan03 | trigflag in ('u','t','m') |
| trigchan01 | saveend > savestart |