ccdw_dim_customer
This table contains detailed information about customers.
Column Alias | Data Type | Key | Description | Index? |
---|---|---|---|---|
customer_id (PK) | BIGINT | PK | Unique identifier for a customer. | Yes |
ncustomer_id | VARCHAR | Natural key of the customer, representing the ID of the customer in the source system. | Yes | |
login | VARCHAR | Customer's login name or ID. | No | |
salutation | VARCHAR | Customer's salutation (for example, "Mr.", "Ms."). | No | |
title | VARCHAR | Customer's title. | No | |
job_title | VARCHAR | Customer's job title. | No | |
first_name | VARCHAR | Customer's first name. | No | |
second_name | VARCHAR | Customer's middle name. | No | |
last_name | VARCHAR | Customer's last name. | No | |
suffix | VARCHAR | Customer's name suffix. | No | |
gender | VARCHAR | Customer's gender. | No | |
dob | DATE | Customer's date of birth. | No | |
email_address | VARCHAR | Customer's email address. | No | |
phone_home | VARCHAR | Customer's home phone number. | No | |
phone_business | VARCHAR | Customer's business phone number. | No | |
phone_mobile | VARCHAR | Customer's mobile phone number. | No | |
fax | VARCHAR | Customer's fax number. | No | |
repeat_buyer | BOOLEAN | Boolean indicating if the customer is a repeat buyer. | No | |
purchase_count | INTEGER | Total number of purchases made by the customer. | No |