+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_moneymanager_user:/tablelist/okayapi_moneymanager_user.html


-- MySQL Table okayapi_moneymanager_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_moneymanager_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `loginName` varchar(32) NULL COMMENT '登录名',
    `userName` varchar(50) NULL COMMENT '用户名',
    `okayapi_moneymanager_user_password` varchar(32) NULL COMMENT '密码',
    `sex` varchar(1) NULL COMMENT '性别(0:男  1:女)',
    `birthday` double NULL COMMENT '生日',
    `email` varchar(255) NULL COMMENT '',
    `qq` varchar(50) NULL COMMENT '',
    `roleId` int(11) NULL COMMENT '角色ID',
    `isActive` int(11) NULL COMMENT '是否激活(0:未激活  1:已激活)',
    `createDate` double NULL COMMENT '创建日期',
    KEY `loginName` (`loginName`),
    KEY `userName` (`userName`),
    KEY `okayapi_moneymanager_user_password` (`okayapi_moneymanager_user_password`),
    KEY `sex` (`sex`),
    KEY `birthday` (`birthday`),
    KEY `email` (`email`),
    KEY `qq` (`qq`),
    KEY `roleId` (`roleId`),
    KEY `isActive` (`isActive`),
    KEY `createDate` (`createDate`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'mm财务管理-用户';

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
loginNamevarchar(32)登录名
userNamevarchar(50)用户名
okayapi_moneymanager_user_passwordvarchar(32)密码
sexvarchar(1)性别(0:男 1:女)
birthdaydouble生日
emailvarchar(255)
qqvarchar(50)
roleIdint(11)角色ID
isActiveint(11)是否激活(0:未激活 1:已激活)
createDatedouble创建日期

Guess You Like

MySQL Table Design okayapi_f_base_component_resource

MySQL Table Design okayapi_f_base_data_control

MySQL Table Design okayapi_f_base_dictionary

MySQL Table Design okayapi_f_base_log_info

MySQL Table Design okayapi_f_base_module

MySQL Table Design okayapi_f_base_organization

MySQL Table Design okayapi_f_base_organization_role

MySQL Table Design okayapi_f_base_permission

MySQL Table Design okayapi_f_base_role

MySQL Table Design okayapi_f_base_role_permission

MySQL Table Design okayapi_f_base_role_permission_data_control

MySQL Table Design okayapi_f_base_user

MySQL Table Design okayapi_f_base_user_role

MySQL Table Design okayapi_f_sample_product

MySQL Table Design okayapi_f_sample_task

MySQL Table Design okayapi_moneymanager_billforin

MySQL Table Design okayapi_moneymanager_billforout

MySQL Table Design okayapi_moneymanager_menu

MySQL Table Design okayapi_moneymanager_message

MySQL Table Design okayapi_moneymanager_page

TOP ↑