kakaotalk
Tables (4)
Chat
- member_id (Key) — Long — Foreign key → Member.member_id — NOT NULL
- room_id (Key2) — uuid — Foreign key → Room.room_id — NOT NULL
- chat_id (Field) — Long
- contents (Field2) — String
- createdAt (Field3) — DateTime
- modifiedAt (Field4) — DateTIme
Member
- member_id (Key) — Long — Primary key — NOT NULL
- email (Field) — String
- nickname (Field2) — String
- password (Field3) — String
- createdAt (Field4) — DateTIme
- modifiedAt (Field5) — DateTIme
MemberRoom
- memberRoom_id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → Member.member_id — NOT NULL
- room_id (Key3) — uuid — Foreign key → Room.room_id — NOT NULL
Room (Rooms)
- room_id (Key) — uuid — Primary key — NOT NULL
- roomName (Field) — String
- createdAt (Field2) — DateTime
- modifiedAt (Field3) — DateTime