채팅방
테이블 (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