+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_mcms_manager:/tablelist/okayapi_mcms_manager.html


-- MySQL Table okayapi_mcms_manager
-- From: OkayAPI.com
CREATE TABLE `okayapi_mcms_manager` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NULL COMMENT '角色编号',
    `people_id` int(11) NULL DEFAULT '0' COMMENT '用户编号即商家编号',
    `manager_admin` varchar(255) NULL COMMENT '管理员标识,超级管理员:super,子管理员:open',
    `manager_name` varchar(15) NULL COMMENT '管理员用户名',
    `manager_nickname` varchar(15) NULL COMMENT '管理员昵称',
    `manager_password` varchar(45) 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 `role_id` (`role_id`),
    KEY `people_id` (`people_id`),
    KEY `manager_admin` (`manager_admin`),
    KEY `manager_name` (`manager_name`),
    KEY `manager_nickname` (`manager_nickname`),
    KEY `manager_password` (`manager_password`),
    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-11 of 11 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
role_idint(11)角色编号Normal Index
people_idint(11)0用户编号即商家编号0
manager_adminvarchar(255)管理员标识,超级管理员:super,子管理员:open
manager_namevarchar(15)管理员用户名
manager_nicknamevarchar(15)管理员昵称
manager_passwordvarchar(45)管理员密码
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_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_model

MySQL Table Design okayapi_mcms_role

MySQL Table Design okayapi_mcms_role_model

TOP ↑