chat

Tables (5)

chat_message (Untitled4)

  • id (chat_message_pk) — Primary key — NOT NULL
  • id (user_participant_pk) — Foreign key → chat_participant.id — NOT NULL
  • id (chat_room_pk) — Foreign key → chat_room.id — NOT NULL

chat_participant (Untitled3)

  • id (user_participant_pk) — Primary key — NOT NULL
  • id (user_pk) — Foreign key → user.id — NOT NULL
  • id (chat_room_pk) — Foreign key → chat_room.id — NOT NULL
  • status (참가상태)

chat_room (Untitled2)

  • id (chat_room_pk) — Primary key — NOT NULL
  • 이름 (name)
  • id (user_pk) — Foreign key → user.id — NOT NULL

read_status (Untitled5)

  • id (read_status_pk) — Primary key — NOT NULL
  • id (user_participant_pk) — Foreign key → chat_participant.id — NOT NULL
  • id (chat_message_pk) — Foreign key → chat_message.id — NOT NULL
  • status (상태)

user (Untitled)

  • id (user_pk) — Primary key — NOT NULL
  • username (유저아이디)
  • password (패스워드)