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

Table 5

Information of building.

Field name	Field type	Data length	Primary key/foreign key	Allow to be empty
Building ID	Int	32	Primary key	No
Property ID	Int	32	Foreign key	No
unit number	Nvarchar	10	No	No
Area	Float	7	No	No
Construction area	Float	7	No	No
Building type ID	Int	32	Foreign key	No
Number of layers	Varchar	10	No	No
Number of garages	Int	32	No	No
Number of households per floor	Int	32	No	No
Consumer groups	Nvarchar	30	No	No
Remark	Text	250	No	Yes
Total houses	Int	32	No	Yes
Sold	Int	32	No	Yes
Unsold	Int	32	No	Yes