psql -U postgres -f db_setup.sql
- year column
Represents the year when the pipe has been installed. The minimum year should be 1950 and the maximum year should be the current year.
Database side constraint:
CHECK (year IS NULL OR year > 1950 AND year <= EXTRACT(YEAR FROM NOW()));
QGIS side constraint (2.16):
"year" IS NULL OR (1950 <= "year" AND "year" <= now())
Description: Install year must be between 1950 and the current year.
Possible QGIS widgets:
-
Textedit
-
Range (Editable, Slider, Dial)
-
fk_status column
Represents the functioning status of the column.
Possible QGIS widgets:
- Value Map
- Value relation
...
Constraints on widgets since QGIS 2.16 http://qgis.org/en/site/forusers/visualchangelog216/#feature-constraints-on-widgets
Default values on widgets since QGIS 2.18.