-- Fetch all the Orders belonging to the Recharge
-- account of a particular user.
SELECT *
FROM fiber.recharge_order
WHERE account_id = '{user.recharge_id}'
-- Fetch all the Orders belonging to the Recharge
-- account of a particular user.
SELECT *
FROM fiber.recharge_order
WHERE account_id = '{user.recharge_id}'
Code
CREATE TABLE fiber.recharge_order (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
available JSONB,
pending JSONB,
object TEXT,
connect_reserved JSONB,
instant_available JSONB,
issuing JSONB,
livemode BOOLEAN
)
CREATE TABLE fiber.recharge_order (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
available JSONB,
pending JSONB,
object TEXT,
connect_reserved JSONB,
instant_available JSONB,
issuing JSONB,
livemode BOOLEAN
)
Model definition