what is site mean in here?? ----- Original Message ----- From: "Suprie" <suprie1983@xxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Wednesday, March 28, 2007 5:03 PM Subject: 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
