Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database stuff - Coggle Diagram
Database stuff
adults
fname
sname
acode - autogenerated
password
password pre set by admin
username
email
house
not all adults need to be in a house
staff number
not all organiers need to be staff
PC
Not all adults are in a pc
students
house
sname
fname
scode
email
must be unique
password
not required as is initially blank
PC
all PCs have an adult
events
date
start time
end time
eid
description
points worth
admins
username
password
email
fname
sname
attendances
who
when
who scanned
what event
notices
date
title
text
acode of writer
leaderboard
house
points
colour
interacts with leader board graphic to make life easier