#原料表
|
drop table if exists raw_material;
|
create table raw_material
|
(
|
id bigint auto_increment primary key,
|
product_model_id bigint not null default 0 comment '产品型号id',
|
batch_no varchar(255) null comment '批次号',
|
check_type tinyint null comment '检验类型 0入场检 1车间检 2出厂检',
|
check_result tinyint null comment '检验结果 0合格 1不合格',
|
inspect_state tinyint null comment '类别(0:未提交;1:已提交)',
|
check_user_name varchar(255) null comment '检验员名称',
|
check_time date null comment '检验日期',
|
create_time datetime null comment '录入时间',
|
update_time datetime null comment '更新时间',
|
index idx_product_model_id (product_model_id)
|
);
|
|
drop table if exists raw_material_quality_inspect_item;
|
create table raw_material_quality_inspect_item
|
(
|
id bigint auto_increment primary key,
|
raw_material_id bigint not null default 0 comment '原料id',
|
quality_inspect_item_id bigint not null default 0 comment '质量检验项id',
|
create_time datetime null comment '录入时间',
|
update_time datetime null comment '更新时间',
|
unique idx_raw_material_id_quality_inspect_item_id (raw_material_id, quality_inspect_item_id)
|
);
|
