📄️ Database Schema
This document provides a comprehensive overview of the Farm Data Model (FDM) database schema. It details each schema and table, their properties, and columns, explaining their purpose and how they relate to the overall data structure.
📄️ Farms
The Farm asset is the top-level container for all other assets and actions in the Farm Data Model (FDM). It represents a single farming business or enterprise and is the primary unit within the system.
📄️ Fields
The Field asset is the primary spatial asset in the Farm Data Model (FDM). It represents a specific area of land where agricultural activities take place.
📄️ Cultivations
A Cultivation represents the lifecycle of a crop on a Field. It is a central concept in the Farm Data Model (FDM) that allows you to track the entire process of growing a crop, from planting to harvest.
📄️ Harvests
Harvesting is a critical event in the cultivation cycle. In the Farm Data Model (FDM), the harvest is not just a single data point but a detailed data structure that captures the nuances of different crops and their specific measurements. This detailed approach allows for accurate agronomic calculations, such as nutrient balances and yield comparisons.
📄️ Fertilizers
Fertilizer management is a critical aspect of modern agriculture, and the Farm Data Model (FDM) provides a comprehensive way to track and manage fertilizer applications.
📄️ Soil Analyses
Soil analysis is a fundamental practice in agriculture, providing valuable insights into the health and fertility of the soil. The Farm Data Model (FDM) provides a structured way to store and manage soil analysis data.
📄️ Catalogues
The fdm-data package is a key component of the Farm Data Model (FDM) that provides pre-defined, standardized data sets for a variety of agricultural concepts. These data sets are known as catalogues.
📄️ Authentication
Authentication is the process of verifying the identity of a user. The Farm Data Model (FDM) utilizes the Better Auth library to provide a standard authentication system. This implementation supports multiple authentication strategies and handles session management through a database-backed approach.
📄️ Authorization
Authorization is the process of determining what actions a user is allowed to perform. The Farm Data Model (FDM) provides a resource-based permission model that allows you to control access to your data.
📄️ Organizations
Organizations provide a way to group and manage multiple farms and users under a single entity. This is particularly useful for large agricultural businesses, cooperatives, and other organizations that need to manage data from multiple farms.