[PHP-DB] Re: Database Design Help
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 PROTECTED] 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 [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] 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 [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 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
[PHP-DB] Re: Database Design Help
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 [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 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
[PHP-DB] Re: Database Design Help
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 [EMAIL PROTECTED] escribió en el mensaje news:[EMAIL PROTECTED] 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 [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 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
[PHP-DB] Re: Database Design Help
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 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