User Tools
touchregtime:dg_design
Table of Contents
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)
touchregtime/dg_design.txt · Last modified: 2017/10/24 09:59 by tschulz
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
