help in database design

From: Date: Wed, 28 Mar 2007 10:03:12 +0000
Subject: help in database design
Groups: php.db 
Request: Send a blank email to php-db+get-43352@lists.php.net to get a copy of this message
hi all, i need help in design a database, our office is hospital equipment supplier, we had a list of items, each items had it's own configuration, and each item could consist of several item. we also had contract that have a lot of site, sometimes equipmend that have been ordered different from what the site received, in that case we made a change request... for now we have this |contract|------|has|-----|site|
                      |
                      |
                  |item|----|material|
                      |
                      |
             |configuration|
but i really confused about the Change Request thing, we have to keep both what have been ordered and what have been received... where should i put it, sorri for my bad english tq -- Jangan tanyakan apa yang Indonesia telah berikan pada mu tapi bertanyalah apa yang telah engkau berikan kepada Indonesia -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GU/IT d- s: a-- C++ UL P L++ E W++ N* o-- K- w PS Y-- PGP- t++ 5 X R++ tv b+ DI D+ G e+ h* r- z? ------END GEEK CODE BLOCK------

« previous php.db (#43352) next »