sys_addfields - Giswater/giswater_dbmodel GitHub Wiki
Description:
System catalog of personalized fields. Addfields may be automatically created using the function gw_fct_admin_manage_addfields, which fills in the definition on this table, adds field on a child view and creates configuration on config_form_fields.
Fields:
| Column name | Data type | Description | Example | Domain values |
|---|---|---|---|---|
| id | serial | Id | 2 |
|
| param_name | character varying(50) | DB name of an addfield | outfallvalve_param_1 |
|
| cat_feature_id | character varying(30) | Name of the feature for which addfield is created, defined as id on cat_feature | OUTFALL_VALVE |
|
| is_mandatory | boolean | If true, field is mandatory and must have a value | FALSE |
|
| datatype_id | text | Data type of addfield | text |
[boolean,date,float, integer,json,string] |
| orderby | integer | Addfield order inside the child view | 1 |
|
| active | boolean | definition of how they work | TRUE |
|
| iseditable | boolean | If true, value is editable | TRUE |