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