Supplement 2. Documentation of database (BETYdb) used in the present study, including schema and contents.

File List bety.sql: subset of BETYdb database used in the present analysis. (MD5: 0560351a1ac737c324eb4fbaaa96bf49) dbdocumentation_users.pdf: BETYdb documentation. (MD5: a33ba4b340e2c7ca0745bfbf9239685e) Description Database Subset The file bety.sql contains the database schema and data used in the analysis. This is the same database that is included in the PEcAn 1.1 virtual machine found at http://hdl.handle.net/2142/34619 with source code found at: http://hdl.handle.net/2142/34655. This file contains the subset of the database used in the present analysis, including the data in Tables A1 and A2 as well as metadata tables and the database schema. This subset was generated from the production version of BETYdb using the script from the /bash/dump.db.subset.sh file in the PEcAn source code, which calls the mysqldump command to generate tables that can easily be imported using the command “/bash/create.db.subset.sh inst/extdata/bety.sql”. This is the same database that is included in the PEcAn 1.1 virtual machine. Figure S1 provides an illustration of the database schema, and the database user’s guide is provided as the file dbdocumentation_users.pdf. This subset was generated from the production version of BETYdb using the script from the PEcAn source/bash/dump.db.subset.sh. This database can be imported to mysql with the command /bash/create.db.subset.sh bety.sql. <br> Database Documentation dbdocumentation_users.pdf A comprehensive documentation of the database created to support PEcAn at the time that the analysis was generated. -- IMAGE: Please see in attached file. -- FIG. S1. Relationships among tables in BETYdb used to store data and metadata related to plant traits, yields, and ecosystem services. Detailed description of these tables can be found on the website; the documentation for 1.0 is contained in the appendices as dbdocumentation_users.pdf.

文件列表：
bety.sql：本研究分析所用BETYdb数据库的子集（MD5值：0560351a1ac737c324eb4fbaaa96bf49）
dbdocumentation_users.pdf：BETYdb数据库文档（MD5值：a33ba4b340e2c7ca0745bfbf9239685e）

数据库子集说明
文件bety.sql包含本次分析所用的数据库架构与数据，与http://hdl.handle.net/2142/34619 提供的PEcAn 1.1虚拟机中内置的数据库完全一致，该虚拟机的源代码可通过http://hdl.handle.net/2142/34655 获取。本文件为分析所用的数据库子集，涵盖表A1、A2中的数据、元数据表以及完整的数据库架构。该子集源自BETYdb生产版本，通过PEcAn源代码中/bash/dump.db.subset.sh脚本生成，该脚本调用mysqldump命令生成可通过“/bash/create.db.subset.sh inst/extdata/bety.sql”命令快速导入的表文件。本数据库与PEcAn 1.1虚拟机中内置的数据库完全一致。图S1展示了该数据库架构，数据库用户指南以dbdocumentation_users.pdf文件形式提供。本子集同样通过PEcAn源代码/bash/dump.db.subset.sh脚本从BETYdb生产版本生成。可通过命令“/bash/create.db.subset.sh bety.sql”将该数据库导入至MySQL环境中。

数据库文档：dbdocumentation_users.pdf
本文件为分析生成时为支撑PEcAn项目编写的完整数据库说明文档。
-- 图片说明：详见附件文件。
-- 图S1：BETYdb中用于存储植物性状、产量与生态系统服务相关数据及元数据的表间关联关系。上述表格的详细说明可于官方网站查询；1.0版本的数据库文档已以附录形式收录于dbdocumentation_users.pdf中。