Mercurial > gemma
view schema/README.md @ 3003:92818da6133d
Cleanup VIEW definition
NULLS LAST is not necessary on non-nullable columns;
avoid materializing unused columns in a CTE;
use boolean value directly instead of comparing to auto-casted string;
gauge_measurements might contain not only waterlevels;
avoid unnecessary subselects.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 10 Apr 2019 18:50:20 +0200 |
parents | 85c47d63fdb9 |
children | f2f0b776ba12 |
line wrap: on
line source
The gemma database schema requires PostgreSQL >= 11. `dot.tmpl` is a template file for `postgresql_autodoc` to be more similiar to UML and leave out some less useful labels. See `../docker/README.md`