Room229

Tables (6)

Reserve (예약목록)

  • id — Primary key — NOT NULL
  • 예약시간 (data_time)
  • 삭제시간 (delete_yn)

Reserve_chat (방정보)

  • id (채팅내역) — Primary key — NOT NULL
  • id (user_id) — Foreign key → User.id
  • id (course_id) — Foreign key → course.id — NOT NULL
  • 채팅내역 (content)

Reserve_chat (예약별 채팅)

  • id (chat_id) — Primary key — NOT NULL
  • 예약정보 (reserve_id) — Foreign key → Reserve.id — NOT NULL
  • id (user_id) — Foreign key → User.id
  • 채팅내역 (content)

User (유저)

  • id (user_id) — Primary key
  • 이름 (name)
  • 비밀번호 (pass_word)
  • 타입 (type)
  • 학번 (ynu_number)

course (강의)

  • id (course_id) — Primary key — NOT NULL
  • 이름 (course_name)
  • 번호 (course_number)

notification (알림)

  • id (notification_id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → User.id
  • 내용 (content)
  • 여부 (is_read)
  • 생성시간 (create_at)