Differences between revisions 2 and 4 (spanning 2 versions)
Revision 2 as of 2006-07-17 21:40:00
Size: 1909
Comment: dns names (URL)
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
 {{{
| 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 | |
+---------------------+----------------------+------+-----+---------+----------------+
}}}
 * contacts
 * Table: school
|| Field || Type || Null || Key || Default || Extra ||
||<-6> ||
|| 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 ||
||<-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