-- Fetch all the Boards belonging to the Monday
-- account of a particular user.
SELECT *
FROM fiber.monday_board
WHERE account_id = '{user.monday_id}'
-- Fetch all the Boards belonging to the Monday
-- account of a particular user.
SELECT *
FROM fiber.monday_board
WHERE account_id = '{user.monday_id}'
Code
CREATE TABLE fiber.monday_board (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
name TEXT,
activity_logs JSONB,
board_folder_id TEXT,
board_kind TEXT,
columns JSONB,
communication JSONB,
creator TEXT,
description TEXT,
groups JSONB,
item_terminology TEXT,
items_count DOUBLE PRECISION,
owner TEXT,
permissions JSONB,
state TEXT,
subscribers JSONB,
tags JSONB,
top_group JSONB,
type TEXT,
url TEXT,
views JSONB,
workspace JSONB
)
CREATE TABLE fiber.monday_board (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
name TEXT,
activity_logs JSONB,
board_folder_id TEXT,
board_kind TEXT,
columns JSONB,
communication JSONB,
creator TEXT,
description TEXT,
groups JSONB,
item_terminology TEXT,
items_count DOUBLE PRECISION,
owner TEXT,
permissions JSONB,
state TEXT,
subscribers JSONB,
tags JSONB,
top_group JSONB,
type TEXT,
url TEXT,
views JSONB,
workspace JSONB
)
Model definition