| Table slot9.WORLD.TSTA.ITEM_LOCATION_MANAGERS This table defines the managers for an agency assigned to an inventory location
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| USER_ACTIVE_FLAG IN ('Y', 'N') | CK_ITLCM_USR_ACT_FLAG |
| "LOCATION_ID" IS NOT NULL | ITLCM_LOC_ID_NN |
| "LOGIN_ID" IS NOT NULL | ITLCM_LOGIN_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| LOCATION_ID + LOGIN_ID | Primary key | Asc/Asc | ITLCM_PK |
| LOCATION_ID | Performance | Asc | ITLCM_ITLC_FK_I |
| LOGIN_ID | Performance | Asc | ITLCM_IUP_FK_I |
|