|
id
|
int(11)
|
|
|
|
|
job_code
|
varchar(100)
|
|
|
|
|
job_title
|
varchar(255)
|
|
|
|
|
open_job_date
|
date
|
|
|
|
|
foreman_name
|
varchar(150)
|
|
|
|
|
sale_name
|
varchar(150)
|
|
|
|
|
deliver_job_date
|
date
|
|
|
|
|
workflow_status
|
varchar(50)
|
|
|
pending
|
|
status_note
|
varchar(255)
|
|
|
|
|
plan_work_date
|
date
|
|
|
|
|
work_day_label
|
varchar(100)
|
|
|
|
|
estimated_duration
|
varchar(120)
|
|
|
|
|
bill_receive_date
|
date
|
|
|
|
|
wood_team
|
varchar(150)
|
|
|
|
|
timeline_start_date
|
date
|
|
|
|
|
timeline_end_date
|
date
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|