Combine-Language
Tables (4)
lesson_reservations
- reserve_id — SERIAL
- lesson_id — INTEGER — Foreign key → lessons.lesson_id — NOT NULL
- teacher_id — VARCHAR(100) — Foreign key → teachers.user_id — NOT NULL
- user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
- reserved_date — DATE — NOT NULL
- reserved_time — TIME — NOT NULL
- status — VARCHAR(20)
- payment_status — BOOLEAN
- meeting_link — TEXT
- completed_by_student — BOOLEAN
- auto_completed — BOOLEAN
- created_at — TIMESTAMP
- fee — INTEGER
lessons
- lesson_id — SERIAL
- teacher_id — VARCHAR(100) — Foreign key → teachers.user_id — NOT NULL
- title — VARCHAR(100)
- description — TEXT
- created_at — TIMESTAMP
- available_date — DATE
- available_time — TIME
- tag — VARCHAR(100)
- file_path — TEXT
- fee — INTEGER
teachers
- user_id — VARCHAR(100) — Foreign key → users.user_id
- level — INTEGER
- approved — BOOLEAN
- language — VARCHAR(3)
users
- user_id — VARCHAR(100)
- password — VARCHAR(255) — NOT NULL
- teacher — BOOLEAN — NOT NULL
- created_at — TIMESTAMP