Editing SH.CUSTOMERS (table)

Jump to: navigation, search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision Your text
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
 
| SH.CUSTOMERS
 
| SH.CUSTOMERS
−
|- valign="top"
+
|-
−
| '''Description
 
−
| dimension table
 
 
|}
 
|}
  
−
=== Columns ===
+
 
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 17: Line 15:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''PK
−
 
+
| '''Index
−
|- valign="top"
+
 +
|-
 
| CUST_ID
 
| CUST_ID
 
| NUMBER
 
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
−
| primary key
+
| CUSTOMERS_PK
−
|- valign="top"
+
|
 +
|-
 
| CUST_FIRST_NAME
 
| CUST_FIRST_NAME
 
| VARCHAR2(20)
 
| VARCHAR2(20)
 
| not null
 
| not null
 
|  
 
|  
−
| first name of the customer
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_LAST_NAME
 
| CUST_LAST_NAME
 
| VARCHAR2(40)
 
| VARCHAR2(40)
 
| not null
 
| not null
 
|  
 
|  
−
| last name of the customer
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_GENDER
 
| CUST_GENDER
 
| CHAR(1)
 
| CHAR(1)
 
| not null
 
| not null
 
|  
 
|  
−
| gender; low cardinality attribute
+
|  
−
|- valign="top"
+
| CUSTOMERS_GENDER_BIX
 +
|-
 
| CUST_YEAR_OF_BIRTH
 
| CUST_YEAR_OF_BIRTH
 
| NUMBER(4, 0)
 
| NUMBER(4, 0)
 
| not null
 
| not null
 
|  
 
|  
−
| customer year of birth
+
|  
−
|- valign="top"
+
| CUSTOMERS_YOB_BIX
 +
|-
 
| CUST_MARITAL_STATUS
 
| CUST_MARITAL_STATUS
 
| VARCHAR2(20)
 
| VARCHAR2(20)
 
| null
 
| null
 
|  
 
|  
−
| customer marital status; low cardinality attribute
+
|  
−
|- valign="top"
+
| CUSTOMERS_MARITAL_BIX
 +
|-
 
| CUST_STREET_ADDRESS
 
| CUST_STREET_ADDRESS
 
| VARCHAR2(40)
 
| VARCHAR2(40)
 
| not null
 
| not null
 
|  
 
|  
−
| customer street address
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_POSTAL_CODE
 
| CUST_POSTAL_CODE
 
| VARCHAR2(10)
 
| VARCHAR2(10)
 
| not null
 
| not null
 
|  
 
|  
−
| postal code of the customer
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_CITY
 
| CUST_CITY
 
| VARCHAR2(30)
 
| VARCHAR2(30)
 
| not null
 
| not null
 
|  
 
|  
−
| city where the customer lives
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_CITY_ID
 
| CUST_CITY_ID
 
| NUMBER
 
| NUMBER
Line 79: Line 87:
 
|  
 
|  
 
|  
 
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_STATE_PROVINCE
 
| CUST_STATE_PROVINCE
 
| VARCHAR2(40)
 
| VARCHAR2(40)
 
| not null
 
| not null
 
|  
 
|  
−
| customer geography: state or province
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_STATE_PROVINCE_ID
 
| CUST_STATE_PROVINCE_ID
 
| NUMBER
 
| NUMBER
Line 91: Line 101:
 
|  
 
|  
 
|  
 
|  
−
|- valign="top"
+
|
 +
|-
 
| COUNTRY_ID
 
| COUNTRY_ID
 
| NUMBER
 
| NUMBER
 
| not null
 
| not null
 
|  
 
|  
−
| foreign key to the countries table (snowflake)
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_MAIN_PHONE_NUMBER
 
| CUST_MAIN_PHONE_NUMBER
 
| VARCHAR2(25)
 
| VARCHAR2(25)
 
| not null
 
| not null
 
|  
 
|  
−
| customer main phone number
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_INCOME_LEVEL
 
| CUST_INCOME_LEVEL
 
| VARCHAR2(30)
 
| VARCHAR2(30)
 
| null
 
| null
 
|  
 
|  
−
| customer income level
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_CREDIT_LIMIT
 
| CUST_CREDIT_LIMIT
 
| NUMBER
 
| NUMBER
 
| null
 
| null
 
|  
 
|  
−
| customer credit limit
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_EMAIL
 
| CUST_EMAIL
 
| VARCHAR2(30)
 
| VARCHAR2(30)
 
