messaging-gateway

line_channels

Description

LINEチャンネル

Table Definition

```sql CREATE TABLE `line_channels` ( `id` varchar(256) NOT NULL COMMENT 'LINEチャンネルID', `encrypted_secret_key` text NOT NULL COMMENT '暗号化済み秘密鍵', `kid` text NOT NULL COMMENT 'LINEから発行されたKID', `memo` text DEFAULT NULL COMMENT 'メモ', `created_at` datetime NOT NULL DEFAULT current_timestamp() COMMENT '作成日時', `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT '更新日時', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='LINEチャンネル' ```

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	varchar(256)		false				LINEチャンネルID
encrypted_secret_key	text		false				暗号化済み秘密鍵
kid	text		false				LINEから発行されたKID
memo	text	NULL	true				メモ
created_at	datetime	current_timestamp()	false				作成日時
updated_at	datetime	current_timestamp()	false	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

This site is open source. Improve this page.