TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

How do you document your mysql database tables and fields

2 pointsby beeover 14 years ago
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?

3 comments

madhouseover 14 years ago
There's two ways I create database tables:<p>- either I create them through an ORM, in which case I don't document the database tables or fields, I document the object instead.<p>- 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
joubertover 14 years ago
There are tools that can reverse-engineer tables (and relations). For example, Visio can do it for SQL Server databases.
one010101over 14 years ago
SQL is pretty much self-documenting. But I still use hand-drawn diagrams showing how fields are related.