# 员工合同表
|
drop table if exists staff_contract;
|
create table staff_contract
|
(
|
id bigint auto_increment primary key,
|
staff_on_job_id bigint not null default 0 comment '员工在职id',
|
contract_start_time datetime null comment '合同开始时间',
|
contract_end_time datetime null comment '合同结束时间',
|
contract_term int not null default 0 comment '合同期限',
|
tenant_id bigint not null comment '租户id',
|
create_time datetime null comment '录入时间',
|
update_time datetime null comment '更新时间'
|
);
|
