Editing OE.CUSTOMERS (table)
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
| Latest revision | Your text | ||
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- |
| '''Table | | '''Table | ||
| OE.CUSTOMERS | | OE.CUSTOMERS | ||
| Line 9: | Line 9: | ||
| Contains customers data either entered by an employee or by the customer | | Contains customers data either entered by an employee or by the customer | ||
him/herself over the Web. | him/herself over the Web. | ||
| + | |- | ||
|} | |} | ||
| + | |||
=== Columns === | === Columns === | ||
| Line 19: | Line 21: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- |
| CUSTOMER_ID | | CUSTOMER_ID | ||
| NUMBER(6, 0) | | NUMBER(6, 0) | ||
| Line 26: | Line 28: | ||
| | | | ||
| Primary key column. | | Primary key column. | ||
| − | |- | + | |- |
| CUST_FIRST_NAME | | CUST_FIRST_NAME | ||
| VARCHAR2(20) | | VARCHAR2(20) | ||
| Line 32: | Line 34: | ||
| | | | ||
| NOT NULL constraint. | | NOT NULL constraint. | ||
| − | |- | + | |- |
| CUST_LAST_NAME | | CUST_LAST_NAME | ||
| VARCHAR2(20) | | VARCHAR2(20) | ||
| Line 38: | Line 40: | ||
| | | | ||
| NOT NULL constraint. | | NOT NULL constraint. | ||
| − | |- | + | |- |
| CUST_ADDRESS | | CUST_ADDRESS | ||
| OE.CUST_ADDRESS_TYP | | OE.CUST_ADDRESS_TYP | ||
| Line 44: | Line 46: | ||
| | | | ||
| Object column of type address_typ. | | Object column of type address_typ. | ||
| − | |- | + | |- |
| PHONE_NUMBERS | | PHONE_NUMBERS | ||
| OE.PHONE_LIST_TYP | | OE.PHONE_LIST_TYP | ||
| Line 50: | Line 52: | ||
| | | | ||
| Varray column of type phone_list_typ | | Varray column of type phone_list_typ | ||
| − | |- | + | |- |
| NLS_LANGUAGE | | NLS_LANGUAGE | ||
| VARCHAR2(3) | | VARCHAR2(3) | ||
| Line 56: | Line 58: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| NLS_TERRITORY | | NLS_TERRITORY | ||
| VARCHAR2(30) | | VARCHAR2(30) | ||
| Line 62: | Line 64: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| CREDIT_LIMIT | | CREDIT_LIMIT | ||
| NUMBER(9, 2) | | NUMBER(9, 2) | ||
| Line 68: | Line 70: | ||
| | | | ||
| Check constraint. | | Check constraint. | ||
| − | |- | + | |- |
| CUST_EMAIL | | CUST_EMAIL | ||
| VARCHAR2(30) | | VARCHAR2(30) | ||
| Line 74: | Line 76: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| ACCOUNT_MGR_ID | | ACCOUNT_MGR_ID | ||
| NUMBER(6, 0) | | NUMBER(6, 0) | ||
| Line 80: | Line 82: | ||
| | | | ||
| References hr.employees.employee_id. | | References hr.employees.employee_id. | ||
| − | |- | + | |- |
| CUST_GEO_LOCATION | | CUST_GEO_LOCATION | ||
| MDSYS.SDO_GEOMETRY | | MDSYS.SDO_GEOMETRY | ||
| Line 86: | Line 88: | ||
| | | | ||
| SDO (spatial) column. | | SDO (spatial) column. | ||
| − | |- | + | |- |
| DATE_OF_BIRTH | | DATE_OF_BIRTH | ||
| DATE(7) | | DATE(7) | ||
| Line 92: | Line 94: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| MARITAL_STATUS | | MARITAL_STATUS | ||
| VARCHAR2(20) | | VARCHAR2(20) | ||
| Line 98: | Line 100: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| GENDER | | GENDER | ||
| VARCHAR2(1) | | VARCHAR2(1) | ||
| Line 104: | Line 106: | ||
| | | | ||
| | | | ||
| − | |- | + | |- |
| INCOME_LEVEL | | INCOME_LEVEL | ||
| VARCHAR2(20) | | VARCHAR2(20) | ||
| Line 117: | Line 119: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
| − | |- | + | |- |
| CUSTOMERS_PK | | CUSTOMERS_PK | ||
| CUSTOMER_ID | | CUSTOMER_ID | ||
| Line 128: | Line 130: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
| − | + | ||
| − | |- | + | |- |
| − | | | + | | CUST_UPPER_NAME_IX |
| + | | | ||
| | | | ||
| − | + | |- | |
| − | |- | ||
| CUST_EMAIL_IX | | CUST_EMAIL_IX | ||
| | | | ||
| CUST_EMAIL | | CUST_EMAIL | ||
| − | |- | + | |- |
| + | | CUST_ACCOUNT_MANAGER_IX | ||
| + | | | ||
| + | | ACCOUNT_MGR_ID | ||
| + | |- | ||
| CUST_LNAME_IX | | CUST_LNAME_IX | ||
| | | | ||
| CUST_LAST_NAME | | CUST_LAST_NAME | ||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| Line 153: | Line 155: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- |
| CUST_FNAME_NN | | CUST_FNAME_NN | ||
| "CUST_FIRST_NAME" IS NOT NULL | | "CUST_FIRST_NAME" IS NOT NULL | ||
| | | | ||
| − | |- | + | |- |
| CUST_LNAME_NN | | CUST_LNAME_NN | ||
| "CUST_LAST_NAME" IS NOT NULL | | "CUST_LAST_NAME" IS NOT NULL | ||
| | | | ||
| − | |- | + | |- |
| CUSTOMER_CREDIT_LIMIT_MAX | | CUSTOMER_CREDIT_LIMIT_MAX | ||
| credit_limit <= 5000 | | credit_limit <= 5000 | ||
| | | | ||
| − | |- | + | |- |
| CUSTOMER_ID_MIN | | CUSTOMER_ID_MIN | ||
| customer_id > 0 | | customer_id > 0 | ||
| Line 178: | Line 180: | ||
| '''Column | | '''Column | ||
| '''Referenced Column | | '''Referenced Column | ||
| − | + | ||
| − | |- | + | |- |
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]] | | [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]] | ||
| ACCOUNT_MGR_ID | | ACCOUNT_MGR_ID | ||
| Line 191: | Line 193: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
| − | + | ||
| − | |- | + | |- |
| [[OE.ORDERS_(table)|OE.ORDERS]] | | [[OE.ORDERS_(table)|OE.ORDERS]] | ||
| CUSTOMER_ID | | CUSTOMER_ID | ||
| CUSTOMER_ID | | CUSTOMER_ID | ||
| + | |} | ||
| + | |||
| + | === References === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Dependency Type | ||
| + | | '''Object Type | ||
| + | | '''Referenced Object | ||
| + | |||
| + | |- | ||
| + | | Data Type | ||
| + | | Type | ||
| + | | [[OE.CUST_ADDRESS_TYP_(type)|OE.CUST_ADDRESS_TYP]] | ||
| + | |||
| + | |- | ||
| + | | Data Type | ||
| + | | Type | ||
| + | | [[OE.PHONE_LIST_TYP_(type)|OE.PHONE_LIST_TYP]] | ||
| + | |||
| + | |} | ||
| + | |||
| + | === Dependencies === | ||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- style="background:silver" | ||
| + | | '''Reference Type | ||
| + | | '''Object Type | ||
| + | | '''Referencing Object | ||
| + | |||
| + | |- | ||
| + | | Select | ||
| + | | View | ||
| + | | [[OE.ACCOUNT_MANAGERS_(view)|OE.ACCOUNT_MANAGERS]] | ||
| + | |||
|} | |} | ||
