sj_system_user_permission.sql 848 B

1234567891011121314
  1. create table sj_system_user_permission
  2. (
  3. id bigint unsigned auto_increment comment '主键'
  4. primary key,
  5. group_name varchar(64) not null comment '组名称',
  6. namespace_id varchar(64) default '764d604ec6fc45f68cd92514c40e9e1a' not null comment '命名空间id',
  7. system_user_id bigint not null comment '系统用户id',
  8. create_dt datetime default CURRENT_TIMESTAMP not null comment '创建时间',
  9. update_dt datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间',
  10. constraint uk_namespace_id_group_name_system_user_id
  11. unique (namespace_id, group_name, system_user_id)
  12. )
  13. comment '系统用户权限表';