I am creating a database and that i would appreciate suggestions on maintaining data that describes the tables, characteristics, etc. I'll create a Database Design Document, however i want something that may be more helpful for upgrading changes towards the database schema.
I just read an article that indicates utilizing a Data Dictionary in YAML or JSON, however i haven't found anything else regarding the subject.
My questions are: "What options to data dictionaries exist for monitoring this data?"
"Out of your professional experience, what's the easiest method to maintain this data?"
You will probably find the
comment functionality helpful, e.g.:
comment on table foo is 'some comments go here';