From dbscript Online Help
wikibot
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| CUSTOMER_ID
|
NUMBER(6, 0)
|
not null
|
|
CUSTOMERS_PK
|
|
| CUST_FIRST_NAME
|
VARCHAR2(20)
|
not null
|
|
|
|
| CUST_LAST_NAME
|
VARCHAR2(20)
|
not null
|
|
|
CUST_LNAME_IX
|
| CUST_ADDRESS
|
OE.CUST_ADDRESS_TYP
|
null
|
|
|
|
| PHONE_NUMBERS
|
OE.PHONE_LIST_TYP
|
null
|
|
|
|
| NLS_LANGUAGE
|
VARCHAR2(3)
|
null
|
|
|
|
| NLS_TERRITORY
|
VARCHAR2(30)
|
null
|
|
|
|
| CREDIT_LIMIT
|
NUMBER(9, 2)
|
null
|
|
|
|
| CUST_EMAIL
|
VARCHAR2(30)
|
null
|
|
|
CUST_EMAIL_IX
|
| ACCOUNT_MGR_ID
|
NUMBER(6, 0)
|
null
|
|
|
CUST_ACCOUNT_MANAGER_IX
|
| CUST_GEO_LOCATION
|
MDSYS.SDO_GEOMETRY
|
null
|
|
|
|
| DATE_OF_BIRTH
|
DATE(7)
|
null
|
|
|
|
| MARITAL_STATUS
|
VARCHAR2(20)
|
null
|
|
|
|
| GENDER
|
VARCHAR2(1)
|
null
|
|
|
|
| INCOME_LEVEL
|
VARCHAR2(20)
|
null
|
|
|
|
| Relation
|
Column
|
Referenced Column
|
| HR.EMPLOYEES
|
ACCOUNT_MGR_ID
|
EMPLOYEE_ID
|
| Detail Table
|
Column
|
Referencing Column
|
| OE.ORDERS
|
CUSTOMER_ID
|
CUSTOMER_ID
|
