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。本文件为BETYdb生产版本的子集，涵盖了本分析所需的全部数据，包括表A1、表A2中的数据、元数据表以及数据库架构。该子集通过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中。