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