OE.CUSTOMERS (table) - Revision history

Bot at 09:34, 27 August 2011

2011-08-27T09:34:43Z

Bot at 05:15, 24 June 2010

2010-06-24T05:15:14Z

Show changes

Bot at 07:27, 11 February 2010

2010-02-11T07:27:54Z

Show changes

Bot at 19:00, 24 August 2009

2009-08-24T19:00:53Z

Bot: Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | OE.CUSTOMERS |- |}'

2009-08-24T18:57:12Z

Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | OE.CUSTOMERS |- |}'

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.CUSTOMERS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...

2009-05-02T17:06:00Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.CUSTOMERS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bord...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| 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
| not null
|
| CUSTOMERS_PK
|
|-
| CUST_FIRST_NAME
| VARCHAR2
| not null
|
|
|
|-
| CUST_LAST_NAME
| VARCHAR2
| not null
|
|
| CUST_LNAME_IX
|-
| CUST_ADDRESS
| OE.CUST_ADDRESS_TYP
| null
|
|
|
|-
| PHONE_NUMBERS
| OE.PHONE_LIST_TYP
| null
|
|
|
|-
| NLS_LANGUAGE
| VARCHAR2
| null
|
|
|
|-
| NLS_TERRITORY
| VARCHAR2
| null
|
|
|
|-
| CREDIT_LIMIT
| NUMBER
| null
|
|
|
|-
| CUST_EMAIL
| VARCHAR2
| null
|
|
| CUST_EMAIL_IX
|-
| ACCOUNT_MGR_ID
| NUMBER
| null
|
|
| CUST_ACCOUNT_MANAGER_IX
|-
| CUST_GEO_LOCATION
| MDSYS.SDO_GEOMETRY
| null
|
|
|
|-
| DATE_OF_BIRTH
| DATE
| null
|
|
|
|-
| MARITAL_STATUS
| VARCHAR2
| null
|
|
|
|-
| GENDER
| VARCHAR2
| null
|
|
|
|-
| INCOME_LEVEL
| VARCHAR2
| 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
|}

@@ Line 130: / Line 130: @@
 |- valign="top"
-| CUST_UPPER_NAME_IX
+| CUST_ACCOUNT_MANAGER_IX
+|
 |- valign="top"
 | CUST_EMAIL_IX
@@ Line 138: / Line 138: @@
 | CUST_EMAIL
 |- valign="top"
-| CUST_ACCOUNT_MANAGER_IX
+| CUST_LNAME_IX
+|
-| ACCOUNT_MGR_ID
+| CUST_LAST_NAME
 |- valign="top"
-| CUST_LNAME_IX
+| CUST_UPPER_NAME_IX
+|
 |}
@@ Line 196: / Line 196: @@
 | CUSTOMER_ID
 | CUSTOMER_ID
 |}

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''table
+| '''Table
 | OE.CUSTOMERS
 |-
 |}