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')