Controlpanel / Database
Database Explorer
Read-only SQL/JSON werkbank. Open een databron, kies een tabel, zoek in echte rijen en inspecteer data als ruwe JSON. Geen vrije SQL, geen writes, geen export.
6 bronnen66 tabellen/stores257.133 rijen/items22 domeincontainers
Zoeken
Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.
Rijen: postgres-main.knowledge_bases
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
WITH _statement_timeout AS (SELECT set_config('statement_timeout', '1500ms', true)) SELECT t.* FROM public."knowledge_bases" t CROSS JOIN _statement_timeout LIMIT 50 OFFSET 0| key | value_json | version | updated_at |
|---|---|---|---|
| nhg_werkgeversverklaring_nl | { "purpose": "Normalisatie-, template- en controleregels voor NHG model-werkgeversverklaringen.", "sections": [ { "id": "employer", "name": "Gegevens werkgever", "expected_fields": [ "employer_name", "employer_address", "employer_postcode_city", "employer_kvk" ] }, { "id": "employee", "name": "Gegevens werknemer", "expected_fields": [ "employee_name", "employee_address", "employee_postcode_city", "employee_birth_date", "employment_start_date", "job_title" ] }, { "id": "employment_type", "name": "Aard van het dienstverband", "expected_fields": [ "contract_indefinite", "contract_temporary_until", "flexible_employment_type", "probation", "probation_passed", "reorganisation_or_termination_risk", "director_shareholder" ] }, { "id": "continuation_statement", "name": "Verklaring voortzetting dienstverband", "expected_fields": [ "continuation_applies", "continuation_indefinite", "continuation_temporary_months", "no_continuation", "renewal_conditions_changed", "renewal_conditions_explanation", "continuation_signer_name", "continuatio ... [afgekapt: 22555 tekens] | 1.0.0 | 1778160770026 |
| hypotheek_document_templates_nl | { "purpose": "Strikte templatekennisbank voor Nederlandse hypotheekdossier-documenten waarvan het feitelijke brondocument lokaal is gedownload.", "scope_note": "Geen generieke templates. Een documenttype staat hier alleen in als er een feitelijk bronbestand in knowledge/source-documents aanwezig is. Documenten zonder publiek/gedownload voorbeeldbestand horen niet in deze database.", "field_catalog": [ { "aliases": [ "Direct noodzakelijke kosten" ], "data_type": "money", "source_ids": [ "nhg_model_bouwkundig_rapport_2026" ], "canonical_key": "direct_noodzakelijke_kosten", "mortgage_relevance": "critical" }, { "aliases": [ "Op termijn noodzakelijke kosten" ], "data_type": "money", "source_ids": [ "nhg_model_bouwkundig_rapport_2026" ], "canonical_key": "op_termijn_noodzakelijke_kosten", "mortgage_relevance": "critical" }, { "aliases": [ "Kosten voor verbetering" ], "data_type": "money", "source_ids": [ "nhg_model_bouwkundig_rapport_2026" ], "canonical_key": "kosten_voor_verbetering", "mortgage_relevance": "important" }, { "aliases": [ "Actie" ], "data_type": "text", "source_ids": [ "nhg_model_bouwkun ... [afgekapt: 27829 tekens] | 2026-05-07.4 | 1778168156167 |
| salarisstrook_templates_nl | { "purpose": "Normalisatie- en extractiedatabase voor Nederlandse salarisstroken in de Adviestool.", "sources": [ { "id": "rijksoverheid-loonstrook", "url": "https://www.rijksoverheid.nl/onderwerpen/arbeidsovereenkomst-en-cao/vraag-en-antwoord/wat-staat-er-op-mijn-loonstrook", "use": "Verplichte/verwachte loonstrookgegevens: brutoloon, loonopbouw, pensioen, minimumloon, naam, werkgever, periode, uren, contracttype.", "name": "Rijksoverheid - Wat staat er op mijn loonstrook?" }, { "id": "randstad-loonstrook", "url": "https://www.randstad.nl/ontwikkelen/loonstrook", "use": "Begrippen: jaarloon bijzonder tarief, loondagen, pensioenpremie, loon voor loonheffing/SV-loon, WGA, loonheffing, nettoloon, cumulatief.", "name": "Randstad - Loonstrook voorbeeld en uitleg" }, { "id": "nmbrs-loonstrook", "url": "https://www.nmbrs.com/nl/uitleg-loonstrook-voorbeeld", "use": "Softwaretemplate en uitleg: bruto salaris, pensioenpremie, loonheffing BT, betalingen/IBAN, vakantiegeld, fiscaal loon, SV-loon.", "name": "Nmbrs - Uitleg loonstrook met voorbeeld" }, { "id": "loon-salarissoftware-2026", "url": "https://www.loon.nl/loon/UitlegLoonstrook2026/uitleg-letters-bij-de-loonstrook-van-arbeidskorting-tot-zorgverzekering", "use": "Layout met ... [afgekapt: 38052 tekens] | 1.1.0 | 1778412863794 |
| gmail_oauth_tokens | { "scope": "https://www.googleapis.com/auth/calendar.events https://www.googleapis.com/auth/calendar.readonly https://www.googleapis.com/auth/contacts https://www.googleapis.com/auth/gmail.readonly https://www.googleapis.com/auth/gmail.send https://www.googleapis.com/auth/tasks https://www.googleapis.com/auth/userinfo.email openid https://www.googleapis.com/auth/contacts.readonly", "account": "rogierzwarthoff@gmail.com", "expires_at": 1781710184370, "token_type": "Bearer", "updated_at": 1781706645371, "access_token": "ya29.a0AT3oNZ8YCe-xZtd_hQq1E0IxGAgHDsaiMfOGubPB-Q0-jl79JKrLXZ7lhrbhiULTa3GioeubTSMkCy8xW9InZPQ57CjpFz6lRYB0CYFggbnEnAmJnCGU5sDZ6PQ5YfT1g5j5BYzJNe24QntDI1vdbq-Z5XTKG1C7SgD1Cvcop2yPRuvPlIg7nbSikfgE-FvQ3iOyz_B2aCgYKAZ0SARUSFQHGX2MiQfgB2kqidG4d08JRFW5TfQ0207", "connected_at": 1778226849272, "refresh_token": "1//0cLA697n-Yb0lCgYIARAAGAwSNwF-L9IrcZH4NCwlqe-seFdgSccTQn6Nb1kPx2igniuxO2MC4iA9Bxh3IcZw3P8kIs7ec7TQkWA" } | 1 | 1781706649307 |
| mail_koppelen_learning_v1 | { "rules": [ { "id": "mail-rule:sender_email:d1d96ea8-3a18-41f4-ae78-8e24c0cce484:noreply@desktoptaxatie.nl", "kind": "sender_email", "status": "active", "pattern": "noreply@desktoptaxatie.nl", "createdAt": 1778676061220, "dossierId": "d1d96ea8-3a18-41f4-ae78-8e24c0cce484", "updatedAt": 1778676061220, "confidence": 52, "lastSeenAt": 1778676061220, "description": "Verhoog de matchscore voor Staniszweska , Izabela (IM) (148431) wanneer mail komt van noreply@desktoptaxatie.nl.", "dossierName": "Staniszweska , Izabela (IM) (148431)", "observations": 1 }, { "id": "mail-rule:sender_email:supplier-lloyds-bank:communicatie@lloydsbank.nl", "kind": "sender_email", "status": "active", "pattern": "communicatie@lloydsbank.nl", "createdAt": 1778357071925, "dossierId": "supplier-lloyds-bank", "updatedAt": 1778357071925, "confidence": 92, "lastSeenAt": 1778256068000, "description": "Verhoog de matchscore voor Leverancier - Lloyds Bank wanneer mail komt van communicatie@lloydsbank.nl.", "dossierName": "Leverancier - Lloyds Bank", "observations": 6 }, { "id": "mail-rule:sender_email:supplier-abn-amro:informatie@nl.abnamro.com", "kind": "sender_email", "status": "active", ... [afgekapt: 34028 tekens] | 1 | 1778676061223 |
| gmail_oauth_state | { "state": "1892f3dd-4c14-4314-8eee-7e2f31647957", "returnTo": "/mail", "created_at": 1781341676201 } | 1 | 1781341676201 |
Raw JSON details
Rij 1
{
"key": "nhg_werkgeversverklaring_nl",
"value_json": {
"purpose": "Normalisatie-, template- en controleregels voor NHG model-werkgeversverklaringen.",
"sections": [
{
"id": "employer",
"name": "Gegevens werkgever",
"expected_fields": [
"employer_name",
"employer_address",
"employer_postcode_city",
"employer_kvk"
]
},
{
"id": "employee",
"name": "Gegevens werknemer",
"expected_fields": [
"employee_name",
"employee_address",
"employee_postcode_city",
"employee_birth_date",
"employment_start_date",
"job_title"
]
},
{
"id": "employment_type",
"name": "Aard van het dienstverband",
"expected_fields": [
"contract_indefinite",
"contract_temporary_until",
"flexible_employment_type",
"probation",
"probation_passed",
"reorganisation_or_termination_risk",
"director_shareholder"
]
},
{
"id": "continuation_statement",
"name": "Verklaring voortzetting dienstverband",
"expected_fields": [
"continuation_applies",
"continuation_indefinite",
"continuation_temporary_months",
"no_continuation",
"renewal_conditions_changed",
"renewal_conditions_explanation",
"continuation_signer_name",
"continuation_extra_signature"
]
},
{
"id": "income",
"name": "Inkomen",
"expected_fields": [
"gross_annual_salary",
"holiday_allowance",
"thirteenth_month",
"year_end_bonus",
"structural_irregular_allowance",
"structural_overtime",
"structural_commission",
"structural_flexible_budget",
"income_line_9",
"income_line_10"
]
},
{
"id": "loans_and_garnishment",
"name": "Leningen en loonbeslag",
"expected_fields": [
"private_loan_to_employee",
"private_loan_start_date",
"private_loan_principal",
"private_loan_term_months",
"private_loan_monthly_payment",
"wage_garnishment",
"wage_garnishment_amount"
]
},
{
"id": "signature",
"name": "Ondertekening en verificatie",
"expected_fields": [
"truth_statement",
"signed_place",
"signed_date",
"signer_name",
"signature_present",
"verification_contact_name",
"verification_contact_phone"
]
}
],
"generated_at": "2026-05-07",
"source_notes": [
{
"url": "https://www.nhg.nl/het-krijgen-van-nhg/werkgeversverklaring-nhg/",
"facts": [
"Bij een NHG-aanvraag moet de werkgeversverklaring volgens het NHG-model zijn ingevuld.",
"Werkgeversverklaring 2024-1 versie 2.0 is geldig vanaf 1 maart 2024.",
"De verklaring moet door de werkgever worden ingevuld.",
"Na volledig invullen moet de werkgever het document ondertekenen; de handtekening mag elektronisch zijn.",
"Een firmastempel is niet nodig.",
"Eigen stijl van werkgever kan alleen als teksten inclusief voetnoten gelijk zijn aan het NHG-model."
],
"source": "NHG werkgeversverklaring pagina"
}
],
"current_model": {
"id": "nhg_wgv_2024_1_v2",
"name": "NHG Werkgeversverklaring 2024-1 versie 2.0",
"pdf_url": "https://www.nhg.nl/media/4p1iia2m/nhg-werkgeversverklaring-2024-nl_v2.pdf",
"word_url": "https://www.nhg.nl/media/0rgnvul5/nhg-werkgeversverklaring-2024-nl-v2.docx",
"local_pdf": "knowledge/nhg-werkgeversverklaring-models/nhg-werkgeversverklaring-2024-1-v2.pdf",
"local_word": "knowledge/nhg-werkgeversverklaring-models/nhg-werkgeversverklaring-2024-1-v2.docx",
"valid_from": "2024-03-01",
"page_source": "https://www.nhg.nl/het-krijgen-van-nhg/werkgeversverklaring-nhg/"
},
"field_catalog": [
{
"aliases": [
"Naam werkgever",
"Werkgever"
],
"section": "employer",
"required": true,
"data_type": "text",
"validation": [
"must_not_be_empty"
],
"canonical_key": "employer_name",
"inventarisatie_target": "data.naam_werkgever"
},
{
"aliases": [
"Adres werkgever",
"Adres"
],
"section": "employer",
"required": true,
"data_type": "text",
"canonical_key": "employer_address",
"inventarisatie_target": "data.adres_werkgever"
},
{
"aliases": [
"Postcode en woonplaats"
],
"section": "employer",
"required": true,
"data_type": "text",
"canonical_key": "employer_postcode_city",
"inventarisatie_target": "data.postcode_werkgever"
},
{
"aliases": [
"KvK-nummer",
"KvK nummer",
"Kvk"
],
"section": "employer",
"required": true,
"data_type": "text",
"validation": [
"kvk_format_or_manual_review"
],
"canonical_key": "employer_kvk"
},
{
"aliases": [
"Naam werknemer",
"Werknemer"
],
"section": "employee",
"required": true,
"data_type": "text",
"validation": [
"compare_with_dossier_name"
],
"canonical_key": "employee_name",
"inventarisatie_target": "a1.naam"
},
{
"aliases": [
"Adres werknemer"
],
"section": "employee",
"required": true,
"data_type": "text",
"canonical_key": "employee_address",
"inventarisatie_ta ... [afgekapt: 19632 tekens]Rij 2
{
"key": "hypotheek_document_templates_nl",
"value_json": {
"purpose": "Strikte templatekennisbank voor Nederlandse hypotheekdossier-documenten waarvan het feitelijke brondocument lokaal is gedownload.",
"scope_note": "Geen generieke templates. Een documenttype staat hier alleen in als er een feitelijk bronbestand in knowledge/source-documents aanwezig is. Documenten zonder publiek/gedownload voorbeeldbestand horen niet in deze database.",
"field_catalog": [
{
"aliases": [
"Direct noodzakelijke kosten"
],
"data_type": "money",
"source_ids": [
"nhg_model_bouwkundig_rapport_2026"
],
"canonical_key": "direct_noodzakelijke_kosten",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Op termijn noodzakelijke kosten"
],
"data_type": "money",
"source_ids": [
"nhg_model_bouwkundig_rapport_2026"
],
"canonical_key": "op_termijn_noodzakelijke_kosten",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Kosten voor verbetering"
],
"data_type": "money",
"source_ids": [
"nhg_model_bouwkundig_rapport_2026"
],
"canonical_key": "kosten_voor_verbetering",
"mortgage_relevance": "important"
},
{
"aliases": [
"Actie"
],
"data_type": "text",
"source_ids": [
"nhg_model_bouwkundig_rapport_2026"
],
"canonical_key": "actie",
"mortgage_relevance": "important"
},
{
"aliases": [
"registratienummer",
"Rapportnummer"
],
"data_type": "text",
"source_ids": [
"nrvt_model_taxatierapport_woonruimte_2026"
],
"canonical_key": "taxatie_registratienummer",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Adres",
"objectadres",
"straat, nummer, plaats"
],
"data_type": "text",
"source_ids": [
"nrvt_model_taxatierapport_woonruimte_2026"
],
"canonical_key": "objectadres",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Inspectiedatum"
],
"data_type": "text",
"source_ids": [
"nrvt_model_taxatierapport_woonruimte_2026"
],
"canonical_key": "inspectiedatum",
"mortgage_relevance": "important"
},
{
"aliases": [
"waardepeildatum"
],
"data_type": "text",
"source_ids": [
"nrvt_model_taxatierapport_woonruimte_2026"
],
"canonical_key": "waardepeildatum",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Marktwaarde"
],
"data_type": "money",
"source_ids": [
"nrvt_model_taxatierapport_woonruimte_2026"
],
"canonical_key": "market_value",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Naam taxateur"
],
"data_type": "text",
"source_ids": [
"nrvt_model_taxatierapport_woonruimte_2026"
],
"canonical_key": "taxateur",
"mortgage_relevance": "important"
},
{
"aliases": [
"Inschrijfnummer NRVT"
],
"data_type": "text",
"source_ids": [
"nrvt_model_taxatierapport_woonruimte_2026"
],
"canonical_key": "nrvt_inschrijfnummer",
"mortgage_relevance": "important"
},
{
"aliases": [
"Hypotheeksom (totaal en per leningdeel)"
],
"data_type": "money",
"source_ids": [
"nhg_checklist_brondata_2026"
],
"canonical_key": "hypotheeksom",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Rentepercentage (per leningdeel)"
],
"data_type": "percentage",
"source_ids": [
"nhg_checklist_brondata_2026"
],
"canonical_key": "rentepercentage_leningdeel",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Rentevastperiode (per leningdeel)"
],
"data_type": "text",
"source_ids": [
"nhg_checklist_brondata_2026"
],
"canonical_key": "rentevastperiode_leningdeel",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Oorspronkelijke hoofdsom DUO-lening"
],
"data_type": "money",
"source_ids": [
"nhg_checklist_brondata_2026"
],
"canonical_key": "duo_oorspronkelijke_hoofdsom",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Rentepercentage van de DUO-lening"
],
"data_type": "percentage",
"source_ids": [
"nhg_checklist_brondata_2026"
],
"canonical_key": "duo_rentepercentage",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Looptijd van de DUO-lening"
],
"data_type": "text",
"source_ids": [
"nhg_checklist_brondata_2026"
],
"canonical_key": "duo_looptijd",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Kosten"
],
"data_type": "money",
"source_ids": [
"nrvt_uniforme_verbouwingsspecificatie_2025"
],
"canonical_key": "verbouwingskosten",
"mortgage_relevance": "critical"
},
{
"aliases": [
"Werkzaamheden",
"Verbouwing"
],
"data_type": "text",
"source_ids": [
"nrvt_uniforme_verbouwingsspecificatie_2025"
],
"canonical_key": "verbouwing_werkzaamheden", ... [afgekapt: 25341 tekens]Rij 3
{
"key": "salarisstrook_templates_nl",
"value_json": {
"purpose": "Normalisatie- en extractiedatabase voor Nederlandse salarisstroken in de Adviestool.",
"sources": [
{
"id": "rijksoverheid-loonstrook",
"url": "https://www.rijksoverheid.nl/onderwerpen/arbeidsovereenkomst-en-cao/vraag-en-antwoord/wat-staat-er-op-mijn-loonstrook",
"use": "Verplichte/verwachte loonstrookgegevens: brutoloon, loonopbouw, pensioen, minimumloon, naam, werkgever, periode, uren, contracttype.",
"name": "Rijksoverheid - Wat staat er op mijn loonstrook?"
},
{
"id": "randstad-loonstrook",
"url": "https://www.randstad.nl/ontwikkelen/loonstrook",
"use": "Begrippen: jaarloon bijzonder tarief, loondagen, pensioenpremie, loon voor loonheffing/SV-loon, WGA, loonheffing, nettoloon, cumulatief.",
"name": "Randstad - Loonstrook voorbeeld en uitleg"
},
{
"id": "nmbrs-loonstrook",
"url": "https://www.nmbrs.com/nl/uitleg-loonstrook-voorbeeld",
"use": "Softwaretemplate en uitleg: bruto salaris, pensioenpremie, loonheffing BT, betalingen/IBAN, vakantiegeld, fiscaal loon, SV-loon.",
"name": "Nmbrs - Uitleg loonstrook met voorbeeld"
},
{
"id": "loon-salarissoftware-2026",
"url": "https://www.loon.nl/loon/UitlegLoonstrook2026/uitleg-letters-bij-de-loonstrook-van-arbeidskorting-tot-zorgverzekering",
"use": "Layout met lettercodes; heffingsloonopbouw; WGA, PAWW, reiskosten, arbeidskorting, sector/cao, minimumloon en cumulatieven.",
"name": "Loon Salarissoftware - Uitleg loonstrook 2026"
},
{
"id": "loket-loonstrook",
"url": "https://loket.nl/kennisbank/wat-moet-er-op-een-loonstrook-staan/",
"use": "Verplichte gegevens en Loket-template/infographic context.",
"name": "Loket.nl - Wat moet er op een loonstrook staan?"
},
{
"id": "adp-voorbeeld-2023",
"url": "https://nl.adp.com/-/media/adpnl/pdfs/resources/tools/voorbeeld-salarisstrook-2023.pdf",
"use": "ADP/TWK-template: kopgegevens, belastingtabellen, dagen/uren, bedragen, TWK-resultaat, pensioen en bijtelling.",
"name": "ADP - Voorbeeld salarisstrook 2023"
},
{
"id": "sdworx-loonstrook",
"url": "https://www.sdworx.jobs/nl-nl/je-loopbaan/ontwikkel-jezelf/salaris/loonstrook",
"use": "Uitzend/payroll-context: week, 4-weken of maand, bruto/netto, loonheffingskorting, reiskosten.",
"name": "SD Worx Jobs - Je loonstrook lezen"
},
{
"id": "visma-youserve",
"url": "https://community.visma.com/t5/Kennisbank-YouServe/Payroll-Business-Uitleg-salarisspecificaties-2024/ta-p/631083",
"use": "Sector-/3-koloms salarisstrookfamilie, relevant voor zorg/onderwijs/overheid.",
"name": "Visma/YouServe - Uitleg salarisspecificaties"
},
{
"id": "afas-salariswijzer",
"url": "https://www.afas.nl/salariswijzer",
"use": "AFAS voorbeeldloonstrook en uitleg van loonheffing, pensioenbijdrage en uitbetaling.",
"name": "AFAS - Salariswijzer"
}
],
"scope_note": "Geen enkele database kan letterlijk alle werkgeverspecifieke loonstroken dekken. Deze set dekt de hoofdpatronen van Nederlandse salarissoftware, uitzend/payroll-stroken, sectorstroken en hypotheekrelevante velden. Nieuwe labels kunnen zonder migratie worden toegevoegd via aliases.",
"generated_at": "2026-05-08",
"field_catalog": [
{
"group": "identity",
"notes": "Gebruik voor dossiermatching, niet voor inkomensberekening.",
"aliases": [
"Naam werknemer",
"Medewerker",
"Werknemer",
"Naam",
"Persoonsnaam"
],
"data_type": "text",
"canonical_key": "employee_name",
"typical_location": "kop links of rechts",
"mortgage_relevance": "supporting"
},
{
"group": "identity",
"notes": "Gebruik voor match met werkgeversverklaring en CAO-zoekopdracht.",
"aliases": [
"Werkgever",
"Bedrijf",
"Naam werkgever",
"Inhoudingsplichtige"
],
"data_type": "text",
"canonical_key": "employer_name",
"typical_location": "kop",
"mortgage_relevance": "supporting"
},
{
"group": "period",
"notes": "Nodig om maand/week/4-weken naar jaarbasis te normaliseren.",
"aliases": [
"Periode",
"Tijdvak",
"Loontijdvak",
"Periodeomschrijving",
"Maand",
"Week",
"4-weken"
],
"data_type": "period",
"canonical_key": "period",
"typical_location": "kop of boven tabel",
"mortgage_relevance": "critical"
},
{
"group": "period",
"notes": "Maand=12, 4-weken=13, week=52 perioden per jaar.",
"aliases": [
"Maand",
"4-weken",
"Week",
"Per uitbetaling",
"Per periode"
],
"data_type": "enum",
"canonical_key": "pay_frequency",
"typical_location": "afgeleid uit periode of betaalfrequentie",
"mortgage_relevance": "critical"
},
{
"group": "contract",
"notes": "Controle op parttimepercentage en structureel inkomen.",
"aliases": [
"Contracturen",
"Contr.uren",
"Uren per week",
"Loonuren",
"Standaard uren",
"Parttime uren"
],
"data_type": "number",
"canonical_key": "contract_hours",
"typical_location": "kop of contractblok",
"mortgage_relevance": "important"
},
{
"group": "contract",
"notes": "Nodig voor parttimepercentage.",
"aliases": [
"Fulltime uren",
"Standaard aantal uren",
"No ... [afgekapt: 36340 tekens]Rij 4
{
"key": "gmail_oauth_tokens",
"value_json": {
"scope": "https://www.googleapis.com/auth/calendar.events https://www.googleapis.com/auth/calendar.readonly https://www.googleapis.com/auth/contacts https://www.googleapis.com/auth/gmail.readonly https://www.googleapis.com/auth/gmail.send https://www.googleapis.com/auth/tasks https://www.googleapis.com/auth/userinfo.email openid https://www.googleapis.com/auth/contacts.readonly",
"account": "rogierzwarthoff@gmail.com",
"expires_at": 1781710184370,
"token_type": "Bearer",
"updated_at": 1781706645371,
"access_token": "ya29.a0AT3oNZ8YCe-xZtd_hQq1E0IxGAgHDsaiMfOGubPB-Q0-jl79JKrLXZ7lhrbhiULTa3GioeubTSMkCy8xW9InZPQ57CjpFz6lRYB0CYFggbnEnAmJnCGU5sDZ6PQ5YfT1g5j5BYzJNe24QntDI1vdbq-Z5XTKG1C7SgD1Cvcop2yPRuvPlIg7nbSikfgE-FvQ3iOyz_B2aCgYKAZ0SARUSFQHGX2MiQfgB2kqidG4d08JRFW5TfQ0207",
"connected_at": 1778226849272,
"refresh_token": "1//0cLA697n-Yb0lCgYIARAAGAwSNwF-L9IrcZH4NCwlqe-seFdgSccTQn6Nb1kPx2igniuxO2MC4iA9Bxh3IcZw3P8kIs7ec7TQkWA"
},
"version": "1",
"updated_at": 1781706649307
}Rij 5
{
"key": "mail_koppelen_learning_v1",
"value_json": {
"rules": [
{
"id": "mail-rule:sender_email:d1d96ea8-3a18-41f4-ae78-8e24c0cce484:noreply@desktoptaxatie.nl",
"kind": "sender_email",
"status": "active",
"pattern": "noreply@desktoptaxatie.nl",
"createdAt": 1778676061220,
"dossierId": "d1d96ea8-3a18-41f4-ae78-8e24c0cce484",
"updatedAt": 1778676061220,
"confidence": 52,
"lastSeenAt": 1778676061220,
"description": "Verhoog de matchscore voor Staniszweska , Izabela (IM) (148431) wanneer mail komt van noreply@desktoptaxatie.nl.",
"dossierName": "Staniszweska , Izabela (IM) (148431)",
"observations": 1
},
{
"id": "mail-rule:sender_email:supplier-lloyds-bank:communicatie@lloydsbank.nl",
"kind": "sender_email",
"status": "active",
"pattern": "communicatie@lloydsbank.nl",
"createdAt": 1778357071925,
"dossierId": "supplier-lloyds-bank",
"updatedAt": 1778357071925,
"confidence": 92,
"lastSeenAt": 1778256068000,
"description": "Verhoog de matchscore voor Leverancier - Lloyds Bank wanneer mail komt van communicatie@lloydsbank.nl.",
"dossierName": "Leverancier - Lloyds Bank",
"observations": 6
},
{
"id": "mail-rule:sender_email:supplier-abn-amro:informatie@nl.abnamro.com",
"kind": "sender_email",
"status": "active",
"pattern": "informatie@nl.abnamro.com",
"createdAt": 1778357071925,
"dossierId": "supplier-abn-amro",
"updatedAt": 1778357071925,
"confidence": 95,
"lastSeenAt": 1778255468000,
"description": "Verhoog de matchscore voor Leverancier - ABN AMRO wanneer mail komt van informatie@nl.abnamro.com.",
"dossierName": "Leverancier - ABN AMRO",
"observations": 8
},
{
"id": "mail-rule:sender_email:supplier-florius:marketing@mail.florius.nl",
"kind": "sender_email",
"status": "active",
"pattern": "marketing@mail.florius.nl",
"createdAt": 1778357071925,
"dossierId": "supplier-florius",
"updatedAt": 1778357071925,
"confidence": 95,
"lastSeenAt": 1778252554000,
"description": "Verhoog de matchscore voor Leverancier - Florius wanneer mail komt van marketing@mail.florius.nl.",
"dossierName": "Leverancier - Florius",
"observations": 10
},
{
"id": "mail-rule:sender_email:supplier-nibc:service@mail.nibc.com",
"kind": "sender_email",
"status": "active",
"pattern": "service@mail.nibc.com",
"createdAt": 1778357071925,
"dossierId": "supplier-nibc",
"updatedAt": 1778357071925,
"confidence": 92,
"lastSeenAt": 1778251561000,
"description": "Verhoog de matchscore voor Leverancier - NIBC wanneer mail komt van service@mail.nibc.com.",
"dossierName": "Leverancier - NIBC",
"observations": 6
},
{
"id": "mail-rule:sender_email:supplier-asr:info@email.asr.nl",
"kind": "sender_email",
"status": "active",
"pattern": "info@email.asr.nl",
"createdAt": 1778357071925,
"dossierId": "supplier-asr",
"updatedAt": 1778357071925,
"confidence": 68,
"lastSeenAt": 1778239250000,
"description": "Verhoog de matchscore voor Leverancier - ASR wanneer mail komt van info@email.asr.nl.",
"dossierName": "Leverancier - ASR",
"observations": 3
},
{
"id": "mail-rule:sender_email:supplier-bijbouwe:marketing@bijbouwe.nl",
"kind": "sender_email",
"status": "active",
"pattern": "marketing@bijbouwe.nl",
"createdAt": 1778357071925,
"dossierId": "supplier-bijbouwe",
"updatedAt": 1778357071925,
"confidence": 95,
"lastSeenAt": 1778228071000,
"description": "Verhoog de matchscore voor Leverancier - bijBouwe wanneer mail komt van marketing@bijbouwe.nl.",
"dossierName": "Leverancier - bijBouwe",
"observations": 15
},
{
"id": "mail-rule:sender_email:supplier-uw-garantiestelling:no-reply@uwgarantiestelling.nl",
"kind": "sender_email",
"status": "active",
"pattern": "no-reply@uwgarantiestelling.nl",
"createdAt": 1778357071925,
"dossierId": "supplier-uw-garantiestelling",
"updatedAt": 1778357071925,
"confidence": 60,
"lastSeenAt": 1778219722000,
"description": "Verhoog de matchscore voor Leverancier - Uw Garantiestelling wanneer mail komt van no-reply@uwgarantiestelling.nl.",
"dossierName": "Leverancier - Uw Garantiestelling",
"observations": 2
},
{
"id": "mail-rule:sender_email:supplier-nibc:info@mail.nibc.com",
"kind": "sender_email",
"status": "active",
"pattern": "info@mail.nibc.com",
"createdAt": 1778357071925,
"dossierId": "supplier-nibc",
"updatedAt": 1778357071925,
"confidence": 95,
"lastSeenAt": 1778167897000,
"description": "Verhoog de matchscore voor Leverancier - NIBC wanneer mail komt van info@mail.nibc.com.",
"dossierName": "Leverancier - NIBC",
"observations": 18
},
{
"id": "mail-rule:sender_email:supplier-ing:marketing@lni.nl",
"kind": "sender_email",
"status": "active",
"pattern": "marketing@lni.nl",
"createdAt": 1778357071925,
"dossierId": "supplier-ing",
"updatedAt": 1778357071925,
"confidence": 60,
"lastSeenAt": 1778160970000,
"description": "Verhoog de matchscore voor Leverancier - ING wanneer mail komt van marketing@lni.nl.",
"dossierName": "Leverancier - ING",
"observations": 2
},
{
"id": "mail-rule:sender_email:supplier-nrv ... [afgekapt: 31333 tekens]Rij 6
{
"key": "gmail_oauth_state",
"value_json": {
"state": "1892f3dd-4c14-4314-8eee-7e2f31647957",
"returnTo": "/mail",
"created_at": 1781341676201
},
"version": "1",
"updated_at": 1781341676201
}Andere domeindatabases
Gefilterde containerinventaris. Niet alle containers hebben al een veilige connector.
| Container | Image | Status |
|---|---|---|
| adviestool-web | adviestool-web:latest | Up 9 minutes |
| adviestool-whatsapp | adviestool-whatsapp:latest | Up About an hour |
| adviestool-ocr | adviestool-ocr:latest | Up About an hour (healthy) |
| adviestool-web-preview | adviestool-web-preview:latest | Up 3 days |
| adviestool-preview-ocr | 9e5e9933f3ab | Up 3 days (healthy) |
| adviestool-postgres-test | postgres:17-alpine | Up 3 days (healthy) |
| adviestool-postgres | postgres:17-alpine | Up 5 days (healthy) |
| boekhouding-uw-zekerheid-mssql-1 | mcr.microsoft.com/mssql/server:2022-latest | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-arq-worker-1 | boekhouding-uw-zekerheid-arq-worker | Up 6 days |
| boekhouding-uw-zekerheid-api-1 | boekhouding-uw-zekerheid-api | Up 6 days |
| boekhouding-uw-zekerheid-web-1 | boekhouding-uw-zekerheid-web | Up 6 days |
| boekhouding-uw-zekerheid-caddy-1 | caddy:2-alpine | Up 6 days |
| boekhouding-uw-zekerheid-otel-collector-1 | otel/opentelemetry-collector:0.136.0 | Up 6 days |
| boekhouding-uw-zekerheid-redis-1 | redis:7-alpine | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-postgres-1 | pgvector/pgvector:pg16 | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-minio-1 | minio/minio:RELEASE.2025-09-07T16-13-09Z | Up 6 days |
| adviseursite | adviseursite-adviseursite | Up 7 days (healthy) |
| hypotheek-gate | hypotheek-gate:latest | Up 7 days (healthy) |
| dash | dash-uw-zekerheid:latest | Up 7 days (healthy) |
| adviesbox-windows | dockurr/windows | Up 7 days |
| klantportaal | klantportaal:latest | Up 7 days (healthy) |
| uwpaleis-test | uwpaleis-website:latest | Up 7 days (healthy) |