=== Table: service_applications ===
  id (int(10) unsigned) NOT NULL
  ulb_id (int(10) unsigned) NOT NULL
  application_no (varchar(60)) NOT NULL
  applicant_name (varchar(150)) NOT NULL
  applicant_mobile (varchar(20)) NOT NULL
  service_type (enum('TENANCY_MUTATION','RENT_NOC','BUSINESS_USE_CHANGE','LEASE_RENEWAL','DEPOSIT_REFUND')) NOT NULL
  unit_id (int(10) unsigned) NULL
  submission_date (date) NOT NULL
  sla_deadline_date (date) NOT NULL
  current_status (enum('SUBMITTED','UNDER_SCRUTINY','FIELD_INSPECTION','APPROVED','REJECTED')) NOT NULL
  rejection_reason (text) NULL
  sanction_certificate_url (varchar(255)) NULL
  created_at (timestamp) NOT NULL
=== Table: document_templates ===
  id (int(10) unsigned) NOT NULL
  code (varchar(50)) NOT NULL
  title_mr (varchar(150)) NOT NULL
  title_en (varchar(150)) NOT NULL
  category (enum('BILL','NOTICE','AGREEMENT','RECEIPT','ORDER')) NOT NULL
  header_html (text) NULL
  body_template (longtext) NOT NULL
  footer_html (text) NULL
  updated_at (timestamp) NOT NULL
=== Table: payment_receipts ===
  id (int(10) unsigned) NOT NULL
  ulb_id (int(10) unsigned) NOT NULL
  bill_id (int(10) unsigned) NOT NULL
  tenant_id (int(10) unsigned) NOT NULL
  unit_id (int(10) unsigned) NOT NULL
  receipt_number (varchar(60)) NOT NULL
  receipt_date (date) NOT NULL
  amount_paid (decimal(12,2)) NOT NULL
  principal_settled (decimal(12,2)) NOT NULL
  interest_settled (decimal(12,2)) NOT NULL
  payment_mode (enum('CASH','CHEQUE','DD','POS_CARD','UPI_BHIM','NEFT_RTGS','ONLINE_GATEWAY')) NOT NULL
  transaction_ref_no (varchar(100)) NULL
  bank_name (varchar(100)) NULL
  cheque_no (varchar(30)) NULL
  cheque_date (date) NULL
  cheque_status (enum('CLEARED','BOUNCED','PENDING_CLEARING')) NOT NULL
  cashier_id (int(10) unsigned) NULL
  printed_count (int(11)) NOT NULL
  created_at (timestamp) NOT NULL