okayapi_72crm_admin_config - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_72crm_admin_config：/tablelist/okayapi_72crm_admin_config.html


-- MySQL Table okayapi_72crm_admin_config
-- From: OkayAPI.com
CREATE TABLE `okayapi_72crm_admin_config` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `setting_id` int(9) NULL COMMENT '',
    `okayapi_72crm_admin_config_status` int(1) NULL DEFAULT '0' COMMENT '状态，0:不启用 1 ： 启用',
    `okayapi_72crm_admin_config_name` varchar(255) NULL COMMENT '设置名称',
    `okayapi_72crm_admin_config_value` varchar(255) NULL COMMENT '值',
    `description` varchar(255) NULL COMMENT '描述',
    KEY `setting_id` (`setting_id`),
    KEY `okayapi_72crm_admin_config_status` (`okayapi_72crm_admin_config_status`),
    KEY `okayapi_72crm_admin_config_name` (`okayapi_72crm_admin_config_name`),
    KEY `okayapi_72crm_admin_config_value` (`okayapi_72crm_admin_config_value`),
    KEY `description` (`description`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CRM-客户规则';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-5 of 5 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
setting_id	int(9)		否
okayapi_72crm_admin_config_status	int(1)	0	否	状态，0:不启用 1 ：启用	0
okayapi_72crm_admin_config_name	varchar(255)		否	设置名称
okayapi_72crm_admin_config_value	varchar(255)		是	值
description	varchar(255)		是	描述