Re: [geo] Database Schema

[Michael Viron <mviron@findaschool.org>]

At 06:46 AM 01/07/2002 -0600, you wrote:
>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.
this should be 'facility' not '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
>
>
>