/*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_supplier_apply` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '申请ID', `apply_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '申请编号', `supplier_id` bigint DEFAULT NULL COMMENT '供应商ID', `erp_supplier_id` bigint DEFAULT NULL COMMENT '关联ERP供应商ID', `supplier_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '供应商名称', `supplier_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '供应商类型', `company_nature` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '企业性质', `registered_capital` decimal(24,6) DEFAULT NULL COMMENT '注册资金(万元)', `business_license_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '营业执照编号', `tax_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '税号', `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '公司地址', `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开户银行', `bank_account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '银行账号', `contact_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系人', `contact_mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系电话', `contact_email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱', `apply_user_id` bigint DEFAULT NULL COMMENT '申请人ID', `apply_user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '申请人姓名', `apply_time` datetime DEFAULT NULL COMMENT '申请时间', `apply_status` int NOT NULL DEFAULT '0' COMMENT '审核状态', `process_instance_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'BPM 流程实例编号', `purchase_reviewer_id` bigint DEFAULT NULL COMMENT '采购审核人ID', `purchase_review_time` datetime DEFAULT NULL COMMENT '采购审核时间', `purchase_review_opinion` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '采购审核意见', `quality_reviewer_id` bigint DEFAULT NULL COMMENT '质量审核人ID', `quality_review_time` datetime DEFAULT NULL COMMENT '质量审核时间', `quality_review_opinion` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '质量审核意见', `finance_reviewer_id` bigint DEFAULT NULL COMMENT '财务审核人ID', `finance_review_time` datetime DEFAULT NULL COMMENT '财务审核时间', `finance_review_opinion` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '财务审核意见', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_apply_no` (`apply_no`) USING BTREE, KEY `idx_supplier_id` (`supplier_id`) USING BTREE, KEY `idx_apply_status` (`apply_status`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='供应商准入申请表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_supplier_certificate` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '证书ID', `supplier_id` bigint NOT NULL COMMENT '供应商ID', `certificate_type` int NOT NULL COMMENT '证书类型', `certificate_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '证书名称', `certificate_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '证书编号', `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名称', `file_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件地址', `issuing_authority` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '颁发机构', `valid_start_date` date DEFAULT NULL COMMENT '有效开始日期', `valid_end_date` date DEFAULT NULL COMMENT '有效结束日期', `status` int NOT NULL DEFAULT '0' COMMENT '状态', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, KEY `idx_supplier_id` (`supplier_id`) USING BTREE, KEY `idx_certificate_type` (`certificate_type`) USING BTREE, KEY `idx_valid_end_date` (`valid_end_date`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='供应商资质证书表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_supplier_evaluation` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '评价ID', `supplier_id` bigint NOT NULL COMMENT '供应商ID', `evaluation_period` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '评价周期', `quality_score` decimal(5,2) DEFAULT NULL COMMENT '质量评分', `quality_pass_rate` decimal(5,2) DEFAULT NULL COMMENT '来料合格率', `quality_defect_count` int DEFAULT '0' COMMENT '不良次数', `delivery_score` decimal(5,2) DEFAULT NULL COMMENT '交付评分', `delivery_on_time_rate` decimal(5,2) DEFAULT NULL COMMENT '准时交付率', `delivery_delay_count` int DEFAULT '0' COMMENT '延迟次数', `price_score` decimal(5,2) DEFAULT NULL COMMENT '价格评分', `service_score` decimal(5,2) DEFAULT NULL COMMENT '服务评分', `service_response_speed` int DEFAULT NULL COMMENT '响应速度评分', `composite_score` decimal(5,2) DEFAULT NULL COMMENT '综合评分', `evaluation_level` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '评价等级', `evaluator_id` bigint DEFAULT NULL COMMENT '评价人ID', `evaluation_time` datetime DEFAULT NULL COMMENT '评价时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, KEY `idx_supplier_id` (`supplier_id`) USING BTREE, KEY `idx_evaluation_period` (`evaluation_period`) USING BTREE, KEY `idx_composite_score` (`composite_score`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='供应商绩效评价表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_tender_project` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '招标项目ID', `tender_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '招标编号', `tender_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '招标名称', `tender_type` int NOT NULL COMMENT '招标类型', `purchase_org` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '采购组织', `project_leader_id` bigint DEFAULT NULL COMMENT '项目负责人ID', `project_leader_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '项目负责人姓名', `tender_status` int NOT NULL DEFAULT '0' COMMENT '招标状态', `bidding_mode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FULL' COMMENT '招投标模式: FULL-完整版, SIMPLE-简易版', `budget_amount` decimal(24,6) DEFAULT NULL COMMENT '预算金额', `start_time` datetime DEFAULT NULL COMMENT '开始时间', `end_time` datetime DEFAULT NULL COMMENT '截止时间', `bid_open_time` datetime DEFAULT NULL COMMENT '预计开标时间', `tender_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '招标说明', `qualification_requirements` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '资质要求', `purchase_request_id` bigint DEFAULT NULL COMMENT '关联采购申请ID', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_tender_no` (`tender_no`) USING BTREE, KEY `idx_tender_status` (`tender_status`) USING BTREE, KEY `idx_purchase_request_id` (`purchase_request_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='招标项目表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_tender_material` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '物料明细ID', `tender_project_id` bigint NOT NULL COMMENT '招标项目ID', `product_id` bigint DEFAULT NULL COMMENT '物料ID', `product_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '物料编码', `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '物料名称', `product_spec` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '规格型号', `quantity` decimal(24,6) NOT NULL COMMENT '数量', `unit` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '单位', `tech_requirement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '技术要求', `estimated_price` decimal(24,6) DEFAULT NULL COMMENT '预估单价', `sort` int NOT NULL DEFAULT '0' COMMENT '排序', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, KEY `idx_tender_project_id` (`tender_project_id`) USING BTREE, KEY `idx_product_code` (`product_code`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='招标物料明细表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_tender_bid` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '投标ID', `tender_project_id` bigint NOT NULL COMMENT '招标项目ID', `supplier_id` bigint NOT NULL COMMENT '供应商ID', `bid_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '投标编号', `bid_status` int NOT NULL DEFAULT '0' COMMENT '投标状态', `bid_time` datetime DEFAULT NULL COMMENT '投标时间', `bid_total_amount` decimal(24,6) DEFAULT NULL COMMENT '投标总金额', `bid_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '投标文件名称', `bid_file_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '投标文件地址', `withdraw_reason` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '撤标原因', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_bid_no` (`bid_no`) USING BTREE, KEY `idx_tender_project_id` (`tender_project_id`) USING BTREE, KEY `idx_supplier_id` (`supplier_id`) USING BTREE, KEY `idx_bid_status` (`bid_status`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='投标记录表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_supplier_quote` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '报价ID', `tender_project_id` bigint NOT NULL COMMENT '招标项目ID', `supplier_id` bigint NOT NULL COMMENT '供应商ID', `bid_id` bigint DEFAULT NULL COMMENT '投标记录ID', `tender_material_id` bigint NOT NULL COMMENT '招标物料ID', `quote_price` decimal(24,6) NOT NULL COMMENT '报价价格', `tax_rate` decimal(5,2) DEFAULT NULL COMMENT '税率(%)', `delivery_cycle` int DEFAULT NULL COMMENT '交货周期(天)', `payment_terms` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '付款条件', `warranty_period` int DEFAULT NULL COMMENT '质保期(月)', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, KEY `idx_tender_project_id` (`tender_project_id`) USING BTREE, KEY `idx_supplier_id` (`supplier_id`) USING BTREE, KEY `idx_bid_id` (`bid_id`) USING BTREE, KEY `idx_tender_material_id` (`tender_material_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='供应商报价明细表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_bid_open` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '开标ID', `tender_project_id` bigint NOT NULL COMMENT '招标项目ID', `open_time` datetime NOT NULL COMMENT '开标时间', `open_person_id` bigint DEFAULT NULL COMMENT '开标人员ID', `open_person_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '开标人员姓名', `open_record` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '开标记录', `attachment_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '附件名称', `attachment_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '附件地址', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, KEY `idx_tender_project_id` (`tender_project_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='开标记录表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_bid_evaluation` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '评标ID', `tender_project_id` bigint NOT NULL COMMENT '招标项目ID', `supplier_id` bigint NOT NULL COMMENT '供应商ID', `bid_id` bigint NOT NULL COMMENT '投标记录ID', `price_score` decimal(5,2) DEFAULT NULL COMMENT '价格评分', `tech_score` decimal(5,2) DEFAULT NULL COMMENT '技术评分', `delivery_score` decimal(5,2) DEFAULT NULL COMMENT '交付评分', `service_score` decimal(5,2) DEFAULT NULL COMMENT '服务评分', `composite_score` decimal(5,2) DEFAULT NULL COMMENT '综合评分', `ranking` int DEFAULT NULL COMMENT '排名', `evaluator_id` bigint DEFAULT NULL COMMENT '评标人ID', `evaluator_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '评标人姓名', `evaluation_opinion` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '评标意见', `evaluation_time` datetime DEFAULT NULL COMMENT '评标时间', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, KEY `idx_tender_project_id` (`tender_project_id`) USING BTREE, KEY `idx_supplier_id` (`supplier_id`) USING BTREE, KEY `idx_bid_id` (`bid_id`) USING BTREE, KEY `idx_ranking` (`ranking`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='评标记录表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_bid_award` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '定标ID', `tender_project_id` bigint NOT NULL COMMENT '招标项目ID', `supplier_id` bigint NOT NULL COMMENT '中标供应商ID', `bid_id` bigint NOT NULL COMMENT '中标投标ID', `award_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '中标通知书编号', `award_status` int NOT NULL DEFAULT '0' COMMENT '定标状态', `award_amount` decimal(24,6) NOT NULL COMMENT '中标金额', `award_time` datetime DEFAULT NULL COMMENT '定标时间', `notice_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '中标通知书文件名', `notice_file_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '中标通知书文件地址', `purchase_order_id` bigint DEFAULT NULL COMMENT '关联生成的采购订单ID', `purchase_order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '关联生成的采购订单号', `approver_id` bigint DEFAULT NULL COMMENT '审批人ID', `approval_time` datetime DEFAULT NULL COMMENT '审批时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uk_award_no` (`award_no`) USING BTREE, KEY `idx_tender_project_id` (`tender_project_id`) USING BTREE, KEY `idx_supplier_id` (`supplier_id`) USING BTREE, KEY `idx_purchase_order_id` (`purchase_order_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='定标记录表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_tender_config` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '配置ID', `default_bidding_mode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FULL' COMMENT '默认招投标模式: FULL-完整版, SIMPLE-简易版', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='SRM招投标配置表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_delivery_plan` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '交货计划ID', `collaboration_id` bigint NOT NULL COMMENT '采购协同ID', `order_id` bigint NOT NULL COMMENT '采购订单ID', `order_item_id` bigint DEFAULT NULL COMMENT '采购订单项ID', `product_id` bigint DEFAULT NULL COMMENT '物料ID', `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '物料名称', `planned_quantity` decimal(24,6) NOT NULL COMMENT '计划数量', `actual_quantity` decimal(24,6) DEFAULT NULL COMMENT '实际数量', `planned_delivery_date` date NOT NULL COMMENT '计划交货日期', `actual_delivery_date` date DEFAULT NULL COMMENT '实际交货日期', `delivery_status` int NOT NULL DEFAULT '0' COMMENT '交货状态', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, KEY `idx_collaboration_id` (`collaboration_id`) USING BTREE, KEY `idx_order_id` (`order_id`) USING BTREE, KEY `idx_delivery_status` (`delivery_status`) USING BTREE, KEY `idx_planned_delivery_date` (`planned_delivery_date`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='交货计划表'; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `srm_purchase_collaboration` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '协同ID', `order_id` bigint NOT NULL COMMENT '采购订单ID', `order_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '采购订单号', `supplier_id` bigint NOT NULL COMMENT '供应商ID', `collaboration_status` int NOT NULL DEFAULT '0' COMMENT '协同状态', `confirm_time` datetime DEFAULT NULL COMMENT '确认时间', `confirm_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '确认人', `reject_reason` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '拒绝原因', `planned_delivery_time` datetime DEFAULT NULL COMMENT '预计交付时间', `actual_delivery_time` datetime DEFAULT NULL COMMENT '实际交付时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注', `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`) USING BTREE, KEY `idx_order_id` (`order_id`) USING BTREE, KEY `idx_supplier_id` (`supplier_id`) USING BTREE, KEY `idx_collaboration_status` (`collaboration_status`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='采购协同记录表'; /*!40101 SET character_set_client = @saved_cs_client */;