Re: [Agendaware-dev-db] DB Table Definitions

[Shane T. <tur...@ya...>]

I was looking at the doc and just wanted to get a few
suggestions in before I fogot them.  The initial draft
looks good, however the one thing I don't think we
need to do is have an individual table per user.  I
think adding and dropping tables should be left to the
DBA and the application should simply update them. Not
to mention that with a lot of users, the DB
administration could get ugly with so many tables to
manage. I think in the messages and calendar tables,
we need to have a msg_id (as you've already noted) and
also have a field indicating the user id to which the
mesg belongs.  We would then keep indexes on mesg_id
and owner for access purposes.  I also think at this
moment, we shouldn't worry about the calendaring stuff
too much.  First goal should be to get email working
properly. The key is going to be getting each
component working well (extremely), and then slowly
adding the others.  I may try to add to your db design
a little later if I find the time, I'm still working
on some server code design at the moment.  

--- zack <za...@th...> wrote:
> OK everyone.  I put together an initial draft of
> what I think is needed 
> in the database.  I organized it by table and field.
> 
> Keep in mind, I do not do much (any) database work,
> so there might be 
> some flaws in my thinking, this is just a starting
> point.  I have also 
> left some ??? in there as well.  Not complete, but I
> ran out of brain.
> 
> Also, it is checked in cvs under db/docs.
> 
> Have a look.  Send me any changes/addition/deletions
> you can think of.
> 
> Also, does anyone want to write some sql scripts for
> generating the 
> tables?  There could also be a "test data" script
> for populating some 
> fluff data, just to make testing easier (a couple of
> users at least, and 
> maybe a mail message or 2).
> 
> Zack
> 
> 
> _______________________________________________
> Agendaware-dev-db mailing list
> Age...@li...
>
https://lists.sourceforge.net/lists/listinfo/agendaware-dev-db


__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com