user_id int PK

password varchar

phone varchar

first_name varchar

last_name varchar

age tinyint

gender enum

user_type enum

is_active tinyint

created_at timestamp

last_active datetime

seen tinyint

case_id int PK

user_id int FK

incident_type varchar

incident_date date

incident_time time

location text

description text

respondent varchar

photo text

witnesses text

evidence_files text

status enum

priority enum

assigned_admin int

created_at timestamp

seen tinyint

notification_id int PK

user_id int FK

title varchar

message text

type enum

is_read tinyint

created_at timestamp

progress_id int PK

case_id int FK

admin_id int FK

action_taken text

status_update enum

notes text

created_at timestamp

schedule_id int PK

admin_id int FK

case_id int FK

title varchar

description text

schedule_date date

schedule_time time

location varchar

status enum

created_at timestamp

seen tinyint

request_id int PK

schedule_id int FK

user_id int FK

requested_date date

requested_time time

reason text

status enum

created_at timestamp

seen tinyint