chatting

Tables (3)

Chat (Untitled)

  • pk (chat_id) — BIGINT — Primary key — NOT NULL
  • pk (id2) — BIGINT — Foreign key → Participant.pk — NOT NULL
  • 메시지 (message) — VARCHAR(500)
  • 채팅 유형 (chatType) — ENUM

Participant (CopyOfUntitled)

  • pk (id) — BIGINT — Primary key — NOT NULL
  • 메시지 (message) — VARCHAR(500)
  • 채팅 유형 (chatType) — ENUM

Room (CopyOfCopyOfUntitled)

  • pk (room_id) — BIGINT — Primary key — NOT NULL
  • 방이름 (roomName) — VARCHAR(500)
  • 방 내용 (roomContent) — varchar(25)
  • 채팅목록 (chat)