trackman_portable

Tables (3)

trackman.pitches (trackman)

  • pitch_uid (Key) — uuid — Primary key — NOT NULL
  • date (Field11) — timestamp without timezone
  • pitch_timestamp (Field) — character varying
  • pitcher (Field2) — character varying
  • pitcher_id (Field3) — integer
  • pitcher_throws (Field4) — character varying
  • pitcher_team (Field5) — character varying
  • pitcher_set (Field6) — character varying
  • tagged_pitch_type (Field7) — character varying
  • pitch_session (Field8) — character varying
  • flag (Field9) — character varying
  • rel_speed (Field10) — double precision
  • ver_rel_angle (Field12) — double precision
  • horz_rel_angle (Field13) — double precision
  • spin_rate (Field14) — double precision
  • spin_axis (Field15) — double precision
  • tilt (Field16) — character varying
  • rel_height (Field17) — double precision
  • rel_side (Field18) — double precision
  • extension (Field19) — double precision
  • vert_break (Field20) — double precision
  • induced_vert_break (Field21) — double precision
  • horz_break (Field22) — double precision
  • plate_loc_height (Field23) — double precision
  • plate_loc_side (Field24) — double precision
  • zone_speed (Field25) — double precision
  • vert_appr_angle (Field26) — double precision
  • horz_appr_angle (Field27) — double precision
  • zone_time (Field28) — double precision
  • pfxx (Field29) — double precision
  • pfxz (Field30) — double precision
  • x0 (Field31) — double precision
  • y0 (Field32) — double precision
  • z0 (Field33) — double precision
  • vx0 (Field34) — double precision
  • vy0 (Field35) — double precision
  • vz0 (Field36) — double precision
  • ax0 (Field37) — double precision
  • ay0 (Field38) — double precision
  • az0 (Field39) — double precision
  • calibration_id (Field40) — character varying
  • eff_velo (Field41) — double precision
  • practice_type (Field42) — character varying
  • device (Field43) — character varying
  • created_at (Field44) — timestamp without timezone
  • updated_at (Field45) — timestamp without timezone
  • pitch_no (Field46) — integer

trackman_portable.pitches

  • pitch_uid (Key) — uuid — Primary key — NOT NULL
  • date (Field11) — timestamp without timezone
  • pitch_timestamp (Field) — character varying
  • pitcher (Field2) — character varying
  • pitcher_id (Field3) — integer
  • pitcher_throws (Field4) — character varying
  • pitcher_team (Field5) — character varying
  • pitcher_set (Field6) — character varying
  • tagged_pitch_type (Field7) — character varying
  • pitch_session (Field8) — character varying
  • flag (Field9) — character varying
  • rel_speed (Field10) — double precision
  • ver_rel_angle (Field12) — double precision
  • horz_rel_angle (Field13) — double precision
  • spin_rate (Field14) — double precision
  • spin_axis (Field15) — double precision
  • tilt (Field16) — character varying
  • rel_height (Field17) — double precision
  • rel_side (Field18) — double precision
  • extension (Field19) — double precision
  • vert_break (Field20) — double precision
  • induced_vert_break (Field21) — double precision
  • horz_break (Field22) — double precision
  • plate_loc_height (Field23) — double precision
  • plate_loc_side (Field24) — double precision
  • zone_speed (Field25) — double precision
  • vert_appr_angle (Field26) — double precision
  • horz_appr_angle (Field27) — double precision
  • zone_time (Field28) — double precision
  • pfxx (Field29) — double precision
  • pfxz (Field30) — double precision
  • x0 (Field31) — double precision
  • y0 (Field32) — double precision
  • z0 (Field33) — double precision
  • vx0 (Field34) — double precision
  • vy0 (Field35) — double precision
  • vz0 (Field36) — double precision
  • ax0 (Field37) — double precision
  • ay0 (Field38) — double precision
  • az0 (Field39) — double precision
  • calibration_id (Field40) — character varying
  • eff_velo (Field41) — double precision
  • practice_type (Field42) — character varying
  • device (Field43) — character varying
  • created_at (Field44) — timestamp without timezone
  • updated_at (Field45) — timestamp without timezone
  • pitch_no (Field46) — integer

trakman.pitch_video (trackman.pitch_videos)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3