okayapi_f_base_user - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_f_base_user：/tablelist/okayapi_f_base_user.html


-- MySQL Table okayapi_f_base_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_f_base_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `create_time` datetime NULL COMMENT '',
    `email` varchar(128) NULL COMMENT '',
    `okayapi_f_base_user_password` varchar(64) NULL COMMENT '',
    `phone` varchar(32) NULL COMMENT '',
    `realname` varchar(32) NULL COMMENT '',
    `salt` varchar(32) NULL COMMENT '',
    `okayapi_f_base_user_status` varchar(16) NULL COMMENT '',
    `username` varchar(32) NULL COMMENT '',
    `organization_id` bigint(20) NULL COMMENT '',
    KEY `create_time` (`create_time`),
    KEY `email` (`email`),
    KEY `okayapi_f_base_user_password` (`okayapi_f_base_user_password`),
    KEY `phone` (`phone`),
    KEY `realname` (`realname`),
    KEY `salt` (`salt`),
    KEY `okayapi_f_base_user_status` (`okayapi_f_base_user_status`),
    KEY `username` (`username`),
    KEY `organization_id` (`organization_id`),
    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-9 of 9 results.

Field Name	Field Type	IS NULL	Index
create_time	datetime	是
email	varchar(128)	是
okayapi_f_base_user_password	varchar(64)	否
phone	varchar(32)	是
realname	varchar(32)	否
salt	varchar(32)	否
okayapi_f_base_user_status	varchar(16)	否
username	varchar(32)	否	Unique Index
organization_id	bigint(20)	是	Normal Index