| id |
int(10)
|
|
|
|
| company_id |
int(10)
|
|
|
|
| branch_id |
int(10)
|
|
|
|
| insight_date |
date
|
|
|
|
| insight_type |
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
| insight_title |
varchar(220)
|
utf8mb4_unicode_ci
|
|
|
| insight_description |
text
|
utf8mb4_unicode_ci
|
|
|
| related_module |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| related_entity_type |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| related_entity_id |
int(10)
|
|
|
|
| severity |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| ai_score |
decimal(8,2)
|
|
|
|
| recommended_action |
text
|
utf8mb4_unicode_ci
|
|
|
| action_status |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| resolved_by |
int(10)
|
|
|
|
| resolved_at |
datetime
|
|
|
|
| resolution_notes |
text
|
utf8mb4_unicode_ci
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| delete_status |
tinyint(1)
|
|
|
|
| created_by |
int(10)
|
|
|
|
| updated_by |
int(10)
|
|
|
|
| deleted_by |
int(10)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| deleted_at |
datetime
|
|
|
|