DB응
테이블 (12)
Chat_Message
- message_id — INT
- room_id — INT — NOT NULL
- sender_id — INT — NOT NULL
- content — TEXT
- timestamp — TIMESTAMP
Chat_Room
- room_id — INT
- student_id — INT — NOT NULL
- teacher_id — INT — NOT NULL
Homework
- homework_id — INT
- lesson_id — INT — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- status — VARCHAR(50) — NOT NULL
Lesson
- lesson_id — INT
- student_id — INT — NOT NULL
- teacher_id — INT — NOT NULL
- subject_id — INT — NOT NULL
- lesson_start_time — TIMESTAMP — NOT NULL
- duration_minutes — INT — NOT NULL
- status — VARCHAR(50) — NOT NULL
Lesson_Change_Request
- request_id — INT
- lesson_id — INT — NOT NULL
- student_id — INT — NOT NULL
- request_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
Notification
- notification_id — INT
- user_id — INT — NOT NULL
- message — VARCHAR(255)
- is_read — BOOLEAN
- timestamp — TIMESTAMP
Review
- review_id — INT
- lesson_id — INT — NOT NULL
- student_id — INT — NOT NULL
- teacher_id — INT — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT — EX
Settlement
- settlement_id — INT
- lesson_id — INT — NOT NULL
- teacher_id — INT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(50) — NOT NULL
Subject
- subject_id — INT
- subject_name — VARCHAR(255) — NOT NULL
Teacher_Availability
- avail_id — INT
- teacher_id — INT — NOT NULL
- day_of_week — VARCHAR(10)
- start_time — TIME
- end_time — TIME
Teacher_Subject
- teacher_id — INT — 기본 키 — NOT NULL
- subject_id — INT — 기본 키 — NOT NULL
User
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- user_type — VARCHAR(50) — NOT NULL
- target_level — VARCHAR(255)