채팅방

테이블 (4)

Untitled (user)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(20) — NOT NULL

Untitled (room)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (roomName) — varchar(20) — NOT NULL
  • Field (currentMembers) — int — NOT NULL
  • Field2 (maxMembers) — int — NOT NULL

Untitled (message)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (content) — varchar(255) — NOT NULL
  • Field (createAt) — datetime — NOT NULL
  • Key (senderId) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (roomId) — bigint — 외래 키 → Untitled.Key — NOT NULL

Untitled (user_room)

  • Key (userRoomId) — bigint — 기본 키 — NOT NULL
  • Field (role) — varchar(20) — NOT NULL
  • Key (usreId) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (roomId) — bigint — 외래 키 → Untitled.Key — NOT NULL