TestDB
Tables (5)
Albatros Key (albatros_key)
- Main Key (main_key) — char(10) — Primary key — NOT NULL — location+golf+course
- Area Key (area_key) — char(8) — Foreign key → Area key table.Area Key — NOT NULL — latitude + ID + longitude + ID
- Location Num (location_num) — int(3) — Foreign key → Location key.Location Num — NOT NULL
- Golf Num (golf_num) — int(3) — Foreign key → Golf info table.Golf Num — NOT NULL
- Course (course) — int
- Hole (hole) — int
Area key table (gps_area)
- Area Key (area_key) — Primary key — NOT NULL — latitude + ID + longitude + ID
- Latitude (latitude) — int
- Latitude Id (latitude_id) — char
- Longitude (longitude) — int
- Longitude Id (longitude_id) — char
- Update Date (update_date) — Date
Golf info table (golf_name)
- Golf Num (golf_num) — int(3) — Primary key — NOT NULL
- Location Num (location_num) — int(3) — Foreign key → Location key.Location Num — NOT NULL
- Golf Name (golf_name) — VARCHAR(255)
- Course Max (course_max) — Int
- Hole Max (hole_max) — int
- Average GPS X (ave_gps_x) — double
- Average GPS Y (ave_gps_y) — double
- Date (date) — Date
Location key (location_name)
- Location Num (location_num) — int(3) — Primary key — NOT NULL
- Location Name (location_name) — VARCHAR(255)
Map Data table (full_data)
- Main Key (main_key) — char(10) — Foreign key → Albatros Key.Main Key — NOT NULL — location+golf+course
- Red X (red_x) — double
- Red Y (red_y) — double
- Yellow X (yellow_x) — double
- Yellow Y (yellow_y) — double
- White X (white_x) — double
- White Y (white_y) — double
- Blue X (blue x) — double
- Blue Y (blue y) — double
- Black X (black x) — double
- Black Y (black y) — double
- IP one X (ip_one_x) — double
- IP one Y (ip_one_y) — double
- IP two X (ip_two_x) — double
- IP two Y (ip_two_y) — double
- G one X (g_one_x) — double
- G one Y (g_one_y) — double
- G two X (g_two_x) — double
- G two Y (g_two_y) — double