skala_practice

Tables (10)

Assignment

  • assignment_id — long — Primary key — NOT NULL
  • title — varchar(64)
  • description — varchar(240)
  • due_date — datetime
  • created_at — datetime
  • course_id — long — Foreign key → Course.course_id — NOT NULL

Assignment_Submit

  • assignment_submit_id — long — Primary key — NOT NULL
  • submitted_at — datetime
  • score — int
  • student_id — long — Foreign key → Student.student_id — NOT NULL
  • assignment_id — long — Foreign key → Assignment.assignment_id — NOT NULL

Attendence

  • attendence_id — long — Primary key — NOT NULL
  • attendence_date — datetime
  • status — Enum(PRESENT/ ABSENT/ LATE)
  • created_at — datetime
  • student_id — long — Foreign key → Student.student_id — NOT NULL
  • course_id — long — Foreign key → Course.course_id — NOT NULL

Course

  • course_id — long — Primary key — NOT NULL
  • title — varchar(64)
  • start_date — datetime
  • end_date — datetime
  • level — int
  • created_at — datetime
  • instructor_id — long — Foreign key → Instructor.instructor_id — NOT NULL
  • manager_id — long — Foreign key → Manager.manager_id — NOT NULL

Course_Enrollment

  • course_enrollment_id — long — Primary key — NOT NULL
  • enrolled_at — datetime
  • student_id — long — Foreign key → Student.student_id — NOT NULL
  • course_id — long — Foreign key → Course.course_id — NOT NULL

Description

  • description_id — long — Primary key — NOT NULL
  • content — varchar(240)
  • created_at — datetime
  • updated_at — datetime
  • course_id — long — Foreign key → Course.course_id — NOT NULL

Instructor

  • instructor_id — long — Primary key — NOT NULL
  • name — varchar(64)
  • email — varchar(64)
  • phone — varchar(64)
  • created_at — datetime

Manager

  • manager_id — long — Primary key — NOT NULL
  • name — varchar(64)
  • email — varchar(64)
  • phone — varchar(64)
  • created_at — datetime

Review

  • review_id — long — Primary key — NOT NULL
  • rating — int
  • content — varchar(240)
  • created_at — datetime
  • student_id — long — Foreign key → Student.student_id — NOT NULL
  • course_id — long — Foreign key → Course.course_id — NOT NULL

Student

  • student_id — long — Primary key — NOT NULL
  • name — varchar(64)
  • email — varchar(64)
  • phone — varchar(64)
  • created_at — datetime