MySQL Create Table SQL
Table Structure: okayapi_zheng_upms_user_role：/tablelist/okayapi_zheng_upms_user_role.html
-- MySQL Table okayapi_zheng_upms_user_role
-- From: OkayAPI.com
CREATE TABLE `okayapi_zheng_upms_user_role` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NULL COMMENT '用户编号',
`role_id` int(10) NULL COMMENT '角色编号',
KEY `user_id` (`user_id`),
KEY `role_id` (`role_id`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'zheng敏捷开发-用户角色关联表';
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 |
|---|---|---|---|---|---|---|
| user_id | int(10) | 否 | 用户编号 | |||
| role_id | int(10) | 是 | 角色编号 |
