id
|
int(11)
|
|
|
|
emergency_type
|
tinyint(1)
|
|
|
0
|
police_required
|
tinyint(1)
|
|
|
0
|
ambulance_required
|
tinyint(1)
|
|
|
0
|
fire_required
|
tinyint(1)
|
|
|
0
|
tow_required
|
tinyint(1)
|
|
|
0
|
description
|
varchar(5000)
|
|
|
|
callername
|
varchar(100)
|
|
|
|
contact_details
|
varchar(100)
|
|
|
|
area
|
varchar(100)
|
|
|
|
postal
|
varchar(25)
|
|
|
|
street
|
varchar(100)
|
|
|
|
calltrackedby
|
varchar(5000)
|
|
|
|
call_coords_x
|
decimal(10,6)
|
|
|
|
call_coords_y
|
decimal(10,6)
|
|
|
|
call_coords_z
|
decimal(10,6)
|
|
|
|
archived_call
|
tinyint(1)
|
|
|
0
|
call_time
|
timestamp
|
|
|
current_timestamp()
|