[geo] Database Schema

[Les Richardson <richl@mail.tfsd.sk.ca>]

Hi,

Here's a rough outline of the Dbase, as I see it: <grin>

basic table (could we change this to "base"?)

id int(11) auto_increment, not null
faculty char(255),	- name of faculty.
link char(255),	- URL 
country char(6),	- iso character code for country.
state	char(255),	- don't really need it this big, but what the heck.
category int,		- category number matching category table
language char(6)	- iso language code for faculty.


country table  - list of iso country codes.
code char(6),
name char(60)


language table - list of iso language codes.
code char(6),
name char(60)


user  - list of admins
id int(11) auto_increment, not null
username - char(20),
fname - char(60),
lname - char(60),
passwd - char(30)


group - listing of country codes which give access to particular admins
id int(11) auto_increment, not null
gname - char(20) - mnemonic name for group
glist - text - listing of country codes


link table - listing of external links.
id int(11) auto_increment, not null
name char(60),
url char(255),
category char(60),


Comments please,

Les