SWOT Research on the Development of Rural Tourism E-Commerce System under the Background of Big Data Era

Table 1

Database table of travel e-commerce system.

Name	Data type	Notes
User id	Int (11)	Identify users, each user has a unique corresponding user id
User name	Varchar (255)	Identify user name
Password	Varchar (255)	User password
Auth id	Int (11)	Identify permissions, a user has several permissions
Place id	Int (11)	Attraction identification, marking the only attraction
Desc	Text	Attraction information description
Order id	Int (11)	Identify ID, marking the unique order
Number	Int (11)	Number of visitors in the order
Total money	Decimal	The total amount paid for the order
Pay id	Int (11)	Identify information identification
User card no	Varchar (255)	User payment card number