Skip to main content

Data Model Overview

LeBonTag uses multiple PostgreSQL schemas:

  • Application schema (lebontag)
  • OSM reference schema (osm2pgsql)
  • Routing schema (osm2pgrouting, optional)

Global schema diagram​

Data Model

Application schema (lebontag)​

Main logical domains:

Validation domain​

  • lbt_validation
  • lbt_osmshift
  • lbt_validation_history
  • lbt_state

Purpose: Track validation lifecycle and decisions.

Quality rules domain​

  • lbt_quality_rule
  • lbt_quality_rule_instance
  • lbt_quality_rule_instance_businessgroup
  • lbt_quality_processed_items

Purpose: Define and execute SQL-based quality checks.

Object grouping domain​

  • lbt_objectgroup
  • lbt_theme
  • lbt_tag
  • lbt_light
  • lbt_light_tag

Purpose: Classify OSM objects according to business logic.

Business and permissions domain​

  • lbt_businessgroup
  • lbt_user_businessgroup
  • lbt_user
  • lbt_userrole

Purpose: Control access and scope of validation.

OSM reference schema (osm2pgsql)​

Stores:

  • nodes
  • ways
  • relations
  • tags
  • geometries (PostGIS)

Used by:

  • Quality rule SQL queries
  • Map rendering
  • Validation contextual data

Routing schema (osm2pgrouting)​

Optional schema used for:

  • Network analysis
  • Connectivity validation
  • Topological checks