Petition API

Tables

1. Table should be in the plural
2. Table Modal should be in the singular and column name should be in the underscore(_) format

Users Table¶

id
name
user_name
mobile
password
is_active
created_at
updated_at
created_by
updated_by

Petitions Table¶

id
petition_no (DDMMYY/today count/total count)
date
mode_of_complaints
received_by
referred_by
patitioner_name
mobile
email
type_of_issue
is_field_visit_required
address
panchayat_id
habitation_id
taulk_id
district_id
state_id
created_at
updated_at
created_by
updated_by

petition_departments¶

department_id
petition_id

field_visits table¶

id
visit_date
visit_by
visit_report
is_letter_required
created_at
updated_at
created_by
updated_by

petition_field_visits table¶

petition_id
field_visit_id

Letters table¶

id
date
created_at
updated_at
create_by
updated_by

petition_letters table¶

petition_id
letter_id

letter_formats¶

id
name
type
content
created_at
updated_at
created_by
updated_by

final_responses table¶

id
date
status
created_at
updated_at
create_by
updated_by

final_response_petitions table¶

petition_id
final_response_id

final_department_response table¶

id
department_id
final_response_id
date
reply_received
remarks
created_at
updated_at
create_by
updated_by

file_uploads table¶

id
file_name
letter_id
field_visit_id
final_response_id
file_url (s3_url)
created_at
updated_at
create_by
updated_by

letter_format_master¶

id
type
content
created_at
updated_at
created_by
updated_by

A dropdown list that we need to get from the client

1. mode of complaints
2. received_by
3. referred_by (Referred by will can’t be given in drop down. It have to be entered manually. It can have high variation.)
4. department
5. state
6. final response status