chat
Tables (4)
Chat (CopyOfCopyOfCopyOfUntitled)
- Id (PK) — Long — Primary key — NOT NULL
- message (권한) — String — NOT NULL
- room_id (room_FK) — Long — Foreign key → Room.Id — NOT NULL
- member_id (member_FK) — Long — Foreign key → Member.Id — NOT NULL
Member (Untitled)
- Id (PK) — Long — Primary key — NOT NULL
- username (아이디) — string — NOT NULL
- nickname (닉네임) — string — NOT NULL
Room (CopyOfUntitled)
- Id (PK) — Long — Primary key — NOT NULL
- roomName (방 이름) — string — NOT NULL
RoomMember (CopyOfCopyOfUntitled)
- Id (PK) — Long — Primary key — NOT NULL
- role (권한) — enum(ADMIN, MEMBER) — NOT NULL
- room_id (room_FK) — Long — Foreign key → Room.Id — NOT NULL
- member_id (member_FK) — Long — Foreign key → Member.Id — NOT NULL