Taken from this article:
- Primary keys are always named
id
whatever the data type is. - Timestamps are past tense, suffixed
…_at
- Date, Time, and Datetime are not timestamps, name them freely.
- Booleans are always positive and start with
is_…
- Numeric columns should be plural, like
guesses
orfailures
- Lists as JSON columns are plural, and may end with 1…_list1
- Complex JSON trees can be named freely, but may end with
…_tree