Please enable JavaScript.
Coggle requires JavaScript to display documents.
Guard Hiring System, GHS_DB - Coggle Diagram
Guard Hiring System
ADMIN
Login
Accept/Reject request guard job form
accept request
reject
pending
Logout
View users
view visitor info
add property
assign guard to property and update shift
view report
add_category
USERS/Guard
Register
Login
view/update profile
view job status
add visitor info
chaange password/forget password
Logout
view assign proprty and shift details
GHS_DB
user
id(pk)
name
phone
email
address
password
status
Pending
success
rejected
created_date
update_date
photo
user_type
GAURD
ADMIN
visitors
id(pk)
fk_user_id(fk from user)
name
address
purpose_of_visit
login_time
logout_time
phone
created_date
update_date
property
id(pk)
p_name
address
owner_name
owner_mobile
status
created_date
updated_date
p_photo
fk_cat_id
assign_property
id(pk)
fk_property_id(fk from proprty table)
fk_user_id
shift_details
7am-3pm
3pm to 11pm
11pm - 7am
cretaed_date
updated_date
category
id(pk)
category_name
ATM,College,School,Personal_home
status
created_date
updated_date