30 tables. 1000+ columns.* Millions of rows. I invite anybody who thinks poker is a shallow game of chance to spend a few hours swimming through a decently-sized PokerTracker 3 database.

Now I know what you're thinking...

Is that a color-coded diagram of the PokerTracker 3 database schema in your pocket, or are you just happy to see me?

...and watch out. You already know I love diagrams, and I actually have a poster-sized version of this one hanging above my desk. I got tired of consulting the mammoth PokerTracker 3 PostgreSQL Database Schema Documentation PDF every time I needed to look up a column name (the PT3PQDBSDPDF is a great reference, but it's still a reference; a tome). I found myself wanting more of a Where's Waldo?-style cheat sheet, and I couldn't find one, so I built one and tacked it to the wall.

Feel free to download the original Visio document and, if anybody ever tells you "poker is just a gambling game," you can thwap them over the head with it (make sure to roll it up first). Said diagram might also come in handy if you do a lot of advanced/custom PokerTracker work:

Custom statistics

Fancy HUD layouts

PokerTracker programming

It's also good for wrapping fish, starting fires, creating aerodynamically superior paper airplanes, that sort of thing. Enjoy.

(By the way, if you're curious how the above diagram was generated: I installed psqlODBC, the PostgreSQL ODBC driver, created a data source, attached Microsoft Visio to that data source, and had it extract the tables. The layouting, color-coding, and annotations were performed by hand.)

* - The exact number of columns will vary from installation to installation, depending on cached statistics.