====== 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)