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