Overview of Intake24 Database Architecture
Intake24 uses PostgreSQL as its database engine. The API Server interacts with the database using a combination of the Sequelize ORM and the Kysely query builder. The system is split into two primary databases:
foods: Contains all food-related data (foods, food groups, nutrients, etc.).system: Contains system-related data (users, permissions, roles, feedback schemes, surveys, etc.).