Spaces:
Sleeping
Sleeping
| -- 1. CLEAR OLD DATA (To avoid duplicates) | |
| TRUNCATE TABLE plants; | |
| -- 2. INSERT DATA WITH FULL RANGES (Min/Max/Optimal) | |
| INSERT INTO plants (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": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 14, | |
| "temp_min_c": 20, "temp_max_c": 26, "temp_optimal_c": 24, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 8000, "light_lux_max": 12000 | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 35, | |
| "temp_min_c": 18, "temp_max_c": 26, "temp_optimal_c": 24, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, | |
| "light_lux_min": 12000, "light_lux_max": 15000, | |
| "notes": "Harvest phase." | |
| } | |
| }'::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": 25, "temp_max_c": 30, "temp_optimal_c": 27, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 12, | |
| "temp_min_c": 24, "temp_max_c": 29, "temp_optimal_c": 27, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, | |
| "light_lux_min": 10000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 13, "day_end": 30, | |
| "temp_min_c": 24, "temp_max_c": 29, "temp_optimal_c": 27, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, | |
| "light_lux_min": 12000, "light_lux_max": 18000 | |
| } | |
| }'::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": 26, "temp_max_c": 32, "temp_optimal_c": 28, | |
| "humidity_min_pct": 85, "humidity_max_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 10, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 30, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 12000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 11, "day_end": 25, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 30, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, | |
| "light_lux_min": 15000, "light_lux_max": 20000 | |
| } | |
| }'::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": 25, "temp_max_c": 30, "temp_optimal_c": 27, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 12, | |
| "temp_min_c": 25, "temp_max_c": 30, "temp_optimal_c": 27, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, | |
| "light_lux_min": 10000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 13, "day_end": 35, | |
| "temp_min_c": 24, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 65, "humidity_max_pct": 85, | |
| "light_lux_min": 15000, "light_lux_max": 20000 | |
| } | |
| }'::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": 23, "temp_max_c": 28, "temp_optimal_c": 25, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 14, | |
| "temp_min_c": 23, "temp_max_c": 28, "temp_optimal_c": 25, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, | |
| "light_lux_min": 12000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 45, | |
| "temp_min_c": 22, "temp_max_c": 28, "temp_optimal_c": 25, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, | |
| "light_lux_min": 15000, "light_lux_max": 20000 | |
| } | |
| }'::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": 22, "temp_max_c": 26, "temp_optimal_c": 24, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 14, | |
| "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, | |
| "light_lux_min": 10000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 40, | |
| "temp_min_c": 20, "temp_max_c": 25, "temp_optimal_c": 22, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 15000, "light_lux_max": 20000 | |
| } | |
| }'::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": 28, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 7, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 28, | |
| "humidity_min_pct": 80, "humidity_max_pct": 95, | |
| "light_lux_min": 12000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 8, "day_end": 21, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 30, | |
| "humidity_min_pct": 70, "humidity_max_pct": 90, | |
| "light_lux_min": 15000, "light_lux_max": 25000 | |
| } | |
| }'::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": 18, "temp_max_c": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 1000, "light_lux_max": 5000 | |
| }, | |
| "seedling": { | |
| "day_start": 11, "day_end": 30, | |
| "temp_min_c": 18, "temp_max_c": 24, "temp_optimal_c": 20, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, | |
| "light_lux_min": 10000, "light_lux_max": 14000 | |
| }, | |
| "vegetative": { | |
| "day_start": 31, "day_end": 60, | |
| "temp_min_c": 16, "temp_max_c": 22, "temp_optimal_c": 18, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, | |
| "light_lux_min": 15000, "light_lux_max": 20000 | |
| } | |
| }'::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": 22, "temp_max_c": 28, "temp_optimal_c": 25, | |
| "humidity_min_pct": 85, "humidity_max_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 7, "day_end": 28, | |
| "temp_min_c": 22, "temp_max_c": 28, "temp_optimal_c": 25, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 12000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 29, "day_end": 70, | |
| "temp_min_c": 22, "temp_max_c": 28, "temp_optimal_c": 25, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, | |
| "light_lux_min": 15000, "light_lux_max": 25000 | |
| } | |
| }'::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": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 8, "day_end": 30, | |
| "temp_min_c": 25, "temp_max_c": 29, "temp_optimal_c": 27, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 14000, "light_lux_max": 20000 | |
| }, | |
| "vegetative": { | |
| "day_start": 31, "day_end": 60, | |
| "temp_min_c": 26, "temp_max_c": 32, "temp_optimal_c": 28, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, | |
| "light_lux_min": 30000, "light_lux_max": 50000, | |
| "notes": "Requires full sun." | |
| } | |
| }'::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": 24, "temp_max_c": 28, "temp_optimal_c": 26, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 6, "day_end": 25, | |
| "temp_min_c": 22, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 14000, "light_lux_max": 20000 | |
| }, | |
| "vegetative": { | |
| "day_start": 26, "day_end": 50, | |
| "temp_min_c": 22, "temp_max_c": 29, "temp_optimal_c": 26, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, | |
| "light_lux_min": 30000, "light_lux_max": 50000, | |
| "notes": "Requires full sun." | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'melon', | |
| ARRAY['Melon', 'Muskmelon', '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": 28, "temp_max_c": 32, "temp_optimal_c": 30, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 14, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 75, "humidity_max_pct": 85, | |
| "light_lux_min": 12000, "light_lux_max": 18000 | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 35, | |
| "temp_min_c": 28, "temp_max_c": 35, "temp_optimal_c": 30, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, | |
| "light_lux_min": 40000, "light_lux_max": 60000, | |
| "notes": "Requires strong sunlight." | |
| } | |
| }'::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": 28, "temp_max_c": 32, "temp_optimal_c": 30, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 5, "day_end": 15, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 75, "humidity_max_pct": 85, | |
| "light_lux_min": 12000, "light_lux_max": 18000 | |
| }, | |
| "vegetative": { | |
| "day_start": 16, "day_end": 40, | |
| "temp_min_c": 28, "temp_max_c": 35, "temp_optimal_c": 30, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, | |
| "light_lux_min": 40000, "light_lux_max": 60000 | |
| } | |
| }'::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": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 3, "day_end": 12, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 80, "humidity_max_pct": 90, | |
| "light_lux_min": 12000, "light_lux_max": 18000 | |
| }, | |
| "vegetative": { | |
| "day_start": 13, "day_end": 30, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 35000, "light_lux_max": 50000 | |
| } | |
| }'::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": 27, "temp_max_c": 31, "temp_optimal_c": 29, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 8, "day_end": 35, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 14000, "light_lux_max": 20000 | |
| }, | |
| "vegetative": { | |
| "day_start": 36, "day_end": 60, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, | |
| "light_lux_min": 30000, "light_lux_max": 50000 | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'pumpkin', | |
| ARRAY['Pumpkin', 'Squash', 'Labu', 'Labumadu', 'Suprema'], | |
| 'Cucurbita moschata', | |
| 'Cucurbitaceae', | |
| 'Vigorous seedling.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 4, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 5, "day_end": 14, | |
| "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, | |
| "light_lux_min": 12000, "light_lux_max": 18000 | |
| }, | |
| "vegetative": { | |
| "day_start": 15, "day_end": 40, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, | |
| "light_lux_min": 35000, "light_lux_max": 50000 | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| '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": 23, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 5, "day_end": 21, | |
| "temp_min_c": 22, "temp_max_c": 26, "temp_optimal_c": 24, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, | |
| "light_lux_min": 12000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 22, "day_end": 50, | |
| "temp_min_c": 20, "temp_max_c": 24, "temp_optimal_c": 22, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 25000, "light_lux_max": 40000 | |
| } | |
| }'::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": 23, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 4, "day_end": 21, | |
| "temp_min_c": 23, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 75, "humidity_max_pct": 90, | |
| "light_lux_min": 12000, "light_lux_max": 15000 | |
| }, | |
| "vegetative": { | |
| "day_start": 22, "day_end": 60, | |
| "temp_min_c": 23, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 65, "humidity_max_pct": 80, | |
| "light_lux_min": 25000, "light_lux_max": 40000 | |
| } | |
| }'::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": 23, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 85, "humidity_max_pct": 95, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 11, "day_end": 42, | |
| "temp_min_c": 23, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 14000, "light_lux_max": 18000 | |
| }, | |
| "vegetative": { | |
| "day_start": 43, "day_end": 70, | |
| "temp_min_c": 25, "temp_max_c": 29, "temp_optimal_c": 27, | |
| "humidity_min_pct": 60, "humidity_max_pct": 75, | |
| "light_lux_min": 30000, "light_lux_max": 50000 | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'papaya', | |
| ARRAY['Papaya', 'Pepaya', 'Lovena'], | |
| 'Carica papaya', | |
| 'Caricaceae', | |
| 'Nursery only.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 14, | |
| "temp_min_c": 28, "temp_max_c": 32, "temp_optimal_c": 30, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 15, "day_end": 45, | |
| "temp_min_c": 26, "temp_max_c": 30, "temp_optimal_c": 28, | |
| "humidity_min_pct": 75, "humidity_max_pct": 85, | |
| "light_lux_min": 14000, "light_lux_max": 20000 | |
| }, | |
| "vegetative": { | |
| "day_start": 46, "day_end": 100, | |
| "temp_min_c": 28, "temp_max_c": 32, "temp_optimal_c": 30, | |
| "humidity_min_pct": 70, "humidity_max_pct": 80, | |
| "light_lux_min": 40000, "light_lux_max": 60000 | |
| } | |
| }'::jsonb | |
| ), | |
| ( | |
| 'marigold', | |
| ARRAY['Marigold', 'Bunga Tai Ayam', 'Golden Bloom', 'Maharani'], | |
| 'Tagetes erecta', | |
| 'Asteraceae', | |
| 'Refugia.', | |
| ARRAY['EWINDO Catalog'], | |
| '{ | |
| "germination": { | |
| "day_start": 0, "day_end": 4, | |
| "temp_min_c": 24, "temp_max_c": 28, "temp_optimal_c": 26, | |
| "humidity_min_pct": 90, "humidity_max_pct": 99, | |
| "light_lux_min": 0, "light_lux_max": 0 | |
| }, | |
| "seedling": { | |
| "day_start": 5, "day_end": 20, | |
| "temp_min_c": 23, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 70, "humidity_max_pct": 85, | |
| "light_lux_min": 12000, "light_lux_max": 15000 | |
| }, | |
| "flowering": { | |
| "day_start": 21, "day_end": 60, | |
| "temp_min_c": 23, "temp_max_c": 27, "temp_optimal_c": 25, | |
| "humidity_min_pct": 60, "humidity_max_pct": 80, | |
| "light_lux_min": 30000, "light_lux_max": 50000 | |
| } | |
| }'::jsonb | |
| ); |