mafia

Tables (4)

GAME_HISTORY (Untitled3)

  • id — Bigint — Primary key — NOT NULL
  • winner
  • start_at — Timestamp
  • end_at — Timestamp
  • play_time — int

PARTICIPANTS (Untitled2)

  • id — Primary key — NOT NULL
  • user_id — Bigint — Foreign key → USERS.id — NOT NULL
  • game_id — Bigint — Foreign key → GAME_HISTORY.id — NOT NULL
  • game_role — Enum
  • result — Enum
  • is_alive — Boolean

REPORT (Untitled4)

  • id — Primary key — NOT NULL
  • reporter_id — Bigint — Foreign key → USERS.id — NOT NULL
  • reported_id — Bigint — Foreign key → USERS.id — NOT NULL
  • reason — text
  • created_at — Timestamp
  • deleted_at — Timestamp

USERS (Untitled)

  • id — Bigint — Primary key — NOT NULL
  • social_provider — Enum
  • social_uuid — VARCHAR(255)
  • nickname — VARCHAR(255)
  • role — Enum
  • status — Enum
  • created_at — Timestamp
  • updated_at — Timestamp
  • deleted_at — Timestamp