Always get headache about schemas

Black box is another nightmare of table schemas. People come and go, in result some services or code bases become THE BLACK BOX. It works without documentations and no one knows how it works. Then, few people knows the meaning of the table schemas and the columns.

Curious that how your teams maintain such documentations. Is there anyone already has a LLM tool for it? Wondering if that’s actually useful.