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)