Re: [geo] Database Schema

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

Hi,

> >i have to agree with mike about the facility thing :) -- i see mention
> >of a category table ... but dont actually see one

Not created yet. Just current 3 entries.

 -- one thing about the
> >user table ... how will you know which "group" they belong to? -- either
> >a column in the user table with an int or a separate table if there is
> >the possibility of a user being allowed to admin more than one group 

I don't really see an advantage for a separate table. I would just put
user_perms and groupid in the usertable.

> >
> >user_perms -- table of administrative permissions
> >userid - int(11) 
> >groupid - int(11)
> >
> >so that you could have multiple occurances ... but you owuld end up with
> >ugly SQL :) -- but it would work fairly well i think
> >
> >Please correct me if im wrong ... Thanks ...


Les R.




> >
> >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

Errr....yes....right...I can spell it....


   facility char(255)- name of facility.

> >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  - listof 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