multilingo
Tables (6)
Course
- id — uuid — Primary key — NOT NULL
- title — VARCHAR(100)
- description — VARCHAR(20)
- language — ENUM
- level — ENUM
- max_students — INT
- created_at — timestampz
- updated_at — timestampz
- instructor_id (id2) — VARCHAR(255) — Foreign key → users.id — NOT NULL
Enrollment
- id — uuid — Primary key — NOT NULL
- enrolled_at — timestampz
- completed_at — timestampz
- student_id (id2) — VARCHAR(255) — Foreign key → users.id — NOT NULL
- course_id (id3) — VARCHAR(100) — Foreign key → Course.id — NOT NULL
- status — ENUM
Material
- id — uuid — Primary key — NOT NULL
- title — VARCHAR(100)
- file_url — VARCHAR(2048)
- order_index — VARCHAR(255)
- created_at — timestampz
- course_id — VARCHAR(255) — Foreign key → Course.id — NOT NULL
QnA
- id — uuid — Primary key — NOT NULL
- parent_id — VARCHAR(20)
- title — VARCHAR(100)
- content — TEXT
- is_question — BOOLEAN
- created_at — timestampz
- updated_at — timestampz
- author_id (id2) — VARCHAR(100) — Foreign key → users.id — NOT NULL
- course_id (id3) — VARCHAR(255) — Foreign key → Course.id — NOT NULL
Review
- id — uuid — Primary key — NOT NULL
- rating — DECIMAL(3,2)
- content — VARCHAR(2000)
- created_at — timestampz
- updated_at — timestampz
- student_id (id2) — VARCHAR(255) — Foreign key → users.id — NOT NULL
- course_id (id3) — VARCHAR(255) — Foreign key → Course.id — NOT NULL
users
- id — uuid — Primary key — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(100)
- role — ENUM
- created_at — timestampz
- updated_at — timestampz