This table contains detailed information about registered customers. Unregistered buyers (guest checkouts) aren't included in this table. In fact tables, records for unregistered buyers have customer_id = 1, which can't be used to distinguish one unregistered buyer from another.
| 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 |