| Column
|
Datatype
|
Nullable
|
Default value
|
Comment
|
| CUSTOMER_ID
|
NUMBER(6,0)
|
N
|
|
Primary key column.
|
| CUST_FIRST_NAME
|
VARCHAR2(20)
|
N
|
|
NOT NULL constraint.
|
| CUST_LAST_NAME
|
VARCHAR2(20)
|
N
|
|
NOT NULL constraint.
|
| CUST_ADDRESS
|
CUST_ADDRESS_TYP(1)
|
Y
|
|
Object column of type address_typ.
|
| PHONE_NUMBERS
|
PHONE_LIST_TYP(147)
|
Y
|
|
Varray column of type phone_list_typ
|
| NLS_LANGUAGE
|
VARCHAR2(3)
|
Y
|
|
|
| NLS_TERRITORY
|
VARCHAR2(30)
|
Y
|
|
|
| CREDIT_LIMIT
|
NUMBER(9,2)
|
Y
|
|
Check constraint.
|
| CUST_EMAIL
|
VARCHAR2(30)
|
Y
|
|
|
| ACCOUNT_MGR_ID
|
NUMBER(6,0)
|
Y
|
|
References hr.employees.employee_id.
|
| CUST_GEO_LOCATION
|
SDO_GEOMETRY(1)
|
Y
|
|
SDO (spatial) column.
|