MySQL Create Table SQL
Table Structure: okayapi_appver_user：/tablelist/okayapi_appver_user.html
-- MySQL Table okayapi_appver_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_appver_user` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` varchar(64) NOT NULL COMMENT '用户ID',
`phone` varchar(32) NOT NULL COMMENT '手机号',
`username` varchar(255) NOT NULL COMMENT '用户名',
`password` varchar(255) NOT NULL COMMENT '用户密码',
`nick_name` varchar(32) NOT NULL COMMENT '昵称',
`first_login_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`is_admin` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是超级管理员',
KEY `user_id` (`user_id`),
KEY `phone` (`phone`),
KEY `username` (`username`),
KEY `password` (`password`),
KEY `nick_name` (`nick_name`),
KEY `first_login_time` (`first_login_time`),
KEY `is_admin` (`is_admin`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'App版本管理-用户';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| user_id | varchar(64) | 否 | 用户ID | |||
| phone | varchar(32) | 否 | 手机号 | Unique Index | ||
| username | varchar(255) | 否 | 用户名 | |||
| password | varchar(255) | 否 | 用户密码 | |||
| nick_name | varchar(32) | 否 | 昵称 | |||
| first_login_time | timestamp | CURRENT_TIMESTAMP | 否 | 创建时间 | CURRENT_TIMESTAMP | |
| is_admin | tinyint(1) | 0 | 否 | 是否是超级管理员 | 0 |
