-- Fetch all the Accounts belonging to the Xero
-- organization of a particular user.
SELECT *
FROM fiber.xero_account
WHERE organization_id = '{user.organization_id}'
-- Fetch all the Accounts belonging to the Xero
-- organization of a particular user.
SELECT *
FROM fiber.xero_account
WHERE organization_id = '{user.organization_id}'
Code
CREATE TABLE fiber.xero_account (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
organization_id TEXT,
date TIMESTAMP WITH TIME ZONE,
from TEXT
)
CREATE TABLE fiber.xero_account (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
organization_id TEXT,
date TIMESTAMP WITH TIME ZONE,
from TEXT
)
Model definition
