+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_mcms_mdiy_model:/tablelist/okayapi_mcms_mdiy_model.html


-- MySQL Table okayapi_mcms_mdiy_model
-- From: OkayAPI.com
CREATE TABLE `okayapi_mcms_mdiy_model` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `model_json` text NULL COMMENT 'json',
    `model_table_name` varchar(255) NULL COMMENT '模型表名',
    `model_name` varchar(30) NULL COMMENT '模型名称',
    `model_type` varchar(255) NULL COMMENT '自定义模型类型,自定义表单不用该字段',
    `model_field` text NULL COMMENT '模型字段',
    `model_custom_type` varchar(255) NULL COMMENT '类型,自定义表单:post,自定义模型:model',
    `update_date` datetime NULL COMMENT '修改时间',
    `update_by` varchar(11) NULL COMMENT '修改人',
    `create_date` datetime NULL COMMENT '创建时间',
    `create_by` varchar(11) NULL COMMENT '创建人',
    `del` int(1) NULL DEFAULT '0' COMMENT '删除标记',
    KEY `model_json` (`model_json`),
    KEY `model_table_name` (`model_table_name`),
    KEY `model_name` (`model_name`),
    KEY `model_type` (`model_type`),
    KEY `model_field` (`model_field`),
    KEY `model_custom_type` (`model_custom_type`),
    KEY `update_date` (`update_date`),
    KEY `update_by` (`update_by`),
    KEY `create_date` (`create_date`),
    KEY `create_by` (`create_by`),
    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-11 of 11 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
model_jsontextjson
model_table_namevarchar(255)模型表名
model_namevarchar(30)模型名称
model_typevarchar(255)自定义模型类型,自定义表单不用该字段
model_fieldtext模型字段
model_custom_typevarchar(255)类型,自定义表单:post,自定义模型:model
update_datedatetime修改时间
update_byvarchar(11)修改人
create_datedatetime创建时间
create_byvarchar(11)创建人
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_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 ↑