User:Trapa/Registration System/db/events table
This table is used to store key data about each event performed on the system. Each year a new convention each convention is a new event. This table stores the data about the event, such as the rules, and the start and end date and things like that.
|event_id||varchar 10||NOT NULL& UNIQUE||This contains the unique id to identify this event.|
|event_name||VarChar 60||NOT NULL||This is the english displayname for the event. (Califur.1, or Califur 2006, or the like) used at the top of printouts and such|
|event_desc||Int 4||NOT NULL||A long display name. (Califur.1, 2005)|
|start_date||date||NOT NULL||The day the event starts|
|end_date||date||NOT NULL||The day the event ends|
|age_of_maturity||int 2||NULL||This is the age that is used to determing whether the badges are printed as under age or of age.|
|num_delaers_tables||int 3||NULL||This is currently NOT USED, but would in future be for putting dealers table info up on the website.|
|num_artshow_panels||int 3||NULL||This is currently NOT USED, but would in future be used or putting art show panel info on the website.|
|prereg_end_date||date||NULL||This is the date that online registration shuts down.|
|AUP||text||NULL||This field is used to store the AUP for the aup forms to be printed.