sql-project/defining pk-fk.sql at main · ekraj-pok/sql-project · 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
ALTER TABLE project.comments
ADD PRIMARY KEY (comment_id);

ALTER TABLE project.badge_id
ADD PRIMARY KEY (badge_id);

ALTER TABLE project.course_list
ADD PRIMARY KEY (course_id);

ALTER TABLE project.badge_id
ADD PRIMARY KEY (badge_id);

ALTER TABLE project.locations
ADD PRIMARY KEY (location_id);

ALTER TABLE project.schools
ADD PRIMARY KEY (school_id);

ALTER TABLE project.badges
ADD CONSTRAINT school_id FOREIGN KEY (school_id) REFERENCES schools(school_id),
ADD CONSTRAINT badge_id FOREIGN KEY (badge_id) REFERENCES badge_id(badge_id);

ALTER TABLE project.comments
ADD CONSTRAINT FOREIGN KEY (school_id) REFERENCES schools(school_id);

ALTER TABLE project.courses
ADD CONSTRAINT FOREIGN KEY (school_id) REFERENCES schools(school_id),
ADD CONSTRAINT FOREIGN KEY (school_id) REFERENCES schools(school_id);

ALTER TABLE project.locations
ADD CONSTRAINT FOREIGN KEY (school_id) REFERENCES schools(school_id);

ALTER TABLE project.courses
ADD CONSTRAINT FOREIGN KEY (school_id) REFERENCES schools(school_id),
ADD CONSTRAINT FOREIGN KEY (course_id) REFERENCES course_list(course_id);