| 123456789101112131415161718192021222324 |
- create table sys_post
- (
- post_id bigint not null comment '岗位ID'
- primary key,
- tenant_id varchar(20) default '000000' null comment '租户编号',
- dept_id bigint not null comment '部门id',
- post_code varchar(64) not null comment '岗位编码',
- post_category varchar(100) null comment '岗位类别编码',
- post_name varchar(50) not null comment '岗位名称',
- post_sort int not null comment '显示顺序',
- status char not null comment '状态（0正常 1停用）',
- create_dept bigint null comment '创建部门',
- create_by bigint null comment '创建者',
- create_time datetime null comment '创建时间',
- update_by bigint null comment '更新者',
- update_time datetime null comment '更新时间',
- remark varchar(500) null comment '备注'
- )
- comment '岗位信息表';
- INSERT INTO ruoyi.sys_post (post_id, tenant_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1, '000000', 103, 'ceo', null, '董事长', 1, '0', 103, 1, '2025-08-23 21:51:22', null, null, '');
- INSERT INTO ruoyi.sys_post (post_id, tenant_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (2, '000000', 100, 'se', null, '项目经理', 2, '0', 103, 1, '2025-08-23 21:51:22', null, null, '');
- INSERT INTO ruoyi.sys_post (post_id, tenant_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (3, '000000', 100, 'hr', null, '人力资源', 3, '0', 103, 1, '2025-08-23 21:51:22', null, null, '');
- INSERT INTO ruoyi.sys_post (post_id, tenant_id, dept_id, post_code, post_category, post_name, post_sort, status, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (4, '000000', 100, 'user', null, '普通员工', 4, '0', 103, 1, '2025-08-23 21:51:22', null, null, '');
|
