yabolza

Tables (4)

bowling_ball

  • bowling_ball_id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • price — int — NOT NULL
  • flare_potential — varchar(100) — NOT NULL
  • fragrance — varchar(100)
  • weight_block — varchar(100) — NOT NULL
  • company — varchar(100) — NOT NULL
  • performance — varchar(100) — NOT NULL
  • symmetry_yn — varchar(1) — NOT NULL
  • cover_stock — varchar(100) — NOT NULL
  • release_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

bowling_ball_color

  • color — VARCHAR(100) — Primary key — NOT NULL
  • bowling_ball_id — bigint — Foreign key → bowling_ball.bowling_ball_id — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

bowling_ball_core

  • bowling_ball_core_id — bigint — Primary key — NOT NULL
  • bowling_ball_id — bigint — Foreign key → bowling_ball.bowling_ball_id — NOT NULL
  • psa — double — NOT NULL
  • radius — double — NOT NULL
  • rg_differential — double — NOT NULL — 볼의 회전력(자전력) 차이값
  • int_differential — double — 코어의 비대칭값
  • weight — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

bowling_ball_factory_finish

  • factory_finish — varchar(100) — Primary key — NOT NULL
  • bowling_ball_id — bigint — Foreign key → bowling_ball.bowling_ball_id — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL