bootcamp_erd
Tables (7)
Assignments
- assignment_id — INT — Primary key
- offering_id — INT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- due_date — DATE
Course_Offerings
- offering_id — INT — Primary key
- course_id — INT — NOT NULL
- instructor_id — INT — NOT NULL
- cohort — VARCHAR(50) — NOT NULL
- start_date — DATE
- end_date — DATE
Courses
- course_id — INT — Primary key
- title — VARCHAR(200) — NOT NULL
- description — TEXT
Enrollments
- enrollment_id — INT — Primary key
- offering_id (offering_id2) — INT — Foreign key → Course_Offerings.offering_id
- student_id (student_id2) — INT — Foreign key → Students.student_id
- enrolled_at — DATE — NOT NULL
Instructors
- instructor_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- specialty — VARCHAR(100)
Students
- student_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- cohort — VARCHAR(50)
- created_at — DATETIME — NOT NULL
Submissions
- submission_id — INT — Primary key
- assignment_id — INT — NOT NULL
- student_id — INT — NOT NULL
- submitted_at — DATETIME
- grade — DECIMAL(5,2)