chat

Tables (5)

Chat_Room (채팅방)

  • Key (id) — Primary key — NOT NULL
  • 이름 (name)
  • 종류 (type)
  • 생성시각 (created_at)

Chat_room_member (Untitled2)

  • Key (id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Member.Key — NOT NULL
  • Key (chat_room_id) — Foreign key → Chat_Room.Key — NOT NULL
  • Field (joined_at)

Member (회원)

  • Key (id) — Primary key — NOT NULL
  • 닉네임 (nickname)
  • 아이디 (login_id)
  • 비밀번호 (password)

chat_message (Untitled3)

  • Key (id) — Primary key — NOT NULL
  • Key (sender_id) — Foreign key → Member.Key — NOT NULL
  • Key (chat_room_id) — Foreign key → Chat_Room.Key — NOT NULL
  • 메시지 (mesaage_type)
  • 내용 (content)
  • 생성일자 (created_at)

chat_read (Untitled4)