visit - Giswater/giswater_dbmodel GitHub Wiki


Description:

Visit tables consists of a configuration tables with definition of visit classes and it's parameters. All the data is stored in a series of tables listed as visit tables. Each visit is being saved on om_visit table and all related parameters are saved on om_visit_event. If the event has associated photo it's url is stored on om_visit_event_photo. In the tables listed as relation tables all the relations between visit and features are saved as an id of a visit and id of a feature.

Visit tables:

Relation tables:

  • om_visit_x_arc
  • om_visit_x_connec
  • om_visit_x_gully
  • om_visit_x_node