The supplier_resolution table

The append-only crosswalk from whatever handle a source ships for a counterparty to the registry row it resolved to.

Fields#

field type required example meaning
publisher_code text yes The publisher's short handle, where a scheme or registry entry belongs to one publisher rather than being shared.
raw_text text yes as shipped: 'IBERDROLA CLIENTES, S.A.U.' or a contact uuid
raw_kind text yes Whether the source handle was a name or an identifier. An identifier survives a rename; a name does not.
supplier_id uuid yes The named counterparty, where the factor describes one.
resolved_by text yes rule / gazetteer / llm / human
evidence text the log line justifying the mapping
created_at timestamp yes When the row was first written.

Notes#

When a source carries an identifier it is anchored on that rather than the name, which keeps the link intact across a rename.