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)