test

Tables (4)

locker_room_stat

  • id — BIGINT — Foreign key → team.id
  • bat_power_lv — SMALLINT — NOT NULL
  • bat_contact_lv — SMALLINT — NOT NULL
  • bat_eye_lv — SMALLINT — NOT NULL
  • bat_patience_lv — SMALLINT — NOT NULL
  • bat_speed_lv — SMALLINT — NOT NULL
  • bat_fielding_lv — SMALLINT — NOT NULL
  • pit_velocity_lv — SMALLINT — NOT NULL
  • pit_breaking_lv — SMALLINT — NOT NULL
  • pit_stuff_lv — SMALLINT — NOT NULL
  • pit_control_lv — SMALLINT — NOT NULL
  • pit_stamina_lv — SMALLINT — NOT NULL
  • pit_fielding_lv — SMALLINT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • version — BIGINT — NOT NULL

pitcher_captain_stat

  • id — BIGINT — Foreign key → team.id
  • card_id — BIGINT
  • level — SMALLINT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • version — BIGINT — NOT NULL

team

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

team_captain_stat

  • id — BIGINT — Foreign key → team.id
  • card_id — BIGINT
  • level — SMALLINT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • version — BIGINT — NOT NULL