-- 景点表
CREATE TABLE spot (
spot_id INT PRIMARY KEY,
spot_name VARCHAR(100),
city VARCHAR(100),
description TEXT,
rating FLOAT
);
-- 旅游者表
CREATE TABLE traveler (
traveler_id INT PRIMARY KEY,
name VARCHAR(100),
age INT,
gender ENUM('Male', 'Female'),
nationality VARCHAR(100),
contact VARCHAR(100)
);
-- 游记表
CREATE TABLE travelogue (
travelogue_id INT PRIMARY KEY,
title VARCHAR(100),
content TEXT,
publish_time DATETIME,
author_id INT,
FOREIGN KEY (author_id) REFERENCES traveler(traveler_id)
);
-- 攻略表
CREATE TABLE strategy (
strategy_id INT PRIMARY KEY,
title VARCHAR(100),
content TEXT,
publish_time DATETIME,
author_id INT,
FOREIGN KEY (author_id) REFERENCES traveler(traveler_id)
);
-- 评论表
CREATE TABLE comment (
comment_id INT PRIMARY KEY,
content TEXT,
comment_time DATETIME,
spot_id INT,
commenter_id INT,
FOREIGN KEY (spot_id) REFERENCES spot(spot_id),
FOREIGN KEY (commenter_id) REFERENCES traveler(traveler_id)
);
-- 收藏夹表
CREATE TABLE collection (
collection_id INT PRIMARY KEY,
collection_name VARCHAR(100),
creator_id INT,
FOREIGN KEY (creator_id) REFERENCES traveler(traveler_id)
);
-- 收藏明细表
CREATE TABLE collection_detail (
detail_id INT PRIMARY KEY,
collection_id INT,
spot_id INT,
FOREIGN KEY (collection_id) REFERENCES collection(collection_id),
FOREIGN KEY (spot_id) REFERENCES spot(spot_id)
); 我要给上述表中每张表插入5条 数据 mysql8.0代码