1
Tables (10)
course
- course_id (Key) — NUMBER — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- description — TEXT — NOT NULL
course_description
- id (Key) — Primary key — NOT NULL
- course_id — INT — NOT NULL
- content — TEXT — NOT NULL
description_author
- description_id — UUID
- author_id — UUID
- role — VARCHAR
enrollment
- course_id — UUID
- student_id — UUID
- enrolled_at — TIMESTAMP
instructor
- id — UUID
- name — VARCHAR
- email — VARCHAR
manager
- id — UUID
- name — VARCHAR
- email — VARCHAR
managing
- course_id — UUID
- manager_id — UUID
review
- id — UUID
- course_id — UUID
- student_id — UUID
- content — TEXT
- rating — INT
student
- id — UUID
- name — VARCHAR
- email — VARCHAR
teaching
- course_id — UUID
- instructor_id — UUID