TEST
Tables (7)
ChatRoom
- chat_room_id — INT
- user_id — INT
- admin_id — INT
- created_at — TIMESTAMP
Enrollments
- enrollment_id — INT
- lecture_id — INT
- user_id — INT
- created_at — TIMESTAMP
- status — ENUM('진행중', '완료', '취소')
Instructor
- instructor_id — INT
- user_id — INT
- bio — VARCHAR(500)
LectureSections
- section_id — INT
- lecture_id — INT
- title — VARCHAR(255)
- description — VARCHAR(500)
- video_url — VARCHAR(255)
- order — INT
Lectures
- lecture_id — INT
- instructor_id — INT
- title — VARCHAR(255)
- description — VARCHAR(500)
- start_date — DATE
- end_date — DATE
- price — DECIMAL(10, 2)
- category — VARCHAR(100)
Messages
- message_id — INT
- chat_room_id — INT
- sender_id — INT
- message — VARCHAR(255)
- created_at — TIMESTAMP