PixeylPlay

Tables (4)

chat_room

  • id (Key) — uuid — Primary key — NOT NULL
  • owner_id (Field6) — uuid — NOT NULL
  • title (Field) — string — NOT NULL
  • descrption (Field2) — string
  • max_capacity (Field3) — short — NOT NULL
  • created_at (Field4) — date — NOT NULL
  • modified_at (Field5) — date — NOT NULL
  • current_member (Field7) — int — NOT NULL

chat_room_member

  • id (Key) — uuid — Primary key — NOT NULL
  • user_id (Key2) — uuid — Foreign key → user.id — NOT NULL
  • chat_room_id (Key3) — uuid — Foreign key → chat_room.id — NOT NULL
  • last_joined_at (Field2) — date
  • last_read_at (Field3) — date
  • created_at (Field) — date — NOT NULL
  • is_banned (Field4) — boolean — NOT NULL

message

  • id (Key) — uuid — Primary key — NOT NULL
  • user_id (Key2) — uuid — Foreign key → user.id — NOT NULL
  • chat_room_id (Key3) — uuid — Foreign key → chat_room.id — NOT NULL
  • content (Field) — string — NOT NULL
  • created_at (Field2) — date — NOT NULL
  • modified_at (Field3) — date — NOT NULL

user

  • id (Key) — uuid — Primary key — NOT NULL
  • email (Field3) — string — NOT NULL
  • name (Field2) — string — NOT NULL
  • birth (Field6) — string — NOT NULL
  • phone (Field4) — string — NOT NULL
  • gender (Field5) — enum — NOT NULL
  • nickname (Field) — string — NOT NULL
  • created_at (Field8) — date — NOT NULL
  • modified_at (Field9) — date — NOT NULL
  • linked_providers (Field10) — enum[] — NOT NULL
  • photo_url (Field11) — string