- use all features from PostgreSQL or PostGIS and all their guidelines
- use
snake_case
for everything except database keywords, which should be UPPERCASE
- prefer enums over numbers, numbers over text
- enums names should be singular
- table names should be plural
- prefer IDs over
TEXT
for plants
- prefer
TEXT
over VARCHAR(n)
, don't use other variants
- prefer
UUID
as primary keys, except for tables that are not subject to concurrent use (backend creates new items)
- prefer
BIGSEQUENCE
over SEQUENCE
except for users/maps where 2 billion is obviously enough