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