A supplier can have its own catalog number for a part, distinct from the internal PN and manufacturer PN.
- New
supplier_part table: supplier_id, part_id, vendor_pn, is_preferred, notes, unique on (supplier_id, part_id), cascade on delete.
- CRUD API under
/suppliers/{id}/parts plus a cross-reference view GET /parts/{id}/suppliers.
- Web: "Catalog Numbers" panel on supplier detail, "Suppliers" panel on part detail, with inline HTMX add forms.
- Enables part pages to show e.g. "DigiKey: 123-4567, Mouser: 987-6543" and future PO pre-population.
A supplier can have its own catalog number for a part, distinct from the internal PN and manufacturer PN.
supplier_parttable:supplier_id,part_id,vendor_pn,is_preferred,notes, unique on (supplier_id, part_id), cascade on delete./suppliers/{id}/partsplus a cross-reference viewGET /parts/{id}/suppliers.