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

Table 3

Room information table.

Field name	Field type	Data length	Primary key/foreign key	Allow to be empty
Room ID	Int	32	Primary key	No
Building ID	Int	32	Foreign key	No
Floor	Nvarchar	3	No	No
Room No	Nvarchar	50	No	No
Unit ID	Int	32	Foreign key	No
Use	Nvarchar	50	No	Yes
Area	Int	50	No	No
Construction area	Float	7	No	No
Starting price	Money	7	No	No
Highest price	Money	7	No	No
Average selling price	Money	7	No	No
Sales discount	Nvarchar	4	No	No
Selling price	Money	7	No	No
Balcony area	Float	7	No	No
Room orientation	Nvarchar	50	No	No
Decoration standard	Nvarchar	500	No	Yes