dbms_project/quick_sql.txt at master · b-roamer/dbms_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
36
37
38
39
40
41
42
43
44
45
/* quick sql for table init */

faculties
  faculty_id number(1) /pk /between 1 and 4
  faculty_name vc(50) /nn


students
  student_id number(9) /pk
  first_name vc(20) /nn
  last_name vc(20) /nn
  birth_date date /nn
  year number(1) /nn /between 1 and 4
  faculty /fk sdu_faculties(faculty_id)


heads
  student_id /fk sdu_students(student_id)
  first_name vc(20) /nn
  last_name vc(20) /nn
  faculty_id /fk sdu_faculties(faculty_id)
  birth_date date /nn


rooms
  room_id vc(4) /pk
  floor number(1) /between 1 and 3


clubs
  club_id number(3) /pk
  club_name vc(20) /nn
  club_head /fk heads
  club_category vc(20) /nn
  members_number number(3) /nn
  date established
  club_room /fk sdu_rooms(room_id)


events
  event_date date
  club_id /fk sdu_clubs(club_id)
  budget number(9) /nn