om_visit_event - Giswater/giswater_dbmodel GitHub Wiki
Description:
Table of events, where value of each event parameter is stored.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | bigserial | Id | |
| event_code | character varying(16) | External code of visit | |
| visit_id | bigint | Id of visit related to events, defined on om_visit | |
| position_id | character varying(50) | ||
| position_value | double precision | ||
| parameter_id | character varying(50) | Id of event parameter, defined on config_visit_parameter | |
| value | text | Value of the parameter | |
| value1 | integer | Additional value of parameter | |
| value2 | integer | Additional value of parameter | |
| geom1 | double precision | ||
| geom2 | double precision | ||
| geom3 | double precision | ||
| xcoord | double precision | ||
| ycoord | double precision | ||
| compass | double precision | ||
| tstamp | timestamp(6) without time zone | ||
| text | text | Description | |
| index_val | smallint | ||
| is_last | boolean | If true, value is the last evetn |