MySQL Create Table SQL
Table Structure: okayapi_zd_user_auth：/tablelist/okayapi_zd_user_auth.html
-- MySQL Table okayapi_zd_user_auth
-- From: OkayAPI.com
CREATE TABLE `okayapi_zd_user_auth` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NULL COMMENT '用户ID',
`auth_id` bigint(20) NULL COMMENT '权限ID',
`create_uid` bigint(20) NULL COMMENT '创建用户ID',
`update_uid` bigint(20) NULL COMMENT '更新用户ID',
`del_flag` tinyint(4) NULL DEFAULT '0' COMMENT '是否删除 0=未删除 1=已删除',
`auth_custom_suffix` varchar(100) NULL COMMENT '自定义权限结尾',
KEY `user_id` (`user_id`),
KEY `auth_id` (`auth_id`),
KEY `create_uid` (`create_uid`),
KEY `update_uid` (`update_uid`),
KEY `del_flag` (`del_flag`),
KEY `auth_custom_suffix` (`auth_custom_suffix`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'WIKI-用户权限表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-6 of 6 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| user_id | bigint(20) | 是 | 用户ID | |||
| auth_id | bigint(20) | 是 | 权限ID | |||
| create_uid | bigint(20) | 是 | 创建用户ID | |||
| update_uid | bigint(20) | 是 | 更新用户ID | |||
| del_flag | tinyint(4) | 0 | 是 | 是否删除 0=未删除 1=已删除 | 0 | |
| auth_custom_suffix | varchar(100) | 是 | 自定义权限结尾 |
