A centralised, searchable repository for external machine parts, supplier ordering information, machine compatibility, images and controlled add-part approvals.
| Component | Revision |
|---|---|
| Application | 0.13.0 |
| Database | 0.8.0 |
PartsDB uses semantic revisions: major revisions represent incompatible architectural changes, minor revisions represent new features or schema capabilities, and patch revisions represent compatible fixes. Every release must update the application revision, database revision when the schema changes, and this README.
The application footer displays both revisions so a frontend/database mismatch is visible immediately.
- Work is delivered as small, independently testable pull requests.
- Database migrations must be backward-safe and pass the Supabase workflow before merge.
- Completed roadmap items are removed from Action plan and recorded under Updates.
- Backup/export/import compatibility must be checked whenever tables or relationships change.
- Add machine manuals and service notes after machine search/details are stable.
- Add controlled machine change requests with title, notes and compressed images.
- Keep machine documents, notes, requests and images separate from part-request records.
- Reorganised the Administrator portal around the part-request queue and grouped database-management tools.
- Added live approved-part and active-machine totals, Pending/Draft filters, request search, sorting and a bounded scrollable queue.
- Replaced the large server-mode panel with a compact status control while preserving confirmation safeguards.
- Displayed server mode in the global administrator navigation and consolidated all management links below the request queue.
- Allowed the Machine editor to be inspected in Standby mode while retaining read-only save protection.
- Replaced the plain Machine editor selection list with compact searchable thumbnail cards.
- Added machine identity, manufacturer/model/category, status and selected-state cues to each picker result.
- Renamed the administrator Machines page to Machine editor and linked its back action to Reference Data.
- Replaced the machine card list and modal with the same searchable picker and inline editor pattern used by Company editor.
- Preserved direct machine-profile edit links, image replacement, status, category and notes editing.
- Brought Machines into the same compact Reference Data pattern as Companies.
- Added one Machine editor button in the header and removed repeated editor links from machine rows.
- Separated machine search from the labelled Add Machine fields with a divider.
- Added a clear divider between Company search and the Add Company fields.
- Gave company roles and Supply Type dedicated, labelled space so the checkboxes remain aligned.
- Improved the Add Company form layout on narrow screens.
- Collapsed every Reference Data module into a compact header by default.
- Added accessible expand and collapse chevrons that reveal each module's controls and records on demand.
- Added one dedicated Company editor entry point to Reference Data.
- Added company search to both the Reference Data list and the full editor.
- Added full editing of company identity, roles, website, ordering information, notes, supply type, default supplier and active status.
- Removed inline company editing from the Reference Data scroll list.
- Added a direct Add to BOM control for every part in the “Consider ordering with” section while retaining links to each part's full details.
- Kept manufacturers and machines without linked approved parts visible but disabled in the dashboard filters.
- Replaced the Approved Parts manufacturer column with a compatible-machine count and up to two machine names.
- Collapsed unfiltered part and machine result lists into clear availability prompts to reduce dashboard clutter.
- Automatically clears retained manufacturer or machine filters when they no longer have approved parts.
- Added installation-specific Live, Standby and Maintenance server modes stored in
system_metadata. - Added database-enforced restrictive write policies for PartsDB business tables and all three image buckets.
- Added a persistent Standby read-only banner and disabled Add Part, editing, approval, bulk import and reference-data controls while locked.
- Added confirmed administrator controls for entering Maintenance mode, returning to Standby and explicitly setting a server Live.
- Kept searching, viewing, BOM use, backup export and portable ZIP validation available in Standby mode.
- Automatically returns a Maintenance-mode server to Standby after a portable backup import attempt.
- Keeps
site_modeoutside portable backup format version 4 so cloud restores cannot unlock a standby server.
- Replaced JSON-only backup format version 3 with portable ZIP backup format version 4.
- Added database JSON, part images, request images and machine images to one downloadable archive.
- Added an application/database revision manifest, record and image counts, export report and SHA-256 checksums.
- Added complete archive and checksum validation before merge or full restore can begin.
- Restores Storage objects and image metadata, and downloads a completion report after import.
- Remaps missing cloud user references to the administrator performing a portable restore while continuing to exclude authentication accounts, passwords and server secrets.
- Added browser archive-size and safe-path protections for portable backup import.
- Added Part Description to the Part Information card on part profiles.
- Added individual double-square copy buttons for Part Description and Manufacturer Part Number.
- Added brief copied confirmation beside the selected field.
- Auto-fills the first preferred supplier from Part Manufacturer on Add Part.
- Keeps the first supplier part number synchronised with Manufacturer Part Number while typing.
- Stops synchronising each supplier field after the user manually edits it, preserving exceptions.
- Allows a manufacturer company to be selected as the first supplier even when it did not previously have a Supplier role.
- Added an administrator-only Edit machine button to machine profile pages.
- Opens the selected machine directly in the existing administrator machine editor.
- Added type-to-search machine selection to Add Part and administrator request review.
- Removed the requirement to select a machine manufacturer before searching for a machine.
- Automatically selects the linked manufacturer when a machine is chosen from search results.
- Retained part search text and Manufacturer, Machine, Supply type and Category filters while viewing a part.
- Restored the previous parts-search scroll position when returning to the dashboard.
- Kept Clear filters as an explicit reset of the retained part-search state.
- Added a browser-persistent BOM Cart available throughout a signed-in session.
- Added Add to BOM controls to part search results and part detail pages.
- Added live BOM quantity in the main navigation.
- Added editable quantities and line notes, individual removal and clear-cart confirmation.
- Added CSV export with part, preferred supplier, supply type and compatible-machine information.
- Removed the inactive View History button from the pending requests panel.
- Added pending-request checkboxes and a select-all-pending control to the administrator dashboard.
- Added confirmed bulk approval with progress and approved, skipped and failed results.
- Preserved the existing individual edit, approve and reject workflow.
- Kept duplicate protection active: high-confidence matches are skipped for individual administrator review.
- Bulk approval carries across categories, suppliers, machines, ordering groups and request images.
- Replaced one-way “Consider ordering with” links with shared ordering groups.
- Made group relationships symmetric and transitive: linking to any member joins the complete group.
- Migrated existing commonly ordered links into connected groups and removed the obsolete relationship table.
- Added searchable checkbox selection limited to parts compatible with the selected machines.
- Applied group selection to Add Part, administrator request review and Edit Part.
- Updated part details and backup format version 3 for ordering groups.
- Replaced the browser-dependent part-category multi-select with clear checkbox options.
- Applied the same category selection control to Add Part, administrator request review and Edit Part.
- Restored multi-category selection when submitting an Add Part request.
- Restored category review and editing before an administrator approves a request.
- Restored multi-category assignment when an administrator edits an approved part.
- Ensured approved request categories are copied into the part-category relationships used by search.
- Fixed the Add Part blank page caused by an invalid supply-type render reference.
- Restored the part-category filter and its database relationships on the parts search page.
- Added a visible patch revision so the deployed frontend can be identified reliably.
- Added full administrator machine editing for company, name, optional model, category, notes and status.
- Added one compressed WebP image per machine with preview, replacement and removal in a dedicated storage bucket.
- Added administrator-managed machine categories and optional machine-category assignment.
- Added separate machine search by company, category, name and model on the main page.
- Added machine detail pages showing machine information, image and compatible parts.
- Added ranked duplicate detection during request approval using exact/partial part numbers, trigram description similarity and same-machine preference.
- Added match reasons, confidence scores, new-tab review links and a required override for high-confidence matches.
- Updated backup/export coverage for machine categories and machine image records.
- Replaced separate manufacturer and supplier tables with one
companiestable and explicit Manufacturer, Supplier and Distributor roles. - Added one unified Companies section to administrator Reference Data.
- Preserved manufacturer default-supplier selection while allowing one company to perform multiple roles.
- Updated machine, part and preferred-supplier relationships to reference companies.
- Replaced the bulk-import workbook with Companies and Machines sheets.
- Updated JSON backup and restore to format version 2 with companies and company roles.
- Intentionally resets catalogue and reference data while retaining authentication users and profiles.
- Removed the old manufacturer and supplier tables and updated all application queries to use companies directly.
- Replaced hard-coded supply-type choices with one shared database-managed list.
- Updated Add Part, admin approval, part editing, supplier editing, search and bulk import to use supply-type codes while displaying editable names.
- Added supply-type usage counts and active/inactive status to Reference Data.
- Added safe deactivation: unused types can be disabled directly, while types in use require an active replacement.
- Added an administrator-only database operation that replaces all part, request and supplier references before deactivation.
- Added reactivation support and ensured new forms always select an active supply type.
- Made Machine Name required and Machine Model optional.
- Backfilled missing machine names from existing model values.
- Removed the manufacturer/model uniqueness rule so different machines may share a model.
- Added case-insensitive manufacturer/name duplicate protection.
- Updated add-part, approval, reference-data, search and bulk-import paths to use the corrected machine identity.
- Added a separate machine name field to part requests while retaining the model for display and migration compatibility.
- Fixed category relationship auditing for tables that use composite primary keys.
- Changed the audit trigger to derive record identifiers from each table's actual primary key columns.
- Added a deterministic fallback identifier for any audited table without a primary key.
- Restored adding, editing and removing part categories without a null
audit_log.record_idfailure.
- Added formal application and database revision tracking.
- Added visible application/database revision information to the frontend.
- Replaced the informal known-issues list with a dependency-ordered delivery plan.
- Established the rule that completed work moves from the action plan into this Updates section.