Hacker Dan at 11:24, 14 May 2006

2006-05-14T11:24:13Z

New page

==Structure==
* '''id''' - int(11), key, auto_increment
* '''name''' - varchar(255)
* '''address''' - varchar(255)
* '''province_id''' - int(11)
* '''city''' - varchar(255)
* '''postal_code''' - varchar(10)
* '''country_id''' - int(11)
* '''about''' - text
* '''user_id''' - int(11)

===id===
The key id.

===name===
The name of the school.

===address===
The address of the school.

===provicne_id===
The id coseponding to the provicne the school is in. See the [[dwite_provinces|provinces]] table.

===city===
The city the school is in.

===postal_code===
The postal code of the school. Code should be added during registation to check if the postal code is vaild, it is curently not checked.

===country_id===
The country id corsponding to the country the school is in. See the [[dwite_countries|countries]] table.

===about===
Some info for the about page for the school. HTML is striped out of this text threw the view.

===user_id===
This is the id of the user who registered the school. In theroy this should also be the user who is supervsing the teams registered under this school. See the [[dwite_users|users]] table.

==Used By==
This tables id is used by [[dwite_teams|teams]].

==Notes==
* We code do some cool stuff with the postal codes of all the schools like plot them on a map and other fun stuff. So postal code valdiation could be a good idea.
* Most likey we will be adding a few coloumns to this table.
* I guse the user_id coloumn is kind of oddly named as it is not very descriptive, tho it saved a few secods of coding ;)

Dwite schools - Revision history

Hacker Dan at 11:24, 14 May 2006