config_visit_class - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table with basic visit class configuration
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | integer | Id | 0 |
| idval | character varying(30) | Name of class | Arc inspection |
| descript | text | Description | |
| active | boolean | If true, catalog value is being used | TRUE |
| ismultifeature | boolean | If true, many feature types can be assigned to this visit class | TRUE |
| ismultievent | boolean | If true, one class can have many parameters (events), defined on config_visit_class_x_parameter | FALSE |
| feature_type | text | Type of feature on which visit may be executed, defined on sys_feature_type | ARC |
| sys_role | character varying(30) | User's role that allows creation of a class, defined on sys_role | role_om |
| visit_type | integer | Type of visit, defined on om_typevalue as visit_type | 1 |
| param_options | json | Additional parameters of the class | |
| formname | text | User defined name of form definition, defined on config_form_fields as form_visit | visit_insp_arc |
| tablename | text | User defined name of view which is being used to insert data | ve_visit_insp_arc |
| ui_tablename | text | User defined name of view which is being used to show data | v_ui_visit_insp_arc |
| parent_id | integer | Id of parent | |
| inherit_values | json | Allows to show values from another visitclass |