products

Description

Table Definition

CREATE TABLE `products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title_ja_jp` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `title_en_us` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `subject_ja_jp` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `subject_en_us` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `body_ja_jp` text COLLATE utf8mb4_bin NOT NULL,
  `body_en_us` text COLLATE utf8mb4_bin NOT NULL,
  `skills` text COLLATE utf8mb4_bin NOT NULL,
  `url_code` text COLLATE utf8mb4_bin NOT NULL,
  `url_home` text COLLATE utf8mb4_bin NOT NULL,
  `downloads` int DEFAULT NULL,
  `pickup` tinyint(1) NOT NULL,
  `visible` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

Columns

Name	Type	Nullable	Extra Definition	Children
id	int	false	auto_increment	product_images
title_ja_jp	varchar(255)	false
title_en_us	varchar(255)	false
subject_ja_jp	varchar(255)	false
subject_en_us	varchar(255)	false
body_ja_jp	text	false
body_en_us	text	false
skills	text	false
url_code	text	false
url_home	text	false
downloads	int	true
pickup	tinyint(1)	false
visible	tinyint(1)	false

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

Generated by tbls