| null
 
| null
 
|  
 
|  
−
| customer email id
+
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_TOTAL
 
| CUST_TOTAL
 
| VARCHAR2(14)
 
| VARCHAR2(14)
Line 127: Line 143:
 
|  
 
|  
 
|  
 
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_TOTAL_ID
 
| CUST_TOTAL_ID
 
| NUMBER
 
| NUMBER
Line 133: Line 150:
 
|  
 
|  
 
|  
 
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_SRC_ID
 
| CUST_SRC_ID
 
| NUMBER
 
| NUMBER
Line 139: Line 157:
 
|  
 
|  
 
|  
 
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_EFF_FROM
 
| CUST_EFF_FROM
 
| DATE(7)
 
| DATE(7)
Line 145: Line 164:
 
|  
 
|  
 
|  
 
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_EFF_TO
 
| CUST_EFF_TO
 
| DATE(7)
 
| DATE(7)
Line 151: Line 171:
 
|  
 
|  
 
|  
 
|  
−
|- valign="top"
+
|
 +
|-
 
| CUST_VALID
 
| CUST_VALID
 
| VARCHAR2(1)
 
| VARCHAR2(1)
Line 157: Line 178:
 
|  
 
|  
 
|  
 
|  
−
|}
 
−
 
−
=== Primary Key ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Primary Key
 
−
| '''Columns
 
−
|- valign="top"
 
−
| CUSTOMERS_PK
 
−
| CUST_ID
 
−
|}
 
−
 
−
=== Indexes ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Index
 
−
| '''Type
 
−
| '''Columns
 
−
 
−
|- valign="top"
 
−
| CUSTOMERS_GENDER_BIX
 
−
|
 
−
| CUST_GENDER
 
−
|- valign="top"
 
−
| CUSTOMERS_MARITAL_BIX
 
 
|  
 
|  
−
| CUST_MARITAL_STATUS
 
−
|- valign="top"
 
−
| CUSTOMERS_YOB_BIX
 
−
|
 
−
| CUST_YEAR_OF_BIRTH
 
 
|}
 
|}
  
−
=== Check Constraints ===
 
−
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
−
|- style="background:silver"
 
−
| '''Check Constraint
 
−
| '''Expression
 
−
| '''Description
 
  
−
|- valign="top"
 
−
| SYS_C005164
 
−
| "CUST_ID" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005165
 
−
| "CUST_FIRST_NAME" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005166
 
−
| "CUST_LAST_NAME" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005167
 
−
| "CUST_GENDER" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005168
 
−
| "CUST_YEAR_OF_BIRTH" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005169
 
−
| "CUST_STREET_ADDRESS" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005170
 
−
| "CUST_POSTAL_CODE" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005171
 
−
| "CUST_CITY" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005172
 
−
| "CUST_CITY_ID" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005173
 
−
| "CUST_STATE_PROVINCE" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005174
 
−
| "CUST_STATE_PROVINCE_ID" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005175
 
−
| "COUNTRY_ID" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005176
 
−
| "CUST_MAIN_PHONE_NUMBER" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005177
 
−
| "CUST_TOTAL" IS NOT NULL
 
−
|
 
−
|- valign="top"
 
−
| SYS_C005178
 
−
| "CUST_TOTAL_ID" IS NOT NULL
 
−
|
 
−
|}
 
  
−
=== Foreign Keys ===
 
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 265: Line 188:
 
| '''Column
 
| '''Column
 
| '''Referenced Column
 
| '''Referenced Column
−
 
+
−
|- valign="top"
+
|-
 
| [[SH.COUNTRIES_(table)|SH.COUNTRIES]]
 
| [[SH.COUNTRIES_(table)|SH.COUNTRIES]]
 
| COUNTRY_ID
 
| COUNTRY_ID
Line 272: Line 195:
 
|}
 
|}
  
−
=== Detail Tables ===
+
 
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 278: Line 201:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
 
+
−
|- valign="top"
+
|-
 
| [[SH.SALES_(table)|SH.SALES]]
 
| [[SH.SALES_(table)|SH.SALES]]
 
| CUST_ID
 
| CUST_ID
 
| CUST_ID
 
| CUST_ID
 
|}
 
|}

Please note that all contributions to dbscript Online Help may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see Project:Copyrights for details). Do not submit copyrighted work without permission!

Cancel | Editing help (opens in new window)
Retrieved from "http://dbshelp.devio.at/index.php/SH.CUSTOMERS_(table)"