| Table slot9.WORLD.TSTA.ROUTE_ACTION_INST_AGENCIES This table stores roles assigned to a route action instance
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "ACTION_INSTANCE_ID" IS NOT NULL | RTACTINSTAG_ACTINST_ID_NN |
| "AGENCY_CODE" IS NOT NULL | RTACTINSTAG_AGENCY_CODE_NN |
| "ID" IS NOT NULL | RTACTINSTAG_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| ID | Primary key | Asc | RTACTINSTAG_PK |
| AGENCY_CODE | Performance | Asc | RTACTINSTAG_AGNCY_CD_FK_I |
| ACTION_INSTANCE_ID | Performance | Asc | RTACTINSTAG_RTEACTIN_FK_I |
|