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

Table 6

Information of property.

Field name	Field type	Data length	Primary key/foreign key	Allow to be empty
Property ID	Int	32	Primary key	No
Property name	Varchar	30	No	No
Developer	Varchar	50	No	No
Design unit	Varchar	30	No	No
Regional lot	Varchar	20	No	No
Architectural style	Varchar	20	No	No
Area	Float	7	No	No
Construction area	Float	7	No	No
Total number of rooms	Int	35	No	No
Price method	Varchar	10	No	No
Development time	Datetime	8	No	No
Opening time	Datetime	8	No	No
Opening method	Varchar	50	No	No
Traffic condition	Varchar	100	No	Yes
Property management	Varchar	100	No	Yes
Remark	Text	250	No	Yes
File creation date	Datetime	8	No	Yes
Sales call	Varchar	20	No	Yes