chat

Tables (5)

Chat (채팅)

  • id (ID) — Primary key — NOT NULL
  • is_read (읽기여부)
  • chat_room_id (채팅방ID) — Foreign key → ChatRoom.id — NOT NULL
  • sender_id (발신자ID) — Foreign key → Member.id — NOT NULL
  • content (본문)
  • send_time (보낸시간)

ChatRoom (채팅방)

  • id (ID) — Primary key — NOT NULL
  • is_alert (푸시알림전송여부)
  • last_chat (마지막채팅)
  • last_chat_time (마지막채팅시간)
  • post_card_Id (엽서ID) — Foreign key → Postcard.id — NOT NULL

Member (member)

  • id (ID) — Primary key — NOT NULL

MemberChatRoom (매핑테이블)

  • id (ID) — Primary key — NOT NULL
  • member_id (멤버ID) — Foreign key → Member.id — NOT NULL
  • chat_room_id (채팅방ID) — Foreign key → ChatRoom.id — NOT NULL
  • unread_count (안읽은채팅개수)
  • is_alert (알림수신여부)

Postcard (엽서)

  • id (ID) — Primary key — NOT NULL
  • receive_member_id (수신멤버ID) — Foreign key → Member.id — NOT NULL