2
Tables (10)
course
- course_id — NUMBER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- description — TEXT — NOT NULL
course_description
- id (course_description_id) — NUMBER — Primary key — NOT NULL
- course_id — NUMBER — Foreign key → course.course_id — NOT NULL
- content — TEXT — NOT NULL
description_author
- id (description_author_id) — NUMBER — Primary key — NOT NULL
- id (course_description_id) — NUMBER — Foreign key → course_description.id — NOT NULL
- author_type — ENUM('INSTRUCTOR','MANAGER) — NOT NULL
- author_id (authod_id) — NUMBER — NOT NULL
enrollment
- id (enrollment_id) — NUMBER — Primary key — NOT NULL
- course_id — NUMBER — Foreign key → course.course_id — NOT NULL — UNIQUE
- id (student_id) — NUMBER — Foreign key → student.id — NOT NULL — UNIQUE
- enrolled_at — TIMESTAMP — NOT NULL
instructor
- id (instructor_id) — NUMBER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- email — VARCHAR — NOT NULL — UNIQUE
manager
- id (manager_id) — NUMBER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- email — VARCHAR — NOT NULL — UNIQUE
managing
- id (managing_id) — NUMBER — Primary key — NOT NULL
- course_id — NUMBER — Foreign key → course.course_id — NOT NULL — UNIQUE
- id (manager_id) — NUMBER — Foreign key → manager.id — NOT NULL — UNIQUE
review
- id (review_id) — NUMBER — Primary key — NOT NULL
- course_id — NUMBER — Foreign key → course.course_id — NOT NULL
- id (student_id) — NUMBER — Foreign key → student.id — NOT NULL
- content — TEXT
- rating — INT — NOT NULL
student
- id (student_id) — NUMBER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- email — VARCHAR — NOT NULL — UNIQUE
teaching
- id (teaching_id) — NUMBER — Primary key — NOT NULL
- course_id — NUMBER — Foreign key → course.course_id — NOT NULL — UNIQUE
- id (instructor_id) — NUMBER — Foreign key → instructor.id — NOT NULL — UNIQUE