grocery-manager/db/2022-07-13

--
-- PostgreSQL database dump
--

-- Dumped from database version 13.7 (Debian 13.7-0+deb11u1)
-- Dumped by pg_dump version 13.7 (Debian 13.7-0+deb11u1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: insert_category(text, text); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_category(p_name text, "group" text)
    LANGUAGE sql
    AS $$
INSERT INTO groups(name) VALUES (CASE WHEN "group" IS NULL THEN (SELECT g.name FROM categories AS c JOIN groups AS g ON (group_id = g.id) WHERE c.name = p_name) ELSE "group" END) ON CONFLICT DO NOTHING;
INSERT INTO categories(name, group_id) VALUES(p_name, CASE WHEN "group" IS NULL THEN (SELECT group_id FROM categories WHERE name = p_name) ELSE (SELECT id FROM groups WHERE name = "group") END) ON CONFLICT DO NOTHING;
$$;


ALTER PROCEDURE public.insert_category(p_name text, "group" text) OWNER TO das;

--
-- Name: insert_product(text, text, text); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_product(name text, category text, "group" text DEFAULT NULL::text)
    LANGUAGE sql
    AS $$
CALL insert_category(category, "group");
INSERT INTO products(name, category_id) VALUES(name, (SELECT id FROM categories WHERE name = category)) ON CONFLICT DO NOTHING;
$$;


ALTER PROCEDURE public.insert_product(name text, category text, "group" text) OWNER TO das;

--
-- Name: insert_store(text, text); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_store(p_name text, p_code text)
    LANGUAGE sql
    AS $$INSERT INTO stores(name, code) VALUES (p_name, p_code);$$;


ALTER PROCEDURE public.insert_store(p_name text, p_code text) OWNER TO das;

--
-- Name: insert_transaction(timestamp with time zone, text, text, numeric, text, numeric, text, boolean); Type: PROCEDURE; Schema: public; Owner: das
--

CREATE PROCEDURE public.insert_transaction(ts timestamp with time zone, store text, description text, quantity numeric, unit text, price numeric, product text, organic boolean DEFAULT false)
    LANGUAGE sql
    AS $$
INSERT INTO transactions (ts, store_id, description, quantity, unit_id, price, product_id, organic) VALUES (ts at time zone 'utc', (SELECT id FROM stores WHERE name = store), description, quantity, (SELECT id FROM units WHERE name = unit), price, (SELECT id FROM products WHERE name = product), organic);
$$;


ALTER PROCEDURE public.insert_transaction(ts timestamp with time zone, store text, description text, quantity numeric, unit text, price numeric, product text, organic boolean) OWNER TO das;

--
-- Name: transaction_price_per_unit(text); Type: FUNCTION; Schema: public; Owner: das
--

CREATE FUNCTION public.transaction_price_per_unit(p_unit text) RETURNS TABLE(ts timestamp without time zone, store text, description text, price_per_unit numeric, unit text, product text, category text, "group" text, organic boolean)
    LANGUAGE sql
    AS $$
SELECT ts, store, description, min(CASE WHEN p_unit = "to" AND "from" = unit THEN price /(quantity*factor) WHEN p_unit = "from" AND "to" = unit THEN price*factor/quantity WHEN p_unit = unit THEN price/quantity ELSE NULL END) AS price_per_unit, p_unit AS unit, product, category, "group", organic FROM transaction_view JOIN conversion_view ON ("from" = unit OR "to" = unit) WHERE "to" = p_unit OR "from" = p_unit GROUP BY ts, description, product, category, "group", store, organic; 
$$;


ALTER FUNCTION public.transaction_price_per_unit(p_unit text) OWNER TO das;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: categories; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.categories (
    id integer NOT NULL,
    name text NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.categories OWNER TO das;

--
-- Name: categories_id_seq; Type: SEQUENCE; Schema: public; Owner: das
--

CREATE SEQUENCE public.categories_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.categories_id_seq OWNER TO das;

--
-- Name: categories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: das
--

ALTER SEQUENCE public.categories_id_seq OWNED BY public.categories.id;


--
-- Name: products; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.products (
    id integer NOT NULL,
    name text NOT NULL,
    category_id integer NOT NULL
);


ALTER TABLE public.products OWNER TO das;

--
-- Name: transactions; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.transactions (
    id integer NOT NULL,
    ts timestamp without time zone DEFAULT now() NOT NULL,
    description text NOT NULL,
    organic boolean DEFAULT false NOT NULL,
    quantity numeric NOT NULL,
    price numeric NOT NULL,
    unit_id integer NOT NULL,
    product_id integer NOT NULL,
    store_id integer NOT NULL
);


ALTER TABLE public.transactions OWNER TO das;

--
-- Name: category_over_year_month_breakdown_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.category_over_year_month_breakdown_view AS
 SELECT categories.name AS category,
    date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone) AS year,
    date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone) AS month,
    trunc(sum(t.price), 2) AS total_price
   FROM ((public.transactions t
     JOIN public.products ON ((t.product_id = products.id)))
     JOIN public.categories ON ((products.category_id = categories.id)))
  GROUP BY (date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), (date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), categories.name
  ORDER BY (date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), (date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), categories.name;


ALTER TABLE public.category_over_year_month_breakdown_view OWNER TO das;

--
-- Name: conversions; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.conversions (
    id integer NOT NULL,
    _from integer NOT NULL,
    _to integer NOT NULL,
    factor numeric NOT NULL,
    CONSTRAINT conversions_check CHECK ((id = (_from * _to)))
);


ALTER TABLE public.conversions OWNER TO das;

--
-- Name: units; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.units (
    id integer NOT NULL,
    name text NOT NULL
);


ALTER TABLE public.units OWNER TO das;

--
-- Name: conversion_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.conversion_view AS
 SELECT conversions.factor,
    l.name AS "from",
    r.name AS "to"
   FROM ((public.conversions
     JOIN public.units l ON ((conversions._from = l.id)))
     JOIN public.units r ON ((conversions._to = r.id)));


ALTER TABLE public.conversion_view OWNER TO das;

--
-- Name: conversions_complex; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.conversions_complex (
    id integer NOT NULL,
    _from integer NOT NULL,
    _to integer NOT NULL,
    product_id integer NOT NULL,
    factor numeric NOT NULL
);


ALTER TABLE public.conversions_complex OWNER TO das;

--
-- Name: conversions_complex_id_seq; Type: SEQUENCE; Schema: public; Owner: das
--

CREATE SEQUENCE public.conversions_complex_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.conversions_complex_id_seq OWNER TO das;

--
-- Name: conversions_complex_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: das
--

ALTER SEQUENCE public.conversions_complex_id_seq OWNED BY public.conversions_complex.id;


--
-- Name: groups; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.groups (
    id integer NOT NULL,
    name text NOT NULL
);


ALTER TABLE public.groups OWNER TO das;

