Difference between revisions of "OE.CUSTOMERS (table)"

From dbscript Online Help
Jump to: navigation, search
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''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 21: Line 19:
 
| '''Default
 
| '''Default
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| CUSTOMER_ID
 
| CUSTOMER_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
Line 28: Line 26:
 
|  
 
|  
 
| Primary key column.
 
| Primary key column.
−
|-
+
|- valign="top"
 
| CUST_FIRST_NAME
 
| CUST_FIRST_NAME
 
| VARCHAR2(20)
 
| VARCHAR2(20)
Line 34: Line 32:
 
|  
 
|  
 
| NOT NULL constraint.
 
| NOT NULL constraint.
−
|-
+
|- valign="top"
 
| CUST_LAST_NAME
 
| CUST_LAST_NAME
 
| VARCHAR2(20)
 
| VARCHAR2(20)
Line 40: Line 38:
 
|  
 
|  
 
| NOT NULL constraint.
 
| NOT NULL constraint.
−
|-
+
|- valign="top"
 
| CUST_ADDRESS
 
| CUST_ADDRESS
 
| OE.CUST_ADDRESS_TYP
 
| OE.CUST_ADDRESS_TYP
Line 46: Line 44:
 
|  
 
|  
 
| Object column of type address_typ.
 
| Object column of type address_typ.
−
|-
+
|- valign="top"
 
| PHONE_NUMBERS
 
| PHONE_NUMBERS
 
| OE.PHONE_LIST_TYP
 
| OE.PHONE_LIST_TYP
Line 52: Line 50:
 
|  
 
|  
 
| Varray column of type phone_list_typ
 
| Varray column of type phone_list_typ
−
|-
+
|- valign="top"
 
| NLS_LANGUAGE
 
| NLS_LANGUAGE
 
| VARCHAR2(3)
 
| VARCHAR2(3)
Line 58: Line 56:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| NLS_TERRITORY
 
| NLS_TERRITORY
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 64: Line 62:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| CREDIT_LIMIT
 
| CREDIT_LIMIT
 
| NUMBER(9, 2)
 
| NUMBER(9, 2)
Line 70: Line 68:
 
|  
 
|  
 
| Check constraint.
 
| Check constraint.
−
|-
+
|- valign="top"
 
| CUST_EMAIL
 
| CUST_EMAIL
 
| VARCHAR2(30)
 
| VARCHAR2(30)
Line 76: Line 74:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| ACCOUNT_MGR_ID
 
| ACCOUNT_MGR_ID
 
| NUMBER(6, 0)
 
| NUMBER(6, 0)
Line 82: Line 80:
 
|  
 
|  
 
| References hr.employees.employee_id.
 
| References hr.employees.employee_id.
−
|-
+
|- valign="top"
 
| CUST_GEO_LOCATION
 
| CUST_GEO_LOCATION
 
| MDSYS.SDO_GEOMETRY
 
| MDSYS.SDO_GEOMETRY
Line 88: Line 86:
 
|  
 
|  
 
| SDO (spatial) column.
 
| SDO (spatial) column.
−
|-
+
|- valign="top"
 
| DATE_OF_BIRTH
 
| DATE_OF_BIRTH
 
| DATE(7)
 
| DATE(7)
Line 94: Line 92:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| MARITAL_STATUS
 
| MARITAL_STATUS
 
| VARCHAR2(20)
 
| VARCHAR2(20)
Line 100: Line 98:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| GENDER
 
| GENDER
 
| VARCHAR2(1)
 
| VARCHAR2(1)
Line 106: Line 104:
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| INCOME_LEVEL
 
| INCOME_LEVEL
 
| VARCHAR2(20)
 
| VARCHAR2(20)
Line 119: Line 117:
 
| '''Primary Key
 
| '''Primary Key
 
| '''Columns
 
| '''Columns
−
|-
+
|- valign="top"
 
| CUSTOMERS_PK
 
| CUSTOMERS_PK
 
| CUSTOMER_ID
 
| CUSTOMER_ID
Line 130: Line 128:
 
| '''Type
 
| '''Type
 
| '''Columns
 
| '''Columns
−
+
 
−
|-
+
|- valign="top"
 
| CUST_UPPER_NAME_IX
 
| CUST_UPPER_NAME_IX
 
|  
 
|  
 
|  
 
|  
−
|-
+
|- valign="top"
 
| CUST_EMAIL_IX
 
| CUST_EMAIL_IX
 
|  
 
|  
 
| CUST_EMAIL
 
| CUST_EMAIL
−
|-
+
|- valign="top"
 
| CUST_ACCOUNT_MANAGER_IX
 
| CUST_ACCOUNT_MANAGER_IX
 
|  
 
|  
 
| ACCOUNT_MGR_ID
 
| ACCOUNT_MGR_ID
−
|-
+
|- valign="top"
 
| CUST_LNAME_IX
 
| CUST_LNAME_IX
 
|  
 
|  
Line 155: Line 153:
 
| '''Expression
 
| '''Expression
 
| '''Description
 
| '''Description
−
+
 
−
|-
+
|- valign="top"
 
| CUST_FNAME_NN
 
| CUST_FNAME_NN
 
| "CUST_FIRST_NAME" IS NOT NULL
 
| "CUST_FIRST_NAME" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| CUST_LNAME_NN
 
| CUST_LNAME_NN
 
| "CUST_LAST_NAME" IS NOT NULL
 
| "CUST_LAST_NAME" IS NOT NULL
 
|  
 
|  
−
|-
+
|- valign="top"
 
| CUSTOMER_CREDIT_LIMIT_MAX
 
| CUSTOMER_CREDIT_LIMIT_MAX
 
| credit_limit <= 5000
 
| credit_limit <= 5000
 
|  
 
|  
−
|-
+
|- valign="top"
 
| CUSTOMER_ID_MIN
 
| CUSTOMER_ID_MIN
 
| customer_id > 0
 
| customer_id > 0
Line 180: Line 178:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
+
 
−
|-
+
|- valign="top"
 
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 
| ACCOUNT_MGR_ID
 
| ACCOUNT_MGR_ID
Line 193: Line 191:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[OE.ORDERS_(table)|OE.ORDERS]]
 
| [[OE.ORDERS_(table)|OE.ORDERS]]
 
| CUSTOMER_ID
 
| CUSTOMER_ID
Line 207: Line 205:
 
| '''Referenced Object
 
| '''Referenced Object
  
−
|-
+
|- valign="top"
 
| Data Type
 
| Data Type
 
| Type
 
| Type
 
| [[OE.CUST_ADDRESS_TYP_(type)|OE.CUST_ADDRESS_TYP]]
 
| [[OE.CUST_ADDRESS_TYP_(type)|OE.CUST_ADDRESS_TYP]]
  
−
|-
+
|- valign="top"
 
| Data Type
 
| Data Type
 
| Type
 
| Type
Line 226: Line 224:
 
| '''Referencing Object
 
| '''Referencing Object
  
−
|-
+
|- valign="top"
 
| Select
 
| Select
 
| View
 
| View

Revision as of 06:15, 24 June 2010

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
Retrieved from "http://dbshelp.devio.at/index.php?title=OE.CUSTOMERS_(table)&oldid=2749"