# 工艺路线
drop table if exists process_route;
create table process_route
(
    id          bigint auto_increment primary key,
    bom_id      bigint   not null default 0 comment 'BOMid',
    product_model_id  bigint       not null default 0 comment '产品id',
    process_route_code varchar(255) not null default '' comment '工艺路线编号',
    product_model_ids varchar(1024) null comment '多产品id，逗号分隔',
    description varchar(255) not null default '' comment '描述',
    tenant_id   bigint       not null comment '租户id',
    create_time datetime     null comment '录入时间',
    update_time datetime     null comment '更新时间'
);
