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

From dbscript Online Help
Jump to: navigation, search
(Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | OE.CUSTOMERS |- |}')
Line 3: Line 3:
 
{| 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
 
|-
 
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''PK
 +
| '''Index
 +
 +
|-
 +
| CUSTOMER_ID
 +
| NUMBER(6, 0)
 +
| not null
 +
|
 +
| CUSTOMERS_PK
 +
|
 +
|-
 +
| CUST_FIRST_NAME
 +
| VARCHAR2(20)
 +
| not null
 +
|
 +
|
 +
|
 +
|-
 +
| CUST_LAST_NAME
 +
| VARCHAR2(20)
 +
| not null
 +
|
 +
|
 +
| CUST_LNAME_IX
 +
|-
 +
| CUST_ADDRESS
 +
| OE.CUST_ADDRESS_TYP
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| PHONE_NUMBERS
 +
| OE.PHONE_LIST_TYP
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| NLS_LANGUAGE
 +
| VARCHAR2(3)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| NLS_TERRITORY
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| CREDIT_LIMIT
 +
| NUMBER(9, 2)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| CUST_EMAIL
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
| CUST_EMAIL_IX
 +
|-
 +
| ACCOUNT_MGR_ID
 +
| NUMBER(6, 0)
 +
| null
 +
|
 +
|
 +
| CUST_ACCOUNT_MANAGER_IX
 +
|-
 +
| CUST_GEO_LOCATION
 +
| MDSYS.SDO_GEOMETRY
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| DATE_OF_BIRTH
 +
| DATE(7)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| MARITAL_STATUS
 +
| VARCHAR2(20)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| GENDER
 +
| VARCHAR2(1)
 +
| null
 +
|
 +
|
 +
|
 +
|-
 +
| INCOME_LEVEL
 +
| VARCHAR2(20)
 +
| null
 +
|
 +
|
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[HR.EMPLOYEES_(table)|HR.EMPLOYEES]]
 +
| ACCOUNT_MGR_ID
 +
| EMPLOYEE_ID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[OE.ORDERS_(table)|OE.ORDERS]]
 +
| CUSTOMER_ID
 +
| CUSTOMER_ID
 
|}
 
|}

Revision as of 20:00, 24 August 2009

wikibot

Table OE.CUSTOMERS


Column Data Type Nullable Default PK Index
CUSTOMER_ID NUMBER(6, 0) not null CUSTOMERS_PK
CUST_FIRST_NAME VARCHAR2(20) not null
CUST_LAST_NAME VARCHAR2(20) not null CUST_LNAME_IX
CUST_ADDRESS OE.CUST_ADDRESS_TYP null
PHONE_NUMBERS OE.PHONE_LIST_TYP null
NLS_LANGUAGE VARCHAR2(3) null
NLS_TERRITORY VARCHAR2(30) null
CREDIT_LIMIT NUMBER(9, 2) null
CUST_EMAIL VARCHAR2(30) null CUST_EMAIL_IX
ACCOUNT_MGR_ID NUMBER(6, 0) null CUST_ACCOUNT_MANAGER_IX
CUST_GEO_LOCATION MDSYS.SDO_GEOMETRY null
DATE_OF_BIRTH DATE(7) null
MARITAL_STATUS VARCHAR2(20) null
GENDER VARCHAR2(1) null
INCOME_LEVEL VARCHAR2(20) null


Relation Column Referenced Column
HR.EMPLOYEES ACCOUNT_MGR_ID EMPLOYEE_ID


Detail Table Column Referencing Column
OE.ORDERS CUSTOMER_ID CUSTOMER_ID
Retrieved from "http://dbshelp.devio.at/index.php?title=OE.CUSTOMERS_(table)&oldid=871"