FarmTech Sensors documentation

Note

This project is part of a course in Artificial Intelligence at FIAP. This repository is the activity 1 from phase 2.

Summary

• FarmTech Sensors documentation
  • Summary
  • Introduction
  • Database type
  • Table structure
    • Producer
    • Crop
    • Sensor
      • Enums
        • sensor_type
    • Sensor_Reading
    • Application_Adjustment
  • Relationships
  • Database Diagram

Introduction

Database type

• Database system: Generic

Table structure

Producer

Name	Type	Settings	References	Note
id_producer	INT	🔑 PK, not null , autoincrement
name	VARCHAR(100)	not null
location	VARCHAR(255)	not null
registration_date	DATE	not null

Crop

Name	Type	Settings	References	Note
id_crop	INT	🔑 PK, not null , autoincrement
name	VARCHAR(100)	not null
type	VARCHAR(100)	not null
id_producer	INT	not null	Crop_id_producer_fk

Sensor

Name	Type	Settings	References	Note
id_sensor	INT	🔑 PK, not null , autoincrement
sensor_type	ENUM	not null
id_crop	INT	not null	Sensor_id_crop_fk

Enums

sensor_type

• humidity
• pH
• nutrients

Sensor_Reading

Name	Type	Settings	References	Note
id_reading	INT	🔑 PK, not null , autoincrement
id_sensor	INT	not null	Sensor_Reading_id_sensor_fk
reading_value	DOUBLE	not null
reading_date	TIMESTAMP	not null , default: CURRENT_TIMESTAMP

Application_Adjustment

Name	Type	Settings	References	Note
id_adjustment	INT	🔑 PK, not null , autoincrement
water_quantity	DOUBLE	not null
nutrient_quantity	DOUBLE	not null
adjustment_date	TIMESTAMP	not null , default: CURRENT_TIMESTAMP
id_crop	INT	not null	Application_Adjustment_id_crop_fk

Relationships

• Crop to Producer: many_to_one
• Sensor to Crop: many_to_one
• Sensor_Reading to Sensor: many_to_one
• Application_Adjustment to Crop: many_to_one

Database Diagram

erDiagram
	Crop ||--o{ Producer : references
	Sensor ||--o{ Crop : references
	Sensor_Reading ||--o{ Sensor : references
	Application_Adjustment ||--o{ Crop : references

	Producer {
		INT id_producer
		VARCHAR(100) name
		VARCHAR(255) location
		DATE registration_date
	}

	Crop {
		INT id_crop
		VARCHAR(100) name
		VARCHAR(100) type
		INT id_producer
	}

	Sensor {
		INT id_sensor
		ENUM sensor_type
		INT id_crop
	}

	Sensor_Reading {
		INT id_reading
		INT id_sensor
		DOUBLE reading_value
		TIMESTAMP reading_date
	}

	Application_Adjustment {
		INT id_adjustment
		DOUBLE water_quantity
		DOUBLE nutrient_quantity
		TIMESTAMP adjustment_date
		INT id_crop
	}

Loading