#生产班组表
drop table if exists production_team;
create table production_team
(
    id          bigint auto_increment primary key,
    team_name   varchar(100) not null comment '班组名称',
    remark      text null comment '备注',
    tenant_id   bigint       not null comment '租户id',
    create_time datetime null comment '创建时间',
    update_time datetime null comment '更新时间',
    index       idx_team_name (team_name),
);

#班组台账与用户关联表
drop table if exists production_team_user_rel;
create table production_team_user_rel
(
    id                 bigint auto_increment primary key,
    production_team_id bigint  not null comment '生产班组id',
    sys_user_id        bigint  not null comment '系统用户id',
    is_leader          tinyint not null default 0 comment '是否为班组长 0否 1是',
    tenant_id          bigint  not null comment '租户id',
    create_time        datetime null comment '创建时间',
    update_time        datetime null comment '更新时间',
    index              idx_production_team_id (production_team_id),
    index              idx_sys_user_id (sys_user_id),
    unique idx_production_team_user (production_team_id, sys_user_id)
);

alter table production_order add column team_leader_user_id bigint not null default 0 comment '班组长ID';
alter table production_order add index idx_team_leader_user_id (team_leader_user_id);

alter table production_operation_task
    add team_user_id bigint default 0 not null comment '班组团员用户id';