两色金鸡菊溯源系统前期数据库的设计与实现

Design and Implementation of the Preliminary Database for the Coreopsis tinctoria Traceability System

摘要: 本文围绕两色金鸡菊溯源系统前期数据库的设计与实现展开。先阐述两色金鸡菊的价值及建立溯源系统的必要性，接着分析系统业务流程、功能与非功能需求。通过实体识别和E-R图完成概念设计，转换为15张核心表进行逻辑设计，定义约束与索引。物理设计选用MySQL 8.0，确定存储引擎、字符集等，还实现了数据库创建、接口设计与安全防护，并经测试验证。该数据库可支撑全流程溯源，为后续开发奠定基础，可将该数据库设计模式复用至甘草、枸杞等其他药用植物的溯源系统，为中药材质量管控提供参考，助力产业标准化、规范化发展。

Abstract: This paper focuses on the design and implementation of the preliminary database for the Coreopsis tinctoria traceability system. It first expounds the value of Coreopsis tinctoria and the necessity of establishing a traceability system, then analyzes the system’s business processes, functional and non-functional requirements. The conceptual design is completed through entity identification and E-R diagrams, which are converted into 15 core tables for logical design, with constraints and indexes defined. For physical design, MySQL 8.0 is selected, with the storage engine, character set and other parameters determined. In addition, database creation, interface design and security protection are implemented and verified through tests. This database can support the whole-process traceability and lay a foundation for subsequent development. Its design mode can be reused in the traceability systems of other medicinal plants such as licorice and wolfberry, providing references for the quality control of Chinese medicinal materials and facilitating the standardized and normalized development of the industry.