config_param_system - Giswater/giswater_dbmodel GitHub Wiki
Description:
Config_param_system table has all variables to define behaviour of the system. Some of them may be configured using configuration button of Giswater plugin, on tab Admin.
Variables classified in function of role:
In addition there are some usefull variables (dual variables) which may have dual value in function of the state-of-the-art of the project, in order to make easy the initial migration and after to make stable the production enviroment.
Fields:
| Column name | Data type | Description | Example | Domain values |
|---|---|---|---|---|
| parameter | character varying(50) | Name of the parameter | admin_raster_dem |
|
| value | text | Value of the parameter | FALSE |
|
| descript | text | Description | ||
| label | text | Label showed on the form | Use raster DEM for elevation values |
|
| dv_querytext | text | Query that fills in combobox and typeahead widgets in the form | ||
| dv_filterbyfield | text | Field which filters | ||
| isenabled | boolean | If true, parameter is enabled on a form | TRUE |
|
| layoutorder | integer | Widget order on a form | 1 |
|
| project_type | character varying | Project in which function is being used | ws |
[ws, ud, utils] |
| dv_isparent | boolean | If true, widget is a parent of another widget | FALSE |
|
| isautoupdate | boolean | If true, field is automatically updated, without necessity of saving data | FALSE |
|
| datatype | character varying | Data type of parameter | string |
[boolean, date, float, integer, json, string] |
| widgettype | character varying | Type of widget displayed on form | combo |
[check, combo, datetime, linetext, spinbox, text] |
| ismandatory | boolean | If true, field is mandatory and must have a value | FALSE |
|
| iseditable | boolean | If true, value is editable | TRUE |
|
| dv_orderby_id | boolean | If true, data will be ordered by id | TRUE |
|
| dv_isnullvalue | boolean | If true, empty value is allowed | TRUE |
|
| stylesheet | json | Json type field that allows graphical customization of the label | {"label":"color:red; font-weight:bold"} |
|
| widgetcontrols | json | Control of widgets | ||
| placeholder | text | Placeholder with data format | ||
| standardvalue | text | Default value of parameter | ||
| layoutname | text | Layout name in case when parameter is available on form | lyt_system |
[lyt_system, lyt_builder, lyt_review, lyt_topology] |