1
2
3
4
5
6
7
8
9
10
11
12
13
14
| # 产品结构
| drop table if exists product_structure;
| create table product_structure
| (
| id bigint auto_increment
| primary key,
| product_id bigint not null comment '产品id',
| process_id bigint not null comment '工序id',
| unit_quantity numeric(16, 4) not null comment '单位产出需要数量',
| demanded_quantity numeric(16, 4) not null comment '需求数量',
| unit varchar(255) not null comment '单位',
| disk_quantity numeric(16, 4) not null comment '盘数量',
| tenant_id bigint not null comment '租户id'
| );
|
|
