-- 供应商评分权重规则（多条，设一条为默认）
CREATE TABLE IF NOT EXISTS `supplier_score_rule` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '规则名称',
  `quality_weight` int unsigned NOT NULL DEFAULT 50 COMMENT '上年度质量评分权重(%)',
  `price_weight` int unsigned NOT NULL DEFAULT 50 COMMENT '单价评分权重(%)',
  `lead_weight` int unsigned NOT NULL DEFAULT 0 COMMENT '交货期得分权重(%)',
  `lead_enabled` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '1=交货期纳入总分',
  `is_default` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '1=默认计算规则',
  `status` varchar(16) NOT NULL DEFAULT 'normal' COMMENT 'normal/hidden',
  `createtime` datetime DEFAULT NULL,
  `updatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_default` (`is_default`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='供应商服务评分权重规则';

-- 供应商服务评分表（开标验证通过后按订单写入的明细）
CREATE TABLE IF NOT EXISTS `supplier_service_score` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int unsigned NOT NULL DEFAULT 0 COMMENT '供应商ID(customer.id)',
  `company_name` varchar(128) NOT NULL DEFAULT '' COMMENT '供应商名称',
  `ym` char(7) NOT NULL DEFAULT '' COMMENT '对应年月 YYYY-MM',
  `ccydh` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号',
  `score` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '本单总分',
  `rank_no` int unsigned NOT NULL DEFAULT 0 COMMENT '本单排名',
  `quality_score` int NOT NULL DEFAULT 0 COMMENT '上年度质量评分',
  `quality_weight` int unsigned NOT NULL DEFAULT 50 COMMENT '质量百分比',
  `price_sum` decimal(12,4) NOT NULL DEFAULT 0.0000 COMMENT '本单工序单价合计',
  `price_weight` int unsigned NOT NULL DEFAULT 50 COMMENT '价格百分比',
  `price_score` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '单价评分值',
  `lead_days_sum` int NOT NULL DEFAULT 0 COMMENT '本单工序工期合计(天)',
  `lead_weight` int unsigned NOT NULL DEFAULT 0 COMMENT '交货期百分比',
  `lead_enabled` tinyint unsigned NOT NULL DEFAULT 0 COMMENT '1=当时纳入总分',
  `lead_score` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '交货期评分值',
  `rule_id` int unsigned NOT NULL DEFAULT 0 COMMENT '所用规则ID',
  `createtime` datetime DEFAULT NULL,
  `updatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_ccydh_company` (`ccydh`,`company_name`),
  KEY `idx_customer_ym` (`customer_id`,`ym`),
  KEY `idx_ccydh` (`ccydh`),
  KEY `idx_ym` (`ym`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='供应商服务评分订单明细';

-- 月度汇总见 supplier_service_final_score.sql（score=月度总分，final_score=最终得分）