Data Dictionary in Application Database is a document usually in excel sheet that elaborates the entire schema.
You need to write all tables and their columns along with their business purpose, relations, etc. You can add more details like indexes if you want.
You can also use below template
Data Dictionary - Examples | Ag Data Commons[
^]