Differences between revisions 3 and 4
Revision 3 as of 2006-07-17 21:43:22
Size: 1838
Comment:
Revision 4 as of 2006-07-17 22:03:38
Size: 2494
Comment: added layout of school_contact
Deletions are marked like this. Additions are marked like this.
Line 11: Line 11:
 * school  * Table: school
Line 28: Line 28:
 * contacts  * Table: school_contact
|| Field || Type || Null || Key || Default || Extra ||
||<-6> ||
|| 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) || || || || ||

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