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)