okayapi_fie_role_user - MySQ Table Design - OkayAPI.com

+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_fie_role_user：/tablelist/okayapi_fie_role_user.html


-- MySQL Table okayapi_fie_role_user
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_role_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `role_id` int(10) NOT NULL DEFAULT '0' COMMENT '角色 id',
    `user_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id',
    KEY `role_id` (`role_id`),
    KEY `user_id` (`user_id`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-用户角色对应表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-2 of 2 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Index	Demo Data
role_id	int(10)	0	否	角色 id	Normal Index	0
user_id	bigint(20)	0	否	用户id	Normal Index	0

Guess You Like

MySQL Table Design okayapi_message

MySQL Table Design okayapi_article

MySQL Table Design okayapi_fie_admin_menu

MySQL Table Design okayapi_fie_asset

MySQL Table Design okayapi_fie_auth_access

MySQL Table Design okayapi_fie_auth_rule

MySQL Table Design okayapi_fie_comment

MySQL Table Design okayapi_fie_hook

MySQL Table Design okayapi_fie_hook_plugin

MySQL Table Design okayapi_fie_link

MySQL Table Design okayapi_fie_nav

MySQL Table Design okayapi_fie_nav_menu

MySQL Table Design okayapi_fie_option

MySQL Table Design okayapi_fie_plugin

MySQL Table Design okayapi_fie_portal_category

MySQL Table Design okayapi_fie_portal_category_post

MySQL Table Design okayapi_fie_portal_post

MySQL Table Design okayapi_fie_portal_tag

MySQL Table Design okayapi_fie_portal_tag_post

MySQL Table Design okayapi_fie_recycle_bin