ccdw_dim_customer

This table contains detailed information about customers.

Column AliasData TypeKeyDescriptionIndex?
customer_id (PK)BIGINTPKUnique identifier for a customer.Yes
ncustomer_idVARCHARNatural key of the customer, representing the ID of the customer in the source system.Yes
loginVARCHARCustomer's login name or ID.No
salutationVARCHARCustomer's salutation (for example, "Mr.", "Ms.").No
titleVARCHARCustomer's title.No
job_titleVARCHARCustomer's job title.No
first_nameVARCHARCustomer's first name.No
second_nameVARCHARCustomer's middle name.No
last_nameVARCHARCustomer's last name.No
suffixVARCHARCustomer's name suffix.No
genderVARCHARCustomer's gender.No
dobDATECustomer's date of birth.No
email_addressVARCHARCustomer's email address.No
phone_homeVARCHARCustomer's home phone number.No
phone_businessVARCHARCustomer's business phone number.No
phone_mobileVARCHARCustomer's mobile phone number.No
faxVARCHARCustomer's fax number.No
repeat_buyerBOOLEANBoolean indicating if the customer is a repeat buyer.No
purchase_countINTEGERTotal number of purchases made by the customer.No