1
2
3
4
5
6
7
8
9
10
11
12
13
| #员工离职表
| drop table if exists staff_join_leave_record;
| drop table if exists staff_leave;
| create table staff_leave
| (
| id bigint auto_increment primary key,
| staff_on_job_id bigint not null default 0 comment '员工在职id',
| reason varchar(255) null comment '离职原因',
| remark text null comment '离职备注',
| tenant_id bigint not null comment '租户id',
| create_time datetime null comment '录入时间',
| update_time datetime null comment '更新时间'
| );
|
|