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

Table 7

Information of property sales.

Field name	Field type	Data length	Primary key/foreign key	Allow to be empty
Property sales ID	Int	32	Primary key	No
Property ID	Int	32	Foreign key	No
Building ID	Int	32	Foreign key	No
Room ID	Int	32	Foreign key	No
Average selling price	Float	7	No	No
Number of households sold	Int	32	No	No
Sales rate	Varchar	20	No	Yes
Lowest price	Money	7	No	Yes
Highest price	Money	7	No	Yes
Discount	Float	7	No	Yes
Promotion channels	Nvarchar	50	No	Yes
Total houses	Int	32	No	Yes
Predetermined quantity	Int	32	No	No
Unsold quantity	Int	32	No	No