|
id
|
int(11)
|
|
|
|
|
parent_id
|
int(11)
|
|
|
|
|
team_id
|
int(11)
|
|
|
|
|
team_name
|
varchar(100)
|
|
|
|
|
department
|
varchar(100)
|
|
|
|
|
job_number
|
varchar(100)
|
|
|
|
|
job_title
|
varchar(255)
|
|
|
|
|
supervisor
|
varchar(150)
|
|
|
|
|
team_leader
|
varchar(150)
|
|
|
|
|
work_type
|
varchar(100)
|
|
|
|
|
work_type_label
|
varchar(120)
|
|
|
|
|
start_date
|
date
|
|
|
|
|
start_time
|
time
|
|
|
|
|
end_date
|
date
|
|
|
|
|
end_time
|
time
|
|
|
|
|
location
|
varchar(255)
|
|
|
|
|
province
|
varchar(100)
|
|
|
|
|
description
|
text
|
|
|
|
|
members
|
text
|
|
|
|
|
status
|
varchar(50)
|
|
|
pending
|
|
created_by
|
int(11)
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|