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