mktg_customer Table
The mktg_customer table in the marketing database contains information about various marketing campaign customers.
The following table describes the columns in the mktg_customer table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_customer_id |
int |
no |
The ID of this marketing campaign customer. This is the primary key. |
i_industry_id |
int |
yes |
The industry code associated with this customer. This is a foreign key into the mktg_industry_code table. |
i_customer_type |
int |
no |
The type of this customer. |
u_customer_name |
nvarchar(255) |
no |
The name of this customer. |
u_customer_contact |
nvarchar(255) |
yes |
The name of the contact within this customer organization. |
u_customer_url |
nvarchar(512) |
yes |
The URL of this customer's Web site. |
u_customer_address |
nvarchar(1024) |
yes |
The address of this customer. |
u_customer_phone |
nvarchar(100) |
yes |
The telephone number of this customer. |
u_customer_fax |
nvarchar(100) |
yes |
The fax number of this customer. |
u_customer_email |
nvarchar(128) |
yes |
The e-mail address of the contact for this customer. |
u_customer_created |
datetime |
no |
The date and time at which this customer record was created. |
u_customer_exported |
datetime |
yes |
The date and time at which this customer record was last exported to the Data Warehouse Analytics System. |
u_customer_modified |
datetime |
yes |
The date and time at which this customer created was last modified. |
u_customer_modified_by |
nvarchar(50) |
yes |
The name of the user who created or last modified this customer record. |
u_customer_archived |
datetime |
yes |
The date and time at which this customer record was archived/deleted. |
u_customer_comments |
nvarchar(1024) |
yes |
Any arbitrary comments about this customer. |
u_customer_username |
nvarchar(50) |
yes |
A user name for use by the customer when they log on to view and/or modify their campaign data. |
u_customer_password |
nvarchar(50) |
yes |
A password for use by the customer when they log on to view and/or modify their campaign data. |
b_customer_deleted |
bit |
yes |
A Boolean value that indicates whether this customer record has been archived/deleted. |