Skip to content

Instantly share code, notes, and snippets.

View wardva's full-sized avatar

Ward Van Assche wardva

View GitHub Profile
@wardva
wardva / integrations.sql
Created September 18, 2025 10:29
Integration configuration
-- depends_on: tables/organisations
CREATE TABLE integrations (
id TEXT NOT NULL PRIMARY KEY,
org_id TEXT,
FOREIGN KEY (org_id) REFERENCES organisations(id),
sent_categories TEXT[] NOT NULL DEFAULT '{}', -- names or ids of the sent folders, used to calculate message direction.
received_categories TEXT[] NOT NULL DEFAULT '{}', -- names or ids of the received folders, used to calculate message direction.
default_category TEXT -- category that is considered default, used to calculate message direction in case of missing values or a conflict.
@wardva
wardva / schema.prisma
Last active September 19, 2025 13:57
NextGen Analytics - Prisma schema
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
model Thread {
@wardva
wardva / CV.md
Last active August 8, 2023 19:58
CV Ward

Resume

Name
Ward Van Assche

Address
Emiel Lossystraat 89
9040 Ghent

Contact information