The ecocomDP model shown with relational database notation for foreign keys and relationships (e.g, lines ending in crows-foot indicate 1:many relationships). Semi-transparent tables are optional. Medium green fields in each table are the primary key. Yellow/hashed fields are a combined unique constraint. IDs (suffixed, “_id”), must be unique within a table, as in an relational database. Full documentation can be found here. Reproduced from O'Brien et al. (2021).

  Part of: Sokol ER (2021) ecocomDP: A data design pattern and R package to facilitate FAIR biodiversity data for ecological synthesis. Biodiversity Information Science and Standards 5: e75640.