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)