Table of Contents
Quick-Touch DB Design
user entry
user rights def
user rights assignment
Age Groups
Event Info
Event Cost entry
Registration entry
Event_entry
Quick-Touch DB Design
user entry
int id
username
password hash
user rights def
int id
varchar short-name
varchar right-descr
user rights assignment
int id
int right-id
int user-id
Age Groups
int gender
int start_age
int end_age
int id
Event Info
int id
varchar event-title
varchar event-descr
varchar event-length
varchar age_groups (array “Age Groups”)
long start_time
Event Cost entry
int id
int event-id
int age-group-id
Registration entry
varchar fname
varchar lname
int age
char gender
varchar city
varchar state
int zip
varchar email
varchar phone
int id
Event_entry
int id
int reg_entry (foreign id)
boolean has_paid
boolean signed_wavier
int assigned_bib
long time (initial=-1)