Test
Tables (14)
SF_ALERT
- alert_id — NUMBER — Primary key — NOT NULL
- sensor_id — NUMBER — Foreign key → SF_SENSOR.sensor_id — NOT NULL
- alert_type — VARCHAR2(200) — NOT NULL
- alert_time — TIMESTAMP
- status — VARCHAR2(20)
SF_CROP
- crop_id — NUMBER — Primary key — NOT NULL
- crop_name — VARCHAR2(50) — NOT NULL
- planting_date — DATE — NOT NULL
- harvest_date — DATE
- zone_id — NUMBER — Foreign key → SF_ZONE.zone_id — NOT NULL
- growth_pct — NUMBER(3)
- status — VARCHAR2(50)
- image_name — VARCHAR2(100)
SF_CROP_FERTILIZER
- usage_date — DATE — Primary key — NOT NULL
- crop_id — NUMBER — Foreign key → SF_CROP.crop_id — NOT NULL
- fertilizer_id — NUMBER — Foreign key → SF_FERTILIZER.fertilizer_id — NOT NULL
- amount — NUMBER(10,2) — NOT NULL
SF_DEVICE_CONTROL
- control_id — NUMBER — Primary key — NOT NULL
- zone_id — NUMBER — Foreign key → SF_ZONE.zone_id — NOT NULL
- start_time — TIMESTAMP
- end_time — TIMESTAMP
- device_type — VARCHAR2(50) — NOT NULL
- control_type — VARCHAR2(20) — NOT NULL
- control_action — VARCHAR2(10)
- triggered_by — VARCHAR2(50) — NOT NULL
SF_DISEASE
- disease_id — NUMBER — Primary key — NOT NULL
- crop_id — NUMBER — Foreign key → SF_CROP.crop_id — NOT NULL
- disease_name — VARCHAR2(100) — NOT NULL
- symptom — VARCHAR2(500)
- cause — VARCHAR2(500)
- treatment — VARCHAR2(500)
- detect_date — DATE
- status — VARCHAR2(20)
- note — VARCHAR2(500)
SF_ENV_STANDARD
- crop_id — NUMBER — Foreign key → SF_CROP.crop_id — NOT NULL
- max_temp — NUMBER(5,2) — NOT NULL
- min_temp — NUMBER(5,2) — NOT NULL
- max_humidity — NUMBER(5,2) — NOT NULL
- min_humidity — NUMBER(5,2) — NOT NULL
- max_co2 — NUMBER(6,2)
- max_soil_moisture — NUMBER(5,2)
- max_light — NUMBER(10,2)
SF_FARM
- farm_id — NUMBER — Primary key — NOT NULL
- farm_name — VARCHAR2(100) — NOT NULL
- location — VARCHAR2(200) — NOT NULL
- area_size — NUMBER(10,2) — NOT NULL
- user_id — NUMBER — Foreign key → SF_USER.user_id — NOT NULL
SF_FERTILIZER
- fertilizer_id — NUMBER — Primary key — NOT NULL
- fertilizer_name — VARCHAR2(100) — NOT NULL
- manufacturer — VARCHAR2(100)
SF_HARVEST
- harvest_id — NUMBER — Primary key — NOT NULL
- crop_id — NUMBER — NOT NULL
- crop_name — VARCHAR2(50) — NOT NULL
- quantity — NUMBER(10,2) — NOT NULL
- harvest_date — DATE
SF_MAINTENANCE
- maintenance_id — NUMBER — Primary key — NOT NULL
- sensor_id — NUMBER — Foreign key → SF_SENSOR.sensor_id — NOT NULL
- maintenance_date — DATE
- description — VARCHAR2(500) — NOT NULL
SF_SENSOR
- sensor_id — NUMBER — Primary key — NOT NULL
- sensor_type — VARCHAR2(50) — NOT NULL
- install_date — DATE — NOT NULL
- zone_id — NUMBER — Foreign key → SF_ZONE.zone_id — NOT NULL
SF_SENSOR_DATA
- data_id — NUMBER — Primary key — NOT NULL
- sensor_id — NUMBER — Foreign key → SF_SENSOR.sensor_id — NOT NULL
- temperature — NUMBER(5,2)
- humidity — NUMBER(5,2)
- soil_moisture — NUMBER(5,2)
- co2 — NUMBER(6,2)
- light_intensity — NUMBER(10,2)
- measure_time — TIMESTAMP
SF_USER
- user_id — NUMBER — Primary key — NOT NULL
- user_name — VARCHAR2(50) — NOT NULL
- phone — VARCHAR2(20) — NOT NULL
- email — VARCHAR2(100)
- password — VARCHAR2(100) — NOT NULL
SF_ZONE
- zone_id — NUMBER — Primary key — NOT NULL
- zone_name — VARCHAR2(50) — NOT NULL
- farm_id — NUMBER — Foreign key → SF_FARM.farm_id — NOT NULL
- min_temp — NUMBER(5,2)
- max_temp — NUMBER(5,2)
- min_humidity — NUMBER(5,2)
- max_humidity — NUMBER(5,2)