TikiTakaChat
Tables (4)
Message (tb_messages)
- Id (Key) — UUID — Primary key — NOT NULL
- content (Field) — VARCHAR
- messageType (Field2) — ENUM
- senderId (Key2) — UUID — Foreign key → User.Id — NOT NULL
- roomId (Key3) — UUID — Foreign key → Room.Id — NOT NULL
Room (tb_rooms)
- Id (Key) — UUID — Primary key — NOT NULL
- roomType (Field2) — ENUM
RoomUser (tb_user_rooms)
- userId (Key) — UUID — Foreign key → User.Id — NOT NULL
- roomId (Key2) — UUID — Foreign key → Room.Id — NOT NULL
- isInvited (Field)
- EnterDate (Field2)
User (tb_users)
- Id (Key) — UUID — Primary key — NOT NULL
- email (Field3) — VARCHAR
- username (Field) — VARCHAR
- password (Field2) — VARCHAR
- phone_number (Field4) — VARCHAR
- status (Field5) — ENUM