|
id
|
int(11)
|
|
|
|
|
passport
|
int(11)
|
|
|
|
|
name
|
varchar(120)
|
|
|
|
|
phone
|
varchar(40)
|
|
|
|
|
service
|
varchar(40)
|
|
|
|
|
type
|
varchar(80)
|
|
|
|
|
message
|
text
|
|
|
|
|
street
|
varchar(160)
|
|
|
|
|
x
|
double
|
|
|
|
|
y
|
double
|
|
|
|
|
z
|
double
|
|
|
|
|
anonymous
|
tinyint(1)
|
|
|
0
|
|
status
|
varchar(30)
|
|
|
open
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
urgency
|
varchar(40)
|
|
|
|
|
attachment
|
text
|
|
|
|
|
assigned_passport
|
int(11)
|
|
|
|
|
assigned_name
|
varchar(120)
|
|
|
|
|
closed_at
|
timestamp
|
|
|
|