Difference between revisions of "OE.CUSTOMERS (table)"
| Line 130: | Line 130: | ||
|- valign="top" | |- valign="top" | ||
| − | | | + | | CUST_ACCOUNT_MANAGER_IX |
| − | |||
| | | | ||
| + | | ACCOUNT_MGR_ID | ||
|- valign="top" | |- valign="top" | ||
| CUST_EMAIL_IX | | CUST_EMAIL_IX | ||
| Line 138: | Line 138: | ||
| CUST_EMAIL | | CUST_EMAIL | ||
|- valign="top" | |- valign="top" | ||
| − | | | + | | CUST_LNAME_IX |
| | | | ||
| − | | | + | | CUST_LAST_NAME |
|- valign="top" | |- valign="top" | ||
| − | | | + | | CUST_UPPER_NAME_IX |
| + | | | ||
| | | | ||
| − | |||
|} | |} | ||
| Line 196: | Line 196: | ||
| CUSTOMER_ID | | CUSTOMER_ID | ||
| CUSTOMER_ID | | CUSTOMER_ID | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 10:34, 27 August 2011
Contents
wikibot[edit]
| Table | OE.CUSTOMERS |
| Description | Contains customers data either entered by an employee or by the customer
him/herself over the Web. |
Columns[edit]
| 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[edit]
| Primary Key | Columns |
| CUSTOMERS_PK | CUSTOMER_ID |
Indexes[edit]
| Index | Type | Columns |
| CUST_ACCOUNT_MANAGER_IX | ACCOUNT_MGR_ID | |
| CUST_EMAIL_IX | CUST_EMAIL | |
| CUST_LNAME_IX | CUST_LAST_NAME | |
| CUST_UPPER_NAME_IX |
Check Constraints[edit]
| 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[edit]
| Relation | Column | Referenced Column |
| HR.EMPLOYEES | ACCOUNT_MGR_ID | EMPLOYEE_ID |
Detail Tables[edit]
| Detail Table | Column | Referencing Column |
| OE.ORDERS | CUSTOMER_ID | CUSTOMER_ID |
