ERD Diagrams (Database Diagrams) were always the most useful ones for my team

But there is rule to write "Decription" in Properties of each table and column which we create.

Then we use a software name is Enterprise Architect to document Tables with all Indexes , Foreign Keys And Columns with Type and Description.