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 | | |