V146: primary_supplier_uuid on catalogue items.
Backs phoenix_kit_catalogue's per-item default supplier (upstream
catalogue commit 2e47cdf): lets an item specify a supplier directly,
independent of manufacturer — needed for generic/unbranded materials
that have no brand to resolve a supplier through, and to break ties
when a manufacturer has more than one linked supplier.
- Nullable
primary_supplier_uuidFK →phoenix_kit_cat_suppliers(uuid)withON DELETE SET NULL— the pointer is an optional default; the item must survive its supplier (mirrorscategory_uuid's nilify semantics, deliberately NOTmanufacturer_uuid's delete_all). - Partial index on
(primary_supplier_uuid) WHERE NOT NULLfor the "items defaulting to this supplier" reverse lookup.
Idempotent + prefix-safe: bare index name on CREATE, all existence
checks schema-anchored, FK constraint checked via pg_constraint
anchored to the prefixed table (the V51 idiom).