Database conventions
====================


Status
------

2026-02-25: Draft
2026-02-25: Accepted



Context
-------

Database conventions may diverge from programming language style due to the database or SQL specific syntax.



Decision
--------

- plural for table name
- UTC timezone for all date/time columns
- underscore instead of hypen
- non-nullable over nullable
- timestamp with milliseconds precision
- varchar with base 2 size
- lower case SQL queries
- lower case table/column names