← back to Greenland Onboard

scripts/schema.sql

16 lines

-- Full greenland_catalog schema (this session ADDs these onto the pre-existing thin table).
-- On a fresh dw_unified, run this whole block.
CREATE TABLE IF NOT EXISTS greenland_catalog (
  id serial PRIMARY KEY, vendor_code varchar, gl_id integer,
  mfr_sku varchar, pattern_name varchar, color_name varchar, collection varchar,
  category_name varchar, subcategory_names varchar, product_type varchar,
  "use" varchar, width varchar, width_inches numeric, minimum_order varchar,
  pattern_repeat varchar, fire_rating_us varchar, backing varchar, weight varchar,
  composition varchar, image_url text, all_images text, product_url text,
  us_distributor varchar, on_shopify boolean, is_publish integer,
  specs jsonb, ai_description text, ai_colors jsonb, ai_styles jsonb, ai_tags jsonb,
  color_hex varchar, raw jsonb, dw_sku varchar,
  first_seen_at timestamp default now(), crawled_at timestamp default now(), updated_at timestamp default now()
);
CREATE UNIQUE INDEX IF NOT EXISTS greenland_catalog_gl_id_key ON greenland_catalog(gl_id);