Maps each business requirement through to the data model entity, migration phase, and verification approach. Companion to the Business Requirements Document.
| Req ID | Requirement summary | Data model entity | Migration phase | Verification method | Status |
|---|---|---|---|---|---|
| BR-01 | Cultivar master record with IP owner & release status | cultivars | Phase 1 — Licensing & royalty | Schema review + sample data load | Modelled |
| BR-02 | Licence linked to one cultivar and one stakeholder | licences (FK to cultivars, stakeholders) | Phase 1 | Referential integrity test | Modelled |
| BR-03 | Configurable royalty calculation (per-unit / percentage) | royalty_contracts.calculation_basis | Phase 1 | Calculation unit test against sample transactions | Modelled |
| BR-04 | Royalty payment status tracking | royalty_transactions.payment_status | Phase 1 | Reconciliation report review | Modelled |
| BR-05 | Pathology results linked to specific block | pathology_tests (FK to blocks) | Phase 2 — Block & quarantine | Schema review | Modelled |
| BR-06 | Import/export permits linked to quarantine records | quarantine_records (FK to import_export_permits, blocks) | Phase 2 | Referential integrity test | Modelled |
| BR-07 | Concurrent multi-user access, no file locking | Platform-level (PostgreSQL vs. Access) | Phase 0 — Platform migration | Concurrent-session load test | Target architecture defined |
| BR-08 | Change history sufficient to reconstruct block status | blocks.block_status + audit strategy (future: history table) | Phase 2 | Point-in-time reconstruction test | Recommended for Phase 2 design |
| BR-09 | Nursery order tracking from placement to fulfilment | nursery_orders.order_status | Phase 3 — Nursery & orders | Workflow walkthrough | Modelled |