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)