+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_mcms_model:/tablelist/okayapi_mcms_model.html


-- MySQL Table okayapi_mcms_model
-- From: OkayAPI.com
CREATE TABLE `okayapi_mcms_model` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `model_id` int(22) NULL COMMENT '模块的父模块id',
    `manager_id` int(11) NULL COMMENT '模块关联的关联员id',
    `model_parent_ids` varchar(300) NULL COMMENT '父级编号集合,从小到大排序',
    `model_code` varchar(255) NULL COMMENT '模块编码',
    `model_title` varchar(150) NULL COMMENT '模块标题',
    `model_url` varchar(255) NULL COMMENT '模块连接地址',
    `model_icon` varchar(120) NULL COMMENT '模块图标',
    `model_sort` int(11) NULL COMMENT '模块的排序',
    `model_ismenu` int(1) NULL DEFAULT '0' COMMENT '模块是否是菜单',
    `IS_CHILD` varchar(300) NULL COMMENT '扩展字段',
    `model_datetime` datetime 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 `model_id` (`model_id`),
    KEY `manager_id` (`manager_id`),
    KEY `model_parent_ids` (`model_parent_ids`),
    KEY `model_code` (`model_code`),
    KEY `model_title` (`model_title`),
    KEY `model_url` (`model_url`),
    KEY `model_icon` (`model_icon`),
    KEY `model_sort` (`model_sort`),
    KEY `model_ismenu` (`model_ismenu`),
    KEY `IS_CHILD` (`IS_CHILD`),
    KEY `model_datetime` (`model_datetime`),
    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-16 of 16 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
model_idint(22)模块的父模块idNormal Index
manager_idint(11)模块关联的关联员id
model_parent_idsvarchar(300)父级编号集合,从小到大排序
model_codevarchar(255)模块编码
model_titlevarchar(150)模块标题
model_urlvarchar(255)模块连接地址
model_iconvarchar(120)模块图标
model_sortint(11)模块的排序
model_ismenuint(1)0模块是否是菜单0
IS_CHILDvarchar(300)扩展字段
model_datetimedatetime
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

MySQL Table Design okayapi_mcms_mdiy_tag_sql

MySQL Table Design okayapi_mcms_role

MySQL Table Design okayapi_mcms_role_model

TOP ↑