I am working on a project in which there will be two spaces for the customer and the shopkeeper. Multiple shopkeepers can insert data and can modify the products in their shop(they will have a unique id for their shop).The customer with their shop id-they have been assigned can see all the details about their shopkeeper and the available products in his shop.
I have made the database for the one shopkeeper's product details
CREATE TABLE IF NOT EXISTS `products` ( `id` int(11) NOT NULL auto_increment, `product_code` varchar(60) NOT NULL, `product_name` varchar(60) NOT NULL, `product_desc` tinytext NOT NULL, `product_img_name` varchar(60) NOT NULL, `qty` int(5) NOT NULL, `price` decimal(10,2) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `product_code` (`product_code`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
can somebody help me in the designing the database structure for my project any suggestions are welcomed for improving the efficiency?