The easiest way to deal with this is to add a TEXT field to the end of the
Booking table and
have the user put in there all the extra data they need.
If this doesnt resolve your problem you could add an etra table called
extraData or something like that it may look like this:
extraData:
PK extraData_ID
FK Booking_ID
Description <---- Here you describe the data to be captured Ej.
"Location"
Data <-----And here the actual data Ej. "Quebec"
This way you can capture "N" records of extra data for the booking
"Shaun" <shaun@mania.plus.com> escribió en el mensaje
20030401120759.88268.qmail@pb1.pair.com">news:20030401120759.88268.qmail@pb1.pair.com...
> the data colleccted at each booking will be the fields set by an
> administrator that he/she feels are appropriate to collect for that
project.
>
>
> "Gustavo Del Castillo Meza" <gdelcastillo@littledev.com> wrote in message
> 20030331220048.90651.qmail@pb1.pair.com">news:20030331220048.90651.qmail@pb1.pair.com...
> > What kind of data do you need to collect at each booking?
> >
> > "Shaun" <shaun@mania.plus.com> escribió en el mensaje
> > 20030331203035.5070.qmail@pb1.pair.com">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!
> > >
> > >
> >
> >
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
