Guides
Reference notes on database design — how to read a diagram, what type a column should be, what to call things.
- ERD notation: how to read the linesCrow's foot, Barker and Chen draw the same relationship three different ways. This is what each mark means and which one to use.Read
- Choosing a column typeWhich integer, which string, which way to store money and time — with the MySQL, PostgreSQL, Oracle and SQL Server equivalents side by side.Read
- Naming tables and columnsSingular or plural, id or user_id, is_ or has_ — the conventions worth holding to, and the ones that only matter because they are consistent.Read