RE: [PHP-DB] PC Inventory System

2007-03-25 Thread christine
, 2007 23:07 To: OKi98 Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PC Inventory System 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

Re: [PHP-DB] PC Inventory System

2007-03-23 Thread Renzo Clavijo
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 <[EMAIL PROTECTED]> wrote: christine wrote: > Hi all,

Re: [PHP-DB] PC Inventory System

2007-03-23 Thread OKi98
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 co

[PHP-DB] PC Inventory System

2007-03-23 Thread christine
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 db_solution.xls Description: MS-Excel spreadsheet -