This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
touchregtime:dg_design [2017/10/24 08:52] tschulz created |
touchregtime:dg_design [2017/10/24 09:59] (current) tschulz [user rights assignment] |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Quick-Touch DB Design ====== | ====== 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) | ||
+ | |||
+ | |||