Hi, I'm a bit puzzled on the purpose of adding this. A few notes inline: On 13 Mar 2026, at 14:11, Jeroen Massar via db-wg <db-wg@ripe.net> wrote:
etc. Thus these are publically exposed. And for instance bgp.tools gives a handy overview: https://bgp.tools/rir-owner/ch.massar https://bgp.tools/rir-owner/nl.coloclue
if there are objects related to it. (No clue what Benjojo's magic there is, but it is handy ;) )
I imagine this might be https://ftp.ripe.net/ripe/stats/membership/alloclist.txt Not sure about the ASNs.
We do have the 'org' and related 'organisation' objects but these do not directly map to a LIR.
The unique identifier of any organisation in the RIPE database is the organisation: attribute in the organisation object type, and the org-type: identifies the organisation as an LIR (or OTHER).
But the "organisation" object does not map directly to LIR.
It does when the 'org-type' is 'LIR', right? Every LIR is represented in the database by one such object, I thought. Though you are then not required to refer that org from every object you have in the RIPE db.
Thus maybe the correct place is just in the organisation object.
That makes more sense to me, since a regid is just an identifier of certain organisations, which already have an LIR-type organisation object.
Though, it depends on the purpose of why we would add it; knowing which LIR an object exists for would be a good thing, and I do not think all objects have an org reference either, though inetnum/inet6num & amt-num likely yes, thus adding it to organisation would help a lot already to normalize that.
This is the main confusion I have: what does "which LIR an object exists for" mean? Sure, I can see the relation in case of an ALLOCATED-BY-RIR inet6num. But what about my mntner? My person object? An ASSIGNED PI inet6num? For the latter, I suppose you could link the sponsoring LIR, but their relation is quite distant. It sounds like you're trying to attach all objects in the RIPE db to a specific LIR, but I think that does not make sense for all objects, and I'm also not sure what the purpose is. Sasha