EventFilters

CREATE TABLE attendee
(
    email        TEXT                      NOT NULL,
    details      json,
    id           INT generated BY DEFAULT AS IDENTITY PRIMARY KEY,
    eventid      INTEGER,
    eventfilters jsonb DEFAULT '[]'::jsonb NOT NULL
);


INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Org Type", "selected": ["B2C", "Both", "Nonprofit"]}, {"field": "Job Role", "selected": ["Customer Experience", "Digital Marketing"]}, {"field": "Industry Sector", "selected": ["Advertising", "Construction / Development"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Transportation Responsibility", "selected": ["5M - 10M", "10M - 25M"]}, {"field": "Appointment Times", "selected": ["yes"]}, {"field": "Swag", "selected": ["Worldwide", "North America (US, Canada and Mexico)"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Org Type", "selected": ["B2C", "Both", "Nonprofit"]}, {"field": "Job Role", "selected": ["Customer Experience", "Digital Marketing"]}, {"field": "Appointment Times", "selected": ["yes"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Org Type", "selected": ["B2C", "Both", "Nonprofit"]}, {"field": "Job Role", "selected": ["Customer Experience", "Digital Marketing"]}, {"field": "Industry Sector", "selected": ["Advertising", "Construction / Development"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Org Type", "selected": ["B2C", "Both", "Nonprofit"]}, {"field": "Job Role", "selected": ["Customer Experience", "Digital Marketing"]}, {"field": "Appointment Times", "selected": ["yes"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Org Type", "selected": ["B2C", "Both", "Nonprofit"]}, {"field": "Job Role", "selected": ["Customer Experience", "Digital Marketing"]}, {"field": "Appointment Times", "selected": ["yes"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Org Type", "selected": ["B2C", "Both", "Nonprofit"]}, {"field": "Job Role", "selected": ["Customer Experience", "Digital Marketing"]}, {"field": "Industry Sector", "selected": ["Advertising", "Construction / Development"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Org Type", "selected": ["B2C"]}, {"field": "Job Role", "selected": ["Digital Marketing"]}, {"field": "Industry Sector", "selected": ["Advertising", "Construction / Development"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Transportation Responsibility", "selected": ["5M - 10M", "10M - 25M"]}, {"field": "Appointment Times", "selected": ["no"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Org Type", "selected": ["B2C", "Both", "Nonprofit"]}, {"field": "Job Role", "selected": ["Customer Experience", "Digital Marketing"]}, {"field": "Industry Sector", "selected": ["Advertising", "Construction / Development"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('email11example.org', 1, '[{"field": "Transportation Responsibility", "selected": ["5M - 10M", "10M - 25M"]}, {"field": "Appointment Times", "selected": ["yes"]}, {"field": "Swag", "selected": ["Worldwide", "North America (US, Canada and Mexico)"]}]');
INSERT INTO public.attendee (email, eventid, eventfilters) VALUES ('[email protected]', 1, '[{"field": "Transportation Responsibility", "selected": ["5M - 10M", "10M - 25M"]}, {"field": "Appointment Times", "selected": ["yes"]}, {"field": "Swag", "selected": ["Worldwide", "North America (US, Canada and Mexico)"]}]');