8000 Update README.md · arraycto/StudentManageSystem@634747d · GitHub
[go: up one dir, main page]
Skip to content

Commit 634747d

Browse files
ruanjianchengruanjiancheng
committed
Update README.md
1 parent 7207275 commit 634747d

File tree

1 file changed

+58
-0
lines changed

1 file changed

+58
-0
lines changed

‎README.md

Lines changed: 58 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -103,6 +103,64 @@ java -jar student_server-0.0.1-SNAPSHOT.jar
103103

104104

105105

106+
### 数据库设计
107+
108+
<img src="README.assets/image-20220211163057648.png" alt="image-20220211163057648" style="zoom: 50%;" />
109+
110+
建表代码：
111+
112+
```sql
113+
CREATE DATABASE studentms;
114+
115+
USE studentms;
116+
117+
CREATE TABLE `s` (
118+
`sid` INT AUTO_INCREMENT,
119+
`sname` VARCHAR(30) NOT NULL,
120+
`password` VARCHAR(30) NOT NULL,
121+
PRIMARY KEY (`sid`)
122+
);
123+
124+
CREATE TABLE `c` (
125+
`cid` INT AUTO_INCREMENT,
126+
`cname` VARCHAR(30) NOT NULL,
127+
`ccredit` TINYINT,
128+
PRIMARY KEY (`cid`)
129+
);
130+
131+
CREATE TABLE `t` (
132+
`tid` INT AUTO_INCREMENT,
133+
`tname` VARCHAR(30) NOT NULL,
134+
`password` VARCHAR(30) NOT NULL,
135+
PRIMARY KEY (`tid`)
136+
);
137+
138+
CREATE TABLE `ct` (
139+
`ctid` INT AUTO_INCREMENT,
140+
`cid` INT,
141+
`tid` INT,
142+
`term` CHAR(6) NOT NULL,
143+
FOREIGN KEY (`cid`) REFERENCES c(`cid`),
144+
FOREIGN KEY (`tid`) REFERENCES t(`tid`),
145+
PRIMARY KEY (`ctid`)
146+
);
147+
148+
CREATE TABLE `sct` (
149+
`sctid` INT AUTO_INCREMENT,
150+
`sid` INT,
151+
`cid` INT,
152+
`tid` INT,
153+
`grade` FLOAT,
154+
`term` CHAR(6),
155+
FOREIGN KEY (`sid`) REFERENCES s(`sid`),
156+
FOREIGN KEY (`tid`) REFERENCES ct(`tid`),
157+
FOREIGN KEY (`cid`) REFERENCES ct(`cid`),
158+
PRIMARY KEY (`sctid`)
159+
);
160+
```
161+
162+
163+
106164
### 项目存在的问题
107165

108166
- 由于是第一次编写 Vue 项目, 代码复用做得并不是很好. 导致许多组件代码量巨大.

0 commit comments

Comments
 (0)
0