OE CUSTOMERS (table)

Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| OE.CUSTOMERS
|- valign="top"
| '''Description'''
| Contains customers data either entered by an employee or by the customer
him/herself over the Web.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| CUSTOMER_ID
| NUMBER(6, 0)
| not null
| &nbsp;
| Primary key column.
|- valign="top"
| CUST_FIRST_NAME
| VARCHAR2(20)
| not null
| &nbsp;
| NOT NULL constraint.
|- valign="top"
| CUST_LAST_NAME
| VARCHAR2(20)
| not null
| &nbsp;
| NOT NULL constraint.
|- valign="top"
| CUST_ADDRESS
| OE.CUST_ADDRESS_TYP
| null
| &nbsp;
| Object column of type address_typ.
|- valign="top"
| PHONE_NUMBERS
| OE.PHONE_LIST_TYP
| null
| &nbsp;
| Varray column of type phone_list_typ
|- valign="top"
| NLS_LANGUAGE
| VARCHAR2(3)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| NLS_TERRITORY
| VARCHAR2(30)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| CREDIT_LIMIT
| NUMBER(9, 2)
| null
| &nbsp;
| Check constraint.
|- valign="top"
| CUST_EMAIL
| VARCHAR2(30)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| ACCOUNT_MGR_ID
| NUMBER(6, 0)
| null
| &nbsp;
| References hr.employees.employee_id.
|- valign="top"
| CUST_GEO_LOCATION
| MDSYS.SDO_GEOMETRY
| null
| &nbsp;
| SDO (spatial) column.
|- valign="top"
| DATE_OF_BIRTH
| DATE(7)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| MARITAL_STATUS
| VARCHAR2(20)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| GENDER
| VARCHAR2(1)
| null
| &nbsp;
| &nbsp;
|- valign="top"
| INCOME_LEVEL
| VARCHAR2(20)
| null
| &nbsp;
| &nbsp;
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| CUSTOMERS_PK
| CUSTOMER_ID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| CUST_ACCOUNT_MANAGER_IX
| &nbsp;
| ACCOUNT_MGR_ID
|- valign="top"
| CUST_EMAIL_IX
| &nbsp;
| CUST_EMAIL
|- valign="top"
| CUST_LNAME_IX
| &nbsp;
| CUST_LAST_NAME
|- valign="top"
| CUST_UPPER_NAME_IX
| &nbsp;
| &nbsp;
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| CUST_FNAME_NN
| "CUST_FIRST_NAME" IS NOT NULL
| &nbsp;
|- valign="top"
| CUST_LNAME_NN
| "CUST_LAST_NAME" IS NOT NULL
| &nbsp;
|- valign="top"
| CUSTOMER_CREDIT_LIMIT_MAX
| credit_limit <= 5000
| &nbsp;
|- valign="top"
| CUSTOMER_ID_MIN
| customer_id > 0
| &nbsp;
|}

=== Foreign Keys ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Relation'''
| '''Column'''
| '''Referenced Column'''

|- valign="top"
| [[HR EMPLOYEES (table)|HR.EMPLOYEES]]
| ACCOUNT_MGR_ID
| EMPLOYEE_ID
|}

=== Detail Tables ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[OE ORDERS (table)|OE.ORDERS]]
| CUSTOMER_ID
| CUSTOMER_ID
|}
devio dbscript ScrewTurn Wiki

Navigation¶

OE CUSTOMERS (table)
