Guest User

dsadasdas

a guest
Dec 8th, 2019
95
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE CourseGroup(
  2. [course] [varchar](10) NULL,
  3. [course_group] [smallint] NULL,
  4. [course_type] [varchar](1) NULL
  5. );
  6.  
  7. CREATE TABLE Grades(
  8. [semester] [tinyint] NULL,
  9. [year] [smallint] NULL,
  10. [semester_type] [varchar](1) NULL,
  11. [academic_year] [tinyint] NULL,
  12. [course] [varchar](10) NULL,
  13. [teacher_id] [bigint] NULL,
  14. [grade] [real] NULL,
  15. [exam] [varchar](1) NULL,
  16. [student_id] [bigint] NULL
  17. );
  18.  
  19. CREATE TABLE Students(
  20. [spec] [varchar](3) NULL,
  21. [sub_spec] [varchar](3) NULL,
  22. [sub_spec2] [varchar](3) NULL,
  23. [gender] [varchar](1) NULL,
  24. [student_id] [bigint] NULL
  25. );
  26.  
  27. CREATE TABLE Teachers(
  28. [teacher_id] [bigint] NULL,
  29. [gender] [varchar](1) NULL,
  30. [faculty] [smallint] NULL,
  31. [institute] [varchar](5) NULL,
  32. [title_id] [smallint] NULL
  33. );
  34.  
  35. CREATE TABLE TeacherTitle(
  36. [title_id] [smallint] NULL,
  37. [title] [varchar](10) NULL,
  38. [title_long] [varchar](30) NULL
  39. );
RAW Paste Data