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)