-- Fetch all the Accounts belonging to the Plaid
-- account of a particular user.
SELECT *
FROM fiber.plaid_account
WHERE account_id = '{user.plaid_id}'
-- Fetch all the Accounts belonging to the Plaid
-- account of a particular user.
SELECT *
FROM fiber.plaid_account
WHERE account_id = '{user.plaid_id}'
Code
CREATE TABLE fiber.plaid_account (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
plaid_account_id TEXT,
balances_available DOUBLE PRECISION,
balances_current DOUBLE PRECISION,
balances_iso_currency_code TEXT,
balances_limit DOUBLE PRECISION,
balances_unofficial_currency_code TEXT,
mask TEXT,
name TEXT,
official_name TEXT,
subtype TEXT,
type TEXT
)
CREATE TABLE fiber.plaid_account (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
plaid_account_id TEXT,
balances_available DOUBLE PRECISION,
balances_current DOUBLE PRECISION,
balances_iso_currency_code TEXT,
balances_limit DOUBLE PRECISION,
balances_unofficial_currency_code TEXT,
mask TEXT,
name TEXT,
official_name TEXT,
subtype TEXT,
type TEXT
)
Model definition
