Differences between revisions 4 and 5
Revision 4 as of 2006-07-17 22:03:38
Size: 2494
Comment: added layout of school_contact
Revision 5 as of 2006-07-19 15:03:35
Size: 2584
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
''This page is part of the webmaster team. Its aim is to keep track of our projects.''

This page is part of the webmaster team. Its aim is to keep track of our projects.

Survey of Web Presences

International

...

Dynamic Pages

Reference Schools (slschools)

  • Schools can register using an html form that is created by some php scripts. All data is stored in a central mysql database. It embraces two tables:
  • Table: school

Field

Type

Null

Key

Default

Extra

school_id

smallint(5) unsigned

PRI

auto_increment

update_of

smallint(5) unsigned

YES

school_name

varchar(255)

school_postcode

varchar(16)

YES

school_postlocation

varchar(255)

YES

school_streetaddr

varchar(255)

YES

school_comments

text

YES

school_url

varchar(255)

YES

school_joined

datetime

YES

school_updated

datetime

YES

deleted

char(1)

YES

0

longitude

decimal(20,17)

YES

latitude

decimal(20,17)

YES

country

varchar(255)

no

  • Table: school_contact

Field

Type

Null

Key

Default

Extra

contact_id

smallint(5) unsigned

PRI

auto_increment

school_id

smallint(5) unsigned

YES

main_contact

char(1)

YES

contact_name

varchar(255)

YES

contact_email

varchar(255)

YES

password

varchar(32)

Further Information