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