onigokko
Tables (3)
ゲーム (games)
- Key (id) — int — Primary key — NOT NULL
- Field (start_time) — datetime — NOT NULL
- Field (end_time) — datetime — NOT NULL
ゲーム結果 (game_results)
- Key (user_id) — int — Foreign key → ユーザー.Key — NOT NULL
- Key (game_id) — int — Foreign key → ゲーム.Key — NOT NULL
- Field (role) — tinyint — NOT NULL
- Field (result) — tinyint — NOT NULL
ユーザー (users)
- Key (id) — int — Primary key — NOT NULL
- unique (email) — varchar(255) — NOT NULL
- Field (password_hash) — varchar(255) — NOT NULL
- Field (created_at) — datetime — NOT NULL