OE.CUSTOMERS (table)

wikibot

Table	OE.CUSTOMERS
Description	Contains customers data either entered by an employee or by the customer him/herself over the Web.

Columns

Column	Data Type	Nullable	Default	Description
CUSTOMER_ID	NUMBER(6, 0)	not null		Primary key column.
CUST_FIRST_NAME	VARCHAR2(20)	not null		NOT NULL constraint.
CUST_LAST_NAME	VARCHAR2(20)	not null		NOT NULL constraint.
CUST_ADDRESS	OE.CUST_ADDRESS_TYP	null		Object column of type address_typ.
PHONE_NUMBERS	OE.PHONE_LIST_TYP	null		Varray column of type phone_list_typ
NLS_LANGUAGE	VARCHAR2(3)	null
NLS_TERRITORY	VARCHAR2(30)	null
CREDIT_LIMIT	NUMBER(9, 2)	null		Check constraint.
CUST_EMAIL	VARCHAR2(30)	null
ACCOUNT_MGR_ID	NUMBER(6, 0)	null		References hr.employees.employee_id.
CUST_GEO_LOCATION	MDSYS.SDO_GEOMETRY	null		SDO (spatial) column.
DATE_OF_BIRTH	DATE(7)	null
MARITAL_STATUS	VARCHAR2(20)	null
GENDER	VARCHAR2(1)	null
INCOME_LEVEL	VARCHAR2(20)	null

Primary Key

Primary Key	Columns
CUSTOMERS_PK	CUSTOMER_ID

Indexes

Index	Type	Columns
CUST_UPPER_NAME_IX
CUST_EMAIL_IX		CUST_EMAIL
CUST_ACCOUNT_MANAGER_IX		ACCOUNT_MGR_ID
CUST_LNAME_IX		CUST_LAST_NAME

Check Constraints

Check Constraint	Expression	Description
CUST_FNAME_NN	"CUST_FIRST_NAME" IS NOT NULL
CUST_LNAME_NN	"CUST_LAST_NAME" IS NOT NULL
CUSTOMER_CREDIT_LIMIT_MAX	credit_limit <= 5000
CUSTOMER_ID_MIN	customer_id > 0

Foreign Keys

Relation	Column	Referenced Column
HR.EMPLOYEES	ACCOUNT_MGR_ID	EMPLOYEE_ID

Detail Tables

Detail Table	Column	Referencing Column
OE.ORDERS	CUSTOMER_ID	CUSTOMER_ID

References

Dependency Type	Object Type	Referenced Object
Data Type	Type	OE.CUST_ADDRESS_TYP
Data Type	Type	OE.PHONE_LIST_TYP

Dependencies

Reference Type	Object Type	Referencing Object
Select	View	OE.ACCOUNT_MANAGERS