product_images

Description

Table Definition 
CREATE TABLE `product_images` (
  `product_id` int NOT NULL,
  `row_no` int NOT NULL,
  `data` text COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`product_id`,`row_no`),
  CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

Columns

Name Type Default Nullable Children Parents Comment
product_id int false products
row_no int false
data text false

Constraints

Name Type Definition
PRIMARY PRIMARY KEY PRIMARY KEY (product_id, row_no)
product_images_ibfk_1 FOREIGN KEY FOREIGN KEY (product_id) REFERENCES products (id)

Indexes

Name Definition
PRIMARY PRIMARY KEY (product_id, row_no) USING BTREE

Relations

er

Generated by tbls