-- Fetch all the ListingItems belonging to the Amazon
-- Selling Partner seller of a particular user.
SELECT *
FROM fiber.amazon_sp_listing_item
WHERE seller_id = '{user.seller_id}'
-- Fetch all the ListingItems belonging to the Amazon
-- Selling Partner seller of a particular user.
SELECT *
FROM fiber.amazon_sp_listing_item
WHERE seller_id = '{user.seller_id}'
Code
CREATE TABLE fiber.amazon_sp_listing_item (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
seller_id TEXT,
sku TEXT,
summaries JSONB,
issues JSONB,
offers JSONB,
fulfillment_availability JSONB,
procurement JSONB,
attributes JSONB
)
CREATE TABLE fiber.amazon_sp_listing_item (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
seller_id TEXT,
sku TEXT,
summaries JSONB,
issues JSONB,
offers JSONB,
fulfillment_availability JSONB,
procurement JSONB,
attributes JSONB
)
Model definition