User Tools
touchregtime:dg_design
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
touchregtime:dg_design [2017/10/24 08:59] tschulz [Event Info] |
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 ===== | ===== Age Groups ===== | ||
| Line 13: | Line 28: | ||
| * varchar event-length | * varchar event-length | ||
| * varchar age_groups (array "Age Groups") | * varchar age_groups (array "Age Groups") | ||
| + | * long start_time | ||
| + | |||
| + | ===== Event Cost entry ===== | ||
| + | * int id | ||
| + | * int event-id | ||
| + | * int age-group-id | ||
| + | |||
| ===== Registration entry ===== | ===== Registration entry ===== | ||
| Line 26: | Line 48: | ||
| * int id | * 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.1508853580.txt.gz · Last modified: 2017/10/24 08:59 by tschulz
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
