2 ms·
How do you document your mysql database tables and fields
I was wondering how do you create documentation about a mysql database tables and fields (when building a database). Do you use any software? Or?
- madhouse 16y agoThere's two ways I create database tables: - either I create them through an ORM, in which case I don't document the database tables or fields, I document the object instead. - or I create it "by hand", in which case I use the standard comments to document the tables and the fields in my schema file
- joubert 16y agoThere are tools that can reverse-engineer tables (and relations). For example, Visio can do it for SQL Server databases.
- one010101 16y agoSQL is pretty much self-documenting. But I still use hand-drawn diagrams showing how fields are related.