Skip to content

om_visit

advase edited this page Oct 26, 2022 · 3 revisions

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
Clone this wiki locally