采购商品，竞标价按竞价轮数对竞标产商每轮报价排名
CREATE TABLE supply_chain_quoted_price_records (
id bigint unsigned NOT NULL COMMENT '主键',
plan_id bigint unsigned NULL COMMENT '采购计划主表id',
goods_id bigint unsigned NULL COMMENT '商品id',
supplier_id bigint unsigned NULL COMMENT '供应商id',
buyer_id bigint unsigned NULL COMMENT '负责采购员',
quoted_price decimal(18, 2) NULL DEFAULT NULL COMMENT '报价',
quoted_price_remarks varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报价备注',
quoted_price_rounds int(0) NULL DEFAULT NULL COMMENT '报价轮数',
gmt_quoted_price datetime(3) NULL DEFAULT NULL COMMENT '报价时间',
rank_num int(0) NULL DEFAULT NULL COMMENT '最终排名情况',
is_lowest int unsigned NULL COMMENT '是否最低报价(0 否 1 是)',
is_delete int unsigned NOT NULL COMMENT '是否删除(0 否 1 删除)',
meta_code varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '元数据编码',
gmt_create datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
gmt_modified datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '修改时间',
PRIMARY KEY (id) USING BTREE,
UNIQUE INDEX plan_id(plan_id, goods_id, supplier_id, quoted_price_rounds) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '供应链端(所有供应商)报价记录表' ROW_FORMAT = Dynamic;
-- Records of supply_chain_quoted_price_records
INSERT INTO supply_chain_quoted_price_records VALUES (3, 16, 17, 0, 111, 2.00, '我喜欢喝可乐', 1, '2022-01-13 12:03:43.000', NULL, NULL, 0, NULL, '2022-01-13 12:03:22.222', '2022-01-13 15:24:03.192');
INSERT INTO supply_chain_quoted_price_records VALUES (4, 16, 17, 2, 111, 3.00, '我喜欢喝可乐', 1, '2022-01-13 12:03:43.000', NULL, NULL, 0, NULL, '2022-01-13 12:03:22.222', '2022-01-13 15:24:03.192');
INSERT INTO supply_chain_quoted_price_records VALUES (5, 16, 17, 0, 111, 2.50, '我喜欢喝可乐', 2, '2022-01-13 12:03:43.000', NULL, NULL, 0, NULL, '2022-01-13 12:03:22.222', '2022-01-13 15:24:03.192');
INSERT INTO supply_chain_quoted_price_records VALUES (6, 16, 17, 2, 111, 2.50, '我喜欢喝可乐', 2, '2022-01-13 12:03:43.000', NULL, NULL, 0, NULL, '2022-01-13 12:03:22.222', '2022-01-13 15:24:03.192');
收起