|
id
|
int(11)
|
|
|
|
|
advocate_id
|
int(11)
|
|
|
|
|
advo_client_id
|
int(11)
|
|
|
|
|
client_position
|
enum('Respondent', 'Petitioner')
|
utf8mb4_unicode_ci
|
|
|
|
party_name
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
party_lawyer
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
case_number
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
case_types
|
int(11)
|
|
|
|
|
case_sub_type
|
int(11)
|
|
|
|
|
case_status
|
int(11)
|
|
|
|
|
act
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
priority
|
enum('High', 'Medium', 'Low')
|
utf8mb4_unicode_ci
|
|
|
|
court_no
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
court_type
|
int(11)
|
|
|
|
|
court
|
int(11)
|
|
|
|
|
judge_type
|
int(11)
|
|
|
|
|
judge_name
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
filing_number
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
filing_date
|
datetime
|
|
|
|
|
registration_number
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
registration_date
|
datetime
|
|
|
|
|
remark
|
text
|
utf8mb4_unicode_ci
|
|
|
|
description
|
text
|
utf8mb4_unicode_ci
|
|
|
|
cnr_number
|
varchar(190)
|
utf8mb4_unicode_ci
|
|
|
|
first_hearing_date
|
date
|
|
|
|
|
next_date
|
datetime
|
|
|
|
|
updated_by
|
int(11)
|
|
|
|
|
police_station
|
text
|
utf8mb4_unicode_ci
|
|
|
|
fir_number
|
text
|
utf8mb4_unicode_ci
|
|
|
|
fir_date
|
date
|
|
|
|
|
is_nb
|
enum('Yes', 'No')
|
utf8mb4_unicode_ci
|
|
|
|
decision_date
|
date
|
|
|
|
|
nature_disposal
|
text
|
utf8mb4_unicode_ci
|
|
|
|
is_active
|
enum('Yes', 'No')
|
utf8mb4_unicode_ci
|
|
|
|
created_at
|
timestamp
|
|
|
|
|
updated_at
|
timestamp
|
|
|
|
