Please enable JavaScript.
Coggle requires JavaScript to display documents.
EVENT_MANAGEMENT, DATABASE(cems_pro){college event management} - Coggle…
EVENT_MANAGEMENT
ADMIN
Login
Add/View/Delete Events
View users
Add/view/delete event category
view user list who registered for particular events
logout
USER
Register
Login
View Event and its details like description when it is,location and lot more
Register for event
Logout
DATABASE(cems_pro){college event management}
user
id (pk)
name
usn
email
password
status
created_date
updated_date
user_type
admin
user
clg_name
fk_dept_id(fk from department)
semester
phone
event
id(pk)
event_name
fk_cat_id (fk from category table)
description
when_date
to_date
total_days
status
0-Not Active
1-Active
created_date
updated_date
location
fk_dept_id(fk from department)
fee
free or any fee
event_level
inter_clg
department
open
fk_student_co_id(fk from co-ordinator)
fk_faculty_co_id(fk from coordinator)
category
id(pk)
name
description
created_date
updated_date
participant
id(pk)
fk_user_id (fk from user)
fk_event_id (fk from event)
status
created_date
updated_date
department
id(pk)
name
created_date
updated_date
co-ordinator
id(pk)
name
co_type
student
faculty
phone
email
status
created_date
updated_date