Database

Database configuration and conventions for DW projects.

  • Charset: utf8mb4
  • Collation: utf8mb4_general_ci
  • Engine: InnoDB (recommended)

These settings support emoji and international characters.

Standard Fields

Include these fields on most tables:

FieldTypeDescription
uuidvarchar(36)Primary identifier
created_atdatetimeCreation timestamp
updated_atdatetimeLast modification
deleted_atdatetimeSoft delete timestamp

Common Patterns

Photo Fields

photo_url VARCHAR(255),
photo_url_parameters TEXT

Content Fields

title VARCHAR(255),
slug VARCHAR(255) UNIQUE,
content TEXT,
status ENUM('draft', 'published')

Design Philosophy

Include fields you know you’ll need eventually. Soft deletes (deleted_at) are the default pattern - never hard delete data.