User & Access Control System
USER
user_id
email
full_name
password_hash
phone_no
created_at
ASSIGNED
TO
(1,1)
(0,N)
ROLE
role_id
role_name
serial_no
d
PATIENT
DOCTOR
ADMIN
DOB
gender
consent_status
clinic_name
specialty
license_no
level
assigned_dept
(optional)
GENERATES
(0,N)
AUDIT_LOG
log_id
action
timestamp
(1,1)
N