Please enable JavaScript.
Coggle requires JavaScript to display documents.
Electric vehivcle charging, slot_book_system - Coggle Diagram
Electric vehivcle charging
ADMIN
Login
Add new user
add/view charging station
assign charging slot to user
see all details of charging slot
USER
Register
Login
Add personal Information
View slot details
Book Slot
Add Vehicle
slot_book_system
book_slot
id (pk)
fk_vehicle_id (fk from vehicle)
dk_user_id (fk from user)
fk_slot_id (fk from slot)
date_time
status
created_date
updated_date
total_time
user
id (pk)
name
email
password
user_type
dept_id (fk)
created_date
updated_date
vehicle
id (pk)
user_id (fk from user)
vehicle_name
vehicle_number
created_date
updated_date
department
id(pk)
dept_name
created_date
updated_date
slot
id(pk)
slot_name
created_date
updated_date