社团管理系统数据库设计及sql代码

3.数据库设计

用户表（user）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

name

姓名

Varchar(25)

是

password

密码

Varchar(32)

否

photo

头像

Varchar(100)

是

phone

手机号码

Char(11)

是

UNIQUE(唯一约束)

email

邮箱地址

Varchar(40)

否

UNIQUE(唯一约束)

create_time

注册时间

datetime

否

update_time

修改时间

datetime

否

state

状态

tinyint

否

0为禁用 1为启用

gender

性别

varchar(10)

否

留言表（leave_info）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

content

内容

Varchar(500)

否

user_id

发送人id

int

否

FK外键

send_time

发送时间

datetime

否

state

处理状态

tinyint

否

0为未查看 1为已查看

社团表（club）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

name

社团名称

varchar(20)

否

introduction

社团介绍

varchar(400)

是

category_id

社团分类编号

int

否

FK(外键)

member_count

社团人数

int

否

create_time

创建时间

datetime

否

update_time

修改时间

datetime

否

admin_id

创建人id

int

否

FK(外键)

user_id

社团团长id

int

否

FK(外键)

state

社团状态

tinyint

否

0为禁用 1为启用

photo

社团头像

varchar(100）

是

用户社团关系表（user_club）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

user_id

用户id

int

否

FK(外键)

club_id

社团id

int

否

FK(外键)

role

角色

tinyint

否

0是成员 1是社长

join_time

加入时间

datetime

否

入团申请表(club_apply)

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

user_id

申请人id

int

否

FK(外键）

club_id

社团ID

int

否

FK(外键）

send_time

申请发送时间

datetime

否

apply_reason

申请理由

varchar(100)

否

state

申请状态

tinyint

否

0为未通过1为通过2为未审核

系统通知表（system_info）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

title

通知标题

varchar(40)

否

content

通知内容

varchar(400)

否

create_time

创建时间

datetime

否

update_time

修改时间

datetime

否

admin_id

创建人id

int

否

FK(外键)

管理员表（admin）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

email

登录账号

varchar(40)

否

password

密码

varchar(32)

否

photo

头像

varchar(100)

是

name

姓名

varchar(25)

否

phone

电话号码

varchar(11)

否

state

状态

tinyint

否

0为禁用 1为启用

role

角色权限

tinyint

否

0为普通管理员 1为超级管理员

社团费用记录表（club_fee）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

club_id

社团id

int

否

FK(外键)

fee_name

费用名称

varchar(120)

否

fee_size

费用金额

varchar(20)

否

create_time

创建时间

datetime

否

update_time

修改时间

datetime

否

note

备注

varchar(400)

是

社团活动申请表（activity_apply）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

user_id

申请人id

int

否

FK（外键）

club_id

社团ID

int

否

FK（外键）

send_time

申请时间

datetime

否

name

活动名称

varchar(40)

否

content

活动内容

varchar(1000)

否

photo

活动宣传图片

varchar(100)

否

start_time

活动开始时间

datetime

否

end_time

活动结束时间

datetime

否

address

活动地址

varchar(100)

否

first_state

第一次审核状态

tinyint

否

0为未通过1为已通过 2为未审核

second_state

第二次审核状态

tinyint

否

0为未通过1为已通过 2为未审核

社团活动表（activity）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

name

活动名称

varchar(40)

否

club_id

社团id

int

否

FK(外键)

content

活动内容

varchar(1000)

否

photo

活动宣传图片

varchar(100)

否

start_time

活动开始时间

datetime

否

end_time

活动结束时间

datetime

否

address

活动地址

varchar(100)

否

user_id

发起人id

int

否

FK(外键)

join_people_count

活动参加人数

int(20)

否

state

活动状态

tinyint

否

0为结束 1为开始 2为未开始

用户活动关系表（user_activity）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

user_id

用户id

int

否

FK(外键)

activity_id

活动id

int

否

FK(外键)

社团分类表（club_category）

字段

描述

类型

允许为空

备注

id

编号

Int

否

PK(主键)

name

分类名称

varchar(20)

否

note

备注

varchar(100)

是

1. Sql
2. /*
3. Navicat Premium Data Transfer
4. Source Server : localhost_3306
5. Source Server Type : MySQL
6. Source Server Version : 80031
7. Source Host : localhost:3306
8. Source Schema : club
9. Target Server Type : MySQL
10. Target Server Version : 80031
11. File Encoding : 65001
12. Date: 27/11/2023 11:09:54
13. */
14. SET NAMES utf8mb4;
15. SET FOREIGN_KEY_CHECKS = 0;

16. ---

17. -- Table structure for activity

18. ---

19. DROP TABLE IF EXISTS activity;
20. CREATE TABLE activity (
21. id int(0) NOT NULL AUTO_INCREMENT,
22. name varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
23. club_id int(0) NOT NULL,
24. content varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
25. photo varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
26. start_time datetime(0) NOT NULL,
27. end_time datetime(0) NOT NULL,
28. address varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
29. user_id int(0) NOT NULL,
30. join_people_count int(0) NOT NULL,
31. state tinyint(0) NOT NULL,
32. PRIMARY KEY (id) USING BTREE,
33. INDEX club_id(club_id) USING BTREE,
34. INDEX user_id(user_id) USING BTREE,
35. CONSTRAINT activity_ibfk_1 FOREIGN KEY (club_id) REFERENCES club (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
36. CONSTRAINT activity_ibfk_2 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE RESTRICT ON UPDATE RESTRICT
37. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

38. ---

39. -- Records of activity

40. ---

41. INSERT INTO activity VALUES (1, '活动1', 1, '活动1的内容', 'activity1.jpg', '2023-11-17 10:00:00', '2023-11-17 12:00:00', '地址1', 1, 2, 2);
42. INSERT INTO activity VALUES (2, '活动2', 1, '活动2的内容', 'activity2.jpg', '2023-11-18 13:00:00', '2023-11-18 15:00:00', '地址2', 2, 1, 2);
43. INSERT INTO activity VALUES (3, '活动3', 2, '活动3的内容', 'activity3.jpg', '2023-11-19 14:00:00', '2023-11-19 16:00:00', '地址3', 3, 1, 2);
44. INSERT INTO activity VALUES (4, '活动4', 2, '活动4的内容', 'activity4.jpg', '2023-11-20 15:00:00', '2023-11-20 17:00:00', '地址4', 4, 1, 2);
45. INSERT INTO activity VALUES (5, '活动5', 3, '活动5的内容', 'activity5.jpg', '2023-11-21 16:00:00', '2023-11-21 18:00:00', '地址5', 5, 1, 2);

46. ---

47. -- Table structure for activity_apply

48. ---

49. DROP TABLE IF EXISTS activity_apply;
50. CREATE TABLE activity_apply (
51. id int(0) NOT NULL AUTO_INCREMENT,
52. user_id int(0) NOT NULL,
53. club_id int(0) NOT NULL,
54. send_time datetime(0) NOT NULL,
55. first_state tinyint(0) NOT NULL,
56. second_state tinyint(0) NOT NULL,
57. name varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
58. content varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
59. photo varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
60. start_time datetime(0) NOT NULL,
61. end_time datetime(0) NOT NULL,
62. address varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
63. PRIMARY KEY (id) USING BTREE,
64. INDEX user_id(user_id) USING BTREE,
65. INDEX club_id(club_id) USING BTREE,
66. CONSTRAINT activity_apply_ibfk_1 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
67. CONSTRAINT activity_apply_ibfk_2 FOREIGN KEY (club_id) REFERENCES club (id) ON DELETE RESTRICT ON UPDATE RESTRICT
68. ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

69. ---

70. -- Records of activity_apply

71. ---

72. INSERT INTO activity_apply VALUES (1, 1, 1, '2023-11-17 10:00:00', 0, 0, '活动1', '活动1的内容', 'activity1.jpg', '2023-11-17 10:00:00', '2023-11-17 12:00:00', '地址1');
73. INSERT INTO activity_apply VALUES (2, 2, 1, '2023-11-18 11:00:00', 0, 0, '活动2', '活动2的内容', 'activity2.jpg', '2023-11-18 13:00:00', '2023-11-18 15:00:00', '地址2');
74. INSERT INTO activity_apply VALUES (3, 3, 2, '2023-11-19 12:00:00', 0, 0, '活动3', '活动3的内容', 'activity3.jpg', '2023-11-19 14:00:00', '2023-11-19 16:00:00', '地址3');
75. INSERT INTO activity_apply VALUES (4, 4, 2, '2023-11-20 13:00:00', 0, 0, '活动4', '活动4的内容', 'activity4.jpg', '2023-11-20 15:00:00', '2023-11-20 17:00:00', '地址4');
76. INSERT INTO activity_apply VALUES (5, 5, 3, '2023-11-21 14:00:00', 0, 0, '活动5', '活动5的内容', 'activity5.jpg', '2023-11-21 16:00:00', '2023-11-21 18:00:00', '地址5');
77. INSERT INTO activity_apply VALUES (6, 2, 2, '2023-11-21 22:29:32', 1, 2, '劳动最光荣', '我爱劳动，劳动最光荣', 'abc.jpg', '2023-11-30 10:00:00', '2023-12-21 10:00:00', '操场');
78. INSERT INTO activity_apply VALUES (7, 2, 2, '2023-11-24 16:32:59', 1, 2, '劳动最光荣', '我爱劳动，劳动最光荣', 'abc.jpg', '2023-11-30 10:00:00', '2023-12-21 10:00:00', '操场');

79. ---

80. -- Table structure for admin

81. ---

82. DROP TABLE IF EXISTS admin;
83. CREATE TABLE admin (
84. id int(0) NOT NULL AUTO_INCREMENT,
85. email varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
86. password varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
87. photo varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
88. name varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
89. phone varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
90. state tinyint(0) NOT NULL,
91. role tinyint(0) NOT NULL,
92. PRIMARY KEY (id) USING BTREE
93. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

94. ---

95. -- Records of admin

96. ---

97. INSERT INTO admin VALUES (1, 'admin1@qq.com', 'e10adc3949ba59abbe56e057f20f883e', 'admin1.jpg', '管理员1', '12345678901', 1, 1);
98. INSERT INTO admin VALUES (2, 'admin2@qq.com', 'e10adc3949ba59abbe56e057f20f883e', 'admin2.jpg', '管理员2', '12345678902', 1, 0);
99. INSERT INTO admin VALUES (3, 'admin3@qq.com', 'e10adc3949ba59abbe56e057f20f883e', 'admin3.jpg', '管理员3', '12345678903', 1, 0);
100. INSERT INTO admin VALUES (4, 'admin4@qq.com', 'e10adc3949ba59abbe56e057f20f883e', 'admin4.jpg', '管理员4', '12345678904', 1, 0);
101. INSERT INTO admin VALUES (5, 'admin5@qq.com', 'e10adc3949ba59abbe56e057f20f883e', 'admin5.jpg', '管理员5', '12345678905', 1, 0);

102. ---

103. -- Table structure for club

104. ---

105. DROP TABLE IF EXISTS club;
106. CREATE TABLE club (
107. id int(0) NOT NULL AUTO_INCREMENT,
108. name varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
109. introduction varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
110. category_id int(0) NOT NULL,
111. member_count int(0) NOT NULL,
112. create_time datetime(0) NOT NULL,
113. update_time datetime(0) NOT NULL,
114. admin_id int(0) NOT NULL,
115. user_id int(0) NOT NULL,
116. state tinyint(0) NOT NULL,
117. photo varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
118. PRIMARY KEY (id) USING BTREE,
119. INDEX category_id(category_id) USING BTREE,
120. INDEX admin_id(admin_id) USING BTREE,
121. INDEX user_id(user_id) USING BTREE,
122. CONSTRAINT club_ibfk_1 FOREIGN KEY (category_id) REFERENCES club_category (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
123. CONSTRAINT club_ibfk_2 FOREIGN KEY (admin_id) REFERENCES admin (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
124. CONSTRAINT club_ibfk_3 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE RESTRICT ON UPDATE RESTRICT
125. ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

126. ---

127. -- Records of club

128. ---

129. INSERT INTO club VALUES (1, '1社', '我们社团是一个开放，和谐的社团', 1, 100, '2023-11-17 10:00:00', '2023-11-26 22:04:17', 1, 1, 1, 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/d35e0e27-49b6-49a2-958d-1b9840aa429e.png');
130. INSERT INTO club VALUES (2, '2社', '我们社团是一个开放，和谐的社团', 2, 120, '2023-11-18 10:00:00', '2023-11-26 16:47:09', 2, 2, 1, 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/d35e0e27-49b6-49a2-958d-1b9840aa429e.png');
131. INSERT INTO club VALUES (3, '3社', '我们社团是一个开放，和谐的社团', 3, 150, '2023-11-19 10:00:00', '2023-11-26 16:47:09', 3, 3, 1, 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/d35e0e27-49b6-49a2-958d-1b9840aa429e.png');
132. INSERT INTO club VALUES (4, '4社', '我们社团是一个开放，和谐的社团', 4, 180, '2023-11-20 10:00:00', '2023-11-26 16:47:09', 4, 4, 1, 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/d35e0e27-49b6-49a2-958d-1b9840aa429e.png');
133. INSERT INTO club VALUES (5, '5社', '我们社团是一个开放，和谐的社团', 5, 200, '2023-11-21 10:00:00', '2023-11-26 16:47:09', 5, 5, 1, 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/d35e0e27-49b6-49a2-958d-1b9840aa429e.png');
134. INSERT INTO club VALUES (9, '魔术社', '我们社团是一个开放，和谐的社团', 5, 1, '2023-11-25 22:50:44', '2023-11-26 18:02:08', 1, 6, 1, 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/d35e0e27-49b6-49a2-958d-1b9840aa429e.png');

135. ---

136. -- Table structure for club_apply

137. ---

138. DROP TABLE IF EXISTS club_apply;
139. CREATE TABLE club_apply (
140. id int(0) NOT NULL AUTO_INCREMENT,
141. user_id int(0) NOT NULL,
142. club_id int(0) NOT NULL,
143. send_time datetime(0) NOT NULL,
144. apply_reason varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
145. state tinyint(0) NOT NULL,
146. PRIMARY KEY (id) USING BTREE,
147. INDEX user_id(user_id) USING BTREE,
148. INDEX club_id(club_id) USING BTREE,
149. CONSTRAINT club_apply_ibfk_1 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
150. CONSTRAINT club_apply_ibfk_2 FOREIGN KEY (club_id) REFERENCES club (id) ON DELETE RESTRICT ON UPDATE RESTRICT
151. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

152. ---

153. -- Records of club_apply

154. ---

155. INSERT INTO club_apply VALUES (1, 1, 1, '2023-11-17 10:00:00', '申请加入社团1的理由', 1);
156. INSERT INTO club_apply VALUES (2, 2, 1, '2023-11-18 10:00:00', '申请加入社团1的理由', 1);
157. INSERT INTO club_apply VALUES (4, 4, 2, '2023-11-20 10:00:00', '申请加入社团2的理由', 1);
158. INSERT INTO club_apply VALUES (5, 5, 3, '2023-11-21 10:00:00', '申请加入社团3的理由', 1);
159. INSERT INTO club_apply VALUES (6, 2, 1, '2023-11-21 10:10:00', '我想加入该社团', 1);

160. ---

161. -- Table structure for club_category

162. ---

163. DROP TABLE IF EXISTS club_category;
164. CREATE TABLE club_category (
165. id int(0) NOT NULL AUTO_INCREMENT,
166. name varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
167. note varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
168. PRIMARY KEY (id) USING BTREE
169. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

170. ---

171. -- Records of club_category

172. ---

173. INSERT INTO club_category VALUES (1, '人文', NULL);
174. INSERT INTO club_category VALUES (2, '类别2', '类别2的备注');
175. INSERT INTO club_category VALUES (3, '类别3', '类别3的备注');
176. INSERT INTO club_category VALUES (4, '类别4', '类别4的备注');
177. INSERT INTO club_category VALUES (5, '类别5', '类别5的备注');

178. ---

179. -- Table structure for club_fee

180. ---

181. DROP TABLE IF EXISTS club_fee;
182. CREATE TABLE club_fee (
183. id int(0) NOT NULL AUTO_INCREMENT,
184. club_id int(0) NOT NULL,
185. fee_name varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
186. fee_size varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
187. create_time datetime(0) NOT NULL,
188. update_time datetime(0) NOT NULL,
189. note varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
190. PRIMARY KEY (id) USING BTREE,
191. INDEX club_id(club_id) USING BTREE,
192. CONSTRAINT club_fee_ibfk_1 FOREIGN KEY (club_id) REFERENCES club (id) ON DELETE RESTRICT ON UPDATE RESTRICT
193. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

194. ---

195. -- Records of club_fee

196. ---

197. INSERT INTO club_fee VALUES (1, 1, '会费1', '100', '2023-11-17 10:00:00', '2023-11-17 10:00:00', '会费1的备注');
198. INSERT INTO club_fee VALUES (2, 2, '会费2', '200', '2023-11-18 10:00:00', '2023-11-18 10:00:00', '会费2的备注');
199. INSERT INTO club_fee VALUES (3, 3, '会费3', '300', '2023-11-19 10:00:00', '2023-11-19 10:00:00', '会费3的备注');
200. INSERT INTO club_fee VALUES (4, 4, '会费4', '400', '2023-11-20 10:00:00', '2023-11-20 10:00:00', '会费4的备注');
201. INSERT INTO club_fee VALUES (5, 5, '会费5', '500', '2023-11-21 10:00:00', '2023-11-21 10:00:00', '会费5的备注');

202. ---

203. -- Table structure for leave_info

204. ---

205. DROP TABLE IF EXISTS leave_info;
206. CREATE TABLE leave_info (
207. id int(0) NOT NULL AUTO_INCREMENT,
208. content varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
209. user_id int(0) NOT NULL,
210. send_time datetime(0) NOT NULL,
211. state tinyint(0) NOT NULL,
212. PRIMARY KEY (id) USING BTREE,
213. INDEX user_id(user_id) USING BTREE,
214. CONSTRAINT leave_info_ibfk_1 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE RESTRICT ON UPDATE RESTRICT
215. ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

216. ---

217. -- Records of leave_info

218. ---

219. INSERT INTO leave_info VALUES (1, '请假信息1', 1, '2023-11-17 10:00:00', 0);
220. INSERT INTO leave_info VALUES (2, '请假信息2', 1, '2023-11-18 10:00:00', 0);
221. INSERT INTO leave_info VALUES (3, '请假信息3', 2, '2023-11-19 10:00:00', 0);
222. INSERT INTO leave_info VALUES (4, '请假信息4', 2, '2023-11-20 10:00:00', 0);
223. INSERT INTO leave_info VALUES (5, '请假信息5', 3, '2023-11-21 10:00:00', 0);
224. INSERT INTO leave_info VALUES (6, '没啥事我就是想给管理员聊天', 2, '2023-11-22 17:18:23', 0);
225. INSERT INTO leave_info VALUES (7, '没啥事我就是想给管理员聊天凄凄切切', 2, '2023-11-22 23:29:35', 0);

226. ---

227. -- Table structure for system_info

228. ---

229. DROP TABLE IF EXISTS system_info;
230. CREATE TABLE system_info (
231. id int(0) NOT NULL AUTO_INCREMENT,
232. title varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
233. content varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
234. create_time datetime(0) NOT NULL,
235. update_time datetime(0) NOT NULL,
236. admin_id int(0) NOT NULL,
237. PRIMARY KEY (id) USING BTREE,
238. INDEX admin_id(admin_id) USING BTREE,
239. CONSTRAINT system_info_ibfk_1 FOREIGN KEY (admin_id) REFERENCES admin (id) ON DELETE RESTRICT ON UPDATE RESTRICT
240. ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

241. ---

242. -- Records of system_info

243. ---

244. INSERT INTO system_info VALUES (1, '系统消息1', '系统消息1的内容', '2023-11-17 10:00:00', '2023-11-17 10:00:00', 1);
245. INSERT INTO system_info VALUES (2, '系统消息2', '系统消息2的内容', '2023-11-18 10:00:00', '2023-11-18 10:00:00', 2);
246. INSERT INTO system_info VALUES (3, '系统消息3', '系统消息3的内容', '2023-11-19 10:00:00', '2023-11-19 10:00:00', 3);
247. INSERT INTO system_info VALUES (4, '系统消息4', '系统消息4的内容', '2023-11-20 10:00:00', '2023-11-20 10:00:00', 4);
248. INSERT INTO system_info VALUES (5, '系统消息5', '系统消息5的内容', '2023-11-21 10:00:00', '2023-11-21 10:00:00', 5);

249. ---

250. -- Table structure for user

251. ---

252. DROP TABLE IF EXISTS user;
253. CREATE TABLE user (
254. id int(0) NOT NULL AUTO_INCREMENT,
255. name varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
256. password varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
257. photo varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
258. phone char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
259. email varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
260. create_time datetime(0) NOT NULL,
261. update_time datetime(0) NOT NULL,
262. state tinyint(0) NOT NULL,
263. gender varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
264. PRIMARY KEY (id) USING BTREE,
265. UNIQUE INDEX email(email) USING BTREE,
266. UNIQUE INDEX phone(phone) USING BTREE
267. ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

268. ---

269. -- Records of user

270. ---

271. INSERT INTO user VALUES (1, '李四一', '508df4cb2f4d8f80519256258cfb975f', 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/aeecda3f-fcb0-4011-a3dd-5efdcbedebcd.jpg', '17828029118', '3191069@qq.com', '2023-11-17 10:00:00', '2023-11-25 21:49:25', 1, '男');
272. INSERT INTO user VALUES (2, '用户二', 'e10adc3949ba59abbe56e057f20f883e', 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/aeecda3f-fcb0-4011-a3dd-5efdcbedebcd.jpg', '17828029112', 'user2@example.com', '2023-11-18 10:00:00', '2023-11-24 16:50:06', 1, '男');
273. INSERT INTO user VALUES (3, '用户3', 'e10adc3949ba59abbe56e057f20f883e', 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/aeecda3f-fcb0-4011-a3dd-5efdcbedebcd.jpg', '12345678903', 'user3@example.com', '2023-11-19 10:00:00', '2023-11-19 10:00:00', 1, '男');
274. INSERT INTO user VALUES (4, '用户4', 'e10adc3949ba59abbe56e057f20f883e', 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/aeecda3f-fcb0-4011-a3dd-5efdcbedebcd.jpg', '12345678904', 'user4@example.com', '2023-11-20 10:00:00', '2023-11-20 10:00:00', 1, '女');
275. INSERT INTO user VALUES (5, '用户5', 'e10adc3949ba59abbe56e057f20f883e', 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/aeecda3f-fcb0-4011-a3dd-5efdcbedebcd.jpg', '12345678905', 'user5@example.com', '2023-11-21 10:00:00', '2023-11-21 10:00:00', 1, '男');
276. INSERT INTO user VALUES (6, '张三', 'e10adc3949ba59abbe56e057f20f883e', 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/aeecda3f-fcb0-4011-a3dd-5efdcbedebcd.jpg', '13568920777', '2326403483@qq.com', '2023-11-20 20:06:24', '2023-11-20 20:06:24', 1, '男');
277. INSERT INTO user VALUES (7, '张三', 'e10adc3949ba59abbe56e057f20f883e', 'https://bigeventmy.oss-cn-chengdu.aliyuncs.com/aeecda3f-fcb0-4011-a3dd-5efdcbedebcd.jpg', NULL, '2326403480@qq.com', '2023-11-22 22:57:08', '2023-11-22 22:57:08', 1, '男');

278. ---

279. -- Table structure for user_activity

280. ---

281. DROP TABLE IF EXISTS user_activity;
282. CREATE TABLE user_activity (
283. id int(0) NOT NULL AUTO_INCREMENT,
284. user_id int(0) NOT NULL,
285. activity_id int(0) NOT NULL,
286. PRIMARY KEY (id) USING BTREE,
287. INDEX user_id(user_id) USING BTREE,
288. INDEX activity_id(activity_id) USING BTREE,
289. CONSTRAINT user_activity_ibfk_1 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
290. CONSTRAINT user_activity_ibfk_2 FOREIGN KEY (activity_id) REFERENCES activity (id) ON DELETE RESTRICT ON UPDATE RESTRICT
291. ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

292. ---

293. -- Records of user_activity

294. ---

295. INSERT INTO user_activity VALUES (1, 1, 1);
296. INSERT INTO user_activity VALUES (2, 2, 2);
297. INSERT INTO user_activity VALUES (4, 4, 4);
298. INSERT INTO user_activity VALUES (5, 5, 5);
299. INSERT INTO user_activity VALUES (7, 2, 1);
300. INSERT INTO user_activity VALUES (8, 3, 3);

301. ---

302. -- Table structure for user_club

303. ---

304. DROP TABLE IF EXISTS user_club;
305. CREATE TABLE user_club (
306. id int(0) NOT NULL AUTO_INCREMENT,
307. user_id int(0) NOT NULL,
308. club_id int(0) NOT NULL,
309. role tinyint(0) NOT NULL,
310. join_time datetime(0) NOT NULL,
311. PRIMARY KEY (id) USING BTREE,
312. INDEX user_id(user_id) USING BTREE,
313. INDEX club_id(club_id) USING BTREE,
314. CONSTRAINT user_club_ibfk_1 FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE RESTRICT ON UPDATE RESTRICT,
315. CONSTRAINT user_club_ibfk_2 FOREIGN KEY (club_id) REFERENCES club (id) ON DELETE RESTRICT ON UPDATE RESTRICT
316. ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

317. ---

318. -- Records of user_club

319. ---

320. INSERT INTO user_club VALUES (1, 1, 1, 1, '2023-11-17 10:00:00');
321. INSERT INTO user_club VALUES (2, 2, 2, 1, '2023-11-18 10:00:00');
322. INSERT INTO user_club VALUES (3, 3, 3, 1, '2023-11-19 10:00:00');
323. INSERT INTO user_club VALUES (4, 4, 4, 1, '2023-11-20 10:00:00');
324. INSERT INTO user_club VALUES (5, 5, 5, 1, '2023-11-21 10:00:00');
325. INSERT INTO user_club VALUES (10, 7, 9, 0, '2023-11-25 22:50:43');
326. INSERT INTO user_club VALUES (19, 6, 9, 1, '2023-11-26 18:03:24');
327. SET FOREIGN_KEY_CHECKS = 1;