回答編集履歴
1
追記
test
CHANGED
|
@@ -327,3 +327,45 @@
|
|
|
327
327
|
|
|
328
328
|
|
|
329
329
|
結論から言うと、college_name を users に入れる必要がありません。
|
|
330
|
+
|
|
331
|
+
|
|
332
|
+
|
|
333
|
+
```sql
|
|
334
|
+
|
|
335
|
+
CREATE TABLE `users` (
|
|
336
|
+
|
|
337
|
+
`user_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
338
|
+
|
|
339
|
+
`name` varchar(50) NOT NULL,
|
|
340
|
+
|
|
341
|
+
`username` varchar(30) NOT NULL,
|
|
342
|
+
|
|
343
|
+
`email` varchar(128) NOT NULL,
|
|
344
|
+
|
|
345
|
+
`password` varchar(255) NOT NULL,
|
|
346
|
+
|
|
347
|
+
`college_id` int(11) NOT NULL,
|
|
348
|
+
|
|
349
|
+
PRIMARY KEY (`user_id`),
|
|
350
|
+
|
|
351
|
+
UNIQUE KEY `username` (`username`)
|
|
352
|
+
|
|
353
|
+
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
|
|
354
|
+
|
|
355
|
+
```
|
|
356
|
+
|
|
357
|
+
|
|
358
|
+
|
|
359
|
+
```sql
|
|
360
|
+
|
|
361
|
+
CREATE TABLE `college` (
|
|
362
|
+
|
|
363
|
+
`college_id` int(11) NOT NULL AUTO_INCREMENT,
|
|
364
|
+
|
|
365
|
+
`name` varchar(100) NOT NULL,
|
|
366
|
+
|
|
367
|
+
PRIMARY KEY (`college_id`)
|
|
368
|
+
|
|
369
|
+
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
|
|
370
|
+
|
|
371
|
+
```
|