customer_dimension

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