| Table slot9.WORLD.TSTA.ROUTE_ACTION_INST_USERS this table stores the user and notification instance information for a custom form
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "ACTION_INSTANCE_ID" IS NOT NULL | RTEACTINUS_ACT_INST_ID_NN |
| "ACTION_INST_USER_ID" IS NOT NULL | RTEACTINUS_ACT_INST_USR_ID_NN |
| "AGENCY_CODE" IS NOT NULL | RTEACTINUS_AGNCY_CD_NN |
| "LOGIN_ID" IS NOT NULL | RTEACTINUS_LOGIN_ID_NN |
| "STATUS_CODE" IS NOT NULL | RTEACTINUS_STAT_CD_NN |
| "STATUS_CODE_TYPE" IS NOT NULL | RTEACTINUS_STAT_CD_TP_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| ACTION_INST_USER_ID | Primary key | Asc | RTEACTINUS_PK |
| AGENCY_CODE | Performance | Asc | RTEACTINUS_AGNCY_CD_FK_I |
| LOGIN_ID | Performance | Asc | RTEACTINUS_IUP_FK_I |
| ACTION_INSTANCE_ID | Performance | Asc | RTEACTINUS_RTEACTIN_FK_I |
| STATUS_CODE_TYPE + STATUS_CODE | Performance | Asc/Asc | RTEACTINUS_STS_CD_FK_I |
|