SH.CUSTOMERS (table) - Revision history

Bot at 09:36, 27 August 2011

2011-08-27T09:36:00Z

Bot at 05:16, 24 June 2010

2010-06-24T05:16:36Z

Show changes

Bot at 07:29, 11 February 2010

2010-02-11T07:29:31Z

Show changes

Bot at 19:01, 24 August 2009

2009-08-24T19:01:29Z

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

2009-05-02T17:06:30Z

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

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| SH.CUSTOMERS
|-
|}

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

|-
| CUST_ID
| NUMBER
| not null
|
| CUSTOMERS_PK
|
|-
| CUST_FIRST_NAME
| VARCHAR2
| not null
|
|
|
|-
| CUST_LAST_NAME
| VARCHAR2
| not null
|
|
|
|-
| CUST_GENDER
| CHAR(1)
| not null
|
|
| CUSTOMERS_GENDER_BIX
|-
| CUST_YEAR_OF_BIRTH
| NUMBER
| not null
|
|
| CUSTOMERS_YOB_BIX
|-
| CUST_MARITAL_STATUS
| VARCHAR2
| null
|
|
| CUSTOMERS_MARITAL_BIX
|-
| CUST_STREET_ADDRESS
| VARCHAR2
| not null
|
|
|
|-
| CUST_POSTAL_CODE
| VARCHAR2
| not null
|
|
|
|-
| CUST_CITY
| VARCHAR2
| not null
|
|
|
|-
| CUST_CITY_ID
| NUMBER
| not null
|
|
|
|-
| CUST_STATE_PROVINCE
| VARCHAR2
| not null
|
|
|
|-
| CUST_STATE_PROVINCE_ID
| NUMBER
| not null
|
|
|
|-
| COUNTRY_ID
| NUMBER
| not null
|
|
|
|-
| CUST_MAIN_PHONE_NUMBER
| VARCHAR2
| not null
|
|
|
|-
| CUST_INCOME_LEVEL
| VARCHAR2
| null
|
|
|
|-
| CUST_CREDIT_LIMIT
| NUMBER
| null
|
|
|
|-
| CUST_EMAIL
| VARCHAR2
| null
|
|
|
|-
| CUST_TOTAL
| VARCHAR2
| not null
|
|
|
|-
| CUST_TOTAL_ID
| NUMBER
| not null
|
|
|
|-
| CUST_SRC_ID
| NUMBER
| null
|
|
|
|-
| CUST_EFF_FROM
| DATE
| null
|
|
|
|-
| CUST_EFF_TO
| DATE
| null
|
|
|
|-
| CUST_VALID
| VARCHAR2
| null
|
|
|
|}

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

|-
| [[SH.COUNTRIES_(table)|SH.COUNTRIES]]
| COUNTRY_ID
| COUNTRY_ID
|}

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

|-
| [[SH.SALES_(table)|SH.SALES]]
| CUST_ID
| CUST_ID
|}

@@ Line 176: / Line 176: @@
 | '''Columns
 |- valign="top"
 | CUSTOMERS_MARITAL_BIX
@@ Line 184: / Line 188: @@
+|
 | CUST_YEAR_OF_BIRTH
 |}

@@ Line 27: / Line 27: @@
 |-
 | CUST_FIRST_NAME
-| VARCHAR2
+| VARCHAR2(20)
 | not null
+|
@@ Line 34: / Line 34: @@
 |-
 | CUST_LAST_NAME
-| VARCHAR2
+| VARCHAR2(40)
 | not null
+|
@@ Line 48: / Line 48: @@
 |-
 | CUST_YEAR_OF_BIRTH
-| NUMBER
+| NUMBER(4, 0)
 | not null
+|
@@ Line 55: / Line 55: @@
 |-
 | CUST_MARITAL_STATUS
-| VARCHAR2
+| VARCHAR2(20)
 | null
+|
@@ Line 62: / Line 62: @@
 |-
 | CUST_STREET_ADDRESS
-| VARCHAR2
+| VARCHAR2(40)
 | not null
+|
@@ Line 69: / Line 69: @@
 |-
 | CUST_POSTAL_CODE
-| VARCHAR2
+| VARCHAR2(10)
 | not null
+|
@@ Line 76: / Line 76: @@
 |-
 | CUST_CITY
-| VARCHAR2
+| VARCHAR2(30)
 | not null
+|
@@ Line 90: / Line 90: @@
 |-
 | CUST_STATE_PROVINCE
-| VARCHAR2
+| VARCHAR2(40)
 | not null
+|
@@ Line 111: / Line 111: @@
 |-
 | CUST_MAIN_PHONE_NUMBER
-| VARCHAR2
+| VARCHAR2(25)
 | not null
+|
@@ Line 118: / Line 118: @@
 |-
 | CUST_INCOME_LEVEL
-| VARCHAR2
+| VARCHAR2(30)
 | null
+|
@@ Line 132: / Line 132: @@
 |-
 | CUST_EMAIL
-| VARCHAR2
+| VARCHAR2(30)
 | null
+|
@@ Line 139: / Line 139: @@
 |-
 | CUST_TOTAL
-| VARCHAR2
+| VARCHAR2(14)
 | not null
+|
@@ Line 160: / Line 160: @@
 |-
 | CUST_EFF_FROM
-| DATE
+| DATE(7)
 | null
+|
@@ Line 167: / Line 167: @@
 |-
 | CUST_EFF_TO
-| DATE
+| DATE(7)
 | null
+|
@@ Line 174: / Line 174: @@
 |-
 | CUST_VALID
-| VARCHAR2
+| VARCHAR2(1)
 | null
+|