| id |
bigint(20)
|
|
|
|
| master_activity_id |
bigint(20)
|
|
|
 浏览不相关的值
|
| user_id |
bigint(20)
|
|
|
|
| activity_date |
date
|
|
|
|
| start_time |
time
|
|
|
|
| end_time |
time
|
|
|
|
| actual_duration_minutes |
int(11)
|
|
|
|
| achieved_qty |
decimal(10,2)
|
|
|
|
| efficiency_percentage |
decimal(5,2)
|
|
|
|
| status |
enum('completed', 'incomplete', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| approval_status |
enum('pending', 'approved', 'rejected')
|
utf8mb4_unicode_ci
|
|
|
| program_kerja_id |
bigint(20)
|
|
|
浏览不相关的值
|
| program_kerja_percentage |
decimal(5,2)
|
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| approved_at |
timestamp
|
|
|
|
| approval_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
