| id |
int(10) |
|
|
|
|---|
|
| comlaint_no |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| comlaint_date |
date |
|
|
|
|---|
|
| complaint_category |
int(10) |
|
|
|
|---|
|
| customer |
int(10) |
|
|
|
|---|
|
| product |
int(10) |
|
|
|
|---|
|
| pick_list_no |
int(10) |
|
|
|
|---|
|
| pick_list_date |
date |
|
|
|
|---|
|
| warranty_expiry_date |
date |
|
|
|
|---|
|
| expected_closing_date |
date |
|
|
|
|---|
|
| nature_of_complaint |
int(11) |
|
|
|
|---|
|
| complaint_type |
int(11) |
|
|
|
|---|
|
| part_category |
int(10) |
|
|
|
|---|
|
| part_sub_category |
int(10) |
|
|
|
|---|
|
| charge_type |
int(10) |
|
|
|
|---|
|
| attended_by |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| attended_date |
date |
|
|
|
|---|
|
| description_of_complaint |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| corrective_action_taken |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| root_cause_analysis |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| preventive_action_taken |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| remarks |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| action_required_by |
varchar(255) |
latin1_swedish_ci |
|
|
|---|
|
| preventive_action_date |
date |
|
|
|
|---|
|
| action_date |
date |
|
|
|
|---|
|
| complaint_date |
date |
|
|
|
|---|
|
| CompanyId |
int(10) |
|
|
|
|---|
|
| created_by |
int(10) |
|
|
|
|---|
|
| created_date |
date |
|
|
|
|---|
|
