Dwite contests
From Compsci.ca Wiki
Contents |
Structure
- id - int(11), key, auto_increment
- name - varchar(255)
- desc - text
- start_date - int(255)
- type_id - int(11)
- long_desc - text
id
The key id.
name
The name of the contest.
desc
A short description of the contest that is displayed on the main page. HTML is curently striped out in the view for staftey reasons.
start_date
A time stamp of when the contest will start. Is there a better way of combding a date and time then a unix time stamp? If so we should probly chage this. Also we may whont to add an end_date col if the contest are going to be of difrent lengths. Tho the end_date could be dealt with by the back end.
type_id
This respesents the type of contest, as in what type of teams the contest is open to. See the type table and main data base for more information. -1 is for all types.
long_desc
A long description of the contest for the contests about page. HTML is curently striped out in the view for saftey reasons.
Notes
- More columes will most like have to be added to this table.
- start_date could be updated with somthing better then a unix time stamp if posiable.
- end_date could be added for more dyanickness and control of the back end.
