sys_user_post.sql 269 B

123456789
  1. create table sys_user_post
  2. (
  3. user_id bigint not null comment '用户ID',
  4. post_id bigint not null comment '岗位ID',
  5. primary key (user_id, post_id)
  6. )
  7. comment '用户与岗位关联表';
  8. INSERT INTO ruoyi.sys_user_post (user_id, post_id) VALUES (1, 1);