If in a separate table (thanks, I will study), then, apparently, the task is simplified. I’ll free myself a bit and think about how to do it better. The goal is interesting, especially for communities where there are external links in many posts.
Added: an additional opportunity to work with links. In our case, we want to extract all the links, sort them, check the status of the links, “link weights” and add them to our catalog. Where catalog moderators could describe interesting resources.
So it is possible (in a specific case) to link Discourse and the base of sites in the form of a catalog.