9  Database

9.1 Table and Column Naming Conventions

  • Table names are plural and use all lower case.
  • Unique identifiers are suffixed with:
    • *_id for unique integer keys;
    • *_key for unique string keys;
    • *_seq for auto-incrementing sequence integer keys.
  • Column names are singular and use snake_case.
  • Foreign keys are named with the singular form of the table they reference, followed by _id.
  • Primary keys are named id.

9.2 Species Distribution Models

See entity relationship diagram (ERD) for the species distribution models (SDM) database tables in this workflow:

And example of ingesting SDM outputs into the database in this workflow: