Design Product Table in SQL when you don't know how is foreign keys works in SQL

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

--
-- Table structure for table `products`
--


CREATE TABLE `products` (
  `product_id` int(100) NOT NULL,
  `product_cat` int(100) NOT NULL,
  `product_brand` int(100) NOT NULL,
  `product_title` varchar(255) NOT NULL,
  `product_price` int(100) NOT NULL,
  `product_desc` text NOT NULL,
  `product_image` text NOT NULL,
  `product_keywords` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;