Xinjiang Tree Germplasm Resources Database Table Structure Design

Xinjiang has a vast land, rich in light and heat resources, and it has huge mountains and vast plain valleys. Diverse and special types of environment give birth to rich and unique plant resources. The establishment of the database system of Xinjiang plant germplasm resources is more convenient and faster for realizing the digitization, storage, and query of plant germplasm resources in Xinjiang and its neighboring countries, including crops, trees, medicinal plants, and wild plants. Seed storage is one of the major measures for the preservation of germplasm resources.

As the scale and quantity of plant germplasm resources continue to expand and increase in the course of continuous collection and consolidation, at the same time, as the scale of resources changes, crop classification, crop names, and crop information also need to be adjusted, increased, and changed at any time. Therefore, it is required that the crop germplasm resource storage structure has flexible scalability and adjustability. In order to meet the data storage requirements, the design fully analyzes and mines the underlying relationships of basic data according to the relational database theory, and adopts a “one-to-many” germplasm resource bank relationship structure to design a total classification table, a specific crop name table, and crops. The three-level database storage structure composed of data tables realizes the scalability of data storage.

General classification table: specifies the classification of plants, such as wild plants, medicinal plants, food crops, etc. Each category corresponds to multiple specific crop lists. Specific crop table: Specifies the name of the format table, crop data table, and code table corresponding to each plant type, and the three tables correspond one by one. Format table, crop data table and code table: The format table is used to store information such as general information name, data length and data type of specific crops; crop data table is used to store specific data of plant common information; code table is used to implement common information Coded storage and extraction.

Printing Inks

Printing Ink Industry, Printing Inks, Offset Printing Ink

Dynasty Chemicals (NingBo) Co., Ltd. , https://www.dychemco.com