MySQL Create Table SQL
Table Structure: okayapi_appver_chat_bot：/tablelist/okayapi_appver_chat_bot.html
-- MySQL Table okayapi_appver_chat_bot
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_chat_bot` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT '机器人名称',
`webhook` varchar(256) NOT NULL COMMENT '钉钉群机器人Webhook地址',
`app_id` int(10) NOT NULL DEFAULT '0' COMMENT '关联的APP',
`active_event` varchar(2000) NOT NULL COMMENT '绑定的事件',
`created_by` varchar(32) NOT NULL COMMENT '创建人',
`updated_by` varchar(32) NOT NULL COMMENT '更新人',
`del_flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
KEY `name` (`name`),
KEY `webhook` (`webhook`),
KEY `app_id` (`app_id`),
KEY `active_event` (`active_event`),
KEY `created_by` (`created_by`),
KEY `updated_by` (`updated_by`),
KEY `del_flag` (`del_flag`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-聊天机器人';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| name | varchar(255) | 否 | 机器人名称 | |||
| webhook | varchar(256) | 否 | 钉钉群机器人Webhook地址 | |||
| app_id | int(10) | 0 | 否 | 关联的APP | 0 | |
| active_event | varchar(2000) | 否 | 绑定的事件 | |||
| created_by | varchar(32) | 否 | 创建人 | |||
| updated_by | varchar(32) | 否 | 更新人 | |||
| del_flag | tinyint(1) | 0 | 否 | 是否删除 | 0 |
