Databasegebruik en relaties

CONFIRMED: 36 gebruikte tabelobjecten onderzocht in de live public-catalogus via XLS::Base en een expliciete read-only transactie op 3 oktober 2026. Geen bedrijfsrijen of credentialwaarden opgenomen. Volledige metadata. Schema bewijst veld/constraint-aanwezigheid, niet dat iedere codeflow in productie gebruikt wordt.

scoped_customers en scoped_pakbon zijn CTE's, geen views/tabellen. DBI-handle komt van Base; querywaarden worden vrijwel overal gebonden, dynamische IN-lijsten gebruiken placeholders. De lokale routeplan- en source-reference-migraties zijn gelezen, niet uitgevoerd.

Voor alle tabellen behalve de stop/pakbon-koppeling is PK id; voor die koppeling (lmf_stop, leverancier_pakbon). Hieronder staan daadwerkelijk aanwezige FK/UNIQUE/CHECK-constraints, los van codejoins. De kolomlijsten zijn volledig, zodat SELECT *-gebruik niet wordt verborgen; alleen logistiek relevante velden zijn inhoudelijk verklaard.

Code-afgeleide relaties

• leverancier vertegenwoordigt supplier/HUB/carrier; pakbon.leverancier/hub/transporteur en vers_order-equivalenten worden daarop betrokken.
• klant → lokatie via lokatie.klant; klant.marktplaats → marktplaats; user klant_id/leverancier_id naar account/partij. GUID's zijn API-lookupwaarden, geen vervanging voor numerieke FK's.
• vers_order → order_regel; product → productgroep. Pakbon.vers_order verbindt order aan uitvoering, maar LMF-pakbonnen kunnen zonder order voorkomen.
• pakbon → regels/footer/emballage/bevestigingen; verpakkingartikel bij leverancier; HUB-/stopregistraties hebben eigen nullable bron-FK's.
• route → route_lokatie; actieve user.route selecteert vaste route. Stop-string is softwareconventie, geen FK naar lmf_stop.
• lmf_route → lmf_stop → lmf_stop_leverancier_pakbon is het afzonderlijke importerpad; lmf_route hoort bij project/route/date/carrier.

Waar hieronder een FK ontbreekt maar code een join maakt, is de relatie code-afgeleid, niet als databaseconstraint bewezen. Een UNIQUE op een technisch ID garandeert geen unieke registratie per bedrijfssleutel. Zie packaging-flow voor updatekeys.

Per object

domain

Branding van de apphostname; title/logo/favicon/achtergrond/naam.

• SELECT-callers: XLSLMFHandler.pm::handler.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | title | character varying | YES | | logo | character varying | YES | | host | character varying | YES | | achtergrond | character varying | YES | | size | character varying | YES | | favicon | character varying | YES | | footer_logo | character varying | YES | | stylesheet | character varying | YES | | oneliner | character varying | YES |

</details>

klant

Klantaccount en marktplaats/actief/public; relatiehouder van locaties.

• SELECT-callers: XLS/LMF.pm::_dash_marketplace_scope; XLS/LMF.pm::dash_customers; XLS/LMF.pm::dash_route_customers; XLS/LMF.pm::dash_suppliers; XLS/LMF.pm::dash_orders; XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records; XLS/LMF.pm::klant; XLS/LMF.pm::hub; XLS/LMF.pm::leverancier_lokaties; RoutePlanImporter.pm::_marketplace_route_supplier_for_customer_stops.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (ambassadeur) REFERENCES ambassadeur(id)
  • FOREIGN KEY (cluster) REFERENCES cluster(id) NOT VALID
  • PRIMARY KEY (id)
  • FOREIGN KEY (vereniging) REFERENCES vereniging(id)
  • FOREIGN KEY (webapp_opstelling) REFERENCES webapp_opstelling(id) NOT VALID
  • FOREIGN KEY (marktplaats) REFERENCES marktplaats(id) NOT VALID
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | debiteurnummer | character varying | NO | | adres | character varying | YES | | postcode | character varying | YES | | plaats | character varying | YES | | telefoon | character varying | YES | | fax | character varying | YES | | email | character varying | YES | | contactpersoon | character varying | YES | | eigen_artikelnummers | boolean | NO | | actief | boolean | NO | | ambassadeur | integer | YES | | taalkeuze | boolean | YES | | business_dashboard | boolean | NO | | email_nieuwe_producten | character varying | YES | | email_administratie | character varying | YES | | recept_beheer | boolean | YES | | assortiment_per_lokatie_type | boolean | NO | | vereniging | integer | YES | | logo | character varying | YES | | stylesheet | character varying | YES | | vereniging_style | boolean | YES | | eigen_assortiment | boolean | YES | | balans_module | boolean | YES | | uitzonderingen | boolean | YES | | automatische_factuur_controle | boolean | YES | | automatische_pakbon_controle | boolean | YES | | haccp | boolean | YES | | procuratie | boolean | YES | | footer_logo | character varying | YES | | samengevoegde_ppl_per_leverancier | boolean | NO | | budget_tool | boolean | YES | | afdelingen | boolean | YES | | banqueting | boolean | NO | | leverancier | boolean | NO | | afnemer | boolean | NO | | factuur_naam | character varying | YES | | factuur_contact | character varying | YES | | factuur_email | character varying | YES | | marketing | boolean | NO | | externe_omzet_rapportage | boolean | YES | | live | boolean | NO | | alleen_banqueting | boolean | YES | | balans_op_laatste_vrijdag | boolean | NO | | balans_accorderen | boolean | YES | | open_verkoopprijs | boolean | NO | | background_color | character varying | YES | | email_uitzonderingen | character varying | YES | | afleverdatum | smallint | YES | | bq_order_wijzigen | boolean | NO | | btw_factuur | boolean | NO | | automatische_incasso | boolean | NO | | leverancier_kiezer | boolean | NO | | omzet_dashboard | boolean | NO | | facilitair | boolean | NO | | taalkeuze_in_banqueting | boolean | NO | | banqueting_po_number | boolean | NO | | haccp_checklist | boolean | NO | | banqueting_administratie | boolean | NO | | hub_logistiek | boolean | NO | | fout_marge_in_facturatie | double precision | YES | | partner | integer | YES | | toon_bonus_product | boolean | NO | | account | boolean | NO | | bestel_verkoopartikel | boolean | NO | | factureer_bq_vanuit_ed | boolean | NO | | voorraad_beheer | boolean | NO | | bestel_advies | boolean | NO | | algemene_taken | boolean | NO | | keukenprinters | boolean | NO | | alleen_banqueting_locaties | boolean | NO | | vertalingen | boolean | NO | | open_bq_artikel | boolean | NO | | vrije_verstrekking | boolean | NO | | auto_incasso | boolean | NO | | bezorging | boolean | NO | | btw_rapportage | boolean | NO | | factuur_kenmerk | character varying | YES | | bq_ruimte | boolean | NO | | aanbiedingen | boolean | NO | | officeapp | boolean | NO | | bestellen_vanuit_recepturen | boolean | NO | | menucycli | boolean | NO | | marge_in_artikelomzet | boolean | NO | | rapportage_per_email | boolean | NO | | gln | character varying | YES | | recepten_op_alle_lokaties | boolean | NO | | auto_post_facturen | boolean | NO | | url | character varying | YES | | notifications | boolean | NO | | alle_locaties_bij_bestellers | boolean | NO | | personeels_korting | boolean | NO | | bq_levertijd_per_product | boolean | NO | | domain | character varying | YES | | oneliner | character varying | YES | | verstuur_email_als_klant | boolean | NO | | url_voor_ed | character varying | YES | | bq_url_voor_ed | character varying | YES | | guid | uuid | YES | | ticketing | boolean | NO | | marktplaats | integer | YES | | order_met_levertijd_doorzetten | boolean | YES | | contracten | boolean | NO | | lat_lng | character varying | YES | | individueel | boolean | NO | | zakelijk | boolean | NO | | besteldichtbij | boolean | NO | | redactie | boolean | NO | | bq_po_numbers | boolean | NO | | cost_centers | boolean | NO | | whapapi | boolean | NO | | webshop | boolean | NO | | relatie_code | character varying | YES | | intro | character varying | YES | | online_betalen | boolean | NO | | online_betalen_live | boolean | NO | | minimum_order_bedrag_besteldichtbij | double precision | YES | | bezorgkosten_besteldichtbij | double precision | YES | | shop_url | character varying | YES | | keywords | character varying | YES | | robots_txt | character varying | YES | | omschrijving_seo | character varying | YES | | google_tag | character varying | YES | | service | smallint | YES | | gln_voor_locaties | boolean | NO | | one_user_form | boolean | YES | | tasty_dish | boolean | NO | | edi_mail | character varying | YES | | block_tijden | boolean | NO | | order_per_leverancier_verzenden | boolean | NO | | edifact | boolean | NO | | alternatief_bij_uitzonderingen | boolean | NO | | e_dish | boolean | NO | | toon_intro | boolean | YES | | website_intro | character varying | YES | | max_verschil_in_facturatie | integer | YES | | verzendkosten | boolean | NO | | bereken_btw | boolean | NO | | toon_artikelnummer | boolean | NO | | theme_color | character varying | YES | | vending | boolean | NO | | sysop_email | character varying | YES | | pakbon_ok | boolean | NO | | shopapp | boolean | NO | | help | boolean | NO | | beukk | boolean | NO | | factuur_bv | smallint | NO | | foodsy | boolean | NO | | aanmeld_formulier | boolean | NO | | easy_factuur | boolean | YES | | promovideo | boolean | YES | | externe_orders_op_de_kassa | boolean | YES | | das | boolean | YES | | signup | boolean | YES | | public | boolean | YES | | app_url | character varying | YES | | algemene_voorwaarden | character varying | YES | | favicon | character varying | YES | | css_variabelen | character varying | YES | | public_webshop | boolean | NO | | kortingen | boolean | NO | | statiegeld | boolean | NO | | leveranciers_button | boolean | NO | | pin_payment | boolean | YES | | whatsapp | character varying | YES | | bezorgen | boolean | YES | | afhalen | boolean | YES | | landings_pagina | boolean | YES | | faq | boolean | YES | | sms | boolean | YES | | nix18 | boolean | YES | | assortiment_laatste_update | timestamp without time zone | NO | | leverancier_slider | boolean | NO | | test_modus | boolean | NO | | product_themas | boolean | NO | | bereken_verkoopprijs | boolean | YES | | meest_besteld | boolean | YES | | nieuwe_producten | boolean | YES | | main_category_names | boolean | NO | | subgroup_name_only | boolean | NO | | use_logo_as_home_title | boolean | YES | | shop_open | boolean | YES | | dicht_omdat | character varying | YES | | zoom_map | smallint | NO | | bestellen_tot_weekdag | smallint | NO | | css_beheer | boolean | YES | | postcode_check_voor_bezorgen | boolean | YES | | distributie_via_dc | boolean | YES | | mollie | boolean | YES | | zalen | boolean | YES | | nieuwsbrief | boolean | YES | | samples | boolean | YES | | binnenkort_beschikbaar | boolean | YES | | voorpagina_producten | boolean | YES | | telegram | character varying | YES | | homepage_news | boolean | YES | | news_slider | boolean | YES | | news_button_app | smallint | YES | | type | smallint | YES | | upload_pdf_factuur | boolean | YES | | titel_meest_besteld | character varying | YES | | zoek_met_allergenen | boolean | YES | | image_placeholder | smallint | NO | | toon_webshop_prijzen | boolean | YES | | beukk_code | boolean | YES | | postcode_check_when_logged_in | boolean | YES | | use_name_email_phone_form_when_logged_in | boolean | YES | | confirm_order_when_logged_in | boolean | YES | | beukk_zakelijk | boolean | YES | | lev_lijst | boolean | YES | | print_product_pagina | boolean | YES | | beukk_bank | boolean | YES | | klant_debiteurnummer | bigint | NO | | factuur_nummer | bigint | YES | | customer_apps | boolean | YES | | multilingual | boolean | YES | | bezorg_op_alle_postcodes | boolean | YES | | recent_besteld | boolean | YES | | max_bestellingen_per_week | integer | YES | | bankrelatie | character varying | YES | | bankrekening_nummer | character varying | YES | | ppls_on_homepage | boolean | YES | | about_us | boolean | YES | | eetgemak | boolean | YES | | gebruik_behang | boolean | YES | | order_history_on_homepage | boolean | YES | | cluster | bigint | NO | | fsp_control | boolean | YES | | webapp_notifications | boolean | YES | | demo | boolean | YES | | banqueting_app | boolean | YES | | factuur_per | smallint | NO | | factuur_adres | character varying | YES | | factuur_postcode | character varying | YES | | factuur_plaats | character varying | YES | | background_image | character varying | YES | | menukaart | boolean | YES | | webapp_opstelling | bigint | YES | | beukk_assortiment | boolean | YES | | minimum_order_bedrag_voor_bezorgen | double precision | YES | | trunckrs | boolean | YES | | betalen_na_inloggen | boolean | NO | | htmx | boolean | YES | | lmf | boolean | YES | | voorraad_op_hub | boolean | YES | | menu_stijl | smallint | YES | | budget_blokker | boolean | YES | | inladen_pdf_bestelling | boolean | YES | | plantgoed_voedsel | smallint | YES | | bestelstylesheet | character varying | YES | | salaris_module | boolean | NO | | week_bestelling | boolean | NO | | kvk_nr | character varying | YES | | btw_nr | character varying | YES | | budget_producten | boolean | NO | | email_klantenservice | character varying | YES | | assortiment_filter | boolean | NO | | hub_logo | boolean | NO | | co2_dashboard | boolean | YES | | altijd_bezorgkosten | boolean | NO | | adres_op_factuur | smallint | NO | | chatbot | boolean | NO | | zaal_order | boolean | NO |

