Research on Precision Marketing of Real Estate Market Based on Data Mining

Table 8

Management table of customer information.

Field name	Field type	Data length	Primary key/foreign key	Allow to be empty
Customer ID	Int	32	Primary key	No
client’s name	Varcha	60	No	No
Employer	Varcha	60	No	No
ID number	Varcha	20	No	No
Gender	Varcha	2	No	No
Contact number	Varcha	20	No	No
Address	Varcha	150	No	No
Age	Int	32	No	Yes
Profession	Varcha	50	No	Yes
Demand area	Float	7	No	Yes
Demand floor	Float	7	No	Yes
Demand room type	Varcha	50	No	Yes
Payment method	Varcha	50	No	Yes
Purchase intention	Varcha	100	No	Yes
Number of homes purchased	Int	32	No	Yes
Remark	Varcha	250	No	Yes