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

Table 9

Contract table of sales.

Field name	Field type	Data length	Primary key/foreign key	Allow to be empty
Sales contract ID	Int	32	Primary key	No
Customer name	Varchar	20	No	No
Purchased room	Varchar	20	No	No
Price	Float	7	No	No
Payment method	Varchar	50	No	No
Salesperson	Varchar	50	No	No
Sales manager	Varchar	50	No	No
Financial officer	Varchar	50	No	No
Payment record	Varchar	250	No	No
Related procedures	Varchar	250	No	No
Delivery time	Datatime	8	No	No
Contract remarks	Text	250	No	Yes
Signing time	Datatime	8	No	No
Signatory	Varchar	20	No	No