User:Trapa/Registration System/db/events table
From WikiFur, the furry encyclopedia.
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.
|