articles_metadata

Description

Table Definition

CREATE TABLE `articles_metadata` (
  `id` char(20) COLLATE utf8mb4_bin NOT NULL,
  `title_ja_jp` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `title_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,
  `tags` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `url` text COLLATE utf8mb4_bin NOT NULL,
  `likes_count` int NOT NULL,
  `stocks_count` int NOT NULL,
  `comments_count` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

Columns

Name	Type	Default	Nullable	Extra Definition
id	char(20)		false
title_ja_jp	varchar(255)		false
title_en_us	varchar(255)		false
body_ja_jp	text		false
body_en_us	text		false
tags	varchar(255)		false
url	text		false
likes_count	int		false
stocks_count	int		false
comments_count	int		false
created_at	timestamp	CURRENT_TIMESTAMP	false	DEFAULT_GENERATED
updated_at	timestamp	CURRENT_TIMESTAMP	false	DEFAULT_GENERATED on update CURRENT_TIMESTAMP

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

Generated by tbls