Common problems with SQL - Structure
Let's check another source of problems - structure of a table. Again, this is a very broad topic, so I'll present just one very common example, I guess you'll be able to come up with many variants.
PGMon - database structure
This article contains brief description of database structure used for the PGMon project - tables, their structure, etc.
OpenStats - database structure
Goal of this article is to describe the database structure used for OpenStats project in a nutshell (but with enough details). It contains description of individual tables and their columns, but an explanation of some seemingly illogical solutions.
1
