SHARE
TWEET

dsadasdas

a guest Dec 8th, 2019 85 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top