SH.CUSTOMERS (table)

wikibot

Table

SH.CUSTOMERS

Column	Data Type	Nullable	Default	PK	Index
CUST_ID	NUMBER	not null		CUSTOMERS_PK
CUST_FIRST_NAME	VARCHAR2	not null
CUST_LAST_NAME	VARCHAR2	not null
CUST_GENDER	CHAR(1)	not null			CUSTOMERS_GENDER_BIX
CUST_YEAR_OF_BIRTH	NUMBER	not null			CUSTOMERS_YOB_BIX
CUST_MARITAL_STATUS	VARCHAR2	null			CUSTOMERS_MARITAL_BIX
CUST_STREET_ADDRESS	VARCHAR2	not null
CUST_POSTAL_CODE	VARCHAR2	not null
CUST_CITY	VARCHAR2	not null
CUST_CITY_ID	NUMBER	not null
CUST_STATE_PROVINCE	VARCHAR2	not null
CUST_STATE_PROVINCE_ID	NUMBER	not null
COUNTRY_ID	NUMBER	not null
CUST_MAIN_PHONE_NUMBER	VARCHAR2	not null
CUST_INCOME_LEVEL	VARCHAR2	null
CUST_CREDIT_LIMIT	NUMBER	null
CUST_EMAIL	VARCHAR2	null
CUST_TOTAL	VARCHAR2	not null
CUST_TOTAL_ID	NUMBER	not null
CUST_SRC_ID	NUMBER	null
CUST_EFF_FROM	DATE	null
CUST_EFF_TO	DATE	null
CUST_VALID	VARCHAR2	null

Relation	Column	Referenced Column
SH.COUNTRIES	COUNTRY_ID	COUNTRY_ID

Detail Table	Column	Referencing Column
SH.SALES	CUST_ID	CUST_ID