trig_channel

Logical Entity Name | trig_channel
Default Table Name | trig_channel
Definition | Populated by trig2db

trig_channel Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
TRIGID |  | NUMERIC(15, 0) | NO |
NTID |  | NUMERIC(15, 0) | NO |
AUTH |  | VARCHAR(15) | NO |
SUBSOURCE |  | VARCHAR(8) | YES |
STA |  | VARCHAR(6) | NO |
NET |  | VARCHAR(8) | YES |
CHANNEL |  | VARCHAR(8) | YES |
CHANNELSRC |  | VARCHAR(8) | YES |
SEEDCHAN |  | VARCHAR(3) | YES |
LOCATION |  | VARCHAR(2) | YES |
TRIGFLAG |  | VARCHAR(1) | YES |
DATETIME |  | NUMERIC(25, 10) | NO |
SAVESTART |  | NUMERIC(25, 10) | NO |
SAVEEND |  | NUMERIC(25, 10) | NO |
RFLAG |  | VARCHAR(2) | YES |
LDDATE |  | DATE | YES |

trig_channel Keys

Key Name | Key Type | Keys
TRIGCHANKEY01 | PrimaryKey | TRIGID

trig_channel 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

trig_channel Check Constraints

Check Constraint Name | CheckConstraint
TRIGCHAN01 | saveend > savestart
TRIGCHAN02 | rflag in ('a','h','f','A','H','F')
TRIGCHAN03 | trigflag in ('u','t','m')