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.

See Also

Other Resources

Marketing Database Tables

Marketing Lists Database Tables

mktg_industry_code Table