ISD 820 Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

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

ISD 820 Knowledge Base

User Tools

Site Tools

Page Tools