id |
int(11)
|
|
|
|
job_name |
varchar(50)
|
utf8mb4_general_ci
|
|
|
type |
varchar(50)
|
utf8mb4_general_ci
|
|
|
coords |
varchar(300)
|
utf8mb4_general_ci
|
|
|
grades_type |
varchar(20)
|
utf8mb4_general_ci
|
|
|
specific_grades |
longtext
|
utf8mb4_bin
|
|
|
min_grade |
smallint(6)
|
|
|
|
data |
longtext
|
utf8mb4_bin
|
|
|
blip_id |
int(11)
|
|
|
|
blip_color |
int(11)
|
|
|
|
blip_scale |
float
|
|
|
|
label |
varchar(50)
|
utf8mb4_general_ci
|
|
|
marker_type |
int(11)
|
|
|
|
marker_scale_x |
float
|
|
|
|
marker_scale_y |
float
|
|
|
|
marker_scale_z |
float
|
|
|
|
marker_color_red |
int(3)
|
|
|
|
marker_color_green |
int(3)
|
|
|
|
marker_color_blue |
int(3)
|
|
|
|
marker_color_alpha |
int(3)
|
|
|
|
ped |
varchar(50)
|
utf8mb4_general_ci
|
|
|
ped_heading |
float
|
|
|
|
object |
varchar(50)
|
utf8mb4_general_ci
|
|
|
object_heading |
float
|
|
|
|