From dbscript Online Help
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
|
