+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_mcms_mdiy_tag:/tablelist/okayapi_mcms_mdiy_tag.html


-- MySQL Table okayapi_mcms_mdiy_tag
-- From: OkayAPI.com
CREATE TABLE `okayapi_mcms_mdiy_tag` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `tag_name` varchar(255) NULL COMMENT '标签名称',
    `tag_type` varchar(255) NULL COMMENT '标签类型',
    `tag_description` varchar(255) NULL 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 `tag_name` (`tag_name`),
    KEY `tag_type` (`tag_type`),
    KEY `tag_description` (`tag_description`),
    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-8 of 8 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
tag_namevarchar(255)标签名称
tag_typevarchar(255)标签类型
tag_descriptionvarchar(255)描述
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_dict

MySQL Table Design okayapi_mcms_mdiy_model

MySQL Table Design okayapi_mcms_mdiy_page

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 ↑