| 1234567891011121314 |
- create table sj_system_user_permission
- (
- id bigint unsigned auto_increment comment '主键'
- primary key,
- group_name varchar(64) not null comment '组名称',
- namespace_id varchar(64) default '764d604ec6fc45f68cd92514c40e9e1a' not null comment '命名空间id',
- system_user_id bigint not null comment '系统用户id',
- create_dt datetime default CURRENT_TIMESTAMP not null comment '创建时间',
- update_dt datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间',
- constraint uk_namespace_id_group_name_system_user_id
- unique (namespace_id, group_name, system_user_id)
- )
- comment '系统用户权限表';
|