i need help in design a database, our office is hospital equipment
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
for now we have this
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
Why does that have to fit into this scheme?
Why can't it be separate?
create table change_requests (
request_id primary key .. blah blah,
item_order_date timestamp, // so you know when you ordered it
item_receive_date timestamp // so you know when you received it.
problem solved ?
Postgresql & php tutorials
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php