Re: help in database design

what is site mean in here?? ----- Original Message ----- From: "Suprie" <suprie1983@gmail.com> To: <php-db@lists.php.net> Sent: Wednesday, March 28, 2007 5:03 PM Subject: [PHP-DB] help in database design > 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| i rather confused on configuration.. but plz send me a light?? > > 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 -- -- Table structure for table rsib_contract -- CREATE TABLE rsib_contract ( conId int(11) NOT NULL, conItemID int(11) NOT NULL, conSiteID int(11) NOT NULL, conDesc varchar(100) collate latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table rsib_contract -- -- -------------------------------------------------------- -- -- Table structure for table rsib_item -- CREATE TABLE rsib_item ( itemId int(11) NOT NULL, itemName varchar(45) collate latin1_general_ci NOT NULL, itemStat varchar(4) collate latin1_general_ci NOT NULL, itemDesc text collate latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table rsib_item -- -- -------------------------------------------------------- -- -- Table structure for table rsib_material -- CREATE TABLE rsib_material ( matId int(11) NOT NULL, matName varchar(34) collate latin1_general_ci NOT NULL, matDesc text collate latin1_general_ci NOT NULL, matItemId int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; -- -- Dumping data for table rsib_material -- -- -------------------------------------------------------- -- -- Table structure for table rsib_site -- CREATE TABLE rsib_site ( siteId int(11) NOT NULL, siteName varchar(60) collate latin1_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; > > -- > 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------ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >