c6xMqn7f

1CREATE TABLE IF NOT EXISTS Faculty (
2  id   INT AUTO_INCREMENT PRIMARY KEY,
3  name VARCHAR(30)
4);
5
6CREATE TABLE IF NOT EXISTS Specialization (
7  id   INT AUTO_INCREMENT PRIMARY KEY,
8  name VARCHAR(30)
9);
10
11CREATE TABLE IF NOT EXISTS Groups (
12  group_number INT AUTO_INCREMENT PRIMARY KEY,
13  fac_fkey     INT,
14  spec_fkey    INT,
15  FOREIGN KEY (fac_fkey) REFERENCES Faculty (id),
16  FOREIGN KEY (spec_fkey) REFERENCES Specialization (id),
17  name         VARCHAR(30)
18);
19
20CREATE TABLE IF NOT EXISTS Student (
21  id              INT AUTO_INCREMENT PRIMARY KEY,
22  lastName        VARCHAR(30),
23  firstName       VARCHAR(30),
24  patronymic      VARCHAR(30),
25  group_id        INT,
26  startDate       DATE,
27  endDate         DATE,
28  fk_studentgroup INT,
29  FOREIGN KEY (fk_studentgroup) REFERENCES Groups (group_number)
30);
31
32CREATE TABLE IF NOT EXISTS ExamResults (
33  id         INT AUTO_INCREMENT PRIMARY KEY,
34  student_id INT,
35  avgMark    INT,
36  FOREIGN KEY (student_id) REFERENCES Student (id),
37  term       INT
38);
39
40CREATE TABLE IF NOT EXISTS Scholarship (
41  id      INT AUTO_INCREMENT PRIMARY KEY,
42  name    VARCHAR(30),
43  avgMark DOUBLE,
44  amount  DOUBLE
45);
46
47CREATE TABLE IF NOT EXISTS Payment (
48  id             INT AUTO_INCREMENT PRIMARY KEY,
49  fk_scholarship INT,
50  FOREIGN KEY (fk_scholarship) REFERENCES Scholarship (id),
51  name           VARCHAR(30)
52);