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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
loginName | varchar(32) | 是 | 登录名 | |||
userName | varchar(50) | 是 | 用户名 | |||
okayapi_moneymanager_user_password | varchar(32) | 是 | 密码 | |||
sex | varchar(1) | 是 | 性别(0:男 1:女) | |||
birthday | double | 是 | 生日 | |||
varchar(255) | 是 | |||||
varchar(50) | 是 | |||||
roleId | int(11) | 是 | 角色ID | |||
isActive | int(11) | 是 | 是否激活(0:未激活 1:已激活) | |||
createDate | double | 是 | 创建日期 |