An indicative product table with JSONB column for specs

product_table_with_jsonb.sql

CREATE TABLE product (
  uuid        UUID    NOT NULL DEFAULT gen_random_uuid(),
  name        TEXT    NOT NULL, 
  category    TEXT    NOT NULL,
  description TEXT    NOT NULL,
  price       NUMERIC NOT NULL,
  spec        JSONB   NOT NULL,
  PRIMARY KEY (uuid)
);