Advertisement
tankmaster

Untitled

Nov 19th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. TABLE: MARKS
  2. ID INT NOT NULL,
  3. Activity_id INT,
  4. User_id INT,
  5. Value FLOAT(2),
  6. IsAccepted BIT,
  7. PRIMARY KEY(ID)
  8.  
  9.  
  10. TABLE: ACTIVITIES
  11. ID INT NOT NULL,
  12. Lecturer_id INT,
  13. Subject_id INT,
  14. Room_id INT,
  15. Type_id INT,
  16. Term DATETIME2,
  17. PRIMARY KEY(ID)
  18.  
  19. TABLE: USERACTIVITY
  20. ID INT NOT NULL,
  21. User_id INT,
  22. Activity_id INT,
  23. PRIMARY KEY(ID)
  24.  
  25. TABLE: ACTIVITYTYPE
  26. ID INT NOT NULL,
  27. Name VARCHAR(100),
  28. PRIMARY KEY(ID)
  29.  
  30. TABLE: FACULTIES
  31. ID INT NOT NULL,
  32. Name VARCHAR(100),
  33. Threshold INT NOT NULL,
  34. PRIMARY KEY(ID)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement