SQL/Untitled (7).sql at main · bytenari/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
CREATE TABLE `user` (
  `id` INT,
  `name` varchar(255),
  `email` varchar(255),
  `roleid` int
);

CREATE TABLE `content` (
  `id` int,
  `title` varchar(255),
  `body` varchar(255),
  `created_at` timestamp,
  `userid` int
);

CREATE TABLE `content_category` (
  `id` int,
  `contentid` int,
  `categoryid` int
);

CREATE TABLE `category` (
  `id` int PRIMARY KEY,
  `name` varchar(255)
);

CREATE TABLE `role` (
  `id` int,
  `name` varchar(255)
);

ALTER TABLE `user` ADD FOREIGN KEY (`roleid`) REFERENCES `role` (`id`);

ALTER TABLE `user` ADD FOREIGN KEY (`id`) REFERENCES `content` (`userid`);

ALTER TABLE `content` ADD FOREIGN KEY (`id`) REFERENCES `content_category` (`contentid`);

ALTER TABLE `content_category` ADD FOREIGN KEY (`categoryid`) REFERENCES `category` (`id`);