JUBY
Tables (6)
Harvest
- id — INT
- robot_id — INT — NOT NULL
- farm_name — VARCHAR(255) — NOT NULL
- member_ID — VARCHAR(254) — NOT NULL
- image_name — VARCHAR(255)
- ripeness_status — VARCHAR(255)
JubyAdministrator
- admin_ID — VARCHAR(254)
- admin_password — VARCHAR(255)
Member
- member_ID — VARCHAR(254)
- password — VARCHAR(255) — NOT NULL
Robot
- id — INT
- member_ID — VARCHAR(254) — NOT NULL
- farm_name — VARCHAR(255) — NOT NULL
- area — VARCHAR(255)
- height — VARCHAR(255)
- temperature — FLOAT
- humidity — FLOAT
- soil_temperature — FLOAT
- soil_humidity — FLOAT
- date — DATETIME
SmartFarm
- farm_name — VARCHAR(255)
- member_ID — VARCHAR(254) — NOT NULL
- robot_id — VARCHAR(255)
- crop — VARCHAR(255)
TemperatureData
- id — INT
- timestamp — DATETIME — NOT NULL
- outdoor_temperature — FLOAT — NOT NULL
- indoor_temperature — FLOAT — NOT NULL