OE.CUSTOMERS (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table OE.CUSTOMERS
Description Contains customers data either entered by an employee or by the customer

him/herself over the Web.

Columns[edit]

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[edit]

Primary Key Columns
CUSTOMERS_PK CUSTOMER_ID

Indexes[edit]

Index Type Columns
CUST_ACCOUNT_MANAGER_IX ACCOUNT_MGR_ID
CUST_EMAIL_IX CUST_EMAIL
CUST_LNAME_IX CUST_LAST_NAME
CUST_UPPER_NAME_IX

Check Constraints[edit]

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[edit]

Relation Column Referenced Column
HR.EMPLOYEES ACCOUNT_MGR_ID EMPLOYEE_ID

Detail Tables[edit]

Detail Table Column Referencing Column
OE.ORDERS CUSTOMER_ID CUSTOMER_ID