pesticide

Tables (3)

pesticide (Untitled)

  • id (Key) — Primary key — NOT NULL
  • reg_num (Field)
  • made_from (Field2)
  • item_name (Field3)
  • general_name (Field4)
  • ingredient_content (Field5)
  • trademark_name (Field6)
  • trademark_name (Field7)
  • toxicity_fish (Field8)
  • purpose (Field9)
  • reg_date (Field10)
  • mechanism (Field11)
  • formulation (Field12)
  • manufacturer (Field13)
  • target_desc (Field14)
  • category (Field15)

pesticide_sprayinfo (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • pesticide_id (Key2) — Foreign key → pesticide.id — NOT NULL
  • farmhouse_id (Field)
  • use_date (Field2)
  • weather (Field3)
  • purchase_from. (Field4)
  • water_added (Field5)
  • spray_area (Field6)
  • spray_method (Field7)
  • spray_people (Field8)
  • spray_time (Field9)
  • spray_method_etc (Field10)
  • spray_area_h (Field11)

pesticide_usage (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • sprayinfo_id (Key2) — Foreign key → pesticide_sprayinfo.id — NOT NULL
  • pesticide_id (Key3) — Foreign key → pesticide.id — NOT NULL
  • usage_count (Field2)
  • usage_amount (Field3)
  • usage_unit (Field4)
  • target_pest (Field5)
  • usage_amount_gml (Field6)
  • ingredient_usage_amount (Field7)