--
-- Name: group_over_year_month_breakdown_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.group_over_year_month_breakdown_view AS
 SELECT groups.name AS "group",
    date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone) AS year,
    date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone) AS month,
    trunc(sum(t.price), 2) AS total_price
   FROM (((public.transactions t
     JOIN public.products ON ((t.product_id = products.id)))
     JOIN public.categories ON ((products.category_id = categories.id)))
     JOIN public.groups ON ((categories.group_id = groups.id)))
  GROUP BY (date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), (date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), groups.name
  ORDER BY (date_part('year'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), (date_part('month'::text, (timezone('utc'::text, t.ts))::timestamp without time zone)), groups.name;


ALTER TABLE public.group_over_year_month_breakdown_view OWNER TO das;

--
-- Name: groups_id_seq; Type: SEQUENCE; Schema: public; Owner: das
--

CREATE SEQUENCE public.groups_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.groups_id_seq OWNER TO das;

--
-- Name: groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: das
--

ALTER SEQUENCE public.groups_id_seq OWNED BY public.groups.id;


--
-- Name: stores; Type: TABLE; Schema: public; Owner: das
--

CREATE TABLE public.stores (
    id integer NOT NULL,
    name text NOT NULL,
    code character varying(5) NOT NULL
);


ALTER TABLE public.stores OWNER TO das;

--
-- Name: transaction_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.transaction_view AS
 SELECT (( SELECT timezone('utc'::text, t.ts) AS timezone))::timestamp without time zone AS ts,
    s.name AS store,
    t.description,
    t.quantity,
    u.name AS unit,
    t.price,
    p.name AS product,
    c.name AS category,
    g.name AS "group",
    t.organic,
    s.code
   FROM (((((public.transactions t
     JOIN public.stores s ON ((t.store_id = s.id)))
     JOIN public.units u ON ((t.unit_id = u.id)))
     JOIN public.products p ON ((t.product_id = p.id)))
     JOIN public.categories c ON ((p.category_id = c.id)))
     JOIN public.groups g ON ((c.group_id = g.id)));


ALTER TABLE public.transaction_view OWNER TO das;

--
-- Name: legacy_transaction_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.legacy_transaction_view AS
 SELECT (transaction_view.ts)::date AS ts,
    transaction_view.store,
    transaction_view.description,
    transaction_view."group",
    transaction_view.category,
        CASE
            WHEN transaction_view.organic THEN 'Org'::text
            ELSE ''::text
        END AS note,
    trunc(min(
        CASE
            WHEN ((conversion_view."to" = ANY (ARRAY['kg'::text, 'L'::text])) AND (conversion_view."from" = transaction_view.unit)) THEN (transaction_view.quantity * conversion_view.factor)
            WHEN ((conversion_view."from" = ANY (ARRAY['kg'::text, 'L'::text])) AND (conversion_view."to" = transaction_view.unit)) THEN (transaction_view.quantity / conversion_view.factor)
            WHEN (transaction_view.unit = ANY (ARRAY['kg'::text, 'L'::text])) THEN transaction_view.quantity
            WHEN (transaction_view.unit <> ALL (ARRAY['mL'::text, 'L'::text, 'g'::text, 'kg'::text])) THEN transaction_view.quantity
            ELSE NULL::numeric
        END), 3) AS quantity,
        CASE
            WHEN (transaction_view.unit = ANY (ARRAY['mL'::text, 'L'::text])) THEN 'L'::text
            WHEN (transaction_view.unit = ANY (ARRAY['g'::text, 'kg'::text])) THEN 'kg'::text
            ELSE transaction_view.unit
        END AS unit,
    trunc(transaction_view.price, 2) AS price,
    transaction_view.product
   FROM (public.transaction_view
     LEFT JOIN public.conversion_view ON (((transaction_view.unit = conversion_view."from") OR (transaction_view.unit = conversion_view."to"))))
  GROUP BY transaction_view.ts, transaction_view.store, transaction_view.description, transaction_view."group", transaction_view.category, transaction_view.price, transaction_view.product, transaction_view.organic, transaction_view.unit
  ORDER BY transaction_view.ts, transaction_view.store, transaction_view.description, transaction_view."group", transaction_view.category, transaction_view.price, transaction_view.product, transaction_view.organic, transaction_view.unit;


ALTER TABLE public.legacy_transaction_view OWNER TO das;

--
-- Name: legacy_transaction_with_period_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.legacy_transaction_with_period_view AS
 SELECT (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1) AS period,
    (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) % 4) + 1) AS period_week,
    (transaction_view.ts)::date AS ts,
    transaction_view.store,
    transaction_view.description,
    transaction_view.product,
    transaction_view.category,
    transaction_view."group",
        CASE
            WHEN transaction_view.organic THEN 'Org'::text
            ELSE ''::text
        END AS note,
    trunc(min(
        CASE
            WHEN ((conversion_view."to" = ANY (ARRAY['kg'::text, 'L'::text])) AND (conversion_view."from" = transaction_view.unit)) THEN (transaction_view.quantity * conversion_view.factor)
            WHEN ((conversion_view."from" = ANY (ARRAY['kg'::text, 'L'::text])) AND (conversion_view."to" = transaction_view.unit)) THEN (transaction_view.quantity / conversion_view.factor)
            WHEN (transaction_view.unit = ANY (ARRAY['kg'::text, 'L'::text])) THEN transaction_view.quantity
            WHEN (transaction_view.unit <> ALL (ARRAY['mL'::text, 'L'::text, 'g'::text, 'kg'::text])) THEN transaction_view.quantity
            ELSE NULL::numeric
        END), 3) AS quantity,
        CASE
            WHEN (transaction_view.unit = ANY (ARRAY['mL'::text, 'L'::text])) THEN 'L'::text
            WHEN (transaction_view.unit = ANY (ARRAY['g'::text, 'kg'::text])) THEN 'kg'::text
            ELSE transaction_view.unit
        END AS unit,
    trunc(transaction_view.price, 2) AS price,
    sum(transaction_view.price) OVER (PARTITION BY (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1) ORDER BY transaction_view.ts, transaction_view.description ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS running_total
   FROM (public.transaction_view
     LEFT JOIN public.conversion_view ON (((transaction_view.unit = conversion_view."from") OR (transaction_view.unit = conversion_view."to"))))
  GROUP BY (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1), transaction_view.ts, transaction_view.store, transaction_view.description, transaction_view."group", transaction_view.category, transaction_view.price, transaction_view.product, transaction_view.organic, transaction_view.unit
  ORDER BY (((((transaction_view.ts)::date - ((date_part('year'::text, transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1), transaction_view.ts, transaction_view.store, transaction_view.description, transaction_view."group", transaction_view.category, transaction_view.price, transaction_view.product, transaction_view.organic, transaction_view.unit;


ALTER TABLE public.legacy_transaction_with_period_view OWNER TO das;

--
-- Name: legacy_transaction_with_period_and_mode_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.legacy_transaction_with_period_and_mode_view AS
 SELECT subq.mode,
    legacy_transaction_with_period_view.period,
    legacy_transaction_with_period_view.period_week,
    legacy_transaction_with_period_view.ts,
    legacy_transaction_with_period_view.store,
    legacy_transaction_with_period_view.description,
    legacy_transaction_with_period_view.product,
    legacy_transaction_with_period_view.category,
    legacy_transaction_with_period_view."group",
    legacy_transaction_with_period_view.note,
    legacy_transaction_with_period_view.quantity,
    legacy_transaction_with_period_view.unit,
    legacy_transaction_with_period_view.price,
    legacy_transaction_with_period_view.running_total
   FROM (public.legacy_transaction_with_period_view
     JOIN ( SELECT legacy_transaction_with_period_view_1.period,
            mode() WITHIN GROUP (ORDER BY (to_char((legacy_transaction_with_period_view_1.ts)::timestamp with time zone, 'month'::text))) AS mode
           FROM public.legacy_transaction_with_period_view legacy_transaction_with_period_view_1
          GROUP BY legacy_transaction_with_period_view_1.period) subq USING (period));


ALTER TABLE public.legacy_transaction_with_period_and_mode_view OWNER TO das;

--
-- Name: product_group_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.product_group_view AS
 SELECT g.name AS "group",
    c.name AS category,
    p.name AS product
   FROM ((public.products p
     JOIN public.categories c ON ((p.category_id = c.id)))
     JOIN public.groups g ON ((c.group_id = g.id)))
  ORDER BY g.name, c.name, p.name;


ALTER TABLE public.product_group_view OWNER TO das;

--
-- Name: products_id_seq; Type: SEQUENCE; Schema: public; Owner: das
--

CREATE SEQUENCE public.products_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.products_id_seq OWNER TO das;

--
-- Name: products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: das
--

ALTER SEQUENCE public.products_id_seq OWNED BY public.products.id;


--
-- Name: stores_id_seq; Type: SEQUENCE; Schema: public; Owner: das
--

CREATE SEQUENCE public.stores_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.stores_id_seq OWNER TO das;

--
-- Name: stores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: das
--

ALTER SEQUENCE public.stores_id_seq OWNED BY public.stores.id;


--
-- Name: transaction_rollup_view; Type: VIEW; Schema: public; Owner: das
--

CREATE VIEW public.transaction_rollup_view AS
 SELECT ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) + 1) AS period,
    ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) % 4) + 1) AS week,
    (((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date + ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) * 28)) AS period_start,
    ((((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date + ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) * 28)) + 27) AS period_end,
    legacy_transaction_view."group",
    sum(legacy_transaction_view.price) AS sum
   FROM public.legacy_transaction_view
  GROUP BY (((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4), (((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) % 4), (((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date + ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) * 28)), legacy_transaction_view."group"
  ORDER BY (((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date + ((((legacy_transaction_view.ts - ((date_part('year'::text, legacy_transaction_view.ts) || '-04-01'::text))::date) / 7) / 4) * 28)), legacy_transaction_view."group";


ALTER TABLE public.transaction_rollup_view OWNER TO das;

--
-- Name: transactions_id_seq; Type: SEQUENCE; Schema: public; Owner: das
--

CREATE SEQUENCE public.transactions_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.transactions_id_seq OWNER TO das;

--
-- Name: transactions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: das
--

ALTER SEQUENCE public.transactions_id_seq OWNED BY public.transactions.id;


--
-- Name: units_id_seq; Type: SEQUENCE; Schema: public; Owner: das
--

CREATE SEQUENCE public.units_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.units_id_seq OWNER TO das;

--
-- Name: units_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: das
--

ALTER SEQUENCE public.units_id_seq OWNED BY public.units.id;


--
-- Name: categories id; Type: DEFAULT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.categories ALTER COLUMN id SET DEFAULT nextval('public.categories_id_seq'::regclass);


--
-- Name: conversions_complex id; Type: DEFAULT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions_complex ALTER COLUMN id SET DEFAULT nextval('public.conversions_complex_id_seq'::regclass);


--
-- Name: groups id; Type: DEFAULT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.groups ALTER COLUMN id SET DEFAULT nextval('public.groups_id_seq'::regclass);


--
-- Name: products id; Type: DEFAULT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.products ALTER COLUMN id SET DEFAULT nextval('public.products_id_seq'::regclass);


--
-- Name: stores id; Type: DEFAULT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.stores ALTER COLUMN id SET DEFAULT nextval('public.stores_id_seq'::regclass);


--
-- Name: transactions id; Type: DEFAULT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.transactions ALTER COLUMN id SET DEFAULT nextval('public.transactions_id_seq'::regclass);


--
-- Name: units id; Type: DEFAULT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.units ALTER COLUMN id SET DEFAULT nextval('public.units_id_seq'::regclass);


--
-- Data for Name: categories; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.categories (id, name, group_id) FROM stdin;
1	Aromatics	1
2	Tubers	1
4	Prepared	2
5	Fruit	1
6	Canned Goods	3
7	Eggs	4
8	Fish	4
21	Misc	3
25	Butter	26
32	Veggies	1
34	Coconut Milk	3
35	Coffee	36
36	Chocolate	37
37	Beef	4
315	Organic	144
321	Ice Cream	37
324	Chicken	4
491	Milk	26
498	Condiments	499
1930	Soda	36
144	Tea	36
145	Cheese	26
146	Flour	2
147	Sugar	148
1931	Juice	36
546	Electrolytes	36
548	Water	36
549	Chips	2
555	Supplemental	558
556	Nuts	559
557	Bulk	2
559	Dried Fruit	559
561	Seeds	559
143	Baking	144
565	Bars	499
567	Cold	499
569	Whole	2
570	Legumes	559
1932	Frozen Fruit	1
697	Sweetener	3
1993	Oil	3
2007	Lamb	4
2218	Concentrate	36
2264	Conventional	558
\.


--
-- Data for Name: conversions; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.conversions (id, _from, _to, factor) FROM stdin;
2	1	2	1000
12	3	4	1000
\.


--
-- Data for Name: conversions_complex; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.conversions_complex (id, _from, _to, product_id, factor) FROM stdin;
1	7	2	2	166
\.


--
-- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.groups (id, name) FROM stdin;
1	Produce
2	Grains
3	Staples
4	Fish, Meat, Eggs
13	bogus
26	Dairy
36	Drinks
37	Treats
144	Baking
148	Fermenting
499	Prepared
558	Spices
559	Dry Goods
1367	
\.


--
-- Data for Name: products; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.products (id, name, category_id) FROM stdin;
496	Saurkraut	498
2	Onions	1
3	Potatoes	2
4	Crackers	4
5	Bananas	5
6	Tomato Paste	6
7	Free Range Eggs	7
8	Fish Fillets	8
497	Parsnips	32
19	Vinegar	21
20	Apples	5
21	Kumara	2
22	Mushrooms	1
23	Butter	25
501	Canned Tomatoes	6
502	Organic Cheese	145
30	Squash	32
31	Carrots	32
32	Coconut Cream	34
704	FR Chicken Drumsticks	324
34	Whittakers Chocolate	36
35	Beef Mince	37
533	Fish Frames	8
534	Organic Chicken	324
141	Chocolate Chips	143
142	Tulsi Tea	144
143	Vintage Cheese	145
144	Wholemeal Flour	146
145	White Sugar	147
148	Avocado	5
312	Apple Cider Vinegar	21
314	Whole Fish	8
315	Fish Heads	8
317	Mango	5
318	Beetroot	32
319	Ice Cream	321
320	Frozen Peas	32
321	Tasty Cheese	145
322	Whole Chicken	324
489	Raw Milk	491
490	Cream	491
535	Curry Paste	498
536	Cucumber	32
208	Butternut Squash	32
149	Capsicum	32
537	Ginger	1
538	Chicken Drumsticks	324
539	Garlic	1
540	Jalapenos Canned	6
541	Beef Chuck	37
542	Blade Steak	37
2203	Hot Chilli	32
544	Coconut Water	546
545	Chicken Thighs	324
546	Water	548
547	Corn Chips	549
548	Canned Tuna	8
549	FR Chicken Thighs	324
551	Strawberries	5
552	Cabbage	32
553	Brewers Yeast	555
554	Almonds	556
555	Quinoa	557
556	Nutritional Yeast	555
557	Sultanas	559
559	Hemp Seeds	561
2347	Cacao Powder	143
313	Vanilla	143
33	Coffee Beans	35
563	OSM bars	565
564	Starter	143
565	Coconut Yoghurt	567
566	White Flour	146
567	Brown Rice	569
568	Red Lentils	570
569	Mung Beans	570
570	Pumpkin Seeds	561
571	Salt	21
572	Pukka Tea	144
708	FR Chicken Mince	324
2215	Chicken Nibbles	324
712	Chicken Mince	324
2216	Soda Syrup	2218
2217	Rooibos Tea	144
715	Peaches	5
1362	Brazil Nuts	556
1363	Tomato Fresh	32
1364	Marmite	498
2226	Tumeric	1
1991	Coconut Oil	1993
1992	Candied Ginger	21
1993	Olives Jar	6
1994	Pasta	4
1373	Bars	565
1374	Nut Bars	565
1922	Mandarins	5
1923	Broccoli	32
1924	Cauliflower	32
1925	Kiwifruit	5
1926	Pears	5
1927	Burger Patties	37
1928	Tonic Water	1930
1929	Tomato Juice	1931
1930	Blueberries Frozen	1932
1931	Strawberries Frozen	1932
2005	Lamb Shank	2007
2006	Beef Sausages	37
1944	Chicken Frames	324
1945	Canned Peaches	6
1946	Mayo	498
1947	Eggplant	32
1948	M&Ms Mini	36
2262	Garam Masala	2264
2263	Ginger Ground	2264
695	Honey	697
2264	Paprika	2264
1338	Canned Salmon	8
1339	Apricots	5
701	Dried Dates	559
1340	Plums	5
1341	Watermelon	5
1342	Colby Cheese	145
2132	Kelp	555
2155	Fish Sauce	498
2197	Doritos	549
2198	Smoked Salmon	8
2199	Tomato Sauce	6
2200	Seaweed	555
2206	FR Chicken Whole	324
2222	Beef Shin	37
2223	Lamb Cubes	2007
1951	Rye Flour	146
1965	Mild Cheese	145
1966	Beans Canned	6
2267	Baking Soda	143
2118	Oranges	5
2119	Lamb Mince	2007
2120	Pinenuts	556
2128	Chicken Thighs BL	324
2129	Beef Stir Fry	37
2149	Buckwheat Groats	561
2150	Wheat Berries	569
2151	Coconut Desiccated	559
2152	Sunflower Seeds	561
2377	Beef Scotch Fillet	37
2378	Brown Lentils	570
2379	Dry Peas	570
2380	Meatballs	37
2381	Potato Crisps	549
2398	Potato Chips	549
2399	Mixed Fruit Frozen	1932
2400	Beef Patties	37
2401	Maple Syrup	697
\.


--
-- Data for Name: stores; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.stores (id, name, code) FROM stdin;
1	Countdown	CD
3	Healthpost	HP
4	Bin Inn	BI
5	Dreamview	DV
6	Co-op	CO
9	Gordonton Farm Shop	GFS
11	TOFS	TOFS
12	Seafood Bazaar	SB
13	Whatawhata Berry Farm	Farm
2	PaknSave	PnS
14	Taupiri Dairy	TD
15	Sarah Geerlings	PERSN
31	New World	NW
34	Four Square	FS
32	Farmers Market	FM
37	SummerGlow Apiaries	SG
40	Tonic Health	TH
43	New Save	NS
\.


--
-- Data for Name: transactions; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.transactions (id, ts, description, organic, quantity, price, unit_id, product_id, store_id) FROM stdin;
850	2021-06-21 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	489	5
851	2021-06-28 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	489	5
2	2021-06-17 04:41:00	Onions brown loose	f	702	1.76	2	2	1
3	2021-06-17 04:41:00	Potatoes washed loose	f	2.117	6.33	1	3	1
5	2021-06-17 04:41:00	Arnotts vita-weat cracked pepper	f	250	3.5	2	4	1
6	2021-06-17 04:41:00	Short date bananas on special	f	2	3	6	5	1
7	2021-06-17 04:41:00	Ceres Organics tomato paste	t	1140	16.20	2	6	1
852	2021-07-05 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	489	5
853	2021-07-12 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	489	5
12	2021-06-22 22:59:00	Pams White Vinegar 2L	f	2	3.79	3	19	2
13	2021-06-22 22:59:00	NZ Trevally Fillets	f	590	14.04	2	8	2
14	2021-06-22 22:59:00	Apples Pink Lady Large	f	1.201	1.55	1	20	2
15	2021-06-22 22:59:00	Kumara Orange	f	851	2.54	2	21	2
17	2021-06-22 22:59:00	Onions Brown loose	f	196	0.29	2	2	2
16	2021-06-22 22:59:00	Mushrooms white button	f	157	1.73	2	22	2
854	2021-07-19 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	489	5
18	2021-06-22 22:59:00	Anchor butter 500g	f	500	4.80	2	23	2
855	2021-07-26 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	489	5
856	2021-07-28 00:00:00	Dreamview Cream 500mL	f	0.5	6	3	490	5
857	2021-08-02 00:00:00	Dreamview Raw Milk 1L	f	2	6	3	489	5
864	2021-08-11 23:07:00	Local Spray Free Potatoes	f	3	8	1	3	9
865	2021-08-11 23:07:00	Local Spray Free Onions	f	4	2	7	2	9
866	2021-08-11 23:07:00	Good Bugs Ginger Ninja Kimchi	f	500	16	2	496	9
867	2021-08-11 23:07:00	Local Spray Free Parsnips	f	460	3	2	497	9
28	2021-06-22 23:31:00	Potato bag 2.5 kg Odd Bunch	f	2.5	4	1	3	1
29	2021-06-22 23:31:00	Pumpkin Butternut Whole Ea	f	1	3	7	30	1
30	2021-06-22 23:31:00	CD Eggs Sz7 6 pk Special x 2	f	744	5.3	2	7	1
31	2021-06-22 23:31:00	Macro Organic Carrots 1 kg	t	1	6	1	31	1
32	2021-06-22 23:31:00	Essentials Coconut Cream 400 mL	f	800	2.60	4	32	1
33	2021-06-22 23:31:00	Essentials French Whole Bean 200g	f	200	5	2	33	1
34	2021-06-22 23:31:00	Arnotts Vita-weat Cracked Pepper 250g	f	1	10	1	4	1
35	2021-06-22 23:31:00	Whittakers Block Dark Ghana 250g	f	250	4.7	2	34	1
36	2021-06-22 23:31:00	Beef Value Mince 82% 1 kg	f	1	10.90	1	35	1
885	2021-08-12 01:33:00	Essentials Coconut Cream 400 mL	f	1200	3.90	4	32	1
533	2021-08-05 05:33:00	Ceres Organic Apple Cider Vinegar 750mL	t	750	7.89	4	312	2
534	2021-08-05 05:33:00	Coulston Hill Eggs Free Range Mixed 12pk x2	f	1164	10.98	2	7	2
535	2021-08-05 05:33:00	Pams Flour Wholemeal 1.5 kg	f	1.5	1.98	1	144	2
536	2021-08-05 05:33:00	T/Colledge Vanilla Exract 100 mL FairTrade	t	100	8.99	4	313	2
537	2021-08-05 05:33:00	NZ Parore (Black Snapper) Whole	f	1.076	9.46	1	314	2
538	2021-08-05 05:33:00	NZ Snapper Heads	f	0.652	4.56	1	315	2
539	2021-08-05 05:33:00	Apples Cripps Pink Lady Medium	f	1.136	1.12	1	20	2
540	2021-08-05 05:33:00	Apples Fuji	f	1.026	0.81	1	20	2
541	2021-08-05 05:33:00	Bananas Conventional	f	1.131	3.04	1	5	2
542	2021-08-05 05:33:00	Beetroot Conventional	f	0.276	0.96	1	318	2
543	2021-08-05 05:33:00	Kumara Orange	f	2.211	4.40	1	21	2
544	2021-08-05 05:33:00	Mango Mexico Large	f	1	1.89	7	317	2
545	2021-08-05 05:33:00	Mushrooms White Button	f	0.162	1.78	1	22	2
228	2021-06-30 08:39:00	WW Chocolate Chips Dark 200g	f	0.2	2.5	1	141	1
229	2021-06-30 08:40:00	Mainland Cheese Vintage 500g	f	0.5	10.5	1	143	1
230	2021-06-30 08:41:00	Otaika Valley Size 7 12 pack	f	744	7	2	7	1
231	2021-06-30 08:40:00	Whittakers Blk Dark Almond 62% 250g	f	250	4.70	2	34	1
232	2021-06-30 23:20:00	Ceres Organic Tomato Paste 190g	f	1140	14.94	2	6	2
233	2021-06-30 23:20:00	Pams Flour Wholemeal 1.5 kg	f	1.5	1.98	1	144	2
234	2021-06-16 00:00:00	Tulsi Tumeric Ginger Tea	f	25	0	7	142	3
235	2021-06-16 00:00:00	Tulsi Orginal Loose Leaf Tea	f	100	16.40	2	142	3
236	2021-06-16 00:00:00	Tulsi Licorice Spice Tea	f	25	9.50	7	142	3
237	2021-06-30 23:20:00	Pams White Sugar 3 kg	f	3	4.89	1	145	2
238	2021-06-30 23:20:00	Hoki Fillets Fresh	f	0.768	9.82	1	8	2
239	2021-06-30 23:20:00	Apples Braeburn	f	0.961	3.55	1	20	2
240	2021-06-30 23:20:00	Avocado Small	f	4	5	7	148	2
241	2021-06-30 23:20:00	Capsicum Red NZ	f	1	2.99	7	149	2
242	2021-06-30 23:20:00	Carrots Loose	f	1.261	2	1	149	2
243	2021-06-30 23:20:00	Kumara Orange	f	1.136	2.83	1	21	2
244	2021-06-30 23:20:00	Mushrooms White Button Loose	f	0.182	2	1	22	2
245	2021-06-30 23:20:00	Onions Brown Loose	f	0.786	1.01	1	2	2
546	2021-08-05 05:33:00	Onions Brown	f	0.901	1.16	1	2	2
547	2021-08-05 05:33:00	Ben N Jerrys Choc Chip Cookie Dough Ice Cream 458mL	f	458	5	4	319	2
548	2021-08-05 05:33:00	Pams Frozen Peas, Garden 1kg	f	1	2.69	1	320	2
549	2021-08-05 05:33:00	Eclipse Cheese Tasty 1 kg	f	1	11.99	1	321	2
550	2021-08-05 05:33:00	Bird N Barrow Free Range Chicken Whole Short Date Special	f	1.7	10.19	1	322	2
551	2021-08-05 05:33:00	NZ Beef Mince Special	f	0.865	8.65	1	35	2
888	2021-08-12 01:33:00	Mainland Cheese Vintage 500g	f	500	10.50	2	143	1
1324	2021-11-29 20:45:00	Bananas Cavendish	f	0.742	2.23	1	5	1
886	2021-08-12 01:33:00	Macro Organic Tomatoes Diced NAS 400g	t	2000	7.50	2	501	1
262	2021-07-27 04:29:00	Onions Brown Loose	f	0.762	1.52	1	2	1
263	2021-07-27 04:29:00	Mushrooms Button Loose	f	0.318	4.13	1	22	1
264	2021-07-27 04:29:00	Heyden Farms Free Range Sz 7 18 pk	f	1.116	10	1	7	1
265	2021-07-27 04:29:00	Essentials Coconut Cream 400 mL	f	1200	3.9	4	32	1
266	2021-07-27 04:29:00	Whittakers Block Dark Almond 62% 250g	f	250	4.3	2	34	1
267	2021-07-27 04:29:00	Countdown Free Range Sz 6 6pk Short Date Sale x 2	f	636	5.84	2	7	1
954	2021-08-19 01:56:00	Heyden Farms FR Organic Eggs Mixed Grade 10pk	t	485	8.99	2	7	2
357	2021-07-29 06:26:00	Mainland Cheese Vintage	f	500	10.50	2	143	1
358	2021-07-29 06:26:00	Whittakers Block Cocoa Dark 72% 250g	f	750	12.90	2	34	1
359	2021-07-29 06:26:00	Organic Jazz Apple 1 kg bag	t	1	5.50	1	20	1
360	2021-07-29 06:26:00	Pumpkin Butternut Whole Organic	t	1	3.50	7	208	1
955	2021-08-19 01:56:00	NZ Salmon Frames (t/p) x1	f	0.498	4.98	1	533	2
956	2021-08-19 01:56:00	NZ Snapper Heads x2	f	0.430	3.01	1	315	2
957	2021-08-19 01:56:00	Apples Cripps Pink Lady Medium	f	1.736	1.72	1	20	2
958	2021-08-19 01:56:00	Capsicum Yellow	f	3	5	7	149	2
959	2021-08-19 01:56:00	Carrots, Loose	f	0.851	0.84	1	31	2
960	2021-08-19 01:56:00	Mushrooms White Button	f	0.192	2.40	1	22	2
961	2021-08-19 01:56:00	Onions Brown	f	0.556	0.55	1	2	2
962	2021-08-19 01:56:00	Mainland Cheese Organic 500g	t	500	10.39	2	502	2
963	2021-08-19 01:56:00	NZ Organic Chicken Butterfly Bostocks Reduced	t	1.19	12.48	1	534	2
890	2021-08-12 01:33:00	CD Beef Mince 82% 1kg Price Reduced by $5.50	f	1	10.27	1	35	1
891	2021-08-12 01:33:00	CD Free Range Eggs Size 8 6pk Reduced Price	f	1632	10.84	2	7	1
892	2021-08-12 01:33:00	Quick Sale Bananas Freetrade 	f	2	3	1	5	1
966	2021-08-19 01:08:00	Bananas Cavendish	f	0.922	2.58	1	5	1
1325	2021-11-29 20:45:00	Mushrooms Button Loose	f	0.223	2.90	1	22	1
1326	2021-11-29 20:45:00	Garlic NZ	f	0.047	1.17	1	539	1
970	2021-08-19 01:08:00	Macro Organic Tomatoes Diced NAS 400g	t	1600	6	2	501	1
971	2021-08-19 01:08:00	Woodlands Free Range Size 6 10 pk	f	530	4.90	2	7	1
972	2021-08-19 01:08:00	Avocado Loose	f	2	2.50	7	148	1
887	2021-08-12 01:33:00	Macro Organic Fairtrade Medium Beans 200g	f	200	6.50	2	33	1
1054	2021-07-19 21:35:00	Onions Brown Loose	f	0.577	1.44	1	2	1
1055	2021-07-19 21:35:00	Apples 2kg Odd Bunch	f	2	4.30	1	20	1
1056	2021-07-19 21:35:00	Carrots, 1.5 kg Odd Bunch	f	1.5	2	1	31	1
1057	2021-07-19 21:35:00	Countdown Free Range Sz 7 6pk Reduced	f	372	2.10	2	7	1
1058	2021-07-19 21:35:00	Big Paddock Free Range Eggs Mixed 10pk	f	485	5	2	7	1
1059	2021-07-19 21:35:00	Macro Organic Tomatoes Diced NAS 400g	t	1200	4.50	2	501	1
1327	2021-11-29 20:45:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.49	6.49	1	549	1
1328	2021-11-29 20:45:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.546	7.47	1	549	1
1329	2021-11-29 20:45:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.474	6.36	1	549	1
1330	2021-11-29 20:45:00	Essentials Coconut Cream 400 mL	f	400	2.4	4	32	1
1331	2021-11-29 20:45:00	Huntley & Palmers Rosemary Garlic Crackers	f	200	3.40	2	4	1
1332	2021-11-29 20:45:00	Anchor butter 500g	f	500.00	5.8	2	23	1
1333	2021-11-29 20:45:00	Mainland Cheese Organic 500g	t	500	10.60	2	502	1
1334	2021-11-29 20:45:00	Organic Potato	t	2	6.99	1	3	1
1074	2021-08-27 05:14:00	Apple Rose Medium	f	0.257	1.16	1	20	1
1075	2021-08-27 05:14:00	WW French Whole Beans 200g	f	200.00	5	2	33	1
1076	2021-08-27 05:14:00	Countdown Free Range Sz 7 6pk	f	372.00	4.2	2	7	1
1077	2021-08-27 05:14:00	Loose Avocado	f	2	2.3	7	148	1
1335	2021-11-29 20:45:00	Onion Odd Bunch bag 1.5 kg	f	1.5	3.50	1	2	1
1336	2021-11-29 20:45:00	Apples 2 kg Odd Bunch	f	2	4.90	1	20	1
1337	2021-11-29 20:45:00	Avocado Loose	f	2	2.50	7	148	1
1338	2021-11-29 20:45:00	Capsicum Odd Bunch 750g	f	750	5	2	149	1
1342	2021-11-22 23:00:00	Organic Beef Mince 90/10	t	0.4	11	1	35	11
1343	2021-11-22 23:00:00	Organic Beef Blade Steak	t	0.4	11	1	542	11
1344	2021-11-22 23:00:00	Organic Beef Chuck	t	0.40	11	1	541	11
1254	2021-07-02 00:00:00	Organic Beef Mince 90/10	t	0.4	10	1	35	11
1255	2021-07-02 00:00:00	Organic Beef Chuck	t	0.4	10	1	541	11
1256	2021-07-02 00:00:00	Organic Beef Blade Steak	t	0.8	20	1	542	11
1614	2021-11-30 23:00:00	Bulk Red Lentils Ceres 3.5 kg bag	t	3.5	20.26	1	568	6
1615	2021-11-30 23:00:00	Bulk Mung Beans Ceres 3.5 kg bag	t	1	7.72	1	569	6
1616	2021-11-30 23:00:00	Bulk Pumpkin Seeds Ceres 3 kg bag	t	3	39.44	1	570	6
1352	2021-11-15 23:00:00	Hoki Fillets Fresh	f	0.548	10.38	1	8	12
1353	2021-11-15 23:00:00	NZ Snapper Heads	f	1.322	5.95	1	315	12
1356	2021-11-10 23:00:00	Organic Beef Mince 90/10	t	0.4	11.40	1	35	11
1357	2021-11-10 23:00:00	Organic Beef Chuck	t	0.40	11.40	1	541	11
1617	2021-11-30 23:00:00	Bulk Ceres Salt	t	1	2.93	1	571	6
1618	2021-11-30 23:00:00	Licorice and Cinnamon Tea, Pukka 20 count box 40g NET	t	40	15.50	18	572	6
2480	2021-12-20 23:18:00	Value Honey Creamed Clover Blend 500g	f	0.5	5.49	1	695	2
2481	2021-12-20 23:18:00	Otaika Valley Size 7 12 pack	f	2976.00	27.96	2	7	2
2482	2021-12-20 23:18:00	Pams Flour Wholemeal 1.5 kg	f	1.50	1.98	1	144	2
2483	2021-12-20 23:18:00	Queens Diamond Pitted Dates 400g	f	400	2.19	2	701	2
2484	2021-12-20 23:18:00	T/Colledge Vanilla Exract 100 mL FairTrade	t	100.00	8.99	4	313	2
2485	2021-12-20 23:18:00	Value Rice Brown Long Grain 1 kg	f	1	2.09	1	567	2
1294	2021-11-23 00:42:00	Bananas Cavendish	f	1.207	3.62	1	5	1
1295	2021-11-23 00:42:00	Onions Brown Loose	f	0.722	2.16	1	2	1
1296	2021-11-23 00:42:00	Mushrooms Button Loose	f	0.233	3.03	1	22	1
1297	2021-11-23 00:42:00	Waitoa Free Range Chicken Thigh Fillet, Reduced	f	0.532	8.78	1	549	1
1298	2021-11-23 00:42:00	Waitoa Free Range Chicken Thigh Fillet, Reduced	f	0.546	9.01	1	549	1
1299	2021-11-23 00:42:00	Waitoa Free Range Chicken Thigh Fillet, Reduced	f	0.542	8.94	1	549	1
1110	2021-07-14 22:30:00	SweeTango loose apples	f	1.442	7.93	1	20	1
1111	2021-07-14 22:30:00	Onions Brown Loose	f	0.317	0.48	1	2	1
1112	2021-07-14 22:30:00	Otaika Valley Size 7 12 pack Reduced	f	1488.00	13.60	2	7	1
1113	2021-07-14 22:30:00	Exotic Food Panang Curry Paste	f	200	3.95	2	535	1
1114	2021-07-14 22:30:00	Essentials Coconut Cream 400 mL	f	400	1.3	4	32	1
1115	2021-07-14 22:30:00	Organic Potato	t	2	6.99	1	3	1
1116	2021-07-14 22:30:00	Arnotts Vita-weat Cracked Pepper 250g	f	500.00	5	2	4	1
2486	2021-12-20 23:18:00	Whittakers Block Dark Ghana 250g	f	500	9	2	34	2
1118	2021-08-25 23:34:00	Cucumber Green	f	1	4.49	7	536	1
969	2021-08-19 01:08:00	Whittakers Block Cocoa Dark 72% 250g	f	750	12.90	2	34	1
2487	2021-12-20 23:18:00	Whole Snapper Leigh, 1.225 kg after gutted	f	1.456	23.28	1	314	2
889	2021-08-12 01:33:00	Mainland Cheese Organic 500g	t	1	21.00	1	502	1
2488	2021-12-20 23:18:00	Apples Braeburn	f	1.931	7.32	1	20	2
2489	2021-12-20 23:18:00	Avocado Small	f	4	2	7	148	2
2490	2021-12-20 23:18:00	Bananas Conventional	f	1.826	4.91	1	5	2
1347	2021-11-22 23:01:00	NZ Snapper Heads	f	1.17	5.27	1	315	12
1125	2021-07-20 00:18:00	NZ Hoki Fillets	f	0.474	6.06	1	8	2
1126	2021-07-20 00:18:00	Fresh Ginger	f	0.251	3.76	1	537	2
1127	2021-07-20 00:18:00	Mushrooms White Button Loose	f	0.192	2.11	1	22	2
1128	2021-07-20 00:18:00	Mainland Cheese Organic 500g	t	500	10.39	2	502	2
2491	2021-12-20 23:18:00	Beetroot Conventional	f	0.296	1.27	1	318	2
2492	2021-12-20 23:18:00	Carrots, Loose	f	0.626	1.25	1	31	2
2493	2021-12-20 23:18:00	Cucumber Telegraph	f	1.00	0.99	7	536	2
2494	2021-12-20 23:18:00	Kumara Orange	f	1.401	4.19	1	21	2
2495	2021-12-20 23:18:00	Mushrooms Button Loose	f	0.347	4.33	1	22	2
2496	2021-12-20 23:18:00	Onions Brown	f	1.731	3.44	1	2	2
1362	2021-11-10 23:00:00	Snapper Frames	f	0.684	3.08	1	533	12
1363	2021-11-10 23:00:00	NZ Snapper Heads	f	1	4.5	1	315	12
1365	2021-11-04 23:00:00	Snapper Frames	f	0.99	4.48	1	533	12
1371	2021-10-30 23:00:00	Local Carrot Bunch	f	1	2	6	31	9
1372	2021-10-30 23:00:00	Local Spray Free Onions	f	4	2	7	2	9
1373	2021-10-30 23:00:00	Local Cabbage	f	1	5	7	552	9
1374	2021-10-30 23:00:00	Good Bugs Ginger Ninja Kimchi	f	500.00	16.00	2	496	9
1375	2021-10-30 23:00:00	Local Avocado	f	1	1.5	7	148	9
1379	2021-08-05 00:00:00	Organic Beef Mince 90/10	t	0.4	11	1	35	11
1380	2021-08-05 00:00:00	Organic Beef Blade Steak	t	0.4	11	1	542	11
1381	2021-08-05 00:00:00	Organic Beef Chuck	t	0.40	11	1	541	11
2497	2021-12-20 23:18:00	Potatoes washed loose	f	1.246	2.85	1	3	2
2498	2021-12-20 23:18:00	Capsicum mixed bag 700g	f	0.7	2.99	1	149	2
2499	2021-12-20 23:18:00	Anchor butter 500g	f	500	4.9	2	23	2
2500	2021-12-20 23:18:00	Lewis Road Creamery Organic Single Cream 300mL	f	0.3	3.99	3	490	2
1387	2021-11-10 23:00:00	PYO Strawberries at Whatawhata Berry Farm	f	1.037	15.94	1	551	13
3062	2021-11-11 01:02:00	Ceres Organic Tomato Paste 190g	t	760.00	9.96	2	6	2
3063	2021-11-11 01:02:00	Otaika Valley Size 7 12 pack	f	744	6.99	2	7	2
3064	2021-11-11 01:02:00	Otaika Valley Sz 8 10pk 675g	f	1350.00	12.58	2	7	2
3065	2021-11-11 01:02:00	Robert Harris Italian Roast Beans 240g	f	480.00	9.00	2	33	2
3066	2021-11-11 01:02:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	2
3067	2021-11-11 01:02:00	Avocado Small	f	4	4	7	148	2
2558	2021-11-03 23:13:00	Loose Avocado	f	2	2	7	148	1
2559	2021-11-03 23:13:00	Capsicum Red NZ	f	2	3	7	149	1
2560	2021-11-03 23:13:00	WW Coconut Water 1L	f	3	10.50	3	544	1
2561	2021-11-03 23:13:00	Macro Organic Apple 1 kg bag	t	1	4.5	1	20	1
1300	2021-11-23 00:42:00	Countdown Free Range Eggs, Mixed 20 pk	f	970	9.50	2	7	1
1301	2021-11-23 00:42:00	Macro Organic White Washed Potatoes 1.5 kg	t	1.5	8.5	1	3	1
1302	2021-11-23 00:42:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	7	1
1303	2021-11-23 00:42:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	31	1
1304	2021-11-23 00:42:00	Essentials Coconut Cream 400 mL	f	2400.00	7.2	4	32	1
1305	2021-11-23 00:42:00	Robert Harris Italian Roast Beans 200g	f	200.00	5	2	33	1
1306	2021-11-23 00:42:00	WW Tuna Lemon Pepper 95 g	f	95	1.3	2	548	1
1307	2021-11-23 00:42:00	WW Tuna in Springwater 95 g	f	570.00	7.8	2	548	1
1308	2021-11-23 00:42:00	Macro Organic Tomatoes Diced NAS 400g	t	800.00	3	2	501	1
2562	2021-11-03 23:13:00	Mainland Cheese Vintage 500g	f	500	10.50	2	143	1
2563	2021-11-03 23:13:00	Mainland Cheese Organic 500g	t	1000	21.20	2	502	1
2564	2021-11-03 23:13:00	Macro Free Range Chicken Mince Reduced	f	450	7	2	708	1
2565	2021-11-03 23:13:00	Macro Organic White Washed Potatoes 1.5 kg	t	1.5	8.5	1	3	1
2566	2021-11-03 23:13:00	Woodland Free Range Eggs Sz6 18pk	f	954.00	8.50	2	7	1
3068	2021-11-11 01:02:00	Bananas Conventional	f	1.92	3.83	1	5	2
3069	2021-11-11 01:02:00	Cucumber Telegraph	f	1.00	1.99	7	536	2
3070	2021-11-11 01:02:00	Kumara Orange	f	0.61	1.83	1	21	2
1178	2021-11-15 19:44:00	Onions Brown Loose	f	0.922	2.31	1	2	1
1179	2021-11-15 19:44:00	Mushrooms Button Loose	f	0.243	3.16	1	22	1
1180	2021-11-15 19:44:00	Apples Royal Gala	f	0.967	4.06	1	20	1
1181	2021-11-15 19:44:00	Chicken Thighs, Conventional, Reduced	f	0.889	7.46	1	545	1
1182	2021-11-15 19:44:00	Macro Organic White Washed Potatoes 1.5kg Reduced Price	t	1.5	5.95	1	3	1
1183	2021-11-15 19:44:00	Woodland Free Range Eggs Sz6 18pk	f	954	8.5	2	7	1
1184	2021-11-15 19:44:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.5	2	34	1
1185	2021-11-15 19:44:00	Tongariro Natural Spring Water 5L	f	5	3.90	3	546	1
1186	2021-11-15 19:44:00	Capsicum Odd Bunch 750g	f	750	5	2	149	1
1187	2021-11-15 19:44:00	Banana Fairtrade Organic 850g	t	850	4.5	2	5	1
1188	2021-11-15 19:44:00	Mainland Cheese Organic 500g	t	1000	21.20	2	502	1
1189	2021-11-15 19:44:00	Mexicano Corn Chips Natural 300g	f	600	4.90	2	547	1
3071	2021-11-11 01:02:00	Mushrooms Button Loose	f	0.24	2.06	1	22	2
3072	2021-11-11 01:02:00	Apples Fuji Organic 1 kg bag	t	1	3.99	1	20	2
3073	2021-11-11 01:02:00	Eclipse Cheese Tasty 1 kg	f	1.00	11.99	1	321	2
3074	2021-11-11 01:02:00	Chicken Mince, reduced	f	0.518	7.99	1	712	2
6276	2022-01-17 20:17:00	Chicken Frames by Weight	f	1.51	6.04	1	1944	1
6277	2022-01-17 20:17:00	Mushrooms Button Loose	f	0.353	4.94	1	22	1
6278	2022-01-17 20:17:00	Kumara Orange	f	0.507	1.77	1	21	1
1202	2021-11-15 20:10:00	Pam's Organic Fuji Apples 1 kg	t	1	3.99	1	20	2
1203	2021-11-15 20:10:00	Anchor butter 500g	f	500.00	5.4	2	23	2
1204	2021-11-15 20:10:00	Mainland Cheese Organic 500g	t	500	10.39	2	502	2
1205	2021-11-15 20:10:00	Hoco Coconut Water 1L	f	1	2.99	3	544	2
1207	2021-11-03 23:00:00	Snapper Frames	f	0.995	4.48	1	533	12
1620	2021-07-17 00:00:00	Whittakers Block Dark Ghana 250g	f	500	9	2	34	2
6279	2022-01-17 20:17:00	Bananas Cavendish	f	1.137	3.41	1	5	1
6280	2022-01-17 20:17:00	Kiwifruit Green NZ	f	0.432	3.67	1	1925	1
6281	2022-01-17 20:17:00	Apricots Fresh Loose	f	0.382	2.29	1	1339	1
6282	2022-01-17 20:17:00	Watermelon Red Whole 1ea	f	2.04	5.10	1	1341	1
6283	2022-01-17 20:17:00	Killinchy Gold Choc Hazelnut 1L	f	1	9	3	319	1
6284	2022-01-17 20:17:00	Beef Value Mince 82% 500g Reduced	f	1.5	19.86	1	35	1
6285	2022-01-17 20:17:00	Countdown frozen blueberries 1kg	f	1.00	9.50	1	1930	1
6286	2022-01-17 20:17:00	Woodlands Free Range Size 6 10 pk	f	530	4.90	2	7	1
6287	2022-01-17 20:17:00	WW Peach SLices in Fruit Juice 410g	f	820.00	3	2	1945	1
6288	2022-01-17 20:17:00	Macro Organic Tomatoes Diced NAS 400g	t	1600.00	6	2	501	1
2999	2021-11-03 23:00:00	OSM bars chocolate 6 pieces 507g NET 	f	6	13.48	7	563	2
3000	2021-11-03 23:00:00	Fresh Ginger	f	0.096	1.15	1	537	2
3001	2021-11-03 23:00:00	Mushrooms Button Loose	f	0.207	2.59	1	22	2
3002	2021-11-03 23:00:00	Eclipse Cheese Tasty 1 kg	f	1	11.99	1	321	2
6289	2022-01-17 20:17:00	Macro Organic Whole Egg Mayo 440g	t	440	6.5	2	1946	1
6290	2022-01-17 20:17:00	WW Flour Wholemeal 1.5 kg	f	1.50	2	1	144	1
6291	2022-01-17 20:17:00	Eggplant Odd Bunch 500g	f	500	2.99	2	1947	1
6292	2022-01-17 20:17:00	Onions brown 1.5 kg	f	1.5	4.99	1	2	1
6293	2022-01-17 20:17:00	M&Ms Minis Tube 35g	f	35	1.49	2	1948	1
6294	2022-01-17 20:17:00	Mexicano Corn Chips Natural 300g	f	300	3	2	547	1
6644	2022-01-31 23:07:00	Ceres Organic Tomato Paste 190g	t	570.00	7.47	2	6	2
6301	2021-12-14 23:00:00	Local Market Cabbage	f	1.00	3	7	552	32
6645	2022-01-31 23:07:00	OSM bars chocolate 6 pieces 507g NET 	f	12	25.78	7	563	2
6309	2022-01-09 23:00:00	Local Market Cabbage	f	3	9	7	552	32
6646	2022-01-31 23:07:00	Otaika Valley Size 7 12 pack	f	744	6.99	2	7	2
6313	2022-01-12 23:00:00	Tongariro Natural Spring Water 15L	f	15.00	10.5	3	546	1
6198	2021-12-31 03:00:00	Fres produce the Odd Bunch Mandarins 1kg	f	1	5.2	1	1922	1
6199	2021-12-31 03:00:00	Watties tomatoes roasted garlic and onion 400g	f	400	2.20	2	501	1
6200	2021-12-31 03:00:00	CD Cream 1L	f	1	7.62	3	490	1
6201	2021-12-31 03:00:00	Bananas Conventional	f	2	5.60	1	5	1
6202	2021-12-31 03:00:00	Beetroot Conventional	f	0.356	1.95	1	318	1
6203	2021-12-31 03:00:00	Broccoli Fresh	f	1	3	7	1923	1
4771	2021-10-22 00:02:00	Macro Free Range Chicken Drumsticks	f	1.104	12.14	1	704	1
1452	2021-08-05 00:00:00	Dreamview Cream 500mL	f	0.50	6.00	3	490	5
1453	2021-08-08 00:00:00	Dreamview Raw Milk 1L	f	3	9	3	489	5
1454	2021-08-08 00:00:00	Dreamview Cream 500mL	f	0.50	6.00	3	490	5
7167	2022-02-08 01:03:00	Onions Brown Loose	f	0.952	2.85	1	2	1
1456	2021-08-16 00:00:00	Dreamview Cream 500mL	f	0.50	6.00	3	490	5
1457	2021-08-16 00:00:00	Dreamview Raw Milk 1L	f	3	9	3	489	5
1458	2021-08-23 00:00:00	Dreamview Raw Milk 1L	f	1	3	3	489	5
4772	2021-10-22 00:02:00	Macro Free Range Chiken Whole	f	1.608	14.47	1	322	1
1460	2021-07-21 00:00:00	Brewer's Yeast, from Bulk Bin	f	109	5.44	2	553	4
3754	2022-01-11 02:54:00	John West Pink Salmon Canned 210g	f	420.00	5	2	1338	2
3755	2022-01-11 02:54:00	Pams Free Range Eggs Mixed Grade 12s	f	1746.00	15.87	2	7	2
3756	2022-01-11 02:54:00	Value Rice Brown Long Grain 1 kg	f	1	2.09	1	567	2
3757	2022-01-11 02:54:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	2
3758	2022-01-11 02:54:00	NZ Snapper Heads	f	0.836	5.84	1	315	2
3759	2022-01-11 02:54:00	Apples Braeburn	f	1.881	7.13	1	20	2
3760	2022-01-11 02:54:00	Apricots Fresh Loose	f	0.155	0.93	1	1339	2
4773	2021-10-22 00:02:00	Onions Brown Loose	f	1.047	2.62	1	2	1
3761	2022-01-11 02:54:00	Bananas Conventional	f	0.831	2.24	1	5	2
3762	2022-01-11 02:54:00	Cucumber Telegraph	f	1.00	1.49	7	536	2
3763	2022-01-11 02:54:00	Kumara Orange	f	0.661	1.98	1	21	2
3764	2022-01-11 02:54:00	Mango Peru	f	3	5	7	317	2
3765	2022-01-11 02:54:00	Mushrooms Button Loose	f	0.197	2.46	1	22	2
3766	2022-01-11 02:54:00	Onions Brown, 1 large	f	0.311	0.87	1	2	2
3767	2022-01-11 02:54:00	Plums Black Loose	f	0.075	0.37	1	1340	2
3768	2022-01-11 02:54:00	Watermelon Red Whole 1ea	f	2.68	6.99	1	1341	2
3769	2022-01-11 02:54:00	Anchor butter 500g	f	2000	17.56	2	23	2
1479	2021-12-04 23:11:00	Ceres Organic Apple Cider Vinegar 750mL	t	1500	10	4	312	2
1480	2021-12-04 23:11:00	Pams Flour Wholemeal 1.5 kg	f	1.50	1.98	1	144	2
1481	2021-12-04 23:11:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	2
1482	2021-12-04 23:11:00	Bananas Conventional	f	0.671	1.54	1	5	2
1483	2021-12-04 23:11:00	Kumara Orange	f	1.451	2.67	1	21	2
1484	2021-12-04 23:11:00	Mushrooms Button Loose	f	0.227	2.72	1	22	2
1485	2021-12-04 23:11:00	Pam's Organic Fuji Apples 1 kg	t	1	3.99	1	20	2
1486	2021-12-04 23:11:00	Anchor butter 500g	f	1500.00	11.97	2	23	2
1487	2021-12-04 23:11:00	OSM bars chocolate 6 pieces 507g NET 	f	12	25.78	7	563	2
3770	2022-01-11 02:54:00	Valumetric Colby Cheese 1kg	f	1	7.99	1	1342	2
1489	2021-12-08 23:00:00	Tip Top Sundae Ice Cream 2 L	f	2	6.90	3	319	14
4774	2021-10-22 00:02:00	Mushrooms Button Loose	f	0.238	3.09	1	22	1
1491	2021-12-12 23:00:00	NZ Snapper Heads x2	f	1.59	7.16	1	315	12
4775	2021-10-22 00:02:00	Garlic NZ	f	0.052	1.51	1	539	1
1493	2021-12-07 23:00:00	No Label Jumbo dozen eggs	f	800	5	2	7	14
4776	2021-10-22 00:02:00	Beetroot Conventional	f	0.617	3.09	1	318	1
1495	2021-12-11 23:00:00	Sourdough starter with instructions	t	50	5	2	564	15
4777	2021-10-22 00:02:00	Apples Royal Gala	f	1.272	4.45	1	20	1
4778	2021-10-22 00:02:00	Bananas Cavendish	f	1.232	3.45	1	5	1
4779	2021-10-22 00:02:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3	2	4	1
4780	2021-10-22 00:02:00	Jeds Beans 200g	f	200	6	2	33	1
4781	2021-10-22 00:02:00	Delmaine Sliced Jalapenos 280g	f	280	3	2	540	1
6647	2022-01-31 23:07:00	Pams Flour Wholemeal 1.5 kg	f	1.50	1.98	1	144	2
6648	2022-01-31 23:07:00	Pams Flour Wholemeal 1.5 kg	f	1.50	1.98	1	144	2
6649	2022-01-31 23:07:00	Queens Diamond Pitted Dates 400g	f	400.00	2.1900	2	701	2
6650	2022-01-31 23:07:00	Sealord Tuna inWater 185g	f	740.00	10.00	2	548	2
6651	2022-01-31 23:07:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	2
6652	2022-01-31 23:07:00	NZ Snapper Heads	f	1.344	9.39	1	315	2
6653	2022-01-31 23:07:00	Apples Royal Gala	f	1.016	3.04	1	20	2
3107	2021-12-27 03:50:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	2
3108	2021-12-27 03:50:00	Bananas Cavendish	f	1.121	2.57	1	5	2
3109	2021-12-27 03:50:00	Cucumber Telegraph	f	1.00	1.49	7	536	2
3110	2021-12-27 03:50:00	Mushrooms Button Loose	f	0.087	1.09	1	22	2
3111	2021-12-27 03:50:00	Pam's Organic Fuji Apples 1 kg	t	1	3.99	1	20	2
2308	2021-12-19 03:20:00	Bananas Conventional	f	0.626	1.87	1	5	31
3112	2021-12-27 03:50:00	Peaches Yellow Flesh	f	0.46	2.76	1	715	2
3113	2021-12-27 03:50:00	Kapiti Ice Cream Triple Chocolate 1L	f	1	9.89	3	319	2
3114	2021-12-27 03:50:00	Eclipse Cheese Tasty 1 kg	f	1.00	13.99	1	321	2
3115	2021-12-27 03:50:00	Pam's Cream 1L	f	1	7.57	3	490	2
3116	2021-12-27 03:50:00	Anchor butter 500g	f	1000	10	2	23	2
4853	2021-10-31 01:06:00	Avalanche Franz Josef Beans 200g	f	200	4.5	2	33	2
4854	2021-10-31 01:06:00	Nice Natural Roasted Nut Bar Chocolate 6s	f	6	0.99	7	1374	2
4855	2021-10-31 01:06:00	T/Colledge Vanilla Exract 100 mL FairTrade	t	100.00	8.99	4	313	2
4856	2021-10-31 01:06:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.79	2	34	2
4857	2021-10-31 01:06:00	Apples Braeburn	f	1.436	5.3	1	20	2
4858	2021-10-31 01:06:00	Bananas Conventional	f	1.226	2.44	1	5	2
4859	2021-10-31 01:06:00	Pams Butter 500g	f	500	4.89	2	23	2
6316	2021-08-27 00:00:00	Bananas Conventional	f	1	2.57	6	5	34
6654	2022-01-31 23:07:00	Bananas Conventional	f	1.391	2.77	1	5	2
6655	2022-01-31 23:07:00	Capsicum Bag Misfitz 750g	f	750	3.99	2	149	2
6656	2022-01-31 23:07:00	Short Cucumber	f	1.00	1.79	7	536	2
6657	2022-01-31 23:07:00	Fresh Ginger	f	0.181	1.99	1	537	2
3009	2021-11-09 01:09:00	Bananas Cavendish	f	0.902	2.71	1	5	1
3171	2022-01-07 01:28:00	Beetroot Conventional	f	0.172	0.83	1	318	1
3172	2022-01-07 01:28:00	Onions Brown Loose	f	1.142	3.99	1	2	1
3173	2022-01-07 01:28:00	Mushrooms Button Loose	f	0.293	3.81	1	22	1
3174	2022-01-07 01:28:00	Macro Organic Tomatoes Diced NAS 400g	t	2000.00	7.5	2	501	1
3175	2022-01-07 01:28:00	Exotic Food Red Curry Paste 220g	f	440.00	7.6	2	535	1
3176	2022-01-07 01:28:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	31	1
3177	2022-01-07 01:28:00	Essentials French Whole Bean 200g	f	200	5	2	33	1
3178	2022-01-07 01:28:00	Cucumber Telegraph	f	1.00	2	7	536	1
3179	2022-01-07 01:28:00	Capsicum Odd Bunch 750g	f	750	4.5	2	149	1
6658	2022-01-31 23:07:00	Kumara Red	f	0.661	1.98	1	21	2
6659	2022-01-31 23:07:00	Mushrooms Button Loose	f	0.262	3.27	1	22	2
6660	2022-01-31 23:07:00	Onions Brown Loose	f	0.851	2.12	1	2	2
6661	2022-01-31 23:07:00	Killinchy Gold Vanilla 1L	f	1	8.99	3	319	2
6662	2022-01-31 23:07:00	Mainland Cheese Organic 500g	t	1000	20.78	2	502	2
6663	2022-01-31 23:07:00	Mainland Cheese Vintage 500g	f	500	10.39	2	143	2
6664	2022-01-31 23:07:00	Valumetric Colby Cheese 1kg	f	1.00	10.99	1	1342	2
1550	2021-12-12 22:19:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.495	9.78	1	549	1
1551	2021-12-12 22:19:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.513	10.14	1	549	1
1552	2021-12-12 22:19:00	Mushrooms Button Loose	f	228	2.96	2	22	1
1553	2021-12-12 22:19:00	Bananas Cavendish	f	1.182	3.55	1	5	1
1554	2021-12-12 22:19:00	Beetroot Conventional	f	0.117	0.560	1	318	1
1555	2021-12-12 22:19:00	Garlic NZ	f	0.017	0.49	1	539	1
1556	2021-12-12 22:19:00	Fresh Ginger	f	0.232	3.94	1	537	1
1557	2021-12-12 22:19:00	Apples Royal Gala	f	0.947	4.74	1	20	1
1558	2021-12-12 22:19:00	CD Cream 500mL	f	0.50	3.91	3	490	1
1559	2021-12-12 22:19:00	Raglan Coconut Yoghurt Vanilla 700g	t	700	12	2	565	1
1560	2021-12-12 22:19:00	CD Flour Plain 1.5 kg	f	1.5	2	1	566	1
1561	2021-12-12 22:19:00	Onion Red 1.5 kg bag	f	1.5	4	1	2	1
1562	2021-12-12 22:19:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3	2	4	1
1563	2021-12-12 22:19:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.80	2	7	1
1564	2021-12-12 22:19:00	Essentials Coconut Cream 400 mL	f	400	1.2	4	32	1
1565	2021-12-12 22:19:00	Ceres Organic Brown Rice Basmati 500 g	t	500	5.79	2	567	1
1566	2021-12-12 22:19:00	Capsicum Odd Bunch 750g	f	750	5	2	149	1
1567	2021-12-12 22:19:00	Organic Potato	t	2	6.99	1	3	1
1568	2021-12-12 22:19:00	Cucumber Telegraph	f	1.00	1.8	7	536	1
7168	2022-02-08 01:03:00	Potatoes Agria Brushed Loose	f	1.492	5.95	1	3	1
7169	2022-02-08 01:03:00	Macro Free Range Chicken Drumsticks	f	1.276	13.4	1	704	1
6300	2021-12-14 23:00:00	Rye flour at 20kg Co-op price	t	2.5	9	1	1951	6
6304	2021-12-29 23:00:00	Rye flour at 20kg Co-op price	t	2	7.16	1	1951	6
7170	2022-02-08 01:03:00	Bananas Cavendish	f	1.212	4	1	5	1
4782	2021-10-22 00:02:00	WW Flour Wholemeal 1.5 kg	f	1.50	2	1	144	1
4783	2021-10-22 00:02:00	Otaika Valley Size 7 12 pack	f	1488.00	15.60	2	7	1
4784	2021-10-22 00:02:00	Avocado Loose	f	3	3	7	148	1
4785	2021-10-22 00:02:00	Macro Brazil Nuts 250g	f	250	8.50	2	1362	1
1581	2021-10-09 23:00:00	Almonds, Transitional, 2.5 kg bag	f	2.5	56.66	1	554	6
1582	2021-10-09 23:00:00	Quinoa, Tricolor, bulk 3 kg bag	t	3	28.53	1	555	6
1583	2021-10-09 23:00:00	Nutritional Yeast, 1 kg bag	t	1	47.83	1	556	6
1584	2021-10-09 23:00:00	Sultanas, Bulk 2.5 kg bag	t	2.5	21.47	1	557	6
1585	2021-10-09 23:00:00	Chocolate Chips, bulk 10 kg bag	t	3	78.75	1	141	6
1586	2021-10-09 23:00:00	Hemp Hearts, stock	t	1	23.86	1	559	6
4786	2021-10-22 00:02:00	Cucumber Telegraph	f	1.00	2.3	7	536	1
4787	2021-10-22 00:02:00	Capsicum Loose	f	6	9.00	7	149	1
1588	2021-07-26 00:00:00	Jumbo Dozen Eggs from Dairy	f	860	5	2	7	14
2516	2021-11-10 23:48:00	Macro Free Range Chicken Drumsticks	f	0.957	9.47	1	704	1
2517	2021-11-10 23:48:00	CD Prime Beef Mince Reduced	f	1	12.85	1	35	1
2518	2021-11-10 23:48:00	WW Flour Wholemeal 1.5 kg	f	1.50	2	1	144	1
2519	2021-11-10 23:48:00	WW Coconut Water 1L	f	3	10.5	3	544	1
2520	2021-11-10 23:48:00	Macro Organic Tomatoes Diced NAS 400g	t	1.2	4.5	1	501	1
2521	2021-11-10 23:48:00	Essentials Coconut Cream 400 mL	f	800.00	2.4	4	32	1
2522	2021-11-10 23:48:00	Capsicum Odd Bunch 750g	f	750	5	2	149	1
3079	2021-10-25 19:31:00	Apples Braeburn	f	0.651	2.6	1	20	31
3080	2021-10-25 19:31:00	Banana Sweetio 4 pk	f	1	3.49	6	5	31
7171	2022-02-08 01:03:00	Orange Navel Large Imported	f	0.332	1.99	1	2118	1
7172	2022-02-08 01:03:00	Fresh Ginger	f	0.112	1.79	1	537	1
7173	2022-02-08 01:03:00	Mushrooms Button Loose	f	0.253	3.54	1	22	1
6204	2021-12-31 03:00:00	Cauliflower Fresh	f	1	3.99	7	1924	1
6205	2021-12-31 03:00:00	Cucumber Lebanese	f	1.00	1.5	7	536	1
6206	2021-12-31 03:00:00	Cucumber Telegraph	f	1.00	1.8	7	536	1
6207	2021-12-31 03:00:00	Garlic NZ	f	0.07	2.1	1	539	1
6208	2021-12-31 03:00:00	Kiwifruit Green NZ	f	1.2	4.2	1	1925	1
6209	2021-12-31 03:00:00	Mushrooms Button Loose	f	0.21	2.73	1	22	1
6210	2021-12-31 03:00:00	Chinese Pears	f	0.3	1.5	1	1926	1
6211	2021-12-31 03:00:00	Organic Potato	t	4	13.98	1	3	1
6212	2021-12-31 03:00:00	Capsicum Odd Bunch 750g	f	750.00	5	2	149	1
6213	2021-12-31 03:00:00	Countdown Burger Patties Ultimate bbq beef steak 4pk	f	500	11	2	1927	1
6214	2021-12-31 03:00:00	Essentials Coconut Cream 400 mL	f	1600.00	4.8	4	32	1
6215	2021-12-31 03:00:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3	2	4	1
6216	2021-12-31 03:00:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.80	2	7	1
6218	2021-12-31 03:00:00	WW Coconut Water 1L	f	4	14	3	544	1
6219	2021-12-31 03:00:00	Countdown Tonic Water 1.5L	f	3	2.6	3	1928	1
6220	2021-12-31 03:00:00	Keri premium Tomato Juice 1L	f	1	2.5	3	1929	1
6221	2021-12-31 03:00:00	Tongariro Natural Spring Water 5L	f	5.00	3.90	3	546	1
6222	2021-12-31 03:00:00	Countdown frozen blueberries 1kg	f	1	9.5	1	1930	1
6223	2021-12-31 03:00:00	Countdown Frozen Strawberries 500g	f	0.5	5.5	1	1931	1
7174	2022-02-08 01:03:00	Essentials Coconut Cream 400 mL	f	2000.00	6.00	4	32	1
7175	2022-02-08 01:03:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.5	2	501	1
7176	2022-02-08 01:03:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3	2	4	1
7177	2022-02-08 01:03:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	7	1
7178	2022-02-08 01:03:00	Woodland Free Range Eggs Sz6 18pk	f	954	8.8	2	7	1
7179	2022-02-08 01:03:00	Lamb Mince Reduced	f	500	11.44	2	2119	1
6319	2021-12-21 23:00:00	Organic Beef Chuck	t	0.8	24	1	541	11
7180	2022-02-08 01:03:00	Countdown Burger Patties Ultimate bbq beef steak 4pk	f	500.00	12	2	1927	1
7181	2022-02-08 01:03:00	Tasti Pinenuts 70g	f	70	5	2	2120	1
4788	2021-10-22 00:02:00	Tomato Beekist Jelly Beans	f	250	4	2	1363	1
4789	2021-10-22 00:02:00	Macro Org Carrots 1kg	t	1	6	1	31	1
4790	2021-10-22 00:02:00	Mexicano Corn Chips Natural 300g	f	300	3.59	2	547	1
4791	2021-10-22 00:02:00	Sanitarium Marmite 250g	f	250	3.50	2	1364	1
7182	2022-02-08 01:03:00	Avocado. Large Loose	f	2	2.8	7	148	1
6332	2021-10-23 23:00:00	Dreamview Raw Milk 1L	f	3	9	3	489	5
6333	2021-10-16 23:00:00	Dreamview Raw Milk 1L	f	2	6	3	489	5
6310	2022-01-09 23:00:00	Rye flour at 20kg Co-op price	t	2	7.16	1	1951	6
7183	2022-02-08 01:03:00	Cucumber Telegraph	f	1.00	2.99	7	536	1
7336	2022-02-28 22:11:00	Fresh Ginger	f	0.192	3.07	1	537	1
7337	2022-02-28 22:11:00	Mushrooms Button Loose	f	0.203	2.84	1	22	1
7338	2022-02-28 22:11:00	Bananas Cavendish	f	1.777	5.86	1	5	1
4816	2021-10-28 02:33:00	Onions Brown Loose	f	0.487	1.22	1	2	1
4817	2021-10-28 02:33:00	Carrots, Loose	f	0.832	2.49	1	31	1
4818	2021-10-28 02:33:00	Kumara Orange	f	1.727	5.70	1	21	1
4819	2021-10-28 02:33:00	Whittakers Blk Dark Almond 62% 250g	f	250	5	2	34	1
4820	2021-10-28 02:33:00	Capsicum Red NZ	f	1	1.5	7	149	1
4821	2021-10-28 02:33:00	Organic Potato	t	2	6.99	1	3	1
4822	2021-10-28 02:33:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	7	1
4823	2021-10-28 02:33:00	Macro Organic Apple 1 kg bag	t	1	4.5	1	20	1
7339	2022-02-28 22:11:00	Macro Free Range Chicken Drumsticks	f	1.186	12.45	1	704	1
7340	2022-02-28 22:11:00	WW Peach SLices in Fruit Juice 410g	f	1230.00	4.5	2	1945	1
7341	2022-02-28 22:11:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.5	2	501	1
7342	2022-02-28 22:11:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.80	2	7	1
6469	2022-01-24 21:21:00	Bananas Cavendish	f	0.717	2.15	1	5	1
6470	2022-01-24 21:21:00	Mushrooms Button Loose	f	0.198	2.77	1	22	1
6471	2022-01-24 21:21:00	Watermelon Red Whole	f	2.34	4.68	1	1341	1
6472	2022-01-24 21:21:00	Kumara Orange	f	0.967	3.38	1	21	1
6473	2022-01-24 21:21:00	Onions Brown Loose	f	0.152	0.53	1	2	1
6474	2022-01-24 21:21:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.8	2	7	1
6475	2022-01-24 21:21:00	Alpine Cheese Mild 1 kg	f	1	10.95	1	1965	1
6476	2022-01-24 21:21:00	Macro Organic Tomatoes Diced NAS 400g	t	2400.00	9	2	501	1
6477	2022-01-24 21:21:00	Macro Org Baked Beans in Tomato Sauce 420g	t	420	1.5	2	1966	1
6478	2022-01-24 21:21:00	Cucumber Green	f	1.00	2.5	7	536	1
6479	2022-01-24 21:21:00	WW Flour Wholemeal 1.5 kg	f	1.50	2	1	144	1
6480	2022-01-24 21:21:00	Mexicano Corn Chips Natural 300g	f	600.00	7.18	2	547	1
6553	2022-01-31 23:40:00	Doritos corn chips original 170g	f	170	2	2	2197	1
7891	2022-04-12 22:37:00	Mushrooms Button Loose	f	0.298	4.17	1	22	1
6403	2022-01-23 02:54:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	2.99	2	4	31
7892	2022-04-12 22:37:00	Bananas Cavendish	f	0.312	1.03	1	5	1
7893	2022-04-12 22:37:00	Apples Royal Gala	f	0.952	2.86	1	20	1
7894	2022-04-12 22:37:00	Onions Brown Loose	f	0.382	1.14	1	2	1
7895	2022-04-12 22:37:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.539	9.84	1	549	1
7896	2022-04-12 22:37:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.572	10.44	1	549	1
7677	2022-03-22 22:08:00	OSM bars chocolate 6 pieces 507g NET 	f	12	25.78	7	563	2
7678	2022-03-22 22:08:00	Otaika Valley Size 7 12 pack	f	2.23	19.77	1	7	2
7679	2022-03-22 22:08:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	2
7680	2022-03-22 22:08:00	Avocado. Large Loose	f	3	2	7	148	2
7681	2022-03-22 22:08:00	Mushrooms Button Loose	f	0.252	3.02	1	22	2
7682	2022-03-22 22:08:00	Anchor butter 500g	f	500	5.4	2	23	2
7683	2022-03-22 22:08:00	Bird n Barrow FR Chicken Whole Bag 1.7kg	f	1.7	16.99	1	2206	2
7897	2022-04-12 22:37:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.604	11.02	1	549	1
7898	2022-04-12 22:37:00	Essentials Coconut Cream 400 mL	f	2400.00	8.4	4	32	1
6555	2022-01-31 23:40:00	Mexicano Corn Chips Natural 300g	f	600	4.90	2	547	1
7899	2022-04-12 22:37:00	Macro Orgaic Passata 700g	t	2100.00	9	2	2199	1
7259	2022-01-25 23:00:00	Organic Medium Grain Brown Rice, Bulk	t	10	32.89	1	567	6
7900	2022-04-12 22:37:00	Whittakers Block Dark Ghana 250g	f	500	8	2	34	1
7901	2022-04-12 22:37:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.8	2	7	1
7902	2022-04-12 22:37:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3.5	2	4	1
7903	2022-04-12 22:37:00	Barkers SodaSyrup Brewed Ginger Beer 710mL	f	1420.00	10	4	2216	1
7720	2022-03-28 21:49:00	CD Chicken Nibbles Med Reduced	f	1.1	9.74	1	2215	1
6546	2022-01-31 23:40:00	Arnotts Vita-weat Cracked Pepper 250g	f	500	6	2	4	1
6547	2022-01-31 23:40:00	Olivado Natural Coconut Cooking Oil 1L	t	1	10.50	3	1991	1
6548	2022-01-31 23:40:00	Essentials Coconut Cream 400 mL	f	3200.00	9.60	4	32	1
6549	2022-01-31 23:40:00	Macro Organic Tomatoes Diced NAS 400g	t	1200.00	4.5	2	501	1
6550	2022-01-31 23:40:00	Macro Org Carrots 1kg	t	1	8	1	31	1
6551	2022-01-31 23:40:00	Tasti Crystal GInger 150g	f	150	4.5	2	1992	1
6552	2022-01-31 23:40:00	WW Black Sliced Olives 430g	f	430	3.2	2	1993	1
6554	2022-01-31 23:40:00	Macro Org Pasta Penne 500g	f	500	2.50	2	1994	1
6556	2022-01-31 23:40:00	Loose Avocado	f	1	1.5	7	148	1
7721	2022-03-28 21:49:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.543	7.74	1	549	1
7722	2022-03-28 21:49:00	Macro Free Range Chicken Thigh Fillet, Reduced	f	0.475	5.33	1	549	1
7723	2022-03-28 21:49:00	Arnotts Vita-weat Cracked Pepper 250g	f	750	9	2	4	1
7724	2022-03-28 21:49:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	7	1
7343	2022-02-28 22:11:00	WW White Sugar 3 kg	f	3	5.60	1	145	1
7344	2022-02-28 22:11:00	Ahg Fish Sauce 200mL	f	200	2.65	4	2155	1
7345	2022-02-28 22:11:00	Essentials Coconut Cream 400 mL	f	3200.00	9.60	4	32	1
7346	2022-02-28 22:11:00	WW Coconut Water 1L	f	1	3.5	3	544	1
7347	2022-02-28 22:11:00	CD Beef Mince 82% 1kg	f	1	14.5	1	35	1
7725	2022-03-28 21:49:00	Macro Orgaic Passata 700g	t	1400	6	2	2199	1
7726	2022-03-28 21:49:00	Barkers SodaSyrup Brewed Ginger Beer 710mL	f	710	6.5	4	2216	1
7727	2022-03-28 21:49:00	Freshpak Rooibos Tea 40ea 100g	f	100	4.5	2	2217	1
7728	2022-03-28 21:49:00	Doritos Corn Chips Original 170g	f	170	2	2	2197	1
7904	2022-04-12 22:37:00	CD Butter Salted 500g	f	500	5.8	2	23	1
7905	2022-04-12 22:37:00	Fresh Red Chillis	f	2	3.4	7	2203	1
7906	2022-04-12 22:37:00	Avocado. Large Loose	f	2	3.5	7	148	1
6577	2022-02-01 00:24:00	Organic Beef Chuck 400g	t	0.8	21.60	1	541	11
6578	2022-02-01 00:24:00	Organic Beef Mince Lean 400g	t	0.4	12	1	35	11
6579	2022-02-01 00:24:00	Organic Lamb Shanks	t	0.85	28.50	1	2005	11
6580	2022-02-01 00:24:00	Organic Beef Sausage Garlic & Parsley	t	6	12	7	2006	11
6295	2022-01-17 20:17:00	Doritos corn chips original 170g	f	170	2	2	2197	1
6217	2021-12-31 03:00:00	Doritos corn chips original 170g	f	340.00	4	2	2197	1
8115	2022-05-18 02:05:00	Mushrooms Button Loose	f	0.163	2.28	1	22	1
8116	2022-05-18 02:05:00	Apple Rose Medium	f	0.837	2.93	1	20	1
8117	2022-05-18 02:05:00	Fresh Ginger	f	0.232	3.83	1	537	1
8118	2022-05-18 02:05:00	Bananas Cavendish	f	0.932	3.08	1	5	1
8119	2022-05-18 02:05:00	Arnotts Vita-weat Cracked Pepper 250g	f	1000	10	2	4	1
8120	2022-05-18 02:05:00	Essentials Coconut Cream 400 mL	f	2400.00	8.4	4	32	1
8121	2022-05-18 02:05:00	Macro Organic Tomatoes Diced NAS 400g	t	800	3.6	2	501	1
8122	2022-05-18 02:05:00	Macro Orgaic Passata 700g	t	1400.00	6	2	2199	1
8123	2022-05-18 02:05:00	CD Free Range Eggs Sz8 6pack reduced	f	810.00	6.2	2	7	1
8124	2022-05-18 02:05:00	Countdown Free Range Sz 6 6pk Short Date Sale	f	636.00	5.20	2	7	1
8125	2022-05-18 02:05:00	CD Butter Salted 500g	f	500	5.8	2	23	1
8126	2022-05-18 02:05:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	7	1
8127	2022-05-18 02:05:00	Tostitos Splash of Lime 175g	f	175	2.5	2	547	1
7655	2022-03-22 21:45:00	Garlic NZ	f	0.032	1.22	1	539	1
7656	2022-03-22 21:45:00	Macro Orgaic Passata 700g	t	700	3	2	2199	1
7657	2022-03-22 21:45:00	Essentials Coconut Cream 400 mL	f	1200	3.6	4	32	1
7266	2022-02-08 23:00:00	Kelp Granules 250g	f	250	11.90	2	2132	40
7303	2022-02-08 23:01:00	Rye flour, share 25 kg bag	t	10	28.71	1	1951	6
7304	2022-02-08 23:01:00	Buckwheat Hulled, 25 kg share bag	t	13	60.72	1	2149	6
7305	2022-02-08 23:01:00	Wheat, whole, dressed 25 kg bag	t	25	80.42	1	2150	6
7306	2022-02-08 23:01:00	Coconut Flakes, 1.5 kg bag	t	1.5	13.19	1	2151	6
7307	2022-02-08 23:01:00	Sunflower Seeds, 3 kg bag	t	3	20.34	1	2152	6
7308	2022-02-08 23:01:00	Nutritional Yeast, 1 kg bag	t	1.00	48	1	556	6
7309	2022-02-08 23:01:00	Sultanas, Bulk 2.5 kg bag	t	2.50	21.55	1	557	6
7310	2022-02-08 23:01:00	Quinoa, White, 3.5 kg bag	t	3.5	34.75	1	555	6
7311	2022-02-08 23:01:00	Hemp Hearts, stock	t	1.00	22.86	1	559	6
7658	2022-03-22 21:45:00	Raglan Coconut Yoghurt Blueberry 700g	t	700.00	12	2	565	1
7659	2022-03-22 21:45:00	Whittakers Block Cocoa Dark 72% 250g	f	250	4.5	2	34	1
7660	2022-03-22 21:45:00	Macro Org Wholewheat Penne 500g	t	500.00	2.8	2	1994	1
7661	2022-03-22 21:45:00	Mainland Cheese Vintage 500g	f	500	11	2	143	1
7662	2022-03-22 21:45:00	Arnotts Vita-weat Crackers Regular 250g	f	250	3	2	4	1
7975	2022-04-20 01:03:00	Chicken Thigh Boneless Skinless Large	f	1.038	18.04	1	2128	1
7976	2022-04-20 01:03:00	Macro Orgaic Passata 700g	t	2800.00	12	2	2199	1
7977	2022-04-20 01:03:00	WW Tomatoes Diced Italian 800g	f	1.6	4	1	501	1
7978	2022-04-20 01:03:00	Macro Organic Tomatoes Diced NAS 400g	t	800	3.6	2	501	1
7979	2022-04-20 01:03:00	Essentials Coconut Cream 400 mL	f	1600.00	5.60	4	32	1
7980	2022-04-20 01:03:00	Cabbage Red Whole	f	1	6.99	7	552	1
8399	2022-05-27 00:00:00	Alberts Size J 20 pack	f	1455	7.5	2	7	14
8004	2022-04-20 02:34:00	Otaika Valley Size 7 12 pack	f	1488.00	13.18	2	7	2
8005	2022-04-20 02:34:00	Whittakers Block Peanut Butter Jelly 250g	f	250	2.99	2	34	2
8006	2022-04-20 02:34:00	NZ Snapper Heads	f	0.994	6.95	1	315	2
7006	2022-02-22 00:35:00	Watermelon Whole	f	3.265	3.27	1	1341	1
7007	2022-02-22 00:35:00	Chicken Thigh Bonein, Conventional, Reduced	f	0.819	7.01	1	545	1
7008	2022-02-22 00:35:00	Essentials Coconut Cream 400 mL	f	1600.00	4.8	4	32	1
7009	2022-02-22 00:35:00	WW Coconut Water 1L	f	1	3.5	3	544	1
7010	2022-02-22 00:35:00	Capsicum Odd Bunch 750g	f	750	5	2	149	1
7011	2022-02-22 00:35:00	Mainland Cheese Vintage 500g	f	500	11	2	143	1
7012	2022-02-22 00:35:00	Mainland Cheese Organic 500g	t	500	11	2	502	1
8007	2022-04-20 02:34:00	Apples NZ Queen	f	1.206	1.19	1	20	2
7794	2022-04-05 02:55:00	CD Beef Mince 1kg Reduced	f	2	17.88	1	35	1
7795	2022-04-05 02:55:00	CD Butter Salted 500g	f	500	5.8	2	23	1
7796	2022-04-05 02:55:00	Broccoli Fresh	f	1.00	2	7	1923	1
7797	2022-04-05 02:55:00	Avocado. Large Loose	f	4	7	7	148	1
8008	2022-04-20 02:34:00	Avocado. Large Loose	f	2	3	7	148	2
8009	2022-04-20 02:34:00	Mushrooms Button Loose	f	0.352	3.52	1	22	2
8010	2022-04-20 02:34:00	Anchor butter 500g	f	1000	10.80	2	23	2
8014	2022-04-11 00:00:00	No Label Jumbo dozen eggs	f	800.00	5.50	2	7	14
8418	2022-04-11 00:00:00	Almonds, Transitional, 2.5 kg bag	f	2.50	56.6600	1	554	6
8419	2022-04-11 00:00:00	Bulk Mung Beans Ceres 3.5 kg bag	t	3.5	27.01	1	569	6
7241	2022-02-15 01:54:00	Onions Brown Loose	f	0.577	1.73	1	2	1
7242	2022-02-15 01:54:00	Bananas Cavendish	f	0.912	3.01	1	5	1
7243	2022-02-15 01:54:00	Mushrooms Button Loose	f	0.128	1.79	1	22	1
7244	2022-02-15 01:54:00	Watermelon Red Whole	f	2.815	7.04	1	1341	1
7245	2022-02-15 01:54:00	Chicken Thigh Boneless Skinless Large	f	1	18.68	1	2128	1
7246	2022-02-15 01:54:00	Woodlands Free Range Size 6 10 pk	f	530	4.90	2	7	1
7247	2022-02-15 01:54:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	7	1
7248	2022-02-15 01:54:00	Arnotts Vita-weat Cracked Pepper 250g	f	500	6	2	4	1
7249	2022-02-15 01:54:00	Essentials Coconut Cream 400 mL	f	800	2.4	4	32	1
7250	2022-02-15 01:54:00	Organic Potato	t	2	8	1	3	1
7251	2022-02-15 01:54:00	Macro Organic Tomatoes Diced NAS 400g	t	800.00	3	2	501	1
7252	2022-02-15 01:54:00	Macro Org Carrots 1kg	t	1	8	1	31	1
7253	2022-02-15 01:54:00	Capsicum Odd Bunch 750g	f	750	5	2	149	1
7254	2022-02-15 01:54:00	Avocado. Large Loose	f	2	2.8	7	148	1
7255	2022-02-15 01:54:00	CD cheese mild 1 kg	f	1.00	11.8	1	1965	1
7256	2022-02-15 01:54:00	CD Premium Beef Stir Fry reduced	f	1	17.82	1	2129	1
7637	2022-03-15 01:37:00	Fresh Ginger	f	0.14	0.7	1	537	43
7638	2022-03-15 01:37:00	Fresh Green Chillis	f	0.03	0.45	1	2203	43
7947	2022-04-20 00:19:00	Garam Masala Bulk Bin	f	0.052	2.18	1	2262	4
7948	2022-04-20 00:19:00	Ground Ginger Bulk Bin	f	0.06	2.69	1	2263	4
7949	2022-04-20 00:19:00	Brewer's Yeast, from Bulk Bin	f	126	4.4	2	553	4
7950	2022-04-20 00:19:00	Paprika Bulk Bin	f	0.086	2.8	1	2264	4
7953	2022-04-27 04:51:00	Bananas Conventional	f	1.171	3.85	1	5	31
7958	2022-04-20 00:00:00	Beef Chuck from Freezer	t	0.4	10.64	1	541	11
7959	2022-04-20 00:00:00	Spray Free Local Garlic	f	0.037	2	1	539	11
8405	2022-05-19 00:00:00	Buckwheat Hulled, 25 kg share bag	t	25	118.27	1	2149	6
8420	2022-04-11 00:00:00	Wheat, whole, dressed 25 kg bag	t	25.00	80.13	1	2150	6
8421	2022-04-11 00:00:00	Ceres Bulk Cacao Powder 2.2kg	t	2.2	41.80	1	2347	6
8422	2022-04-11 00:00:00	Ceres Bulk Coconut Oil Organic 4.5L	t	4.5	38.4	3	1991	6
8423	2022-04-11 00:00:00	Licorice and Cinnamon Tea, Pukka 20 count box 40g NET	t	40.00	15.5000	18	572	6
7987	2022-04-23 21:47:00	Pam's Baking Soda 500g	f	500	2.47	2	2267	2
7756	2022-04-05 01:06:00	Organic Beef Chuck 400g	t	0.8	24	1	541	11
7777	2022-04-05 02:37:00	Bananas Conventional	f	0.615	1.53	1	5	43
7778	2022-04-05 02:37:00	Apples Royal Gala	f	1	1.49	1	20	43
7779	2022-04-05 02:37:00	Onions Brown Loose	f	0.2	0.4	1	2	43
7780	2022-04-05 02:37:00	Mushrooms Button Loose	f	0.145	1.88	1	22	43
7781	2022-04-05 02:37:00	Cucumber Telegraph	f	1.00	1.99	7	536	43
7782	2022-04-05 02:37:00	Carrots, Loose	f	1	1.89	1	31	43
7783	2022-04-05 02:37:00	Capsicum mixed bag	f	0.582	3.99	1	149	43
7784	2022-04-05 02:37:00	Beetroot Conventional	f	0.255	1.27	1	318	43
7785	2022-04-05 02:37:00	Fiji Tumeric	f	0.085	1.02	1	2226	43
7988	2022-04-23 21:47:00	Bananas Conventional	f	0.826	2.39	1	5	2
7989	2022-04-23 21:47:00	Cucumber Telegraph	f	2	5	7	536	2
8035	2022-05-10 22:53:00	Macro Free Range Chicken Whole	f	1.65	15.84	1	2206	1
8036	2022-05-10 22:53:00	CD Chicken Nibbles Med Reduced	f	1.108	7.52	1	2215	1
8037	2022-05-10 22:53:00	Arnotts Vita-weat Cracked Pepper 250g	f	250	3.5	2	4	1
8038	2022-05-10 22:53:00	Countdown Free Range Sz 7 12pk	f	1488.00	13.8	2	7	1
8039	2022-05-10 22:53:00	Waitoa FR Chicken Thigh Fillet 400g	f	0.8	18.72	1	549	1
8040	2022-05-10 22:53:00	CD Beef Mince 1kg Reduced	f	1	11.47	1	35	1
8041	2022-05-10 22:53:00	CD Butter Salted 500g	f	1000	11.60	2	23	1
8042	2022-05-10 22:53:00	Doritos Corn Chips Original 170g	f	340.00	3.8	2	2197	1
8043	2022-05-10 22:53:00	WW Dates Pitted 500g	f	500	2.40	2	701	1
8044	2022-05-10 22:53:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	31	1
7444	2022-03-07 21:11:00	Otaika Valley Size 7 12 pack	f	2232.00	19.77	2	7	2
7445	2022-03-07 21:11:00	Queens Diamond Pitted Dates 400g	f	400.00	2.1900	2	701	2
7446	2022-03-07 21:11:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	2
7447	2022-03-07 21:11:00	Avocado. Large Loose	f	4	4	7	148	2
7448	2022-03-07 21:11:00	Bananas Conventional	f	0.876	2.53	1	5	2
7449	2022-03-07 21:11:00	Bananas Conventional	f	0.206	0.6	1	5	2
7263	2022-02-04 23:00:00	Fill Your Own Honey	f	3.8	38	1	695	37
7119	2022-02-22 00:00:00	Avalanche Franz Josef Beans 200g	f	400	8	2	33	2
7120	2022-02-22 00:00:00	Hoco Coconut Water 1L	f	1	3.69	3	544	2
7121	2022-02-22 00:00:00	Otaika Valley Size 7 12 pack	f	2976.00	26.36	2	7	2
7122	2022-02-22 00:00:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	2
7123	2022-02-22 00:00:00	NZ Snapper Heads	f	1.042	7.28	1	315	2
7124	2022-02-22 00:00:00	NZ Trevally Fillets	f	0.346	7.61	1	8	2
7125	2022-02-22 00:00:00	Avocado. Large Loose	f	4	4.40	7	148	2
7126	2022-02-22 00:00:00	Bananas Conventional	f	1.696	4.9	1	5	2
7127	2022-02-22 00:00:00	Bananas Conventional	f	0.176	0.51	1	5	2
7128	2022-02-22 00:00:00	Beetroot Conventional	f	0.386	1.66	1	318	2
7129	2022-02-22 00:00:00	Mandarins Loose NZ	f	0.211	1.01	1	1922	2
7130	2022-02-22 00:00:00	Mango Peru	f	3	4.5	7	317	2
7131	2022-02-22 00:00:00	Mushrooms Button Loose	f	0.327	3.92	1	22	2
7132	2022-02-22 00:00:00	Valumetric Colby Cheese 1kg	f	1.00	10.89	1	1342	2
7450	2022-03-07 21:11:00	Carrots, Loose	f	0.601	1.68	1	31	2
7451	2022-03-07 21:11:00	Mango Peru	f	1	1.89	7	317	2
7452	2022-03-07 21:11:00	Mushrooms Button Loose	f	0.252	3.02	1	22	2
7453	2022-03-07 21:11:00	Onions Brown Loose	f	0.971	1.93	1	2	2
7454	2022-03-07 21:11:00	Anchor butter 500g	f	500	5.39	2	23	2
7455	2022-03-07 21:11:00	Raglan Coconut Yoghurt Vanilla 700mL	t	700.00	11	4	565	2
7456	2022-03-07 21:11:00	Valumetric Edam Cheese 1 kg	f	1.00	10.89	1	1965	2
7457	2022-03-07 21:11:00	NZ Chicken Thigh Cutlets	f	0.464	5.1	1	2128	2
7617	2022-03-15 00:29:00	Bananas Cavendish	f	0.777	2.56	1	5	1
7618	2022-03-15 00:29:00	Onions Brown Loose	f	0.177	0.53	1	2	1
7619	2022-03-15 00:29:00	Watermelon Red Whole 1ea	f	2.56	6.4	1	1341	1
7620	2022-03-15 00:29:00	Fresh Ginger	f	0.242	3.87	1	537	1
7621	2022-03-15 00:29:00	Countdown Free Range Sz 6 6pk Short Date Sale	f	2.60	16.17	1	7	1
7622	2022-03-15 00:29:00	Doritos Corn Chips Original 170g	f	340.00	4	2	2197	1
7623	2022-03-15 00:29:00	Born & Bred NZ Prime Beef Mince 500g REDUCED	f	2	20.80	1	35	1
7624	2022-03-15 00:29:00	Ocean Blue Smoked Salmon 180g	f	180	10	2	2198	1
7625	2022-03-15 00:29:00	CD cheese mild 1 kg	f	1.00	11.8	1	1965	1
7626	2022-03-15 00:29:00	Essentials Coconut Cream 400 mL	f	1200.00	3.6	4	32	1
7627	2022-03-15 00:29:00	Macro Orgaic Passata 700g	t	2100	9	2	2199	1
7628	2022-03-15 00:29:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.50	2	501	1
7629	2022-03-15 00:29:00	Whittakers Block Cocoa Dark 72% 250g	f	500	9	2	34	1
7356	2022-03-07 21:29:00	Essentials Coconut Cream 400 mL	f	1600.00	4.80	4	32	1
7357	2022-03-07 21:29:00	Macro Organic Tomatoes Diced NAS 400g	t	1200.00	4.5	2	501	1
7358	2022-03-07 21:29:00	Macro Org Brushed Potato 1 kg	t	1	4.5	1	3	1
7359	2022-03-07 21:29:00	Capsicum Odd Bunch 750g	f	750	5.5	2	149	1
7630	2022-03-15 00:29:00	Avocado. Large Loose	f	2	3.5	7	148	1
7631	2022-03-15 00:29:00	Sigol Seaweed Snack Olive Oil 4g 3pk	f	12.00	2.2	2	2200	1
7632	2022-03-15 00:29:00	WW White Sugar 3 kg	f	3.00	5.6	1	145	1
7686	2022-03-28 21:55:00	Aurora Coffee Beans Prima Qualita 1kg	f	1	17.2	1	33	1
7911	2022-04-17 23:25:00	Bananas Cavendish	f	1.152	2.29	1	5	1
7912	2022-04-17 23:25:00	Garlic NZ	f	0.052	2.76	1	539	1
7743	2022-03-28 22:16:00	Carrots, Loose	f	0.225	0.61	1	31	43
7744	2022-03-28 22:16:00	Onions Brown Loose	f	0.235	0.47	1	2	43
7745	2022-03-28 22:16:00	Garlic NZ	f	0.08	2.4	1	539	43
7746	2022-03-28 22:16:00	Mushrooms Button Loose	f	0.16	2.08	1	22	43
7747	2022-03-28 22:16:00	Capsicum Loose	f	1	2.49	7	149	43
7748	2022-03-28 22:16:00	Bananas Conventional	f	0.765	1.9	1	5	43
7749	2022-03-28 22:16:00	Conventional Cabbage	f	1.505	5.99	1	552	43
7974	2022-04-20 01:03:00	Onions Brown Loose	f	0.297	0.89	1	2	1
8150	2022-05-24 21:00:00	CD Butter Salted 500g	f	500	5.4	2	23	1
8151	2022-05-24 21:00:00	Bananas Conventional	f	1.2	3.96	1	5	1
8152	2022-05-24 21:00:00	Garlic NZ	f	0.05	2.65	1	539	1
8153	2022-05-24 21:00:00	Mushrooms Button Loose	f	0.2	2.8	1	22	1
8154	2022-05-24 21:00:00	CD Chicken Frames by Weight	f	1.6	6.4	1	1944	1
8155	2022-05-24 21:00:00	Essentials Coconut Cream 400 mL	f	1200.00	4.2	4	32	1
8156	2022-05-24 21:00:00	Macro Organic Tomatoes Diced NAS 400g	t	400	1.8	2	501	1
8157	2022-05-24 21:00:00	Doritos Corn Chips Original 170g	f	510.00	6	2	2197	1
8158	2022-05-24 21:00:00	WW Coconut Water 1L	f	2	4	3	544	1
8159	2022-05-24 21:00:00	Macro Orgaic Passata 700g	t	2800.00	12	2	2199	1
8160	2022-05-24 21:00:00	Carrots, 1.5 kg Odd Bunch	f	1.5	3	1	31	1
8402	2022-05-16 12:00:00	No Label Jumbo dozen eggs	f	800.00	5.5	2	7	14
8075	2022-05-10 22:22:00	Karajoz Organic Coffee Beans	f	0.75	20.49	1	33	2
8076	2022-05-10 22:22:00	Pams Flour Plain 1.5 kg	f	1.50	1.8	1	566	2
8077	2022-05-10 22:22:00	T/Colledge Vanilla Exract 100 mL FairTrade	t	200	19.18	4	313	2
8078	2022-05-10 22:22:00	Whittakers Block Cocoa Dark 72% 250g	f	1000	16	2	34	2
8079	2022-05-10 22:22:00	NZ Red Cod Fillets	f	0.544	10.77	1	8	2
8080	2022-05-10 22:22:00	Apples Dazzle NZ	f	1.571	1.56	1	20	2
8081	2022-05-10 22:22:00	Avocado. Large Loose	f	2	4	7	148	2
8082	2022-05-10 22:22:00	Bananas Conventional	f	1.286	3.72	1	5	2
8083	2022-05-10 22:22:00	Bananas Conventional	f	0.276	0.8	1	5	2
8084	2022-05-10 22:22:00	Beetroot Conventional	f	0.226	1.11	1	318	2
8085	2022-05-10 22:22:00	Cabbage Green Whole	f	1	4.99	7	552	2
8086	2022-05-10 22:22:00	Kumara Orange	f	1.661	4.97	1	21	2
8087	2022-05-10 22:22:00	Mushrooms Button Loose	f	0.177	2.12	1	22	2
8088	2022-05-10 22:22:00	Onions Brown Loose	f	0.301	0.6	1	2	2
8660	2022-06-21 23:33:00	Bananas Cavendish	f	1.272	4.2	1	5	1
8661	2022-06-21 23:33:00	Onions Brown Loose	f	0.392	1.17	1	2	1
8662	2022-06-21 23:33:00	Mushrooms Button Loose	f	0.218	3.05	1	22	1
8663	2022-06-21 23:33:00	Organic Agria Potatoes 5kg	t	5	13	1	3	1
8664	2022-06-21 23:33:00	San Remo Pasta No5 Spaghetti 500g	f	500.00	2	2	1994	1
8665	2022-06-21 23:33:00	WW Tuna in Springwater 185g	f	1480.00	16	2	548	1
8666	2022-06-21 23:33:00	Essentials Coconut Cream 400 mL	f	1200	4.2	4	32	1
8667	2022-06-21 23:33:00	Doritos Corn Chips Original 170g	f	340.00	4	2	2197	1
8668	2022-06-21 23:33:00	WW Crinkle Cut Chips Ready 150g	f	150	1.5	2	2398	1
8669	2022-06-21 23:33:00	Orchard Gold Peaches & Blueberry 1kg	f	1.00	10.5	1	2399	1
8670	2022-06-21 23:33:00	McCain Peas Frozen 1kg	f	1.00	3.5	1	320	1
8671	2022-06-21 23:33:00	Rocket Prime NZ Beef Patties 600g REDUCED	f	600	7.15	2	2400	1
8672	2022-06-21 23:33:00	WW Maple Syrup 250mL	f	250	7.5	4	2401	1
8673	2022-06-21 23:33:00	Apples 2 kg Odd Bunch	f	2	3	1	20	1
8674	2022-06-21 23:33:00	Countdown Free Range Sz 7 12pk	f	744	6.9	2	7	1
8561	2022-05-31 22:56:00	Onions Brown Loose	f	0.397	1.19	1	2	1
8562	2022-05-31 22:56:00	Fresh Ginger	f	0.162	2.67	1	537	1
8563	2022-05-31 22:56:00	CD Beef Scotch Fillet Steak REDUCED	f	0.675	15.49	1	2377	1
8564	2022-05-31 22:56:00	CD Chicken Nibbles Med Reduced	f	0.637	4.18	1	2215	1
8565	2022-05-31 22:56:00	Bananas Cavendish	f	2.677	9.37	1	5	1
8566	2022-05-31 22:56:00	Apples 2kg Odd Bunch	f	2	4.99	1	20	1
8567	2022-05-31 22:56:00	CD Still Spring Water 1.5L	f	1.5	0.9	3	546	1
8568	2022-05-31 22:56:00	WW Peach SLices in Fruit Juice 410g	f	1640.00	6	2	1945	1
8569	2022-05-31 22:56:00	Essentials Coconut Cream 400 mL	f	1200	4.2	4	32	1
8570	2022-05-31 22:56:00	Macro Orgaic Passata 700g	t	700	3.00	2	2199	1
8571	2022-05-31 22:56:00	Odd Bunch Avocados 1kg	f	1	7	1	148	1
8572	2022-05-31 22:56:00	Sun Valley Brown Lentils 500g	f	0.5	2.89	1	2378	1
8573	2022-05-31 22:56:00	McKenzies Peas Split Green 500g	f	0.5	1.99	1	2379	1
8574	2022-05-31 22:56:00	Cerebos Coarse Salt 500g	f	0.5	2.19	1	571	1
8575	2022-05-31 22:56:00	Rocket Prime NZ Beef Meatballs 490g REDUCED	f	0.98	12.88	1	2380	1
8576	2022-05-31 22:56:00	CD Beef Mince 1kg Reduced	f	1	11.47	1	35	1
8577	2022-05-31 22:56:00	Raglan Coconut Yoghurt Vanilla 700g	f	700.00	12.99	2	565	1
8578	2022-05-31 22:56:00	Mainland Cheese Vintage 500g	f	500	12.20	2	143	1
8579	2022-05-31 22:56:00	Mexicano Corn Chips Natural 300g	f	300	3	2	547	1
8580	2022-05-31 22:56:00	WW Crinkle Cut Chips Salted 150g	f	150	1.5	2	2381	1
8584	2022-06-22 00:00:00	NZ Snapper Heads	f	1.802	8.24	1	315	12
8587	2022-06-22 01:00:00	1 kg Avocados Spray Free	f	1	5	1	148	9
\.


--
-- Data for Name: units; Type: TABLE DATA; Schema: public; Owner: das
--

COPY public.units (id, name) FROM stdin;
1	kg
2	g
3	L
4	mL
18	Bags
7	Pieces
6	Bunches
\.


--
-- Name: categories_id_seq; Type: SEQUENCE SET; Schema: public; Owner: das
--

SELECT pg_catalog.setval('public.categories_id_seq', 2403, true);


--
-- Name: conversions_complex_id_seq; Type: SEQUENCE SET; Schema: public; Owner: das
--

SELECT pg_catalog.setval('public.conversions_complex_id_seq', 1, true);


--
-- Name: groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: das
--

SELECT pg_catalog.setval('public.groups_id_seq', 2406, true);


--
-- Name: products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: das
--

SELECT pg_catalog.setval('public.products_id_seq', 2401, true);


--
-- Name: stores_id_seq; Type: SEQUENCE SET; Schema: public; Owner: das
--

SELECT pg_catalog.setval('public.stores_id_seq', 43, true);


--
-- Name: transactions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: das
--

SELECT pg_catalog.setval('public.transactions_id_seq', 8674, true);


--
-- Name: units_id_seq; Type: SEQUENCE SET; Schema: public; Owner: das
--

SELECT pg_catalog.setval('public.units_id_seq', 130, true);


--
-- Name: categories categories_name_key; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_name_key UNIQUE (name);


--
-- Name: categories categories_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT categories_pkey PRIMARY KEY (id);


--
-- Name: groups groups_name_key; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.groups
    ADD CONSTRAINT groups_name_key UNIQUE (name);


--
-- Name: groups groups_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.groups
    ADD CONSTRAINT groups_pkey PRIMARY KEY (id);


--
-- Name: products products_name_key; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_name_key UNIQUE (name);


--
-- Name: products products_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_pkey PRIMARY KEY (id);


--
-- Name: stores stores_name_key; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.stores
    ADD CONSTRAINT stores_name_key UNIQUE (name);


--
-- Name: stores stores_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.stores
    ADD CONSTRAINT stores_pkey PRIMARY KEY (id);


--
-- Name: units units_pkey; Type: CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.units
    ADD CONSTRAINT units_pkey PRIMARY KEY (id);


--
-- Name: products fk_category_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT fk_category_id FOREIGN KEY (category_id) REFERENCES public.categories(id);


--
-- Name: conversions fk_from; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions
    ADD CONSTRAINT fk_from FOREIGN KEY (_from) REFERENCES public.units(id);


--
-- Name: conversions_complex fk_from; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions_complex
    ADD CONSTRAINT fk_from FOREIGN KEY (_from) REFERENCES public.units(id);


--
-- Name: categories fk_group_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.categories
    ADD CONSTRAINT fk_group_id FOREIGN KEY (group_id) REFERENCES public.groups(id);


--
-- Name: transactions fk_product_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT fk_product_id FOREIGN KEY (product_id) REFERENCES public.products(id);


--
-- Name: conversions_complex fk_product_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions_complex
    ADD CONSTRAINT fk_product_id FOREIGN KEY (product_id) REFERENCES public.products(id);


--
-- Name: transactions fk_store_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT fk_store_id FOREIGN KEY (store_id) REFERENCES public.stores(id);


--
-- Name: conversions fk_to; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions
    ADD CONSTRAINT fk_to FOREIGN KEY (_to) REFERENCES public.units(id);


--
-- Name: conversions_complex fk_to; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.conversions_complex
    ADD CONSTRAINT fk_to FOREIGN KEY (_to) REFERENCES public.units(id);


--
-- Name: transactions fk_unit_id; Type: FK CONSTRAINT; Schema: public; Owner: das
--

ALTER TABLE ONLY public.transactions
    ADD CONSTRAINT fk_unit_id FOREIGN KEY (unit_id) REFERENCES public.units(id);


--
-- PostgreSQL database dump complete
--