Spaces:
Sleeping
Sleeping
| -- ============================================================= | |
| -- plants_database_day_night.sql | |
| -- Creates a NEW `plants_v2` table with day/night setpoints. | |
| -- This is SEPARATE from the existing `plants` table — the old | |
| -- table is NOT touched. Each lifecycle stage carries: | |
| -- | |
| -- General setpoints (encompass full day+night range, incl. temp_optimal_c) | |
| -- day { temp_min_c, temp_max_c, temp_optimal_c, | |
| -- humidity_min_pct, humidity_max_pct, | |
| -- light_lux_min, light_lux_max } | |
| -- night { ... same keys ... } | |
| -- day { temp_min_c, temp_max_c, temp_optimal_c, | |
| -- humidity_min_pct, humidity_max_pct, | |
| -- light_lux_min, light_lux_max } | |
| -- night { … same keys … } | |
| -- | |
| -- HOW TO USE: | |
| -- 1. Paste the entire file into the Supabase SQL editor. | |
| -- 2. Run it. A new `plants_v2` table is created alongside | |
| -- the existing `plants` table (both coexist safely). | |
| -- 3. Update supabase_client.py to fetch from /plants_v2 | |
| -- and save to plants_database_day_night.json so the AI | |
| -- can use the new day/night setpoints. | |
| -- ============================================================= | |
| -- 1. DROP OLD plants_v2 IF IT EXISTS (idempotent re-run) | |
| DROP TABLE IF EXISTS public.plants_v2 CASCADE; | |
| -- 2. CREATE NEW TABLE | |
| CREATE TABLE public.plants_v2 ( | |
| id TEXT PRIMARY KEY, | |
| common_names TEXT[], | |
| scientific_name TEXT NOT NULL, | |
| family TEXT NOT NULL, | |
| description TEXT, | |
| sources TEXT[], | |
| lifecycle JSONB NOT NULL | |
| ); | |
| -- 3. INSERT ALL 21 PLANTS WITH DAY / NIGHT SETPOINTS | |
| INSERT INTO public.plants_v2 (id, common_names, scientific_name, family, description, sources, lifecycle) VALUES | |
| -- ======================================================= | |
| -- GROUP 1: LEAFY GREENS (Full Cycle Compatible) | |
| -- ======================================================= | |
| ( | |
| 'lettuce', | |
| ARRAY['Lettuce', 'Selada', 'Selada Keriting', 'Grand Rapids'], | |
| 'Lactuca sativa', | |
| 'Asteraceae', | |
| 'Standard loose-leaf lettuce. High value, fast harvest.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 2, | |
| "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 20, "temp_max_c": 22, "temp_optimal_c": 21, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 20, "temp_optimal_c": 19, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 14, | |
| "temp_min_c": 16, "temp_max_c": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, | |
| "light_lux_min": 8000, "light_lux_max": 12000, "light_lux_optimal": 10000, | |
| "day": { "temp_min_c": 22, "temp_max_c": 24, "temp_optimal_c": 23, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 8000, "light_lux_max": 14000, "light_lux_optimal": 11000 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 19, "temp_optimal_c": 18, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 35, | |
| "temp_min_c": 16, "temp_max_c": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, | |
| "light_lux_min": 14000, "light_lux_max": 22000, "light_lux_optimal": 18000, | |
| "notes": "Harvest phase.", | |
| "day": { "temp_min_c": 21, "temp_max_c": 24, "temp_optimal_c": 23, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 14000, "light_lux_max": 25000, "light_lux_optimal": 19500 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 19, "temp_optimal_c": 18, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'pak_choy', | |
| ARRAY['Pak Choy', 'Pakcoy', 'Bok Choy', 'Nauli F1', 'Naura F1'], | |
| 'Brassica rapa chinensis', | |
| 'Brassicaceae', | |
| 'Robust leafy green, very fast turnover.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 2, | |
| "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 25, "temp_max_c": 28, "temp_optimal_c": 27, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 24, "temp_max_c": 26, "temp_optimal_c": 25, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 12, | |
| "temp_min_c": 20, "temp_max_c": 28, "temp_optimal_c": 24, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 10000, "light_lux_max": 13000, "light_lux_optimal": 11500, | |
| "day": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 10000, "light_lux_max": 15000, "light_lux_optimal": 12500 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 13, "day_end": 30, | |
| "temp_min_c": 18, "temp_max_c": 30, "temp_optimal_c": 24, | |
| "humidity_min_pct": 60, "humidity_max_pct": 85, "humidity_optimal_pct": 73, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 24, "temp_max_c": 30, "temp_optimal_c": 27, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'spinach_amaranth', | |
| ARRAY['Spinach', 'Bayam', 'Bayam Hijau', 'Maestro', 'Mira'], | |
| 'Amaranthus tricolor', | |
| 'Amaranthaceae', | |
| 'Tropical spinach (Amaranth). Loves heat and light.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 3, | |
| "temp_min_c": 24, "temp_max_c": 30, "temp_optimal_c": 27, | |
| "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 85, "humidity_max_pct": 90, "humidity_optimal_pct": 88, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 10, | |
| "temp_min_c": 22, "temp_max_c": 30, "temp_optimal_c": 26, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, | |
| "light_lux_min": 12000, "light_lux_max": 17500, "light_lux_optimal": 14750, | |
| "day": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 12000, "light_lux_max": 20000, "light_lux_optimal": 16000 }, | |
| "night": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 11, "day_end": 25, | |
| "temp_min_c": 22, "temp_max_c": 32, "temp_optimal_c": 27, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 20000, "light_lux_max": 30500, "light_lux_optimal": 25250, | |
| "day": { "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 29, "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, "light_lux_min": 20000, "light_lux_max": 35000, "light_lux_optimal": 27500 }, | |
| "night": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'mustard_greens', | |
| ARRAY['Mustard Greens', 'Caisim', 'Sawi Hijau', 'Sawi Pahit', 'Shinta', 'Tosakan', 'Morakot'], | |
| 'Brassica juncea', | |
| 'Brassicaceae', | |
| 'Standard market mustard green.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 2, | |
| "temp_min_c": 20, "temp_max_c": 26, "temp_optimal_c": 23, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 12, | |
| "temp_min_c": 18, "temp_max_c": 26, "temp_optimal_c": 22, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 10000, "light_lux_max": 13000, "light_lux_optimal": 11500, | |
| "day": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 10000, "light_lux_max": 15000, "light_lux_optimal": 12500 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 20, "temp_optimal_c": 19, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 13, "day_end": 35, | |
| "temp_min_c": 15, "temp_max_c": 25, "temp_optimal_c": 20, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 20, "temp_max_c": 25, "temp_optimal_c": 23, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 15, "temp_max_c": 18, "temp_optimal_c": 17, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'kailan', | |
| ARRAY['Kailan', 'Chinese Kale', 'Nita'], | |
| 'Brassica oleracea alboglabra', | |
| 'Brassicaceae', | |
| 'Thick stemmed brassica.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 3, | |
| "temp_min_c": 20, "temp_max_c": 26, "temp_optimal_c": 23, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 14, | |
| "temp_min_c": 16, "temp_max_c": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 12000, "light_lux_max": 15500, "light_lux_optimal": 13750, | |
| "day": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 12000, "light_lux_max": 18000, "light_lux_optimal": 15000 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 18, "temp_optimal_c": 17, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 45, | |
| "temp_min_c": 12, "temp_max_c": 24, "temp_optimal_c": 18, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 18, "temp_max_c": 24, "temp_optimal_c": 21, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 12, "temp_max_c": 16, "temp_optimal_c": 14, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'chinese_cabbage', | |
| ARRAY['Chinese Cabbage', 'Sawi Putih', 'Petsai', 'Leony'], | |
| 'Brassica rapa pekinensis', | |
| 'Brassicaceae', | |
| 'Harvest as Baby Cabbage.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 3, | |
| "temp_min_c": 18, "temp_max_c": 24, "temp_optimal_c": 21, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 14, | |
| "temp_min_c": 14, "temp_max_c": 22, "temp_optimal_c": 18, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, | |
| "light_lux_min": 10000, "light_lux_max": 13000, "light_lux_optimal": 11500, | |
| "day": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 10000, "light_lux_max": 15000, "light_lux_optimal": 12500 }, | |
| "night": { "temp_min_c": 14, "temp_max_c": 18, "temp_optimal_c": 16, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 40, | |
| "temp_min_c": 10, "temp_max_c": 21, "temp_optimal_c": 16, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 15, "temp_max_c": 21, "temp_optimal_c": 18, "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 10, "temp_max_c": 15, "temp_optimal_c": 13, "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'water_spinach', | |
| ARRAY['Water Spinach', 'Kangkung', 'Serimpi', 'Bangkok LP-1'], | |
| 'Ipomoea aquatica', | |
| 'Convolvulaceae', | |
| 'Extremely fast growing.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 2, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 29, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 28, "temp_max_c": 32, "temp_optimal_c": 30, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 7, | |
| "temp_min_c": 24, "temp_max_c": 32, "temp_optimal_c": 28, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, "humidity_optimal_pct": 83, | |
| "light_lux_min": 12000, "light_lux_max": 15500, "light_lux_optimal": 13750, | |
| "day": { "temp_min_c": 28, "temp_max_c": 32, "temp_optimal_c": 30, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 12000, "light_lux_max": 18000, "light_lux_optimal": 15000 }, | |
| "night": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 80, "humidity_max_pct": 90, "humidity_optimal_pct": 85, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 8, "day_end": 21, | |
| "temp_min_c": 22, "temp_max_c": 35, "temp_optimal_c": 29, | |
| "humidity_min_pct": 70, "humidity_max_pct": 95, "humidity_optimal_pct": 83, | |
| "light_lux_min": 20000, "light_lux_max": 30500, "light_lux_optimal": 25250, | |
| "day": { "temp_min_c": 26, "temp_max_c": 35, "temp_optimal_c": 31, "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, "light_lux_min": 20000, "light_lux_max": 35000, "light_lux_optimal": 27500 }, | |
| "night": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 80, "humidity_max_pct": 95, "humidity_optimal_pct": 88, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'celery', | |
| ARRAY['Celery', 'Seledri', 'Daun Sop', 'Amigo', 'Bamby'], | |
| 'Apium graveolens', | |
| 'Apiaceae', | |
| 'Thrives in cooler temps.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 10, | |
| "temp_min_c": 15, "temp_max_c": 22, "temp_optimal_c": 19, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, | |
| "light_lux_min": 1000, "light_lux_max": 4500, "light_lux_optimal": 2750, | |
| "day": { "temp_min_c": 20, "temp_max_c": 22, "temp_optimal_c": 21, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 1000, "light_lux_max": 5000, "light_lux_optimal": 3000 }, | |
| "night": { "temp_min_c": 15, "temp_max_c": 18, "temp_optimal_c": 17, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 11, "day_end": 30, | |
| "temp_min_c": 14, "temp_max_c": 22, "temp_optimal_c": 18, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, | |
| "light_lux_min": 10000, "light_lux_max": 13000, "light_lux_optimal": 11500, | |
| "day": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 10000, "light_lux_max": 15000, "light_lux_optimal": 12500 }, | |
| "night": { "temp_min_c": 14, "temp_max_c": 18, "temp_optimal_c": 16, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 31, "day_end": 60, | |
| "temp_min_c": 12, "temp_max_c": 21, "temp_optimal_c": 17, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 16, "temp_max_c": 21, "temp_optimal_c": 19, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 12, "temp_max_c": 16, "temp_optimal_c": 14, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'green_onion', | |
| ARRAY['Green Onion', 'Bawang Daun', 'Blaze'], | |
| 'Allium fistulosum', | |
| 'Amaryllidaceae', | |
| 'Grown for leaves.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 6, | |
| "temp_min_c": 18, "temp_max_c": 24, "temp_optimal_c": 21, | |
| "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 85, "humidity_max_pct": 90, "humidity_optimal_pct": 88, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 7, "day_end": 28, | |
| "temp_min_c": 14, "temp_max_c": 24, "temp_optimal_c": 19, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, | |
| "light_lux_min": 12000, "light_lux_max": 15500, "light_lux_optimal": 13750, | |
| "day": { "temp_min_c": 18, "temp_max_c": 24, "temp_optimal_c": 21, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 12000, "light_lux_max": 18000, "light_lux_optimal": 15000 }, | |
| "night": { "temp_min_c": 14, "temp_max_c": 18, "temp_optimal_c": 16, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 29, "day_end": 70, | |
| "temp_min_c": 10, "temp_max_c": 24, "temp_optimal_c": 17, | |
| "humidity_min_pct": 50, "humidity_max_pct": 70, "humidity_optimal_pct": 60, | |
| "light_lux_min": 20000, "light_lux_max": 30500, "light_lux_optimal": 25250, | |
| "day": { "temp_min_c": 15, "temp_max_c": 24, "temp_optimal_c": 20, "humidity_min_pct": 50, "humidity_max_pct": 65, "humidity_optimal_pct": 58, "light_lux_min": 20000, "light_lux_max": 35000, "light_lux_optimal": 27500 }, | |
| "night": { "temp_min_c": 10, "temp_max_c": 15, "temp_optimal_c": 13, "humidity_min_pct": 60, "humidity_max_pct": 70, "humidity_optimal_pct": 65, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| -- ======================================================= | |
| -- GROUP 2: NURSERY ONLY (Fruiting Crops) | |
| -- ======================================================= | |
| ( | |
| 'chili_pepper', | |
| ARRAY['Chili', 'Cabai', 'Cabe', 'Bara F1', 'Pilar F1', 'Lado F1', 'Pelita', 'Baja', 'Gada Evo', 'Rawita F1', 'Rajo'], | |
| 'Capsicum annuum', | |
| 'Solanaceae', | |
| 'Nursery Phase Only in PGC.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 7, | |
| "temp_min_c": 24, "temp_max_c": 29, "temp_optimal_c": 27, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 26, "temp_max_c": 29, "temp_optimal_c": 28, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 24, "temp_max_c": 27, "temp_optimal_c": 26, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 8, "day_end": 30, | |
| "temp_min_c": 18, "temp_max_c": 26, "temp_optimal_c": 22, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, | |
| "light_lux_min": 14000, "light_lux_max": 22000, "light_lux_optimal": 18000, | |
| "day": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 14000, "light_lux_max": 25000, "light_lux_optimal": 19500 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 21, "temp_optimal_c": 20, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 31, "day_end": 60, | |
| "temp_min_c": 16, "temp_max_c": 26, "temp_optimal_c": 21, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 25000, "light_lux_max": 35000, "light_lux_optimal": 30000, | |
| "notes": "Requires full sun.", | |
| "day": { "temp_min_c": 21, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 25000, "light_lux_max": 40000, "light_lux_optimal": 32500 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 21, "temp_optimal_c": 19, "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'tomato', | |
| ARRAY['Tomato', 'Tomat', 'Servo F1', 'Agatha', 'Gustavi', 'Gammara'], | |
| 'Solanum lycopersicum', | |
| 'Solanaceae', | |
| 'Nursery Phase Only in PGC.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 5, | |
| "temp_min_c": 22, "temp_max_c": 28, "temp_optimal_c": 25, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 6, "day_end": 25, | |
| "temp_min_c": 18, "temp_max_c": 26, "temp_optimal_c": 22, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 20, "temp_optimal_c": 19, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 26, "day_end": 50, | |
| "temp_min_c": 16, "temp_max_c": 27, "temp_optimal_c": 22, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, | |
| "light_lux_min": 30000, "light_lux_max": 43500, "light_lux_optimal": 36750, | |
| "notes": "Requires full sun.", | |
| "day": { "temp_min_c": 21, "temp_max_c": 27, "temp_optimal_c": 24, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 30000, "light_lux_max": 50000, "light_lux_optimal": 40000 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 18, "temp_optimal_c": 17, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'melon', | |
| ARRAY['Melon', 'Melon', 'Alina', 'Gracia', 'Alisha', 'New Madesta'], | |
| 'Cucumis melo', | |
| 'Cucurbitaceae', | |
| 'High value F1 seeds.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 3, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 29, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 28, "temp_max_c": 32, "temp_optimal_c": 30, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 14, | |
| "temp_min_c": 20, "temp_max_c": 30, "temp_optimal_c": 25, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 35, | |
| "temp_min_c": 18, "temp_max_c": 29, "temp_optimal_c": 24, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 30000, "light_lux_max": 43500, "light_lux_optimal": 36750, | |
| "notes": "Requires strong sunlight.", | |
| "day": { "temp_min_c": 24, "temp_max_c": 29, "temp_optimal_c": 27, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 30000, "light_lux_max": 50000, "light_lux_optimal": 40000 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 21, "temp_optimal_c": 20, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'watermelon', | |
| ARRAY['Watermelon', 'Semangka', 'Amara', 'Baginda F1', 'Palguna', 'Dewangga'], | |
| 'Citrullus lanatus', | |
| 'Cucurbitaceae', | |
| 'Move out quickly.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 4, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 29, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 28, "temp_max_c": 32, "temp_optimal_c": 30, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 5, "day_end": 15, | |
| "temp_min_c": 20, "temp_max_c": 30, "temp_optimal_c": 25, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 16, "day_end": 40, | |
| "temp_min_c": 18, "temp_max_c": 29, "temp_optimal_c": 24, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 30000, "light_lux_max": 43500, "light_lux_optimal": 36750, | |
| "day": { "temp_min_c": 24, "temp_max_c": 29, "temp_optimal_c": 27, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 30000, "light_lux_max": 50000, "light_lux_optimal": 40000 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 21, "temp_optimal_c": 20, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'cucumber', | |
| ARRAY['Cucumber', 'Mentimun', 'Timun', 'Bandana', 'Batara', 'Erina'], | |
| 'Cucumis sativus', | |
| 'Cucurbitaceae', | |
| 'Very fast growth.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 2, | |
| "temp_min_c": 24, "temp_max_c": 30, "temp_optimal_c": 27, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 12, | |
| "temp_min_c": 20, "temp_max_c": 28, "temp_optimal_c": 24, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 22, "temp_optimal_c": 21, "humidity_min_pct": 75, "humidity_max_pct": 85, "humidity_optimal_pct": 80, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 13, "day_end": 30, | |
| "temp_min_c": 17, "temp_max_c": 26, "temp_optimal_c": 22, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 25000, "light_lux_max": 39000, "light_lux_optimal": 32000, | |
| "day": { "temp_min_c": 24, "temp_max_c": 26, "temp_optimal_c": 25, "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, "light_lux_min": 25000, "light_lux_max": 45000, "light_lux_optimal": 35000 }, | |
| "night": { "temp_min_c": 17, "temp_max_c": 21, "temp_optimal_c": 19, "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'eggplant', | |
| ARRAY['Eggplant', 'Terong', 'Lezata', 'Hitavi', 'Yuvita'], | |
| 'Solanum melongena', | |
| 'Solanaceae', | |
| 'Heat lover.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 7, | |
| "temp_min_c": 24, "temp_max_c": 30, "temp_optimal_c": 27, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 8, "day_end": 35, | |
| "temp_min_c": 20, "temp_max_c": 28, "temp_optimal_c": 24, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 36, "day_end": 60, | |
| "temp_min_c": 18, "temp_max_c": 29, "temp_optimal_c": 24, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, | |
| "light_lux_min": 25000, "light_lux_max": 39000, "light_lux_optimal": 32000, | |
| "day": { "temp_min_c": 25, "temp_max_c": 29, "temp_optimal_c": 27, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 25000, "light_lux_max": 45000, "light_lux_optimal": 35000 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'pumpkin', | |
| ARRAY['Pumpkin', 'Labu Kuning', 'Labu', 'Labumadu', 'Suprema'], | |
| 'Cucurbita moschata', | |
| 'Cucurbitaceae', | |
| 'Vigorous seedling.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 4, | |
| "temp_min_c": 24, "temp_max_c": 30, "temp_optimal_c": 27, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 5, "day_end": 14, | |
| "temp_min_c": 16, "temp_max_c": 28, "temp_optimal_c": 22, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, "humidity_min_pct": 60, "humidity_max_pct": 70, "humidity_optimal_pct": 65, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 20, "temp_optimal_c": 18, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 40, | |
| "temp_min_c": 14, "temp_max_c": 29, "temp_optimal_c": 22, | |
| "humidity_min_pct": 50, "humidity_max_pct": 75, "humidity_optimal_pct": 63, | |
| "light_lux_min": 30000, "light_lux_max": 43500, "light_lux_optimal": 36750, | |
| "day": { "temp_min_c": 21, "temp_max_c": 29, "temp_optimal_c": 25, "humidity_min_pct": 50, "humidity_max_pct": 70, "humidity_optimal_pct": 60, "light_lux_min": 30000, "light_lux_max": 50000, "light_lux_optimal": 40000 }, | |
| "night": { "temp_min_c": 14, "temp_max_c": 18, "temp_optimal_c": 16, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| -- ======================================================= | |
| -- GROUP 3: NURSERY ONLY (Brassica / Allium / Tree) | |
| -- ======================================================= | |
| ( | |
| 'cauliflower', | |
| ARRAY['Cauliflower', 'Kembang Kol', 'Aquina', 'PM 126'], | |
| 'Brassica oleracea botrytis', | |
| 'Brassicaceae', | |
| 'Nursery only.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 4, | |
| "temp_min_c": 18, "temp_max_c": 25, "temp_optimal_c": 22, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 20, "temp_max_c": 25, "temp_optimal_c": 23, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 5, "day_end": 21, | |
| "temp_min_c": 14, "temp_max_c": 22, "temp_optimal_c": 18, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 12000, "light_lux_max": 17500, "light_lux_optimal": 14750, | |
| "day": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 12000, "light_lux_max": 20000, "light_lux_optimal": 16000 }, | |
| "night": { "temp_min_c": 14, "temp_max_c": 18, "temp_optimal_c": 16, "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 22, "day_end": 50, | |
| "temp_min_c": 10, "temp_max_c": 24, "temp_optimal_c": 17, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 25000, "light_lux_max": 35000, "light_lux_optimal": 30000, | |
| "day": { "temp_min_c": 15, "temp_max_c": 24, "temp_optimal_c": 20, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 25000, "light_lux_max": 40000, "light_lux_optimal": 32500 }, | |
| "night": { "temp_min_c": 10, "temp_max_c": 16, "temp_optimal_c": 13, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'cabbage', | |
| ARRAY['Cabbage', 'Kubis', 'Kol', 'Talenta'], | |
| 'Brassica oleracea capitata', | |
| 'Brassicaceae', | |
| 'Nursery only.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 3, | |
| "temp_min_c": 18, "temp_max_c": 25, "temp_optimal_c": 22, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 20, "temp_max_c": 25, "temp_optimal_c": 23, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 21, | |
| "temp_min_c": 14, "temp_max_c": 22, "temp_optimal_c": 18, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, "humidity_optimal_pct": 75, | |
| "light_lux_min": 12000, "light_lux_max": 17500, "light_lux_optimal": 14750, | |
| "day": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 12000, "light_lux_max": 20000, "light_lux_optimal": 16000 }, | |
| "night": { "temp_min_c": 14, "temp_max_c": 18, "temp_optimal_c": 16, "humidity_min_pct": 70, "humidity_max_pct": 85, "humidity_optimal_pct": 78, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 22, "day_end": 60, | |
| "temp_min_c": 10, "temp_max_c": 24, "temp_optimal_c": 17, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 25000, "light_lux_max": 35000, "light_lux_optimal": 30000, | |
| "day": { "temp_min_c": 15, "temp_max_c": 24, "temp_optimal_c": 20, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 25000, "light_lux_max": 40000, "light_lux_optimal": 32500 }, | |
| "night": { "temp_min_c": 10, "temp_max_c": 16, "temp_optimal_c": 13, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'shallot', | |
| ARRAY['Shallot', 'Bawang Merah', 'Sanren', 'Lokananta'], | |
| 'Allium cepa var. aggregatum', | |
| 'Amaryllidaceae', | |
| 'Long nursery phase.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 10, | |
| "temp_min_c": 16, "temp_max_c": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 80, "humidity_max_pct": 95, "humidity_optimal_pct": 88, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 18, "temp_max_c": 24, "temp_optimal_c": 21, "humidity_min_pct": 80, "humidity_max_pct": 90, "humidity_optimal_pct": 85, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 20, "temp_optimal_c": 18, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 11, "day_end": 42, | |
| "temp_min_c": 14, "temp_max_c": 22, "temp_optimal_c": 18, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, | |
| "light_lux_min": 15000, "light_lux_max": 17500, "light_lux_optimal": 16250, | |
| "day": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 60, "humidity_max_pct": 70, "humidity_optimal_pct": 65, "light_lux_min": 15000, "light_lux_max": 20000, "light_lux_optimal": 17500 }, | |
| "night": { "temp_min_c": 14, "temp_max_c": 18, "temp_optimal_c": 16, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 43, "day_end": 70, | |
| "temp_min_c": 10, "temp_max_c": 24, "temp_optimal_c": 17, | |
| "humidity_min_pct": 50, "humidity_max_pct": 70, "humidity_optimal_pct": 60, | |
| "light_lux_min": 25000, "light_lux_max": 35000, "light_lux_optimal": 30000, | |
| "day": { "temp_min_c": 15, "temp_max_c": 24, "temp_optimal_c": 20, "humidity_min_pct": 50, "humidity_max_pct": 65, "humidity_optimal_pct": 58, "light_lux_min": 25000, "light_lux_max": 40000, "light_lux_optimal": 32500 }, | |
| "night": { "temp_min_c": 10, "temp_max_c": 15, "temp_optimal_c": 13, "humidity_min_pct": 60, "humidity_max_pct": 70, "humidity_optimal_pct": 65, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'papaya', | |
| ARRAY['Papaya', 'Pepaya', 'Lovena'], | |
| 'Carica papaya', | |
| 'Caricaceae', | |
| 'Nursery only.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 14, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 29, | |
| "humidity_min_pct": 85, "humidity_max_pct": 99, "humidity_optimal_pct": 92, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 28, "temp_max_c": 32, "temp_optimal_c": 30, "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 26, "temp_max_c": 28, "temp_optimal_c": 27, "humidity_min_pct": 90, "humidity_max_pct": 99, "humidity_optimal_pct": 95, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 15, "day_end": 45, | |
| "temp_min_c": 20, "temp_max_c": 29, "temp_optimal_c": 25, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, "humidity_optimal_pct": 73, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 26, "temp_max_c": 29, "temp_optimal_c": 28, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 46, "day_end": 100, | |
| "temp_min_c": 18, "temp_max_c": 29, "temp_optimal_c": 24, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, "humidity_optimal_pct": 70, | |
| "light_lux_min": 30000, "light_lux_max": 43500, "light_lux_optimal": 36750, | |
| "day": { "temp_min_c": 24, "temp_max_c": 29, "temp_optimal_c": 27, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 30000, "light_lux_max": 50000, "light_lux_optimal": 40000 }, | |
| "night": { "temp_min_c": 18, "temp_max_c": 22, "temp_optimal_c": 20, "humidity_min_pct": 70, "humidity_max_pct": 80, "humidity_optimal_pct": 75, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ), | |
| -- ======================================================= | |
| -- GROUP 4: REFUGIA | |
| -- ======================================================= | |
| ( | |
| 'marigold', | |
| ARRAY['Marigold', 'Marigold', 'Golden Bloom', 'Maharani'], | |
| 'Tagetes erecta', | |
| 'Asteraceae', | |
| 'Refugia.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 4, | |
| "temp_min_c": 20, "temp_max_c": 25, "temp_optimal_c": 23, | |
| "humidity_min_pct": 85, "humidity_max_pct": 95, "humidity_optimal_pct": 90, | |
| "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0, | |
| "day": { "temp_min_c": 22, "temp_max_c": 25, "temp_optimal_c": 24, "humidity_min_pct": 85, "humidity_max_pct": 90, "humidity_optimal_pct": 88, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 }, | |
| "night": { "temp_min_c": 20, "temp_max_c": 22, "temp_optimal_c": 21, "humidity_min_pct": 90, "humidity_max_pct": 95, "humidity_optimal_pct": 93, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "seedling": { | |
| "day_start": 5, "day_end": 20, | |
| "temp_min_c": 16, "temp_max_c": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, | |
| "light_lux_min": 15000, "light_lux_max": 22000, "light_lux_optimal": 18500, | |
| "day": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 60, "humidity_max_pct": 70, "humidity_optimal_pct": 65, "light_lux_min": 15000, "light_lux_max": 25000, "light_lux_optimal": 20000 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 18, "temp_optimal_c": 17, "humidity_min_pct": 65, "humidity_max_pct": 75, "humidity_optimal_pct": 70, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| }, | |
| "vegetative": { | |
| "day_start": 21, "day_end": 60, | |
| "temp_min_c": 16, "temp_max_c": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 50, "humidity_max_pct": 75, "humidity_optimal_pct": 63, | |
| "light_lux_min": 20000, "light_lux_max": 35000, "light_lux_optimal": 27500, | |
| "day": { "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, "humidity_min_pct": 50, "humidity_max_pct": 70, "humidity_optimal_pct": 60, "light_lux_min": 20000, "light_lux_max": 40000, "light_lux_optimal": 30000 }, | |
| "night": { "temp_min_c": 16, "temp_max_c": 18, "temp_optimal_c": 17, "humidity_min_pct": 60, "humidity_max_pct": 75, "humidity_optimal_pct": 68, "light_lux_min": 0, "light_lux_max": 0, "light_lux_optimal": 0 } | |
| } | |
| }'::jsonb | |
| ) | |
| ; | |