旅游信息管理系统 数据库设计
前言
代码已上传至github:https://github.com/kalipoison/travelManageSystem
设计思路
用户表 t_user 独立
id username password email
省份表 t_province 省份表:景点表 === 1:N
id name tags placecounts
景点表 t_place
id name picpath hottime hotticket dimticket placedes
--用户表
create table t_user(
id int(6) PRIMARY key auto_increment,
username varchar(60),
password varchar(60),
email varchar(60)
);
--省份表
create table t_province(
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 blob,
hottime TIMESTAMP,
hotticket double(7,2),
dimticket double(7,2),
placedes varchar(300),
provinceid int(6) REFERENCES t_province(id)
);
目录结构如下:
application.properties
server.port=8989
spring.application.name=travels
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/travels?characterEncoding=UTF-8
spring.datasource.</