OE.CUSTOMERS (table)
From dbscript Online Help
Contents |
wikibot
| Table | OE.CUSTOMERS |
| Description | Contains customers data either entered by an employee or by the customer
him/herself over the Web. |
Columns
| 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
| Primary Key | Columns |
| CUSTOMERS_PK | CUSTOMER_ID |
Indexes
| Index | Type | Columns |
| CUST_UPPER_NAME_IX | ||
| CUST_EMAIL_IX | CUST_EMAIL | |
| CUST_ACCOUNT_MANAGER_IX | ACCOUNT_MGR_ID | |
| CUST_LNAME_IX | CUST_LAST_NAME |
Check Constraints
| 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
| Relation | Column | Referenced Column |
| HR.EMPLOYEES | ACCOUNT_MGR_ID | EMPLOYEE_ID |
Detail Tables
| Detail Table | Column | Referencing Column |
| OE.ORDERS | CUSTOMER_ID | CUSTOMER_ID |
References
| Dependency Type | Object Type | Referenced Object |
| Data Type | Type | OE.CUST_ADDRESS_TYP |
| Data Type | Type | OE.PHONE_LIST_TYP |
Dependencies
| Reference Type | Object Type | Referencing Object |
| Select | View | OE.ACCOUNT_MANAGERS |
