OPTIM_STATE_LOOKUP Table

The OPTIM_STATE_LOOKUP table contains state codes and corresponding abbreviations.

The OPTIM_STATE_LOOKUP table has the following columns:

DIST_CODE
CHAR; 3 characters; cannot contain a null value.
DISTRICT
CHAR; 2 characters; cannot contain a null value.

Primary Keys

The OPTIM_STATE_LOOKUP table does not have a primary key.

Relationships to Other Tables

The OPTIM_STATE_LOOKUP table is a child of the OPTIM_SALES table through a substring relationship on column DISTRICT using SUBSTR(SALESMAN_ID,1,2).



Feedback