okayapi_guanggaobao_manager - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_guanggaobao_manager：/tablelist/okayapi_guanggaobao_manager.html


-- MySQL Table okayapi_guanggaobao_manager
-- From: OkayAPI.com
CREATE TABLE `okayapi_guanggaobao_manager` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `okayapi_guanggaobao_manager_name` varchar(50) NULL COMMENT '名称',
    `avatar` varchar(255) NULL COMMENT '头像',
    `mobile` int(11) NULL COMMENT '手机号',
    `email` varchar(255) NULL COMMENT '电子邮箱',
    `okayapi_guanggaobao_manager_password` varchar(255) NULL COMMENT '',
    `okayapi_guanggaobao_manager_level` int(5) NULL COMMENT '账号等级',
    `role` varchar(50) NULL COMMENT '权限',
    `department` int(5) NULL COMMENT '所属部门',
    `create_time` int(11) NULL COMMENT '创建时间',
    `delete_time` int(11) NULL COMMENT '删除时间',
    KEY `okayapi_guanggaobao_manager_name` (`okayapi_guanggaobao_manager_name`),
    KEY `avatar` (`avatar`),
    KEY `mobile` (`mobile`),
    KEY `email` (`email`),
    KEY `okayapi_guanggaobao_manager_password` (`okayapi_guanggaobao_manager_password`),
    KEY `okayapi_guanggaobao_manager_level` (`okayapi_guanggaobao_manager_level`),
    KEY `role` (`role`),
    KEY `department` (`department`),
    KEY `create_time` (`create_time`),
    KEY `delete_time` (`delete_time`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '广告宝-管理员表';

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 Name	Field Type	IS NULL	Field Comment
okayapi_guanggaobao_manager_name	varchar(50)	否	名称
avatar	varchar(255)	否	头像
mobile	int(11)	是	手机号
email	varchar(255)	是	电子邮箱
okayapi_guanggaobao_manager_password	varchar(255)	是
okayapi_guanggaobao_manager_level	int(5)	是	账号等级
role	varchar(50)	是	权限
department	int(5)	是	所属部门
create_time	int(11)	是	创建时间
delete_time	int(11)	是	删除时间