User:Trapa/Registration System/db/events table

From WikiFur, the furry encyclopedia.
Jump to: navigation, search

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.

Field Type Other Purpose
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.