+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_mcms_mdiy_dict:/tablelist/okayapi_mcms_mdiy_dict.html


-- MySQL Table okayapi_mcms_mdiy_dict
-- From: OkayAPI.com
CREATE TABLE `okayapi_mcms_mdiy_dict` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `dict_value` varchar(100) NULL COMMENT '数据值',
    `dict_label` varchar(100) NULL COMMENT '标签名',
    `dict_type` varchar(100) NULL COMMENT '类型',
    `dict_description` varchar(100) NULL COMMENT '描述',
    `is_child` varchar(255) NULL COMMENT '扩展业务标记',
    `dict_enable` varchar(11) NULL DEFAULT '1' COMMENT '启用状态',
    `dict_remarks` varchar(255) NULL COMMENT '备注信息',
    `dict_sort` int(10) NULL DEFAULT '0' COMMENT '排序(升序)',
    `UPDATE_BY` varchar(11) NULL COMMENT '更新人',
    `UPDATE_DATE` datetime NULL COMMENT '更新时间',
    `CREATE_BY` varchar(11) NULL COMMENT '创建人',
    `CREATE_DATE` datetime NULL COMMENT '创建时间',
    `DEL` int(1) NULL DEFAULT '0' COMMENT '删除标记',
    KEY `dict_value` (`dict_value`),
    KEY `dict_label` (`dict_label`),
    KEY `dict_type` (`dict_type`),
    KEY `dict_description` (`dict_description`),
    KEY `is_child` (`is_child`),
    KEY `dict_enable` (`dict_enable`),
    KEY `dict_remarks` (`dict_remarks`),
    KEY `dict_sort` (`dict_sort`),
    KEY `UPDATE_BY` (`UPDATE_BY`),
    KEY `UPDATE_DATE` (`UPDATE_DATE`),
    KEY `CREATE_BY` (`CREATE_BY`),
    KEY `CREATE_DATE` (`CREATE_DATE`),
    KEY `DEL` (`DEL`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'MCSM-字典表';

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


MySQL database table structure design

Displaying 1-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
dict_valuevarchar(100)数据值Normal Index
dict_labelvarchar(100)标签名Normal Index
dict_typevarchar(100)类型
dict_descriptionvarchar(100)描述
is_childvarchar(255)扩展业务标记
dict_enablevarchar(11)1启用状态1
dict_remarksvarchar(255)备注信息
dict_sortint(10)0排序(升序)0
UPDATE_BYvarchar(11)更新人
UPDATE_DATEdatetime更新时间
CREATE_BYvarchar(11)创建人
CREATE_DATEdatetime创建时间
DELint(1)0删除标记0

Guess You Like

MySQL Table Design okayapi_mcms_app

MySQL Table Design okayapi_mcms_cms_category

MySQL Table Design okayapi_mcms_cms_content

MySQL Table Design okayapi_mcms_cms_history_log

MySQL Table Design okayapi_mcms_logger

MySQL Table Design okayapi_mcms_manager

MySQL Table Design okayapi_mcms_mdiy_model

MySQL Table Design okayapi_mcms_mdiy_page

MySQL Table Design okayapi_mcms_mdiy_tag

MySQL Table Design okayapi_mcms_mdiy_tag_sql

MySQL Table Design okayapi_mcms_model

MySQL Table Design okayapi_mcms_role

MySQL Table Design okayapi_mcms_role_model

TOP ↑