+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_mcms_mdiy_page:/tablelist/okayapi_mcms_mdiy_page.html


-- MySQL Table okayapi_mcms_mdiy_page
-- From: OkayAPI.com
CREATE TABLE `okayapi_mcms_mdiy_page` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `page_model_id` int(11) NULL COMMENT '模块id',
    `page_path` varchar(255) NULL COMMENT '自定义页面绑定模板的路径',
    `page_title` varchar(255) NULL COMMENT '自定义页面标题',
    `page_type` varchar(255) NULL COMMENT '字典分类字段',
    `page_key` 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 `page_model_id` (`page_model_id`),
    KEY `page_path` (`page_path`),
    KEY `page_title` (`page_title`),
    KEY `page_type` (`page_type`),
    KEY `page_key` (`page_key`),
    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-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
page_model_idint(11)模块idNormal Index
page_pathvarchar(255)自定义页面绑定模板的路径
page_titlevarchar(255)自定义页面标题
page_typevarchar(255)字典分类字段
page_keyvarchar(255)自定义页面访问路径Normal Index
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_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 ↑