How to properly document the physical layer switching of a local/telephone/fiber network?

Question

Documentation

There is a local network consisting of 22 separate buildings. One of them houses the central node. Communication lines from other buildings converge to the central node with a star (optical fiber, street twisted pair, VDSL lines, telephone lines - Chamber of Commerce and Industry 5-30 * 2).
Each building has its own local communication node, to which client loops (twisted pair and telephony) flock like a star, where they are clogged into patch panels, through which they are connected to equipment (or other highways) with patches.
The question is how to properly document the physical level of switching, i.e. what is plugged in where:
1) which client socket comes to which port of the patch panel
2) which port of the patch panel is connected to which port of the switch
3) which fiber optic distribution box socket, with which switch SFP port
4) which client telephone patch panel port with which telephone trunk patch panel port, etc.
The most important thing is to have a single center for storing and changing all such information so that you don’t have to open a bunch of files and look for everything in different places, and so that changes are made without much puzzle, what to enter / register after some changes in the physical level networks. I started doing it in an excel spreadsheet, ... but I decided to ask.

Answer 1

SQL, with keys - where to drive all switching ports.
there are some paid packages for drawing such diagrams, but I don't remember the names