skala_learning

Tables (7)

Assignment

  • assignment_id — INT
  • course_id — INT — Foreign key → Course.course_id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • deadline — TIMESTAMP
  • slack_thread_ts — VARCHAR(100)

AssignmentRequirement

  • requirement_id — INT
  • assignment_id — INT — Foreign key
  • content — VARCHAR(500) — NOT NULL

Course

  • course_id — INT
  • course_name — VARCHAR(100) — NOT NULL
  • semester — VARCHAR(20)
  • professor_id — INT — Foreign key → Professor.professor_id

Enrollment

  • enrollment_id — INT
  • student_id — INT — Foreign key → Student.student_id
  • course_id — INT — Foreign key → Course.course_id

Professor

  • professor_id — INT
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • department — VARCHAR(50)

Student

  • student_id — INT
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • major — VARCHAR(50)
  • slack_user_id — VARCHAR(50)

Submission

  • submission_id — INT
  • assignment_id — INT — Foreign key → Assignment.assignment_id
  • student_id — INT — Foreign key → Student.student_id
  • file_url — TEXT
  • file_name — VARCHAR(255)
  • submitted_at — TIMESTAMP
  • status — VARCHAR(20)