DWITE DB

From Compsci.ca Wiki

Contents 1 Data Base Layout 1.1 articles 1.2 contests 1.3 countries 1.4 links 1.5 participants 1.6 provinces 1.7 schools 1.8 teams 1.9 types 1.10 users 2 Notes

Data Base Layout

• articles
• contests
• countries
• links
• participants
• provinces
• schools
• teams
• types
• users

articles

This is where the news events on the main page go. Thess are not curently placed on the calander but we could chage that if we whont.

contests

This table holds all the info about the contest but should NOT be use for storing rank, score, teams, users, ect and should just be about the the contest. When a contest is added here it is placed on the contest caladar and on the list of past or upcoming contest depending on the date and time.

countries

This is simpley a list of contorys. I like have such data in the database so we can do more dyanick things with it like contory codes, contry names if difrent langues, ect.

links

Thess are the links on the link page.

participants

This stores the infromation about what team is doing what contest. This should probly be restrucred a bit to alow for users with out a team to particape in contest that do not have teams.

provinces

Much like countries this is just a simple list that i like to have to increas the dynaickness of the code and alow for futtuer things.

schools

Holds all the schools info much like the team table but for schools. More will have to be added to this table. One of the schools in this table should be an called "indepentdent" and have a speahal id for teams formred over the net or that has members form more then one school but still whonts to pertisapte in none school spficet matches.

teams

Holds all the teams info much like the schools table but for teams. More will have to be added to this table.

types

This table holds the types for teams and schools. A type id of -1 means all types. This table is also used by contest table to tell what types the contest is open to.

users

This holds all the users info, incuding there username, password and what team they are on if any. Alot is going to have to be added on to this table.

Notes

• Thess tables are only some starting ones and hardly make up the hole data base. We will need to add more.
• Rember that we should be using the Ruby on Rails naming convetion for the table names and col names.