Please enable JavaScript.
Coggle requires JavaScript to display documents.
Society Maintenance (backend) - Coggle Diagram
Society Maintenance (backend)
Database
Workers
ID ( Integer )
Name ( string )
Role ( String ) [ worker/resident/admin ]
Type of Work ( String )
worker status ( available / started / in-progress / completed )
worker_password
Residents
ID ( Integer )
Name ( String )
Role ( String )
House No. ( Integer )
resident_password
Request
request_id
request_type ( same as service types )
resident_id ( from resident table )
worker_id ( from worker table )
Service Types
Electrician
Plumber
Sanitation
Carpenter