database-modelling.com
Home
(current)
Articles and Guidelines
IHK final exams
Blog
Be consistent (
BE_CONSISTENT)
Modelling dynamic attributes - Blueprints for the Entity-attribute-value model (EAV) (
EAV)
Modelling bank accounts in database diagrams (
MODELLING_BANK_ACCOUNTS)
How to name table columns (
NAMING_COLUMNS)
Naming foreign keys (
NAMING_FOREIGN_KEYS)
Naming primary keys (
NAMING_PRIMARY_KEYS)
How to name database tables (
NAMING_TABLES)
No binary data in your databases (
NO_BINARY_DATA)
For larger web applications, use UUIDs as public primary keys (
PUBLIC_UUID)
Check, if your natural key can not change. (
STATIC_NATURALKEYS)
Use a surrogate key for identifying rows (
SURROGATE_KEYS)