PL_Chatting_ROOM
Tables (3)
chat_message (채팅메시지)
- 메시지_seq (message_seq) — Primary key — NOT NULL
- 채팅룸_seq (room_seq) — Foreign key → chat_room.채팅룸_seq — NOT NULL
- 작성자 (send_id)
- 작성내용 (content)
- 작성타입 (content_type)
- 작성시간 (send_date)
chat_room (채팅룸)
- 채팅룸_seq (room_seq) — Primary key — NOT NULL
- 리더ID (reader_id)
- 코치ID (coach_id)
- 컨설턴트ID (contant_id)
- 생성일 (regist_date)
receive_chat (채팅수신)
- 수신_seq (receive_seq) — Primary key — NOT NULL
- 메시지_seq (message_seq) — Foreign key → chat_message.메시지_seq — NOT NULL
- 수신ID (receive_id)
- 수신여부 (receive_yn)
- 수신시간 (receive_date)