MSC 2.0

테이블 (8)

Practice Club Data(clubData에 합치지 않을 경우) (practice_club_data)

  • Club Id (clubId) — INT — 기본 키
  • User ID (user_id) — VARCHAR(255) — 기본 키
  • Practice Club Avg (practiceClubAvg) — FLOAT
  • Practice Club Max (practiceClubMax) — FLOAT
  • Practice Club Count (practiceClubCount) — INT(11)

Practice Shot Data (practice_shot_data)

  • Shot Id (shot_id) — BIGINT(20) — 기본 키 — NOT NULL
  • Club Id (clubId) — INT — 외래 키 → clubData.Club Id
  • User ID (userId) — VARCHAR(255) — 외래 키 → clubData.User ID
  • Shot Date (shot_date) — DATE
  • Shot Time (shot_time) — DATETIME
  • Mode (mode) — CHAR(4)
  • Target (target) — INT(11)
  • Unit Index (unit_Index) — INT
  • Club Type (clubType) — VARCHAR(4)
  • Club Loft (club_loft) — FLOAT
  • Air pressure (air_pressure) — FLOAT
  • Temperature (temperature) — FLOAT
  • Ball Speed (ball_speed) — FLOAT
  • Club Speed (club_speed) — FLOAT
  • Smash Factor (smash_factor) — FLOAT
  • Launch Angle (launch_angle) — FLOAT
  • Spin (spin) — FLOAT
  • Apex (apex) — FLOAT
  • Carry (carry) — FLOAT
  • Total Distance (total_distance) — FLOAT
  • Device ID (device_id) — CHAR(16)
  • Session ID (session_id) — VARCHAR(255)
  • Data Source (date_source) — CHAR(4)
  • Is Deleted (is_deleted) — CHAR(4)
  • Model (model) — CHAR(8)
  • Firmware Version (firmware_version) — CHAR(8)
  • App Version (app_version) — CHAR(8)

Profiles (sc300_profiles)

  • User Id (user_id) — VARCHAR(255) — 기본 키 — NOT NULL
  • NickName (nickname) — VARCHAR(255)
  • Gender (gender) — CHAR(8)
  • Handedness (handedness) — CHAR(8)
  • Handicap (handicap) — TINYINT(4)
  • Age (age) — TINYINT(4)
  • Height (height) — FLOAT
  • Height Unit (height_unit) — CHAR(8)
  • Weight (weight) — FLOAT
  • Weight Unit (weight_unit) — CHAR(8)
  • Update Time (update_time) — DATETIME

Session Data (sc300_session_data)

  • Data Id (data_id) — VARCHAR(255) — 기본 키 — NOT NULL
  • User Id (user_id) — VARCHAR(255)
  • Club Id (clubid) — INT
  • Session Id (session_id) — VARCHAR(255)
  • Session Date (session_date) — DATE
  • Shot Count (shot_count) — INT(11)
  • Ball Speed Average (ball_speed_avg) — FLOAT
  • Ball Speed Count (ball_speed_count) — INT(11)
  • Club Speed Average (club_speed_avg) — FLOAT
  • Club Speed Count (club_speed_count) — INT(11)
  • Smash Factor Average (smash_factor_avg) — FLOAT
  • Smash Factor Count (smash_factor_count) — INT(11)
  • Launch Angle Average (launch_angle_avg) — FLOAT
  • Launch Angle Count (launch_angle_count) — INT(11)
  • Spin Average (spin_avg) — FLOAT
  • Spin Count (spin_count) — INT(11)
  • Apex Average (apex_avg) — FLOAT
  • Apex Count (apex_count) — INT(11)
  • Carry Average (carry_avg) — FLOAT
  • Carry Count (carry_count) — INT(11)
  • Carry Max (carry_max) — FLOAT

Target Club Data (target_club_data)

  • Club Id (clubId) — INT — 기본 키
  • User ID (userId) — VARCHAR(255) — 기본 키
  • Target Distance (targetDistance) — INT
  • Target Unit (targetUnit) — VARCHAR(4)
  • Target Club Count (targetClubCount) — INT(11)
  • Target Club Average (targetClubAvg) — FLOAT

Target Session Data (target_session_data)

  • Data Id (dataId) — VARCHAR(255) — 기본 키 — NOT NULL
  • Session Id (sessionId) — VARCHAR(255) — 기본 키 — NOT NULL
  • User Id (userId) — VARCHAR(255)
  • Club Id (clubId) — INT
  • Club Type (clubType) — VARCHAR(5)
  • Target Distance (targetDistance) — INT
  • Target Unit (targetUnit) — VARCHAR(4)
  • Score (targetScore) — FLOAT

Target Shot Data (target_shot_data)

  • Shot Id (shot_id) — BIGINT(20) — 기본 키 — NOT NULL
  • Club Id (clubId) — INT — 외래 키 → clubData.Club Id
  • User ID (userId) — VARCHAR(255) — 외래 키 → clubData.User ID
  • Shot Date (shot_date) — DATE
  • Shot Time (shot_time) — DATETIME
  • Mode (mode) — CHAR(4)
  • Target (target) — INT(11)
  • Unit Index (unit index) — INT
  • Club Type (clubType) — VARCHAR(4)
  • Club Loft (club_loft) — FLOAT
  • Air pressure (air_pressure) — FLOAT
  • Temperature (temperature) — FLOAT
  • Ball Speed (ball_speed) — FLOAT
  • Club Speed (club_speed) — FLOAT
  • Smash Factor (smash_factor) — FLOAT
  • Launch Angle (launch_angle) — FLOAT
  • Spin (spin) — FLOAT
  • Apex (apex) — FLOAT
  • Carry (carry) — FLOAT
  • Total Distance (total_distance) — FLOAT
  • Device ID (device_id) — CHAR(16)
  • Session ID (session_id) — VARCHAR(255)
  • Data Source (date_source) — CHAR(4)
  • Is Deleted (is_deleted) — CHAR(4)
  • Model (model) — CHAR(8)
  • Firmware Version (firmware_version) — CHAR(8)
  • App Version (app_version) — CHAR(8)

clubData (club_data)

  • Club Id (clubId) — INT — 기본 키
  • User ID (userId) — VARCHAR(255) — 기본 키
  • Club Type (clubType) — VARCHAR(5)
  • Club Brand (brand) — VARCHAR(20)
  • Club model (model) — VARCHAR(20)
  • Club loft angle (loft) — FLOAT
  • Club lie angle (lie) — FLOAT
  • Club nick name (nickName) — VARCHAR(10)