This article will cover:
The overall structure of the LiteFarm data model
Common or particularly valuable joins for extracting data
Navigation of the data model using foreign keys
Things you’ll need to follow-along:
A tool to open a “.erd” file - DBeaver is a free example
A Postgres client (We’ll use Postico (Mac only), though DBeaver also works)
Read-only access to the beta environment: Talk to Lite Farm about this
This .erd 👇