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)