Write your DB schema

Communicating complex ideas is always a challenge. That applies especially to technical descriptions. What if I told you I want a database that stores information from a scan? I might say there are Deb packages, users, and files, and you should store the state of each. You might ask me how they should be connected. We might spend lots of time typing back and forth, using English. But why spend that time, when “a picture is worth a thousand words”?

Behold our first attempt at documenting a database schema!

A bit small, isn't it?

Yes, that is a bit hard to read. Fear not, we used draw.io to generate XML for this schema. See instructions in our docs/README to open this file in the draw.io editor. The file you want to open is DB_Tables.xml.

Author: Kurt Yoder

Co-founder and CTO of Doveps, Inc.

Leave a Reply