SecureU — Student Safety & Grievance Redressal Portal

1-CLICK DEMO ACCOUNTS

Student Dashboard

Department: CSE — Submit complaints and track resolution progress.

Total Filed

📑

0

Complaints submitted by you

Pending

⏳

0

Awaiting initial administrative review

In Progress

⚙️

0

Assigned to maintenance/staff

Resolved

✅

0

Successfully addressed & closed

ID	Category	Description	Status	Date Filed	Action

Good evening 👋

Last updated: —

Warden Here's an overview of student grievances and their current status.

Total Grievances

0

—

Pending Action

0

—

In Progress

0

—

Resolved

0

—

Resolution Rate

0%

—

Grievance Trends

Total Resolved Pending

Complaint Status Distribution

Complaints by Category

#	Student & Dept	Category	Description	Status	Date Filed	Action

This inspector shows the live state of tables corresponding to sql/CollegeComplaint.sql and App.java.

👥 TABLE: students `(student_id PK, name, department, email UNIQUE, password, phone)`

student_id	name	dept	email	password	phone

🛡️ TABLE: admin `(admin_id PK, name, role ENUM('Warden','HOD'), email UNIQUE, password)`

admin_id	name	role	email	password

📋 TABLE: complaints `(complaint_id PK, student_id FK, category, description, evidence, status, date_filed, remarks)`

ID	student_id	category	description	evidence	status	date	remarks

VOICE.RESOLVE. EMPOWER.

WELCOME BACK

Student Dashboard

My Filed Complaints

Good evening 👋

Grievance Trends

Complaint Status Distribution

Complaints by Category

File a New Grievance

Live Grievance Tracker

1. Complaint Lodged

2. Action & Investigation

3. Redressal & Closed

Update Complaint Redressal

Relational Database Inspector

👥 TABLE: students (student_id PK, name, department, email UNIQUE, password, phone)

🛡️ TABLE: admin (admin_id PK, name, role ENUM('Warden','HOD'), email UNIQUE, password)

📋 TABLE: complaints (complaint_id PK, student_id FK, category, description, evidence, status, date_filed, remarks)

Attachment Preview

VOICE.
RESOLVE. EMPOWER.

👥 TABLE: students `(student_id PK, name, department, email UNIQUE, password, phone)`

🛡️ TABLE: admin `(admin_id PK, name, role ENUM('Warden','HOD'), email UNIQUE, password)`

📋 TABLE: complaints `(complaint_id PK, student_id FK, category, description, evidence, status, date_filed, remarks)`