sql表创建---基于springboot+vue前后端分离旅游项目

--用户表 create table t_user( id int(6) PRIMARY key auto_increment, username varchar(60), password varchar(60), email varchar(60) ); --省份表 create table t_provice( id int(6) PRIMARY key auto_increment, name varchar(60), tags varchar(80), placecounts int(4) ); --景点表 create table t_place( id int(6) PRIMARY key auto_increment, name varchar(60), picpath varchar(100), hottime TIMESTAMP, hotticker double(7,2), dimticket double(7,2), placedes varchar(300), provinceid int(6) REFERENCES t_provice(id) );