Friday
Tables (7)
Assignments
- Key4 — Primary key — NOT NULL
- assignment_id — INT
- class_id — INT — Foreign key → Classes.class_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- due_date — DATE
- Key — Foreign key → Classes.Key — NOT NULL
- Key (Key2) — Foreign key → Classes.Key — NOT NULL
- Key3 — Foreign key → Classes.Key3 — NOT NULL
Classes
- Key3 — Primary key — NOT NULL
- class_id — INT
- course_id — INT — Foreign key → Courses.course_id — NOT NULL
- instructor_id — INT — Foreign key → Instructors.instructor_id
- cohort — VARCHAR(50) — NOT NULL
- start_date — DATE
- end_date — DATE
- Key — Foreign key → Instructors.Key — NOT NULL
- Key (Key2) — Foreign key → Courses.Key — NOT NULL
Courses
- Key — Primary key — NOT NULL
- course_id — INT
- title — VARCHAR(200) — NOT NULL
- description — TEXT
Enrollments
- Key4 — Primary key — NOT NULL
- enrollment_id — INT
- class_id — INT — Foreign key → Classes.class_id — NOT NULL
- student_id — INT — Foreign key → Students.student_id — NOT NULL
- enrolled_at — DATE — NOT NULL
- Key — Foreign key → Students.Key — NOT NULL
- Key (Key2) — Foreign key → Classes.Key — NOT NULL
- Key (Key22) — Foreign key → Classes.Key — NOT NULL
- Key3 — Foreign key → Classes.Key3 — NOT NULL
Instructors
- Key — Primary key — NOT NULL
- instructor_id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- specialty — VARCHAR(100)
Students
- Key — Primary key — NOT NULL
- student_id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
Submissions
- Key4 — Primary key — NOT NULL
- submission_id — INT
- assignment_id — INT — Foreign key → Assignments.assignment_id — NOT NULL
- student_id — INT — Foreign key → Students.student_id — NOT NULL
- submitted_at — DATETIME
- grade — DECIMAL(5,2)
- Key — Foreign key → Students.Key — NOT NULL
- Key (Key2) — Foreign key → Assignments.Key — NOT NULL
- Key (Key22) — Foreign key → Assignments.Key — NOT NULL
- Key3 — Foreign key → Assignments.Key3 — NOT NULL
- Key4 (Key42) — Foreign key → Assignments.Key4 — NOT NULL