om_visit - Giswater/giswater_dbmodel GitHub Wiki
Description:
Main table of visit with all it's basic information.
Fields:
| Column name | Data type | Description |
|---|---|---|
| id | bigserial | Id |
| visitcat_id | integer | Id of visit catalog, defined on om_visit_cat |
| ext_code | character varying(30) | External code of visit |
| startdate | timestamp(6) without time zone | Start date of visit |
| enddate | timestamp(6) without time zone | End date of visit |
| user_name | character varying(50) | User that conducted the visit |
| webclient_id | character varying(50) | Web user that conducted the visit |
| expl_id | integer | Id of an exploitation on which visit is located, defined on exploitation |
| the_geom | geometry(Point,SRID) | Point geometry of element |
| descript | text | Description |
| is_done | boolean | If true, visit is finished |
| class_id | integer | Id of visit class, defined on config_visit_class |
| status | integer | Status of visit, which sets visits stage, defined on om_typevalue as visit_status (1 - On going, 2 - Stand by, 3 - Canceled, 4 - Closed) |
| visit_type | integer | Type of visit, defined on om_typevalue as visit_type. (1 - planned, 2 - unexpected) |
| publish | boolean | If true, visit is being published on web |
| unit_id | integer | Id of unit |
| vehicle_id | integer | Id of vehicle |