Figure - PMC

Skip to main content

An official website of the United States government

Here's how you know

Here's how you know

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you've safely connected to the .gov website. Share sensitive information only on official, secure websites.

View full-text article in PMC

. 2014 Aug 18;2(8):apps.1400030. doi: 10.3732/apps.1400030

Search in PMC
Search in PubMed
View in NLM Catalog
Add to search

© 2014 Han et al. Published by the Botanical Society of America

This work is licensed under a Creative Commons Attribution License (CC-BY-NC-SA).

PMC Copyright notice

Fig. 6. — Entity relation diagram (ERD) of database design. Entities and their relationships are represented as tables with attributes and connected using crow’s feet annotation. For example, the relationship between pollen and pollen_images is a one-to-many identifying relationship. Specifically, one pollen taxon can have multiple images, and each record in pollen_images must reference to only one record in pollen. There are eight pollen-related tables on the right-hand side and eight spore-related tables on the left-hand side. Tables from both sides share similar structure and reference to two common tables—users and sources. Note: There are 76 tables and more than 200,000 records in the database. There are 49 attributes in the table pollen_sources and 39 in the table spore_sources. For simplicity, some auxiliary tables and secondary fields are omitted in this figure. Only the most relevant tables and fields are shown.