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)