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