h2. Tables

Table should be in the plural¶

Table Modal should be in the singular and column name should be in the underscore(_) format¶

h2. Users Table

id
name
user_name
mobile
password
is_active
created_at
updated_at
created_by
updated_by

h2. 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

h2. petition_departments

department_id
petition_id

h2. field_visits table

id
visit_date
visit_by
visit_report
is_letter_required
created_at
updated_at
created_by
updated_by

h2. petition_field_visits table

petition_id
field_visit_id

h2. Letters table

id
date
created_at
updated_at
create_by
updated_by

h2. petition_letters table

petition_id
letter_id

h2. letter_formats

id
name
type
content
created_at
updated_at
created_by
updated_by

h2. final_responses table

id
date
status
created_at
updated_at
create_by
updated_by

h2. final_response_petitions table

petition_id
final_response_id

h2. final_department_response table

id
department_id
final_response_id
date
reply_received
remarks
created_at
updated_at
create_by
updated_by

h2. 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

h2. 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

mode of complaints¶

received_by¶

referred_by (Referred by will can’t be given in drop down. It have to be entered manually. It can have high variation.)¶

department¶

state¶

final response status¶