</details>

klant_koppeling

Klantconfig in XML, onder meer koppeling30 public key.

• SELECT-callers: XLS/LMF.pm::klant.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (klant) REFERENCES klant(id)
  • FOREIGN KEY (koppeling) REFERENCES koppeling(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | klant | integer | YES | | koppeling | integer | YES | | definitie_in_xml | character varying | YES | | actief | boolean | NO |

</details>

leverancier

Supplier, HUB én vervoerder; naam/adres/coords, capability- en navigatie/configflags.

• SELECT-callers: XLS/LMF.pm::hub_customer_products; XLS/LMF.pm::hub_suppliers; XLS/LMF.pm::hub_orders; XLS/LMF.pm::dash_suppliers; XLS/LMF.pm::dash_orders; XLS/LMF.pm::hub_routes; XLS/LMF.pm::lokatie_hub; XLS/LMF.pm::hub_incoming; XLS/LMF.pm::next_stop; XLS/LMF.pm::stops; XLS/LMF.pm::return_packaging; XLS/LMF.pm::new_supplier_deliveries; XLS/LMF.pm::next_logistics_delivery; XLS/LMF.pm::logistics_pickup; XLS/LMF.pm::logistics_delivery; XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::customer_delivery; XLS/LMF.pm::_preload_location_partners; XLS/LMF.pm::_preload_suppliers_by_id; XLS/LMF.pm::_preload_basic_suppliers_by_location_date; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records; XLS/LMF.pm::klant; XLS/LMF.pm::hub; XLS/LMF.pm::leverancier_lokaties; XLS/LMF.pm::leverancier; XLS/LMF.pm::logistiek; XLS/LMF.pm::_logistics_route_planning; EmballageControl.pm::_stop_rows; RoutePlanImporter.pm::_all_supplier_ids_exist.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (assortiment_formaat) REFERENCES assortiment_formaat(id)
  • FOREIGN KEY (erp_pakket) REFERENCES erp_pakket(id) NOT VALID
  • FOREIGN KEY (klant) REFERENCES klant(id) NOT VALID
  • FOREIGN KEY (marktplaats) REFERENCES marktplaats(id)
  • FOREIGN KEY (leverancier_partner) REFERENCES leverancier_partner(id)
  • PRIMARY KEY (id)
  • FOREIGN KEY (vereniging) REFERENCES vereniging(id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | adres | character varying | NO | | postcode | character varying | NO | | plaats | character varying | NO | | telefoon | character varying | NO | | email | character varying | NO | | fax | character varying | YES | | url | character varying | YES | | actief | boolean | NO | | code | character varying | NO | | order_formaat | character varying | YES | | assortiment_formaat | integer | NO | | order_verslag | character varying | YES | | pakbon_formaat | character varying | YES | | factuur_formaat | character varying | YES | | order_mail | character varying | YES | | bevestiging_mail | character varying | YES | | gln | character | YES | | label | character varying | YES | | laatste_bestelling | time without time zone | YES | | verwerking | smallint | YES | | display_name | boolean | YES | | product_url_website | character varying | YES | | grootboekrekening | character varying | YES | | volgorde_op_factuur | integer | YES | | email_facturatie | character varying | YES | | in_statistiek | boolean | YES | | achtergrond | integer | YES | | hoofdgroepen | boolean | NO | | gewichts_artikelen | boolean | NO | | domain | character varying | YES | | manage_assortment | boolean | YES | | use_merk | boolean | YES | | use_verpakking | boolean | YES | | order_notifier | boolean | YES | | dashboard | boolean | YES | | logo | character varying | YES | | check_voorraad | boolean | NO | | bestel_zelfde_dag | boolean | YES | | mail_sender | character varying | YES | | order_per_email | boolean | YES | | order_referenties | boolean | YES | | textregel_per_orderregel | boolean | YES | | manage_bestellers | boolean | YES | | email_administratie | character varying | YES | | niet_in_weekend | boolean | YES | | bestel_uitzonderingen | boolean | NO | | minimum_order_bedrag | integer | YES | | levering_door_partner | boolean | YES | | leverancier_partner | integer | YES | | invoeren_bestellingen | boolean | YES | | manage_partner_assortiment | boolean | YES | | productie | boolean | YES | | route_planning | boolean | YES | | beheer | boolean | NO | | uploaden_assortiment_bestand | boolean | YES | | easy_pakbon | boolean | YES | | easy_factuur | boolean | YES | | kvk_nummer | character varying | YES | | pakbon_directory | character varying | YES | | laatste_bestelling_uitzonderingen | time without time zone | YES | | easy_korting | boolean | NO | | hub | boolean | NO | | banqueting_partner | boolean | YES | | notitie_bij_order | boolean | YES | | contact_persoon | character varying | YES | | webshop_look | boolean | NO | | rechten_voor_medewerkers | boolean | NO | | grootboekrekening_inkoop | character varying | YES | | grootboekrekening_verkoop | character varying | YES | | edi | boolean | NO | | check_order | boolean | NO | | leverancier_kiezer | boolean | YES | | intro | character varying | YES | | leverancier_categorie | integer | YES | | guid | uuid | YES | | live | boolean | NO | | factuur_nummer | integer | NO | | pakbon_printen_zonder_prijs | boolean | NO | | zigzagger | boolean | NO | | vereniging | integer | YES | | pakbon_vandaag_voor_morgen | boolean | NO | | pakbon_vrijdag_voor_maandag | boolean | NO | | maak_inkoop_orders | boolean | NO | | annuleren_banqueting_orders | boolean | NO | | btw_nummer | character varying | YES | | bankrelatie | character varying | YES | | bankrekening_nummer | character varying | YES | | titel | character varying | YES | | betaling_condities | character varying | YES | | banqueting_order_aan | boolean | NO | | voorraad_bij_partner | boolean | NO | | login_per_locatie | boolean | NO | | voorraad_mail | character varying | YES | | excel_assortiment | boolean | NO | | email_voor_aanmeldingen | character varying | YES | | assortiment_csv | boolean | YES | | breed_in_kiezer | boolean | NO | | alle_marktplaatsen | boolean | NO | | verberg_prijzen_op_hub | boolean | NO | | text4locals | character varying | YES | | foto | character varying | YES | | api_services | boolean | NO | | api_key | uuid | YES | | assortiments_hub | boolean | NO | | kleuren | boolean | NO | | maten | boolean | NO | | maps_coordinaten | character varying | YES | | woo_id | integer | YES | | transport_goederen_pakbon | boolean | NO | | latitude | character varying | YES | | longitude | character varying | YES | | woo_hub | boolean | YES | | via_hub | boolean | NO | | prijslijsten | boolean | NO | | symbool | character varying | YES | | afhaalpunt | boolean | NO | | order_mail_naar_ed | boolean | NO | | toon_hele_assortiment_in_beheer | boolean | YES | | voorraad_in_woo | boolean | NO | | qrcode_op_pakbon | boolean | NO | | basis_menu | boolean | NO | | anonimiseren | boolean | NO | | marktplaats | integer | YES | | warehouse | boolean | NO | | print_rfid_labels | boolean | NO | | beukk | boolean | YES | | factureer_vanuit_ed | boolean | NO | | code_vervoerder | character varying | YES | | positioning | boolean | YES | | order_mail_per_afleverdag | boolean | YES | | ip_label_printer | character varying | YES | | recepturen | boolean | YES | | das | boolean | YES | | promo_video | boolean | YES | | woo_commerce | boolean | YES | | klant | bigint | YES | | aanbiedingen | boolean | YES | | das_inschrijver | boolean | YES | | prijs_invoer | smallint | NO | | marge_percentage | smallint | NO | | vooraankondiging | boolean | YES | | leverschema | boolean | YES | | crediteurnummer | character varying | YES | | voorraad_in_warehouse | boolean | YES | | print_labels | boolean | YES | | prijs_per_marktplaats | boolean | NO | | max_bezorgingen_per_dag | smallint | NO | | stylesheet | character varying | YES | | vervoerder | boolean | YES | | faq | boolean | YES | | about_us | boolean | YES | | lijst_per_temperatuur_zone | boolean | YES | | redactie | boolean | YES | | anoniem_afhaalpunt | boolean | YES | | uploaden_pdf_factuur | boolean | YES | | geheim_afhaalpunt | boolean | YES | | beukk_code | boolean | YES | | automatisch_artikelnummer | boolean | YES | | onderhoud_assortiment | boolean | NO | | onderhoud_prijzen | boolean | NO | | mail_message | character varying | YES | | maak_facturen | boolean | YES | | marketing | boolean | YES | | wijzig_pakbon | boolean | YES | | beukk_vragen | boolean | NO | | ontvang_beukk_nieuwsbrief | boolean | YES | | manage_leverancier_kiezer | smallint | YES | | auto_emballage | boolean | YES | | producent | boolean | YES | | bereken_transport_kosten | boolean | YES | | business_web_app | boolean | YES | | handtekening | boolean | YES | | chauffeur_navigatie | boolean | YES | | prijsberekening | smallint | YES | | favicon | character varying | YES | | order_aankondiging | boolean | YES | | lijst_met_bestellers | boolean | YES | | order_indeling | boolean | YES | | orders_in_lmf | boolean | YES | | lmf_dashboard | boolean | YES | | lmf | boolean | YES | | bevestig_pakbon | boolean | YES | | open_pakbon | boolean | YES | | plus_inkoop_lijst | boolean | YES | | ophalen_op_maandag | boolean | YES | | ophalen_op_dinsdag | boolean | YES | | ophalen_op_woensdag | boolean | YES | | ophalen_op_donderdag | boolean | YES | | ophalen_op_vrijdag | boolean | YES | | ophalen_op_zaterdag | boolean | YES | | ophalen_op_zondag | boolean | YES | | skall_id | character varying | YES | | verzamelorder | boolean | YES | | prijs_menu | boolean | YES | | footer_logo | character varying | YES | | factuur_footer | character varying | YES | | beukk_bank | boolean | NO | | factuur_naam | character varying | YES | | onderhoud_beukk | boolean | YES | | vangogh | boolean | YES | | voorraad_van_partner | boolean | YES | | manage_instellingen | boolean | NO | | nutriscore | boolean | NO | | zebra_printer | boolean | YES | | inkoop_hub | boolean | YES | | voorraad_hub | boolean | YES | | auto_klant_prijs | boolean | YES | | manage_seo | boolean | YES | | inkoop_assortiment_van_leveranciers | boolean | YES | | huisnummer | smallint | YES | | toevoeging | character varying | YES | | order_na_bevestiging | boolean | YES | | alternatieve_producten | boolean | YES | | voertuigen | boolean | NO | | akkoord_met_facturen | boolean | YES | | transactie_email | boolean | NO | | teler | boolean | YES | | voorbeeld_producten | boolean | YES | | pgs | boolean | NO | | manage_klant_ppl | boolean | YES | | manage_product_alternatieven | boolean | YES | | app_url | character varying | YES | | order_mail_bevestigd | boolean | YES | | bestel_aankondiging_dagen | smallint | NO | | factuur_adres | character varying | YES | | factuur_postcode | character varying | YES | | factuur_plaats | character varying | YES | | leverancier_htmx_inkoop_module | boolean | NO | | erp_pakket | bigint | YES |

</details>

leverancier_apikey

Integratiesleutel bij leverancier/naam; alleen metadata beschreven.

• SELECT-callers: XLS/LMF.pm::leverancier.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | bigint | NO | | naam | character varying | NO | | key | uuid | NO |

</details>

leverancier_emballage_artikel

Artikelcatalogus, leverancier/code/omschrijving/prijs/maten/volume/gewicht/volgorde.

• SELECT-callers: XLS/LMF.pm::assignment; XLS/LMF.pm::new_supplier_delivery; XLS/LMF.pm::update_supplier_delivery; XLS/LMF.pm::_preload_package_catalogs; XLS/LMF.pm::_preload_registration_details_by_entity_date; XLS/LMF.pm::_preload_dash_registration_details_by_entity_date; XLS/LMF.pm::_preload_guid_packages; XLS/LMF.pm::_preload_delivery_packages; XLS/LMF.pm::_preload_packaging; XLS/LMF.pm::emballage_artikelen_hub; XLS/LMF.pm::klant; XLS/LMF.pm::hub; XLS/LMF.pm::leverancier_emballage_artikelen; EmballageControl.pm::_packing_rows; EmballageControl.pm::_hub_rows; EmballageControl.pm::_stop_rows.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | integer | NO | | code | character varying | YES | | omschrijving | character varying | YES | | prijs | double precision | YES | | volgorde | integer | YES | | gtin | character varying | YES | | gs1_code | character varying | YES | | transport | boolean | NO | | lengte | smallint | YES | | breedte | smallint | YES | | hoogte | double precision | YES | | gewicht | integer | YES | | volume | double precision | YES | | draagcapaciteit | double precision | YES | | actief | boolean | YES | | stam_artikel | boolean | NO |

</details>

leverancier_emballage_registratie

HUB-waarnemingen: supplier of locatie, hub, datum, artikel/kvd, inkomend/uitgaand, bevestigd, actor en bronlinks.

• SELECT-callers: XLS/LMF.pm::_preload_registration_details_by_entity_date; XLS/LMF.pm::_preload_dash_registration_details_by_entity_date; EmballageControl.pm::_hub_rows.
• Schrijvers: XLS/LMF.pm::assignment [INSERT INTO]; XLS/LMF.pm::hub_incoming_deliveries [INSERT INTO/UPDATE]; XLS/LMF.pm::hub_outgoing_deliveries [INSERT INTO/UPDATE].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier_emballage_artikel) REFERENCES leverancier_emballage_artikel(id)
  • FOREIGN KEY (hub) REFERENCES leverancier(id)
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (leverancier_pakbon) REFERENCES leverancier_pakbon(id) ON DELETE RESTRICT
  • FOREIGN KEY (lokatie) REFERENCES lokatie(id) NOT VALID
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | bigint | YES | | hub | bigint | NO | | leverancier_emballage_artikel | bigint | NO | | datum | date | NO | | inkomend | integer | NO | | uitgaand | integer | NO | | lokatie | bigint | YES | | kvd | smallint | YES | | lmf_user | bigint | NO | | bevestigd | boolean | YES | | leverancier_pakbon | bigint | YES | | levering | character varying | YES |

</details>

leverancier_emballage_registratie_stop

Chauffeurwaarneming: partij, timestamp, artikel/kvd, opgehaald/afgeleverd, actor, stop_id, pakbon.

• SELECT-callers: XLS/LMF.pm::next_stop; XLS/LMF.pm::stops; EmballageControl.pm::_stop_rows.
• Schrijvers: XLS/LMF.pm::delivery_stop [INSERT INTO/UPDATE]; XLS/LMF.pm::pickup_stop [INSERT INTO/UPDATE].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier_emballage_artikel) REFERENCES leverancier_emballage_artikel(id)
  • FOREIGN KEY (hub) REFERENCES leverancier(id)
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (leverancier_pakbon) REFERENCES leverancier_pakbon(id) ON DELETE RESTRICT
  • FOREIGN KEY (lokatie) REFERENCES lokatie(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | bigint | YES | | lokatie | bigint | YES | | hub | bigint | YES | | datum | timestamp without time zone | NO | | leverancier_emballage_artikel | bigint | NO | | opgehaald | integer | NO | | afgeleverd | integer | NO | | lmf_user | bigint | NO | | kvd | smallint | YES | | stop_id | character varying | YES | | leverancier_pakbon | bigint | YES |

</details>

leverancier_koppeling

XML-config/prompt/notificaties bij supplier; koppelingen30/31/32.

• SELECT-callers: XLS/LMF.pm::leverancier.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (koppeling) REFERENCES koppeling(id)
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | integer | YES | | koppeling | integer | YES | | definitie_in_xml | character varying | YES | | actief | boolean | NO |

</details>

leverancier_marktplaats

Supplier-toegang tot marktplaats; LMF-scope leest supplier/marktplaats, niet compleet_assortiment.

• SELECT-callers: XLS/LMF.pm::_dash_supplier_marketplaces; XLS/LMF.pm::logistics_deliveries; RoutePlanImporter.pm::_routes_by_name_for_transporteur_marketplaces; RoutePlanImporter.pm::_marketplace_route_supplier_for_customer_stops.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (marktplaats) REFERENCES marktplaats(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | marktplaats | integer | NO | | leverancier | integer | NO | | woo_id | integer | YES | | logistieke_hub | boolean | YES | | standaard_aan | boolean | YES | | compleet_assortiment | boolean | NO |

</details>

leverancier_pakbon

Logistieke bronheader: order, supplier/location/hub/carrier, guid/levering, lever_datum, status/acceptatie.

• SELECT-callers: XLS/LMF.pm::hub_orders; XLS/LMF.pm::dash_orders; XLS/LMF.pm::hub_routes; XLS/LMF.pm::assignment; XLS/LMF.pm::_emballage_source_reference; XLS/LMF.pm::hub_incoming; XLS/LMF.pm::hub_outgoing; XLS/LMF.pm::delivery_stop; XLS/LMF.pm::pickup_stop; XLS/LMF.pm::next_stop; XLS/LMF.pm::stops; XLS/LMF.pm::return_packaging; XLS/LMF.pm::accept_new_delivery; XLS/LMF.pm::confirm_delivery; XLS/LMF.pm::new_supplier_delivery; XLS/LMF.pm::update_supplier_delivery; XLS/LMF.pm::new_supplier_deliveries; XLS/LMF.pm::next_logistics_delivery; XLS/LMF.pm::logistics_pickup; XLS/LMF.pm::logistics_delivery; XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::customer_delivery; XLS/LMF.pm::customer_deliveries; XLS/LMF.pm::supplier_deliveries; XLS/LMF.pm::_preload_locations_by_supplier_date; XLS/LMF.pm::_preload_basic_suppliers_by_location_date; XLS/LMF.pm::_preload_guid_packages; XLS/LMF.pm::_preload_delivery_packages; XLS/LMF.pm::_preload_packaging; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records; XLS/LMF.pm::keana_webhook; EmballageControl.pm::_packing_rows; EmballageControl.pm::_hub_rows; EmballageControl.pm::_stop_rows; RoutePlanImporter.pm::_source_rows.
• Schrijvers: XLS/LMF.pm::assignment [INSERT INTO]; XLS/LMF.pm::stops [UPDATE]; XLS/LMF.pm::accept_new_delivery [UPDATE]; XLS/LMF.pm::new_supplier_delivery [INSERT INTO]; XLS/LMF.pm::new_supplier_deliveries [UPDATE]; XLS/LMF.pm::next_logistics_delivery [UPDATE]; XLS/LMF.pm::logistics_delivery [UPDATE]; XLS/LMF.pm::logistics_deliveries [UPDATE]; XLS/LMF.pm::customer_delivery [UPDATE]; XLS/LMF.pm::customer_deliveries [UPDATE]; XLS/LMF.pm::supplier_deliveries [UPDATE].
• Constraints (catalogus):
  • FOREIGN KEY (beukk_factuur) REFERENCES beukk_factuur(id) NOT VALID
  • FOREIGN KEY (hub) REFERENCES leverancier(id) NOT VALID
  • FOREIGN KEY (hub) REFERENCES leverancier(id) NOT VALID
  • FOREIGN KEY (leverancier_factuur) REFERENCES leverancier_factuur(id) NOT VALID
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (lokatie) REFERENCES lokatie(id)
  • PRIMARY KEY (id)
  • FOREIGN KEY (vers_order) REFERENCES vers_order(id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | integer | NO | | lokatie | integer | NO | | datum | timestamp without time zone | NO | | klant_nummer | integer | YES | | factuur_nummer | character varying | YES | | lever_datum | date | NO | | vers_order | integer | YES | | vestiging_nummer_leverancier | ARRAY | YES | | vestiging_naam_leverancier | character varying | YES | | nieuw | boolean | NO | | status | smallint | YES | | file | character varying | YES | | besteller | integer | YES | | controle_datum | timestamp without time zone | YES | | opmerkingen | character varying | YES | | hm | boolean | NO | | factuur_nummer_in_boekhouding | character varying | YES | | verwerkt_in_voorraad | boolean | NO | | guid | uuid | YES | | via_hub | boolean | NO | | hub | bigint | YES | | edifact_status | smallint | NO | | transport_goederen | boolean | NO | | transporteur | bigint | YES | | beukk_factuur | bigint | YES | | levering | uuid | YES | | status_levering | smallint | NO | | lmf_levering | boolean | YES | | geaccepteerd | timestamp without time zone | YES | | afgeleverd | timestamp without time zone | YES | | leverancier_factuur | bigint | YES | | opgehaald | timestamp without time zone | YES | | hub_in | timestamp without time zone | YES | | hub_uit | timestamp without time zone | YES | | verzonden | boolean | YES | | transport_status | smallint | NO |

</details>

leverancier_pakbon_emballage

Wijzigbare hoeveelheden per pakbon/artikel/kvd volgens leverancier/klant; geen actor/tijd.

• SELECT-callers: XLS/LMF.pm::_preload_guid_packages; XLS/LMF.pm::_preload_delivery_packages; EmballageControl.pm::_packing_rows.
• Schrijvers: XLS/LMF.pm::confirm_delivery [INSERT INTO/UPDATE]; XLS/LMF.pm::new_supplier_delivery [INSERT INTO/UPDATE]; XLS/LMF.pm::update_supplier_delivery [INSERT INTO/UPDATE].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier_emballage_artikel) REFERENCES leverancier_emballage_artikel(id)
  • FOREIGN KEY (leverancier_pakbon) REFERENCES leverancier_pakbon(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier_pakbon | integer | NO | | leverancier_emballage_artikel | integer | NO | | geleverd | integer | YES | | retour | integer | YES | | geleverd_volgens_leverancier | integer | YES | | retour_volgens_leverancier | integer | YES | | kvd | smallint | YES | | ontvangen | integer | YES | | verstuurd | integer | YES |

</details>

leverancier_pakbon_footer

Pakbontotalen, LMF schrijft vooral totaal_emballage_bedrag.

• SELECT-callers: geen directe read gevonden.
• Schrijvers: XLS/LMF.pm::assignment [INSERT INTO]; XLS/LMF.pm::new_supplier_delivery [INSERT INTO/UPDATE]; XLS/LMF.pm::update_supplier_delivery [UPDATE].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier_pakbon) REFERENCES leverancier_pakbon(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier_pakbon | integer | NO | | totaal_netto_regel_bedrag | double precision | NO | | grondslag_bedrag_btw_laag | double precision | NO | | grondslag_bedrag_btw_hoog | double precision | NO | | grondslag_bedrag_btw_nul | double precision | NO | | btw_percentage_laag | double precision | NO | | btw_percentage_hoog | double precision | NO | | btw_bedrag_laag | double precision | NO | | btw_bedrag_hoog | double precision | NO | | totaal_btw_bedrag | double precision | NO | | totaal_emballage_bedrag | double precision | NO | | totaal_factuur_bedrag | double precision | NO | | transport_kosten | double precision | YES | | beukk_totaal_ex | double precision | YES | | beukk_totaal_bedrag | double precision | YES | | beukk_totaal_btw | double precision | YES |

</details>

leverancier_pakbon_levering

Actorbevestiging of extern trackingevent: datum/commentaar/status/eta/ata/tracking_code.

• SELECT-callers: XLS/LMF.pm::confirm_delivery; XLS/LMF.pm::customer_deliveries.
• Schrijvers: XLS/LMF.pm::confirm_delivery [INSERT INTO]; XLS/LMF.pm::keana_webhook [INSERT INTO].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier_pakbon) REFERENCES leverancier_pakbon(id) NOT VALID
  • FOREIGN KEY (lmf_user) REFERENCES lmf_user(id)
  • FOREIGN KEY (order_status) REFERENCES order_status(id) NOT VALID
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | datum | timestamp with time zone | NO | | commentaar | character varying | YES | | lmf_user | bigint | NO | | order_status | bigint | NO | | leverancier_pakbon | bigint | NO | | eta | timestamp with time zone | YES | | ata | timestamp with time zone | YES | | tracking_code | character varying | YES |

</details>

leverancier_pakbon_regel

Bestelde hoeveelheden; fallback packages via SUM(besteld_aantal), geen emballageledger.

• SELECT-callers: XLS/LMF.pm::new_supplier_deliveries; XLS/LMF.pm::next_logistics_delivery; XLS/LMF.pm::logistics_pickup; XLS/LMF.pm::logistics_delivery; XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::customer_delivery; XLS/LMF.pm::customer_deliveries; XLS/LMF.pm::supplier_deliveries; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (leverancier_pakbon) REFERENCES leverancier_pakbon(id)
  • FOREIGN KEY (order_regel) REFERENCES order_regel(id) NOT VALID
  • PRIMARY KEY (id)
  • FOREIGN KEY (product) REFERENCES product(id)
  • FOREIGN KEY (vers_order) REFERENCES vers_order(id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier_pakbon | integer | NO | | vers_order | integer | YES | | lever_datum | date | YES | | bestel_datum | date | YES | | bestel_tijd | time without time zone | YES | | regelnummer | integer | YES | | artikelnummer | integer | YES | | inhoud_verkoop_eenheid | double precision | YES | | verpakking_verkoop_eenheid | character varying | YES | | maat | double precision | YES | | maat_eenheid | character varying | YES | | artikel_omschrijving | character varying | YES | | besteld_aantal | double precision | YES | | gefactureerd_aantal | double precision | YES | | portie_gewicht | double precision | YES | | portie_gewicht_code | character varying | YES | | portie_tekst | character varying | YES | | bruto_prijs | double precision | YES | | korting_percentage | double precision | YES | | factuur_prijs_per_eenheid | double precision | YES | | emballage_prijs | double precision | YES | | consumenten_prijs | double precision | YES | | netto_regel_bedrag | double precision | YES | | btw_tarief | double precision | YES | | artikelgroep | integer | YES | | artikelgroep_omschrijving | character varying | YES | | artikelgroep_klant | integer | YES | | artikelgroep_omschrijving_klant | character varying | YES | | rekeningnummer_groep_klant | character varying | YES | | nzi_code | character varying | YES | | nzi_code_omschrijving | character varying | YES | | nzi_rekening_nummer | character varying | YES | | barcode_consumenten_eenheid | character varying | YES | | barcode_handels_eenheid | character varying | YES | | leveranciers_nummer | character varying | YES | | leveranciers_naam | character varying | YES | | status | smallint | YES | | product | integer | YES | | beukk_prijs | double precision | YES | | beukk_regel_bedrag | double precision | YES | | manco | boolean | YES | | manco_verwerkt | boolean | YES | | manco_aantal | integer | YES | | manco_van | smallint | YES | | manco_reden | integer | YES | | manco_anders | character varying | YES | | order_regel | bigint | YES |

</details>

lmf_bezoeker

IP-geolocatiecache voor branding; geen logistieke stoptracking.

• SELECT-callers: XLS/LMF.pm::lmf_bezoeker.
• Schrijvers: XLS/LMF.pm::lmf_bezoeker [INSERT INTO].
• Constraints (catalogus):
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | ip_adres | inet | NO | | plaats | character varying | NO | | latitude | double precision | YES | | longitude | double precision | YES | | date | timestamp without time zone | NO |

</details>

lmf_log

Connectorberichten, leverancier/username/datum/bericht; geen automatische mutatieaudit.

• SELECT-callers: XLS/LMF.pm::log_report.
• Schrijvers: XLS/LMF.pm::log [INSERT INTO]; XLSLMFHandler.pm::handler [INSERT INTO].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | bigint | YES | | datum | timestamp without time zone | NO | | bericht | character varying | NO | | username | character varying | NO |

</details>

lmf_pagina

Regionale branding met boundingbox.

• SELECT-callers: XLS/LMF.pm::lmf_bezoeker.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | plaats | character varying | NO | | favicon | character varying | NO | | logo | character varying | NO | | behang | character varying | NO | | zuid | double precision | YES | | west | double precision | YES | | noord | double precision | YES | | oost | double precision | YES | | domain | character varying | YES |

</details>

lmf_project

Project aan marktplaats; scope en routeplanningflag via marktplaats-eigenaar.

• SELECT-callers: XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records; XLS/LMF.pm::_logistics_route_planning.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (marktplaats) REFERENCES marktplaats(id) NOT VALID
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | url | character varying | NO | | servicedesk | character varying | NO | | logo | character varying | NO | | postzegel | character varying | YES | | marktplaats | bigint | YES |

</details>

lmf_route

Gedateerd routeplan in aparte importer; project/route/date/carrier/status/timestamps.

• SELECT-callers: RoutePlanImporter.pm::_find_route_plan; RoutePlanImporter.pm::_find_route_plan_by_id; RoutePlanImporter.pm::_lock_route_plan.
• Schrijvers: RoutePlanImporter.pm::_insert_route_plan [INSERT INTO]; RoutePlanImporter.pm::_mark_route_plan_planned [UPDATE].
• Constraints (catalogus):
  • CHECK (((route_id IS NOT NULL) AND (route_date IS NOT NULL) AND (transporteur_id IS NOT NULL)))
  • FOREIGN KEY (lmf_project) REFERENCES lmf_project(id)
  • PRIMARY KEY (id)
  • UNIQUE (lmf_project, route_id, route_date, transporteur_id)
  • FOREIGN KEY (route_id) REFERENCES route(id) ON DELETE RESTRICT
  • CHECK (((status)::text = ANY ((ARRAY['draft'::character varying, 'planned'::character varying, 'in_progress'::character varying, 'completed'::character varying, 'cancelled'::character varying])::text[])))
  • FOREIGN KEY (transporteur_id) REFERENCES leverancier(id) ON DELETE RESTRICT
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | lmf_project | bigint | NO | | nummer | integer | NO | | naam | character varying | NO | | route_id | bigint | YES | | route_date | date | YES | | transporteur_id | bigint | YES | | status | character varying | NO | | created_at | timestamp without time zone | NO | | updated_at | timestamp without time zone | NO |

</details>

lmf_stop

Planstop met type/entity/volgnummer, niet hetzelfde als samengestelde actieve stop_id.

• SELECT-callers: RoutePlanImporter.pm::_existing_stops; RoutePlanImporter.pm::_existing_links; RoutePlanImporter.pm::_delete_stop.
• Schrijvers: RoutePlanImporter.pm::_insert_stop [INSERT INTO]; RoutePlanImporter.pm::_update_stop_sequence [UPDATE]; RoutePlanImporter.pm::_delete_stop [DELETE FROM].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (lmf_route) REFERENCES lmf_route(id)
  • FOREIGN KEY (lokatie) REFERENCES lokatie(id)
  • PRIMARY KEY (id)
  • UNIQUE (lmf_route, volgnummer) DEFERRABLE
  • CHECK (((stop_type)::text = ANY ((ARRAY['hub_start'::character varying, 'supplier'::character varying, 'customer'::character varying, 'hub_end'::character varying])::text[])))
  • CHECK (((((stop_type)::text = ANY ((ARRAY['hub_start'::character varying, 'supplier'::character varying, 'hub_end'::character varying])::text[])) AND (leverancier IS NOT NULL) AND (lokatie IS NULL)) OR (((stop_type)::text = 'customer'::text) AND (lokatie IS NOT NULL) AND (leverancier IS NULL))))
  • CHECK ((volgnummer >= 1))
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | lmf_route | bigint | NO | | leverancier | bigint | YES | | lokatie | bigint | YES | | volgnummer | smallint | NO | | stop_type | character varying | NO |

</details>

lmf_stop_leverancier_pakbon

Veel-op-veel bronkoppeling van importerplanstop naar pakbon.

• SELECT-callers: RoutePlanImporter.pm::_existing_links; RoutePlanImporter.pm::_delete_stop_link; RoutePlanImporter.pm::_delete_stop_links.
• Schrijvers: RoutePlanImporter.pm::_insert_stop_link [INSERT INTO]; RoutePlanImporter.pm::_delete_stop_link [DELETE FROM]; RoutePlanImporter.pm::_delete_stop_links [DELETE FROM].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier_pakbon) REFERENCES leverancier_pakbon(id) ON DELETE RESTRICT
  • FOREIGN KEY (lmf_stop) REFERENCES lmf_stop(id) ON DELETE CASCADE
  • PRIMARY KEY (lmf_stop, leverancier_pakbon)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | lmf_stop | bigint | NO | | leverancier_pakbon | bigint | NO | | created_at | timestamp without time zone | NO |

</details>

lmf_user

Actieve login, token, rolflags, supplier/customer/project/route/navigator.

• SELECT-callers: XLS/LMF.pm::check_token; EmballageControl.pm::_stop_rows; RoutePlanImporter.pm::_active_route_owner_project_ids; XLSLMFHandler.pm::authorization; XLSLMFHandler.pm::credentials; XLSLMFHandler.pm::authen.
• Schrijvers: XLSLMFHandler.pm::authen [UPDATE].
• Constraints (catalogus):
  • FOREIGN KEY (navigator) REFERENCES navigator(id) NOT VALID
  • PRIMARY KEY (id)
  • FOREIGN KEY (route) REFERENCES route(id) NOT VALID
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | roepnaam | character varying | NO | | naam | character varying | NO | | email | character varying | NO | | password | character varying | NO | | klant | boolean | NO | | leverancier | boolean | NO | | logistiek | boolean | NO | | klant_id | bigint | YES | | leverancier_id | bigint | YES | | token | uuid | NO | | actief | boolean | YES | | last_login | timestamp without time zone | YES | | last_login_from | character varying | YES | | telefoon | character varying | YES | | lmf_project | bigint | NO | | chauffeur | boolean | YES | | chauffeur_navigatie | boolean | YES | | hub | boolean | YES | | navigator | bigint | YES | | route | bigint | YES | | dashboard | boolean | YES |

</details>

lmf_user_project

Actieve projecttoegang; gebruikt door moderne logistieke reads en importer.

• SELECT-callers: XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records; RoutePlanImporter.pm::_user_has_project_access.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (lmf_project) REFERENCES lmf_project(id) ON DELETE RESTRICT
  • FOREIGN KEY (lmf_user) REFERENCES lmf_user(id) ON DELETE CASCADE
  • UNIQUE (lmf_user, lmf_project)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | lmf_user | bigint | NO | | lmf_project | bigint | NO | | actief | boolean | NO | | created_at | timestamp without time zone | NO |

</details>

lokatie

Klantlocatie met numeriek id en GUID; adres/lat_lng/bijzonderheden/actief.

• SELECT-callers: XLS/LMF.pm::hub_customer_products; XLS/LMF.pm::hub_customers; XLS/LMF.pm::hub_orders; XLS/LMF.pm::dash_customers; XLS/LMF.pm::dash_route_customers; XLS/LMF.pm::dash_suppliers; XLS/LMF.pm::dash_orders; XLS/LMF.pm::hub_routes; XLS/LMF.pm::customer_dashboard; XLS/LMF.pm::orders; XLS/LMF.pm::assignment; XLS/LMF.pm::hub_outgoing; XLS/LMF.pm::next_stop; XLS/LMF.pm::stops; XLS/LMF.pm::new_supplier_delivery; XLS/LMF.pm::new_supplier_deliveries; XLS/LMF.pm::next_logistics_delivery; XLS/LMF.pm::logistics_delivery; XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::customer_delivery; XLS/LMF.pm::customer_deliveries; XLS/LMF.pm::supplier_deliveries; XLS/LMF.pm::_preload_locations_by_supplier_date; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records; XLS/LMF.pm::klant; XLS/LMF.pm::hub; XLS/LMF.pm::leverancier_lokaties; RoutePlanImporter.pm::_marketplace_route_supplier_for_customer_stops; RoutePlanImporter.pm::_all_location_ids_exist.
• Schrijvers: XLS/LMF.pm::location_comment [UPDATE].
• Constraints (catalogus):
  • FOREIGN KEY (factuur_layout) REFERENCES factuur_layout(id)
  • FOREIGN KEY (cluster) REFERENCES cluster(id)
  • FOREIGN KEY (klant_contract) REFERENCES klant_contract(id)
  • FOREIGN KEY (klant) REFERENCES klant(id)
  • FOREIGN KEY (lokatie_type) REFERENCES lokatie_type(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | adres | character varying | NO | | postcode | character varying | NO | | plaats | character varying | NO | | telefoon | character varying | NO | | email | character varying | YES | | lokatie_type | integer | NO | | cluster | integer | NO | | autorisatie | boolean | YES | | klant | integer | NO | | factuur_layout | integer | NO | | facturen_per_maand | boolean | YES | | budget | boolean | NO | | afleverdatum | smallint | YES | | nzi_voorblad_op_factuur | smallint | YES | | factuur | character | YES | | email_factuur | boolean | YES | | factuur_email_adres | character varying | YES | | pakbon_email_adres | character varying | YES | | testlokatie | boolean | NO | | gln | character varying | YES | | ontvangst_bevestiging | boolean | YES | | order_bevestiging | boolean | YES | | debiteurnummer | character varying | YES | | klant_contract | integer | YES | | actief | boolean | NO | | email_alle_bestellers | boolean | NO | | vereniging_style | boolean | YES | | assortiment_per_lokatie_type | boolean | YES | | guid | uuid | YES | | procuratie | boolean | YES | | dagboek | character varying | YES | | banqueting | boolean | NO | | test_lokatie | boolean | NO | | afleverprocedure | character varying | YES | | eigen_artikelnummers | boolean | YES | | oci_lokatie_code | character varying | YES | | assortiment_lokatie | boolean | NO | | voorraad_lokatie | boolean | NO | | alleen_banqueting | boolean | NO | | gebouw_nummer | character varying | YES | | email_banqueting | character varying | YES | | lat_lng | character varying | YES | | aflever_start | time without time zone | YES | | aflever_eind | time without time zone | YES | | hoofd_lokatie | boolean | NO | | bestel_advies | boolean | NO | | kvk | character varying | YES | | btw_nummer | character varying | YES | | aflever_adres | character varying | YES | | aflever_nummer | character varying | YES | | aflever_toevoeging | character varying | YES | | aflever_plaats | character varying | YES | | aflever_postcode | character varying | YES | | woo_id | bigint | YES | | bijzonderheden | character varying | YES | | lmf | boolean | YES |

</details>

lokatie_leverancier

Relatie leverancier-locatie, debtor en leveringcode1 direct/2 hub/3 via hub/4 transport.

• SELECT-callers: XLS/LMF.pm::assignment; XLS/LMF.pm::lokatie_hub; XLS/LMF.pm::download_orders; XLS/LMF.pm::new_supplier_deliveries; XLS/LMF.pm::next_logistics_delivery; XLS/LMF.pm::logistics_delivery; XLS/LMF.pm::customer_delivery; XLS/LMF.pm::_preload_location_partners; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records; XLS/LMF.pm::klant; XLS/LMF.pm::hub; XLS/LMF.pm::leverancier_lokaties.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (lokatie) REFERENCES lokatie(id)
  • PRIMARY KEY (id)
  • FOREIGN KEY (prijslijst) REFERENCES prijslijst(id) NOT VALID
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | lokatie | integer | NO | | leverancier | integer | NO | | debiteurnummer | character varying | NO | | transport | boolean | YES | | relatie_id | character varying | YES | | crediteurnummer | character varying | YES | | grootboeknummer | character varying | YES | | banqueting_partner | boolean | NO | | levering | smallint | YES | | minimum_order_bedrag | double precision | NO | | laatste_bestelling | time without time zone | YES | | credentials | character varying | YES | | dc_code | character varying | YES | | automatisch_bestellen | boolean | NO | | prijslijst | bigint | YES | | fixed_orderset | boolean | YES |

</details>

marktplaats

Marktplaats/eigenaar leverancier; scope voor klant/route/project.

• SELECT-callers: XLS/LMF.pm::dash_route_customers; XLS/LMF.pm::_logistics_route_planning; RoutePlanImporter.pm::_routes_by_name_for_transporteur_marketplaces; RoutePlanImporter.pm::_marketplace_route_supplier_for_customer_stops.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (domain) REFERENCES domain(id) NOT VALID
  • FOREIGN KEY (klant) REFERENCES klant(id) NOT VALID
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id) NOT VALID
  • PRIMARY KEY (id)
  • FOREIGN KEY (vereniging) REFERENCES vereniging(id) NOT VALID
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | omschrijving | character varying | YES | | actief | boolean | NO | | maps_rectangle_area | character varying | YES | | open | boolean | NO | | vereniging | integer | YES | | woo | boolean | YES | | beukk | boolean | NO | | code | character varying | YES | | domain | bigint | YES | | type | smallint | YES | | leverancier | bigint | YES | | lmf | boolean | YES | | klant | bigint | YES | | lsp_pool | boolean | NO | | nieuwe_omgeving | boolean | NO | | aanmeld_url | character varying | YES | | toon_marges | boolean | NO | | klanten_service_telefoon | character varying | YES | | klanten_service_email | character varying | YES | | aanmeldingen_beheer | boolean | NO |

</details>

navigator

Naam van voorkeursnavigatie voor gebruiker.

• SELECT-callers: XLS/LMF.pm::navigator.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO |

</details>

order_regel

Product/aantal/bestel_gewicht bij vers_order.

• SELECT-callers: XLS/LMF.pm::hub_customer_products; XLS/LMF.pm::hub_supplier_products; XLS/LMF.pm::hub_dashboard; XLS/LMF.pm::supplier_dashboard; XLS/LMF.pm::logistics_dashboard; XLS/LMF.pm::customer_dashboard; XLS/LMF.pm::order_regels; XLS/LMF.pm::products; XLS/LMF.pm::download_orders.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (manco_reden) REFERENCES manco_reden(id)
  • CHECK (((b2b_manco_financieel_actief IS NOT TRUE) OR ((manco IS TRUE) AND (manco_van = ANY (ARRAY[1, 2, 3])) AND (manco_aantal > 0) AND (manco_aantal <= aantal)))) NOT VALID
  • FOREIGN KEY (btw) REFERENCES btw(id)
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (vers_order) REFERENCES vers_order(id)
  • FOREIGN KEY (order_status) REFERENCES order_status(id)
  • PRIMARY KEY (id)
  • FOREIGN KEY (product) REFERENCES product(id)
• Niet-interne triggers: shopapp_order_line_stock → shopapp_order_line_stock_trigger.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | vers_order | integer | NO | | product | integer | NO | | order_status | integer | NO | | aantal | integer | NO | | bestel_gewicht | integer | YES | | leverancier | integer | NO | | verkoop_prijs | numeric | YES | | inkoop_prijs | double precision | YES | | status | boolean | YES | | pakbon_aantal | integer | YES | | pakbon_prijs | double precision | YES | | pakbon_artikel | integer | YES | | pakbon_netto_regelbedrag | double precision | YES | | emballage | boolean | YES | | emballage_bedrag | double precision | YES | | commentaar | character varying | YES | | bedrag | double precision | YES | | pakbon_gewicht | integer | YES | | ok | boolean | YES | | btw | integer | YES | | tekst | character varying | YES | | image | character varying | YES | | promotie_type | smallint | YES | | manco | boolean | YES | | manco_van | smallint | NO | | manco_aantal | smallint | YES | | manco_reden_anders | character varying | YES | | promotie_prijs | double precision | YES | | btw_percentage | double precision | YES | | manco_reden | bigint | YES | | manco_verwerkt | boolean | YES | | beukk_status | smallint | NO | | b2b_manco_financieel_actief | boolean | NO |

</details>

order_status

Statusnaam voor orderweergave en Keana mapping (name versus naam).

• SELECT-callers: XLS/LMF.pm::orders; XLS/LMF.pm::customer_deliveries; XLS/LMF.pm::keana_webhook.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | omschrijving | character varying | YES | | fase | integer | NO | | name | character varying | YES | | akkoord | boolean | YES |

</details>

product

Code/naam/verpakking/stuk_gewicht/productgroep; orderproduct.

• SELECT-callers: XLS/LMF.pm::hub_customer_products; XLS/LMF.pm::hub_supplier_products; XLS/LMF.pm::hub_dashboard; XLS/LMF.pm::supplier_dashboard; XLS/LMF.pm::logistics_dashboard; XLS/LMF.pm::customer_dashboard; XLS/LMF.pm::order_regels; XLS/LMF.pm::products; XLS/LMF.pm::download_orders.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (beukk_productgroep) REFERENCES beukk_productgroep(id) NOT VALID
  • FOREIGN KEY (btw) REFERENCES btw(id) NOT VALID
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (nevo_food) REFERENCES nevo_food(id) NOT VALID
  • FOREIGN KEY (nevo_food_parent) REFERENCES nevo_food(id)
  • PRIMARY KEY (id)
  • FOREIGN KEY (productgroep) REFERENCES productgroep(id)
• Niet-interne triggers: trg_build_product_search_terms_v2 → build_product_search_terms_v2; trg_set_product_updated_true → set_product_updated_true.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | merk | character varying | NO | | productgroep | integer | NO | | aantal_in_verpakking | double precision | NO | | omschrijving_verpakking | character varying | YES | | nzi | integer | YES | | levertijd_in_dagen | integer | NO | | bestelgewicht | integer | YES | | inkoop_prijs | numeric | YES | | verkoop_prijs | numeric | NO | | btw | integer | NO | | stuk_gewicht | integer | NO | | code | character varying | NO | | emballage_prijs | double precision | YES | | ingredienten | character varying | YES | | leverancier | integer | NO | | vervang_artikel | integer | YES | | vervanger_voor | integer | YES | | vervang_datum | date | YES | | oud | boolean | NO | | id_leverancier | character varying | YES | | status | character varying | YES | | status_datum | date | YES | | image | character varying | YES | | voorraad | integer | YES | | datum_laatste_order | date | YES | | emballage_artikel | integer | YES | | ean | character varying | YES | | verpakking | character varying | YES | | minimum_bestelgewicht | integer | YES | | maximum_bestelgewicht | integer | YES | | levercode | smallint | YES | | netto_gewicht | double precision | YES | | gewicht_eenheid | character varying | YES | | minimum_bestel_aantal | integer | YES | | maximum_bestel_aantal | integer | YES | | turnovergroup | smallint | YES | | vatcode | smallint | YES | | allergenen | boolean | NO | | omschrijving | character varying | YES | | voedingswaarde | character varying | YES | | ean_verkoopeenheid | character varying | YES | | transport_naam | character varying | YES | | in_psdb | boolean | NO | | psxml | character varying | YES | | pdf_link | character varying | YES | | productietijd_in_minuten | smallint | YES | | keuze_aantal | integer | YES | | samengesteld | boolean | YES | | topping | boolean | YES | | keuze_artikel | boolean | YES | | gebruik_toppings | boolean | YES | | keuze_mogelijkheid | boolean | YES | | actief | boolean | NO | | voorpagina | boolean | YES | | verzendkosten | double precision | YES | | houdbaarheid_in_dagen | smallint | NO | | kleuren | boolean | NO | | maten | boolean | NO | | tags | character varying | YES | | voorraad_artikel | boolean | YES | | box | boolean | YES | | promo_prijs | double precision | YES | | updated | boolean | NO | | woo_image_id | bigint | YES | | rfid | boolean | YES | | keywords | character varying | YES | | is_recept | boolean | YES | | bio | boolean | YES | | alcohol | boolean | YES | | type | smallint | NO | | temperatuur_zone | smallint | YES | | beukk_code | character varying | YES | | binnenkort_beschikbaar | boolean | YES | | week_voorraad | integer | YES | | automatisch_bijwerken_week_voorraad | boolean | YES | | min_voorraad | integer | YES | | max_voorraad | integer | YES | | vaste_prijs | boolean | YES | | nevo_food | bigint | YES | | nevo_food_parent | bigint | YES | | beukk_productgroep | bigint | YES | | verzameling | boolean | YES | | voorbeeld | boolean | NO | | zoek_string | text | YES | | search_text | tsvector | YES | | search_terms_v2 | text | YES |

</details>

productgroep

Naam voor topgroepen op dashboards.

• SELECT-callers: XLS/LMF.pm::hub_dashboard; XLS/LMF.pm::supplier_dashboard; XLS/LMF.pm::logistics_dashboard; XLS/LMF.pm::customer_dashboard.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (hoofdgroep) REFERENCES hoofdgroep(id)
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (nzi) REFERENCES nzi(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | naam | character varying | NO | | leverancier | integer | NO | | code | character varying | YES | | nzi | integer | YES | | hoofdgroep | integer | YES | | id_leverancier | character varying | YES | | voorraad | boolean | YES | | banqueting | boolean | YES | | woo_id | integer | YES | | volgnummer | integer | YES | | updated | boolean | NO | | is_logistieke_dienst | boolean | NO |

</details>

route

Vaste route, naam/leverancier-eigenaar.

• SELECT-callers: XLS/LMF.pm::dash_route_customers; XLS/LMF.pm::hub_routes; XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::_logistics_route; RoutePlanImporter.pm::_active_route_owner_project_ids; RoutePlanImporter.pm::_route_by_id; RoutePlanImporter.pm::_routes_by_name_for_transporteur_marketplaces.
• Schrijvers: RoutePlanImporter.pm::_insert_route [INSERT INTO].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | integer | NO | | naam | character varying | NO | | maps_rectangle_area | character varying | YES |

</details>

route_lokatie

Routeleden: route, locatie of leverancier, nummer; actieve route_plan schrijft nummer.

• SELECT-callers: XLS/LMF.pm::_route_plan_route_location; XLS/LMF.pm::dash_route_customers; XLS/LMF.pm::hub_routes; XLS/LMF.pm::stops; XLS/LMF.pm::logistics_deliveries; RoutePlanImporter.pm::_source_rows.
• Schrijvers: XLS/LMF.pm::_route_plan_update_route_locations [UPDATE]; RoutePlanImporter.pm::_insert_route_locations [INSERT INTO].
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id) NOT VALID
  • FOREIGN KEY (lokatie) REFERENCES lokatie(id)
  • PRIMARY KEY (id)
  • FOREIGN KEY (route) REFERENCES route(id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | route | integer | NO | | lokatie | integer | YES | | nummer | integer | YES | | leverancier | bigint | YES |

</details>

vers_order

Upstream order, locatie/supplier/hub/carrier/marketplace/datum/bedrag/status; webhook schrijft hub/transportstatus.

• SELECT-callers: XLS/LMF.pm::hub_customer_products; XLS/LMF.pm::hub_supplier_products; XLS/LMF.pm::hub_customers; XLS/LMF.pm::hub_suppliers; XLS/LMF.pm::hub_orders; XLS/LMF.pm::dash_customers; XLS/LMF.pm::dash_route_customers; XLS/LMF.pm::dash_suppliers; XLS/LMF.pm::dash_orders; XLS/LMF.pm::hub_dashboard; XLS/LMF.pm::supplier_dashboard; XLS/LMF.pm::logistics_dashboard; XLS/LMF.pm::customer_dashboard; XLS/LMF.pm::orders; XLS/LMF.pm::products; XLS/LMF.pm::download_orders; XLS/LMF.pm::logistics_deliveries; XLS/LMF.pm::_preload_location_delivery_suppliers_for_records.
• Schrijvers: XLS/LMF.pm::keana_webhook [UPDATE].
• Constraints (catalogus):
  • FOREIGN KEY (hub) REFERENCES leverancier(id) NOT VALID
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • FOREIGN KEY (lokatie) REFERENCES lokatie(id)
  • FOREIGN KEY (besteller) REFERENCES besteller(id)
  • FOREIGN KEY (order_status) REFERENCES order_status(id)
  • PRIMARY KEY (id)
  • FOREIGN KEY (administrator_ok) REFERENCES administrator(id)
  • FOREIGN KEY (afhaalpunt) REFERENCES leverancier(id) NOT VALID
  • FOREIGN KEY (bq_order) REFERENCES bq_order(id)
  • FOREIGN KEY (geautoriseerd_door) REFERENCES besteller(id)
  • FOREIGN KEY (kortingbon) REFERENCES kortingbon(id)
  • FOREIGN KEY (purchase_origin_leverancier) REFERENCES leverancier(id)
• Niet-interne triggers: shopapp_order_delete_stock → shopapp_order_status_stock_trigger; shopapp_order_status_stock → shopapp_order_status_stock_trigger.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | lokatie | integer | NO | | besteller | integer | NO | | order_status | integer | NO | | order_datum | timestamp without time zone | NO | | afleverdatum | date | NO | | referentie | character varying | YES | | bevestigd | boolean | NO | | leverancier | integer | NO | | pakbon | character varying | YES | | pakbon_datum | date | YES | | pakbon_omschrijving | character varying | YES | | ok | boolean | YES | | administrator_ok | integer | YES | | oci_order | integer | YES | | email_send | boolean | YES | | system | boolean | YES | | bedrag | double precision | YES | | geautoriseerd_door | bigint | YES | | geautoriseerd_op | timestamp without time zone | YES | | autorisatie_commentaar | character varying | YES | | regels | integer | YES | | order_id | character varying | YES | | kostenplaats | integer | YES | | banqueting | boolean | NO | | aflevertijd | time without time zone | YES | | notitie | character varying | YES | | transport_order_id | character varying | YES | | banqueting_info | character varying | YES | | banqueting_kostenplaats | character varying | YES | | ip_adres | character varying | YES | | ip_client | character varying | YES | | transport_status | integer | NO | | kostenplaats_naam | character varying | YES | | bq_order | bigint | YES | | factor | double precision | NO | | vrije_verstrekking | boolean | NO | | verwerkt_in_voorraad | boolean | YES | | via_hub | boolean | NO | | hub | bigint | YES | | payment_key | character varying | YES | | payment_id | character varying | YES | | ophalen | boolean | NO | | payment_response | character varying | YES | | bezorgkosten | double precision | NO | | hub_status | smallint | NO | | edi_order | boolean | NO | | btw | double precision | YES | | eindtijd | time without time zone | YES | | json | character varying | YES | | test | boolean | NO | | marktplaats | integer | YES | | bezorgen | boolean | YES | | afhaalpunt | bigint | YES | | app | boolean | NO | | emballage_verwerkt | boolean | YES | | korting | double precision | NO | | kortingbon | bigint | YES | | payment_key_new | uuid | YES | | transporteur | bigint | YES | | betaald | double precision | YES | | inkoop_bedrag | double precision | NO | | beukk_status | smallint | NO | | domain | bigint | YES | | guid | uuid | YES | | verzonden | timestamp without time zone | YES | | purchase_origin_leverancier | bigint | YES |

</details>

voertuig

Actief HUBvoertuig met capaciteit en km/min/stopkosten.

• SELECT-callers: XLS/LMF.pm::hub_vehicles.
• Schrijvers: geen binnen de vier onderzochte backendbestanden.
• Constraints (catalogus):
  • FOREIGN KEY (leverancier) REFERENCES leverancier(id)
  • PRIMARY KEY (id)
• Niet-interne triggers: geen.

<details><summary>Kolommen en typen</summary>

| Kolom | Type | Nullable | |---|---|---| | id | bigint | NO | | leverancier | bigint | NO | | naam | character varying | NO | | type | smallint | NO | | cap_gewicht | numeric | NO | | cap_volume | numeric | NO | | kosten_per_km | numeric | NO | | kosten_per_min | numeric | NO | | actief | boolean | NO | | guid | uuid | NO | | stopkosten | numeric | NO |

</details>

Buiten de directe LMF-dataset

XLS::Logistiek.emballage_saldo gebruikt emballage/emballage_lokatie; deze zijn geen van bovenstaande LMF-tabellen en hun schema is niet in deze 36-objectinspectie opgenomen. ShopAPP/Administratie/leverancierschermen schrijven wel dezelfde pakbonemballage; dit zijn aangrenzende schrijvers, geen functieaanroepen vanuit LMF. Hun rol is vermeld bij emballageboekhouding en audit.

De catalogus geeft op product/order_regel/vers_order enkele niet-interne stock/search-triggers. LMF leest product/regels; de webhook wijzigt hub_status/transport_status. Triggerdefinities staan in het bewijsbestand; geen verborgen emballagebalanstrigger op de onderzochte verpakkingstabellen aangetroffen.