+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_opms_pms_users_profile:/tablelist/okayapi_opms_pms_users_profile.html


-- MySQL Table okayapi_opms_pms_users_profile
-- From: OkayAPI.com
CREATE TABLE `okayapi_opms_pms_users_profile` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `userid` bigint(20) NULL COMMENT '',
    `realname` varchar(15) NULL COMMENT '姓名',
    `sex` tinyint(1) NULL DEFAULT '1' COMMENT '1男2女',
    `birth` varchar(15) NULL COMMENT '',
    `email` varchar(30) NULL COMMENT '邮箱',
    `webchat` varchar(15) NULL COMMENT '微信号',
    `qq` varchar(15) NULL COMMENT 'qq号',
    `phone` varchar(15) NULL COMMENT '手机',
    `tel` varchar(20) NULL COMMENT '电话',
    `address` varchar(100) NULL COMMENT '地址',
    `emercontact` varchar(15) NULL COMMENT '紧急联系人',
    `emerphone` varchar(15) NULL COMMENT '紧急电话',
    `departid` bigint(20) NULL COMMENT '部门ID',
    `positionid` bigint(20) NULL COMMENT '职位id',
    `lognum` int(10) NULL DEFAULT '0' COMMENT '登录次数',
    `ip` varchar(15) NULL COMMENT '最近登录IP',
    `lasted` int(10) NULL COMMENT '最近登录时间',
    KEY `userid` (`userid`),
    KEY `realname` (`realname`),
    KEY `sex` (`sex`),
    KEY `birth` (`birth`),
    KEY `email` (`email`),
    KEY `webchat` (`webchat`),
    KEY `qq` (`qq`),
    KEY `phone` (`phone`),
    KEY `tel` (`tel`),
    KEY `address` (`address`),
    KEY `emercontact` (`emercontact`),
    KEY `emerphone` (`emerphone`),
    KEY `departid` (`departid`),
    KEY `positionid` (`positionid`),
    KEY `lognum` (`lognum`),
    KEY `ip` (`ip`),
    KEY `lasted` (`lasted`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'OPMS和OA管理-用户详情表';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-17 of 17 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
useridbigint(20)
realnamevarchar(15)姓名
sextinyint(1)11男2女1
birthvarchar(15)
emailvarchar(30)邮箱
webchatvarchar(15)微信号
qqvarchar(15)qq号
phonevarchar(15)手机
telvarchar(20)电话
addressvarchar(100)地址
emercontactvarchar(15)紧急联系人
emerphonevarchar(15)紧急电话
departidbigint(20)部门ID
positionidbigint(20)职位id
lognumint(10)0登录次数0
ipvarchar(15)最近登录IP
lastedint(10)最近登录时间

Guess You Like

MySQL Table Design okayapi_opms_pms_albums

MySQL Table Design okayapi_opms_pms_albums_comment

MySQL Table Design okayapi_opms_pms_albums_laud

MySQL Table Design okayapi_opms_pms_businesstrips

MySQL Table Design okayapi_opms_pms_businesstrips_approver

MySQL Table Design okayapi_opms_pms_checkworks

MySQL Table Design okayapi_opms_pms_departs

MySQL Table Design okayapi_opms_pms_expenses

MySQL Table Design okayapi_opms_pms_expenses_approver

MySQL Table Design okayapi_opms_pms_goouts

MySQL Table Design okayapi_opms_pms_goouts_approver

MySQL Table Design okayapi_opms_pms_groups

MySQL Table Design okayapi_opms_pms_groups_permission

MySQL Table Design okayapi_opms_pms_groups_user

MySQL Table Design okayapi_opms_pms_knowledges

MySQL Table Design okayapi_opms_pms_knowledges_comment

MySQL Table Design okayapi_opms_pms_knowledges_laud

MySQL Table Design okayapi_opms_pms_knowledges_sort

MySQL Table Design okayapi_opms_pms_leaves

MySQL Table Design okayapi_opms_pms_leaves_approver

TOP ↑