we have hundreds of flows like registration, sales, cancellation from front end java applicatio to SQL database.
Microsoft SQL database has hundreds of stored procedures, tables, columns, joins, primary keys, foreign keys etc.
it is getting hard to check database stored procedures, tables if issue come on say sales flow to check quickly as no proper documention on database side.
what kind of documentation is good to have on database side.
i think like one excel spreadsheet with columns like stored procedures, then next column relevant tables then next column table 1 columns, table 2 columns and then highight primary key as yellow color and then next column joins and other related tables
please advise any other better ways and best practices and links resources on it