Please enable JavaScript.
Coggle requires JavaScript to display documents.
E-GOVERNANCE, DATABASE - Coggle Diagram
E-GOVERNANCE
ADMIN
Add schemes
view schemes
view users
add officer
view status
Add services
USER
view scheme
register
apply scheme
view scheme status
PDO OFFICER
view schem request
accept/reject scheme request
view user info
DATABASE
user
id (pk)
name
email
phone
password
gender
address
created_date
officer
id(pk)
name
email
phone
password
created_date
scheme
id(pk)
scheme_name
scheme_description
created_date
scheme_end_date
apply_scheme
id(pk)
fk_user_id (fk)
fk_scheme_id (fk)
status
o=pending
1=accept
2=reject
3=completed
ceated_date
admin
id (pk)
email
password
created_date