Floriculture Data Model & Cold-Chain Schema Architecture

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Floriculture Data Model & Cold-Chain Schema Architecture within SmartERP.

Technical specifications of database models, harvest tables, temperature logging schemas, and export logistics relationships.

{screenshot:floriculture-data-model-and-cold-chain-architecture-overview-dashboard}

2. Prerequisites & Security Access Groups#

• Required Modules: smarterp_commodity_export, smarterp_agri_traceability
• Security Groups:
  • Cold Chain & Packhouse Officer (Technical ID: smarterp_export.group_export_user)
  • Floriculture Quality Inspector (Technical ID: smarterp_export.group_export_qa)
  • Floriculture Export Manager (Technical ID: smarterp_export.group_export_manager)
• Master Data Dependencies: Greenhouse greenhouse blocks, rose stem varieties, cold storage temperature telemetry (2°C–4°C), Ethiopian Airlines Bole Cargo space bookings, and European auction buyers.

3. Step-by-Step Configuration & Execution#

Step 1: Navigating to the Module Interface#

1. Log into your SmartERP instance at https://smarterp.et/odoo.
2. Open the main App Switcher (grid icon in the top-left corner).
3. Select the Floriculture Export app icon.
4. From the top navigation bar, open Floriculture Export → Greenhouse → Harvest / Cold Chain / Packhouse / Air Waybills.

{screenshot:floriculture-data-model-and-cold-chain-architecture-app-switcher-navigation}

Step 2: Creating and Parameterizing Records#

1. Click the New button in the top-left control panel.
2. Complete the mandatory fields in the record form:
   • Greenhouse Harvest Batch (Mandatory): Block origin, stem length (cm), and cut date/time
   • Rose Variety & Head Size (Mandatory): Commercial cultivar (Rhodos, Red Naomi, Athena) and bud profile
   • Pre-Cooling Verification (Mandatory): Confirmed forced-air cooling record achieving 2°C–4°C core temperature
   • Bole Cargo e-AWB Number (Mandatory): Ethiopian Airlines booked air waybill identifier
3. Configure optional operational parameters and localized tags as required:
   • Cold Chain Logger ID (Optional): Digital temperature datalogger serial number placed in pallet
   • Auction Consignment Code (Optional): Royal FloraHolland auction lot reference
   • MoA Phytosanitary Seal Number (Optional): Official government export inspection security tag
4. Click the Save icon in the control bar to commit the record.

{screenshot:floriculture-data-model-and-cold-chain-architecture-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Harvested → Pre-Cooled (2°C) → Packhouse Sorted → Cold Truck Transit → Bole Airport Loaded → Cleared).
• Ledger & System Impact: Direct greenhouse labor and packaging costs absorb into crop inventory; e-AWB air freight dispatch recognizes export revenue in foreign currency.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:floriculture-data-model-and-cold-chain-architecture-transaction-processing-state}

Relational Entity Architecture#

SmartERP Floriculture connects greenhouse harvest batches, packhouse grading lines, cold room telemetry, and airfreight manifests:

[agro-export-data-model]

Core Model Specifications#

1. Harvest Batch: flower.harvest.batch#

Captures greenhouse picking data:

• block_id (Many2one -> greenhouse.block).
• variety_id (Many2one -> flower.variety).
• cut_stage (Selection): stage_1_5, stage_2_0, stage_2_5, stage_3_0.
• stems_harvested (Integer), harvest_date (Datetime).
• bucket_solution_id (Many2one -> flower.hydration.solution).

2. Packhouse Grading Run: flower.grading.run#

Tracks stem sorting and defect culling:

• harvest_batch_id (Many2one -> flower.harvest.batch).
• line_ids (One2many -> flower.grading.line):
  • stem_length (Selection): 40cm, 50cm, 60cm, 70cm, 80cm, 90cm.
  • stem_count (Integer), bunch_count (Integer).
• culls_count (Integer), culled_reason (Selection).

3. Temperature Telemetry Log: flower.coldchain.log#

Logs automated IoT thermal sensor readings:

• sensor_id (Char), location_type (Selection: precooler, coldroom, reefer_truck).
• temperature_celsius (Float), humidity_pct (Float).
• timestamp (Datetime, index).
• alert_triggered (Boolean).

4. Advanced Configuration Points#

• Automated Actions & Scheduled Tasks (Crons):
  • Cold Chain: Alert temperature breach above 4°C (smarterp_export.ir_cron_temp_monitor): Runs every 15 minutes checking IoT temperature telemetry
  • Air Cargo: Track Bole cargo flight departure (smarterp_export.ir_cron_flight_status): Runs hourly checking Ethiopian Airlines cargo flight tracking
• Custom Print Templates & Reports:
  • Cold Chain Temperature Compliance Certificate
  • MoA Phytosanitary Export Inspection Dossier
  • Bole Cargo Air Waybill (e-AWB) & Pallet Manifest
  • Consignment Net Realization & Auction Settlement Summary
• Multi-Company Rules: Record-level security isolation under Company 1 (Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.

5. Comprehensive Troubleshooting Matrix#