customer_dimension
This table contains information about all the retail chain’s customers.
This table contains information about all the retail chain’s customers.
| Column Name | Data Type | NULLs |
customer_key |
INTEGER | No |
customer_type |
VARCHAR(16) | Yes |
customer_name |
VARCHAR(256) | Yes |
customer_gender |
VARCHAR(8) | Yes |
title |
VARCHAR(8) | Yes |
household_id |
INTEGER | Yes |
customer_address |
VARCHAR(256) | Yes |
customer_city |
VARCHAR(64) | Yes |
customer_state |
CHAR(2) | Yes |
customer_region |
VARCHAR(64) | Yes |
marital_status |
VARCHAR(32) | Yes |
customer_age |
INTEGER | Yes |
number_of_children |
INTEGER | Yes |
annual_income |
INTEGER | Yes |
occupation |
VARCHAR(64) | Yes |
largest_bill_amount |
INTEGER | Yes |
store_membership_card |
INTEGER | Yes |
customer_since |
DATE | Yes |
deal_stage |
VARCHAR(32) | Yes |
deal_size |
INTEGER | Yes |
last_deal_update |
DATE | Yes |