Re: PC Inventory System
| From: | Renzo Clavijo | Date: | Fri, 23 Mar 2007 16:07:00 +0000 |
| Subject: | Re: PC Inventory System | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43328@lists.php.net to get a copy of this message | ||
Hi ...
I would modify solution 3:
Table user
user_id
First_name
last_name
Table pc
pc_id
user_id (FK)
Table component
component_id
component_type (enum)
stuff_code
desc
Table pc_component
pc_id (fk)
component_id (fk)
On 3/23/07, OKi98 <oki98@centrum.cz> wrote:
christine wrote: Hi all, I need some help to decide the best db design for PC Inventory System. There are 2 solution that I thought, you can see it at the attachment. Which is the best solution ? Is there another solution ? Regards & Thanks, Christine Solution 3: Table pc pc_id Table component component_id component_type (enum) stuff_code desc Table pc_component pc_id (fk) component_id (fk) OKi98 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php