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