|
revision_id
|
bigint(20) unsigned
|
|
|
|
|
blotter_id
|
bigint(20) unsigned
|
|
|
|
|
revision_no
|
int(10) unsigned
|
|
|
|
|
narrative_summary
|
text
|
|
|
|
|
reason
|
varchar(1000)
|
|
|
|
|
amended_by
|
bigint(20) unsigned
|
|
|
|
|
superseded_at
|
datetime
|
|
|
2026-09-26 07:58:15.000000
|
|
complainant_name
|
varchar(255)
|
|
|
|
|
respondent_name
|
varchar(255)
|
|
|
|
|
complainant_contact_number
|
varchar(32)
|
|
|
|
|
case_status
|
enum
|
-- |
|
active
|