Thank you for the offer of the PDFs, they would be VERY welcome. email address is 'edcasati at yahoo dot com'
Made some more progress today, to the point where I need to start thinking about another necessary feature: security. How to require login, and then allow different people to have different rights (edit / create / view only). For example, allowing an employee to login and view only records that pertain to him/her. BTW - I am using the temp agency employee / client / task design only as an example, since it is one that we can all comprehend. The actual database is going to be used for organizing a multi-photographer business, with the goal of eventualy being able to include thumbnails of photographs, which have been tagged according to client, location, person in photo, etc. Looked far and wide, and found nothing that matched the specific need, so decided to 'roll-my-own'. Giving myself a year to get it to V1.0, considering that it is already starting to be useful and it is at version 0.0001 (smile) Thanks again everyone! --- In [email protected], Anggie Bratadinata <[EMAIL PROTECTED]> wrote: > edcasati wrote: > > Thanks to everyone for the answers. It's reassuring to know that I'm > > on the right track. Concerning tracking multiple events, I really > > don't like 'freeform' text, so I will probably add an additional table > > for 'type of work' and make it a lookup table for the tracking table. > > If I allow freeform text, it's actually more work in the long run, > > since I can't just pick an option, I have to type. And it makes > > searching less reliable to allow freeform text. So now I have 5 > > columns: client, employee, type of work, date start, date end. Things > > get complicated quick. And this is just the beginning. Whew! > > I have some pdfs about designing a database. I'll send it to you if you > want. > > In addition, google for "database design tutorial". > > > -- > Anggie Bratadinata > |Web|Flash|Graphic| > Jl. Raya Langsep no.21 > Malang - East Java > I N D O N E S I A > www.nextrand.co.id ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
