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