Table Schema: mf_customer

This topic describes the columns in the mf_customer_addresses table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	Reference Count	Reference To
customer_address_guid	uniqueidentifier	1	0	1	1
customer_guid	uniqueidentifier	0	0	2	0	mf_customers.customer_guid
customer_address_state_id	smallint	0	1	3	0	mf_country_regions.country_region_id
customer_address_country_id	smallint	0	1	4	0	mf_countries.country_id
customer_address_description	varchar (50)	0	1	5	0
customer_address_attention	varchar (255)	0	1	6	0
customer_address_company_name	varchar (255)	0	1	7	0
customer_address_address	varchar (80)	0	1	8	0
customer_address_address2	varchar (80)	0	1	9	0
customer_address_address3	varchar (80)	0	1	10	0
customer_address_city	varchar (50)	0	1	11	0
customer_address_postal_code	varchar (50)	0	1	12	0
customer_address_country_region_name	nvarchar (50)	0	1	13	0
customer_address_email	varchar (80)	0	1	14	0
customer_address_phone	varchar (25)	0	1	15	0
customer_address_phone2	varchar (25)	0	1	16	0
customer_address_phone3	varchar (25)	0	1	17	0
customer_address_fax	varchar (25)	0	1	18	0
customer_address_cell	varchar (25)	0	1	19	0
customer_address_note	varchar (1000)	0	1	20	0
customer_address_deleted	tinyint	0	0	21	0
lu_dt	datetime	0	1	22	0
cr_dt	datetime	0	1	23	0
lu_guid	uniqueidentifier	0	1	24	0
cr_guid	uniqueidentifier	0	1	25	0

Table Schema: mf_customer_addresses