User Tools

Site Tools


touchregtime:dg_design

This is an old revision of the document!


Quick-Touch DB Design

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.1508856785.txt.gz · Last modified: 2017/10/24 09:53 by tschulz