|
id
|
int(11)
|
|
|
|
|
title
|
varchar(255)
|
|
|
|
|
customer_name
|
varchar(255)
|
|
|
|
|
customer_phone
|
varchar(20)
|
|
|
|
|
customer_address
|
text
|
|
|
|
|
description
|
text
|
|
|
|
|
assigned_to
|
int(11)
|
|
|
|
|
latitude
|
decimal(10,8)
|
|
|
|
|
longitude
|
decimal(11,8)
|
|
|
|
|
scheduled_date
|
date
|
|
|
|
|
scheduled_time
|
time
|
|
|
|
|
radius
|
int(11)
|
|
|
100
|
|
status
|
enum
|
-- |
|
pending
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|