NULL with its version when the quote pinned no activation rule; the same holds for the three rules below. A soft-deleted rule still reads.
The category-scoped limit rule the aggregate evaluation picked.
Display name of whichever entity the quote pinned — identity.full_name
or organization.name. NULL only when neither FK is set.
The route-scoped limit rule.
Human display name from product.name (NOT NULL) — the quote's product.
Composed route display name: ${product.name} · ${product_vendor.name}
for the quote's route (route product == quote product).
product_quoterow projected for admin consumers. Internal numeric ids are dropped in favour of the joined external ids. The route's external_id is exposed asrouteId(joined throughproduct_route_version → product_route) — the audit row pins to the version row, but admins reference routes by their identity-row external_id.productIdcomes from the joinedproduct.external_idsince the row'sproductIdcolumn is an internal FK. Each pinned route and rule version comes back as its parent's external id plus a*Version: 1 for the first version written for that parent, 2 for its second, DISABLED versions counted.