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.calendar_events
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."calendar_events" t CROSS JOIN _statement_timeout LIMIT 50 OFFSET 0| id | account | provider | provider_event_id | provider_calendar_id | dossier_id | linked_by | summary | description | location | start | end | all_day | attendees_json | status | html_link | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6b3e905c-c22b-499f-b7cb-cf9be0624bff | rogierzwarthoff@gmail.com | local | 2f118f6f-05da-462f-8d39-dd947dbdb1fd | created_from_dossier | Financieringsvoorbehoud verloopt | Ontbindende voorwaarden voor financiering uit de koopovereenkomst. Aangemaakt door Hermes omdat Google Calendar API in project 312615578048 nog disabled is. | 2026-04-24T18:00:00+02:00 | 2026-04-24T18:30:00+02:00 | false | [] | 1780675685733 | 1780675685733 | |||||
| 5c09de33-0d96-412d-8265-3641b6367059 | rogierzwarthoff@gmail.com | local | 2f118f6f-05da-462f-8d39-dd947dbdb1fd | created_from_dossier | Overdrachtsdatum / levering | Datum akte van levering/eigendomsoverdracht uit de koopovereenkomst. Aangemaakt door Hermes omdat Google Calendar API in project 312615578048 nog disabled is. | 2026-06-01T18:00:00+02:00 | 2026-06-01T18:30:00+02:00 | false | [] | 1780675685964 | 1780675685964 | |||||
| b172f2f9-5c2c-4989-bcfb-f4f880844dda | rogierzwarthoff@gmail.com | local | 2f118f6f-05da-462f-8d39-dd947dbdb1fd | created_from_dossier | Bankgarantie/waarborgsom verloopt | Uiterste datum bankgarantie of waarborgsom. Oorspronkelijke datum: 25-05-2026 (Tweede pinksterdag). Aangemaakt door Hermes omdat Google Calendar API in project 312615578048 nog disabled is. | 2026-05-26T18:00:00+02:00 | 2026-05-26T18:30:00+02:00 | false | [] | 1780675686110 | 1780675686110 | |||||
| c006adff-c0fb-4e34-ae91-f7341466b412 | rogierzwarthoff@gmail.com | local | 2f118f6f-05da-462f-8d39-dd947dbdb1fd | created_from_dossier | 3-daagse bedenktijd verloopt | Einde wettelijke bedenktijd volgens koopovereenkomsttekst. Aangemaakt door Hermes omdat Google Calendar API in project 312615578048 nog disabled is. | 2026-04-02T18:00:00+02:00 | 2026-04-02T18:30:00+02:00 | false | [] | 1780675686238 | 1780675686238 | |||||
| 07571dae-8c15-4088-a2ba-36958b327d08 | rogierzwarthoff@gmail.com | google_calendar | iurofd0opnc74a18h5fiv7ik60 | primary | 2f118f6f-05da-462f-8d39-dd947dbdb1fd | created_from_dossier | Financieringsvoorbehoud verloopt | Ontbindende voorwaarden voor financiering uit de koopovereenkomst. Automatisch aangemaakt vanuit Inventarisatie > Overzicht > Koopovereenkomst. | 2026-04-24T18:00:00+02:00 | 2026-04-24T18:30:00+02:00 | false | [] | confirmed | https://www.google.com/calendar/event?eid=aXVyb2ZkMG9wbmM3NGExOGg1Zml2N2lrNjAgcm9naWVyendhcnRob2ZmQG0 | 1780689987480 | 1780689987480 | |
| a4a510d5-ef45-4010-bb85-17f88066dbaa | rogierzwarthoff@gmail.com | google_calendar | ap4g0ch6mn2hpvan0j29uj1bls | primary | 2f118f6f-05da-462f-8d39-dd947dbdb1fd | created_from_dossier | Overdrachtsdatum / levering | Datum akte van levering/eigendomsoverdracht uit de koopovereenkomst. Automatisch aangemaakt vanuit Inventarisatie > Overzicht > Koopovereenkomst. | 2026-06-01T18:00:00+02:00 | 2026-06-01T18:30:00+02:00 | false | [] | confirmed | https://www.google.com/calendar/event?eid=YXA0ZzBjaDZtbjJocHZhbjBqMjl1ajFibHMgcm9naWVyendhcnRob2ZmQG0 | 1780689989255 | 1780689989255 | |
| 69dc3a54-a737-4c32-9a64-c85e7ca93af7 | rogierzwarthoff@gmail.com | google_calendar | 3alcvrb5it7rs08p9iffr6i0j4 | primary | 2f118f6f-05da-462f-8d39-dd947dbdb1fd | created_from_dossier | Bankgarantie/waarborgsom verloopt | Uiterste datum bankgarantie of waarborgsom. Oorspronkelijke datum: 25-05-2026 (Tweede pinksterdag). Automatisch aangemaakt vanuit Inventarisatie > Overzicht > Koopovereenkomst. | 2026-05-26T18:00:00+02:00 | 2026-05-26T18:30:00+02:00 | false | [] | confirmed | https://www.google.com/calendar/event?eid=M2FsY3ZyYjVpdDdyczA4cDlpZmZyNmkwajQgcm9naWVyendhcnRob2ZmQG0 | 1780689990040 | 1780689990040 | |
| abf2e1f5-b153-41b4-919d-14131a996bf6 | rogierzwarthoff@gmail.com | google_calendar | q1ic1393t57qvajamp2jhdft2c | primary | 2f118f6f-05da-462f-8d39-dd947dbdb1fd | created_from_dossier | 3-daagse bedenktijd verloopt | Einde wettelijke bedenktijd volgens koopovereenkomsttekst. Automatisch aangemaakt vanuit Inventarisatie > Overzicht > Koopovereenkomst. | 2026-04-02T18:00:00+02:00 | 2026-04-02T18:30:00+02:00 | false | [] | confirmed | https://www.google.com/calendar/event?eid=cTFpYzEzOTN0NTdxdmFqYW1wMmpoZGZ0MmMgcm9naWVyendhcnRob2ZmQG0 | 1780689990701 | 1780689990701 |
Raw JSON details
Rij 1
{
"id": "6b3e905c-c22b-499f-b7cb-cf9be0624bff",
"account": "rogierzwarthoff@gmail.com",
"provider": "local",
"provider_event_id": null,
"provider_calendar_id": null,
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"linked_by": "created_from_dossier",
"summary": "Financieringsvoorbehoud verloopt",
"description": "Ontbindende voorwaarden voor financiering uit de koopovereenkomst.\n\nAangemaakt door Hermes omdat Google Calendar API in project 312615578048 nog disabled is.",
"location": "",
"start": "2026-04-24T18:00:00+02:00",
"end": "2026-04-24T18:30:00+02:00",
"all_day": false,
"attendees_json": [],
"status": null,
"html_link": null,
"created_at": 1780675685733,
"updated_at": 1780675685733
}Rij 2
{
"id": "5c09de33-0d96-412d-8265-3641b6367059",
"account": "rogierzwarthoff@gmail.com",
"provider": "local",
"provider_event_id": null,
"provider_calendar_id": null,
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"linked_by": "created_from_dossier",
"summary": "Overdrachtsdatum / levering",
"description": "Datum akte van levering/eigendomsoverdracht uit de koopovereenkomst.\n\nAangemaakt door Hermes omdat Google Calendar API in project 312615578048 nog disabled is.",
"location": "",
"start": "2026-06-01T18:00:00+02:00",
"end": "2026-06-01T18:30:00+02:00",
"all_day": false,
"attendees_json": [],
"status": null,
"html_link": null,
"created_at": 1780675685964,
"updated_at": 1780675685964
}Rij 3
{
"id": "b172f2f9-5c2c-4989-bcfb-f4f880844dda",
"account": "rogierzwarthoff@gmail.com",
"provider": "local",
"provider_event_id": null,
"provider_calendar_id": null,
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"linked_by": "created_from_dossier",
"summary": "Bankgarantie/waarborgsom verloopt",
"description": "Uiterste datum bankgarantie of waarborgsom. Oorspronkelijke datum: 25-05-2026 (Tweede pinksterdag).\n\nAangemaakt door Hermes omdat Google Calendar API in project 312615578048 nog disabled is.",
"location": "",
"start": "2026-05-26T18:00:00+02:00",
"end": "2026-05-26T18:30:00+02:00",
"all_day": false,
"attendees_json": [],
"status": null,
"html_link": null,
"created_at": 1780675686110,
"updated_at": 1780675686110
}Rij 4
{
"id": "c006adff-c0fb-4e34-ae91-f7341466b412",
"account": "rogierzwarthoff@gmail.com",
"provider": "local",
"provider_event_id": null,
"provider_calendar_id": null,
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"linked_by": "created_from_dossier",
"summary": "3-daagse bedenktijd verloopt",
"description": "Einde wettelijke bedenktijd volgens koopovereenkomsttekst.\n\nAangemaakt door Hermes omdat Google Calendar API in project 312615578048 nog disabled is.",
"location": "",
"start": "2026-04-02T18:00:00+02:00",
"end": "2026-04-02T18:30:00+02:00",
"all_day": false,
"attendees_json": [],
"status": null,
"html_link": null,
"created_at": 1780675686238,
"updated_at": 1780675686238
}Rij 5
{
"id": "07571dae-8c15-4088-a2ba-36958b327d08",
"account": "rogierzwarthoff@gmail.com",
"provider": "google_calendar",
"provider_event_id": "iurofd0opnc74a18h5fiv7ik60",
"provider_calendar_id": "primary",
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"linked_by": "created_from_dossier",
"summary": "Financieringsvoorbehoud verloopt",
"description": "Ontbindende voorwaarden voor financiering uit de koopovereenkomst.\n\nAutomatisch aangemaakt vanuit Inventarisatie > Overzicht > Koopovereenkomst.",
"location": "",
"start": "2026-04-24T18:00:00+02:00",
"end": "2026-04-24T18:30:00+02:00",
"all_day": false,
"attendees_json": [],
"status": "confirmed",
"html_link": "https://www.google.com/calendar/event?eid=aXVyb2ZkMG9wbmM3NGExOGg1Zml2N2lrNjAgcm9naWVyendhcnRob2ZmQG0",
"created_at": 1780689987480,
"updated_at": 1780689987480
}Rij 6
{
"id": "a4a510d5-ef45-4010-bb85-17f88066dbaa",
"account": "rogierzwarthoff@gmail.com",
"provider": "google_calendar",
"provider_event_id": "ap4g0ch6mn2hpvan0j29uj1bls",
"provider_calendar_id": "primary",
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"linked_by": "created_from_dossier",
"summary": "Overdrachtsdatum / levering",
"description": "Datum akte van levering/eigendomsoverdracht uit de koopovereenkomst.\n\nAutomatisch aangemaakt vanuit Inventarisatie > Overzicht > Koopovereenkomst.",
"location": "",
"start": "2026-06-01T18:00:00+02:00",
"end": "2026-06-01T18:30:00+02:00",
"all_day": false,
"attendees_json": [],
"status": "confirmed",
"html_link": "https://www.google.com/calendar/event?eid=YXA0ZzBjaDZtbjJocHZhbjBqMjl1ajFibHMgcm9naWVyendhcnRob2ZmQG0",
"created_at": 1780689989255,
"updated_at": 1780689989255
}Rij 7
{
"id": "69dc3a54-a737-4c32-9a64-c85e7ca93af7",
"account": "rogierzwarthoff@gmail.com",
"provider": "google_calendar",
"provider_event_id": "3alcvrb5it7rs08p9iffr6i0j4",
"provider_calendar_id": "primary",
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"linked_by": "created_from_dossier",
"summary": "Bankgarantie/waarborgsom verloopt",
"description": "Uiterste datum bankgarantie of waarborgsom. Oorspronkelijke datum: 25-05-2026 (Tweede pinksterdag).\n\nAutomatisch aangemaakt vanuit Inventarisatie > Overzicht > Koopovereenkomst.",
"location": "",
"start": "2026-05-26T18:00:00+02:00",
"end": "2026-05-26T18:30:00+02:00",
"all_day": false,
"attendees_json": [],
"status": "confirmed",
"html_link": "https://www.google.com/calendar/event?eid=M2FsY3ZyYjVpdDdyczA4cDlpZmZyNmkwajQgcm9naWVyendhcnRob2ZmQG0",
"created_at": 1780689990040,
"updated_at": 1780689990040
}Rij 8
{
"id": "abf2e1f5-b153-41b4-919d-14131a996bf6",
"account": "rogierzwarthoff@gmail.com",
"provider": "google_calendar",
"provider_event_id": "q1ic1393t57qvajamp2jhdft2c",
"provider_calendar_id": "primary",
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"linked_by": "created_from_dossier",
"summary": "3-daagse bedenktijd verloopt",
"description": "Einde wettelijke bedenktijd volgens koopovereenkomsttekst.\n\nAutomatisch aangemaakt vanuit Inventarisatie > Overzicht > Koopovereenkomst.",
"location": "",
"start": "2026-04-02T18:00:00+02:00",
"end": "2026-04-02T18:30:00+02:00",
"all_day": false,
"attendees_json": [],
"status": "confirmed",
"html_link": "https://www.google.com/calendar/event?eid=cTFpYzEzOTN0NTdxdmFqYW1wMmpoZGZ0MmMgcm9naWVyendhcnRob2ZmQG0",
"created_at": 1780689990701,
"updated_at": 1780689990701
}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) |