[PHP-DB] Re: Database Design Help

2003-04-02 Thread shaun
Thanks for your reply but the data fields to be captured have to be the same for each project, ie when an administrator sets up project A, he might want to capture fields X, Y, Z for each booking taken for that project... Gustavo Del Castillo Meza [EMAIL PROTECTED] wrote in message news:[EMAIL

[PHP-DB] Re: Database Design Help

2003-04-01 Thread shaun
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 [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What kind of data do you need to collect at each booking? Shaun

[PHP-DB] Re: Database Design Help

2003-04-01 Thread Gustavo Del Castillo Meza
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

[PHP-DB] Re: Database Design Help

2003-03-31 Thread Gustavo Del Castillo Meza
What kind of data do you need to collect at each booking? Shaun [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] 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