Fig. 2
From: Plant macrofossil data for 48-0 ka in the USGS North American Packrat Midden Database, version 5.0
Relationships among the Linked data tables in the midden database. Each box lists the Linked data table name (bold black text), the common data fields in each table (bold red, blue, green, orange, and purple text) that are used to join the tables in the relational database, and the other data fields in each table (regular black text). Common data fields that provide unique identifiers for each table entry (i.e., each table row) are in italicized text. Note that the common data fields do not need to have the same name to be joined. For example, the REFERENCE field in the CODE TRANSLATION table (Linked Table 6) can be joined with the REFERENCE1 field in the MIDDEN SAMPLE table (Linked Table 2).
