Re: Database Design Help
| From: | Gustavo Del Castillo Meza | Date: | Mon, 31 Mar 2003 22:00:51 +0000 |
| Subject: | Re: Database Design Help | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26776@lists.php.net to get a copy of this message | ||
What kind of data do you need to collect at each booking?
"Shaun" <shaun@mania.plus.com> escribió en el mensaje
news:20030331203035.5070.qmail@pb1.pair.com...
> Hi,
>
> I am creating a database for a web application. The idea for the
application
> is for a company administrator to be able to log into the site and
allocate
> staff to a project.
>
> Staff will be able to log in and update the status of the project they are
> working on and clients will be able to log in and book a member of staff
> to their own projects.
>
> Administrators will be able to add / edit / delete - staff / clients /
> projects.
>
> Here is my database diagram:
>
> http://www.mania.plus.com
>
> My problem is each different project will need to have different data
> collected for it at each booking. How could I handle this in the database
> model? The administrator would like to be able to edit the data collected
> for each project via the site...
>
> Any other comments on my database model would be appreciated as this is my
> weakest area of web development by far!
>
>