sys_version - Giswater/giswater_dbmodel GitHub Wiki
Description:
System table with data about all the software version updates.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | serial | Id | 1 |
| giswater | character varying(16) | Giswater version | 3.4.019 |
| project_type | character varying(16) | Project type | WS |
| postgres | character varying(512) | Postgres version | PostgreSQL 9.5.17, compiled by Visual C++ build 1800, 64-bit |
| postgis | character varying(512) | Postgis version | 2.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1 |
| date | timestamp(6) | Date of last giswater version update | 2020-08-05 11:12:12.679667 |
| language | character varying(50) | Project's language | EN |
| epsg | integer | SRID of project's geometry | 25831 |
| sample | boolean | If true, project has giswater sample dataset | TRUE |