Dwite schools

From Compsci.ca Wiki

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 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 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 users table.

Used By

This tables id is used by 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 ;)