backup.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 11.2 (Debian 11.2-1.pgdg90+1)
-- Dumped by pg_dump version 11.2 (Debian 11.2-1.pgdg90+1)

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 client_min_messages = warning;
SET row_security = off;

--
-- Name: hdb_catalog; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA hdb_catalog;


ALTER SCHEMA hdb_catalog OWNER TO postgres;

--
-- Name: hdb_views; Type: SCHEMA; Schema: -; Owner: postgres
--

CREATE SCHEMA hdb_views;


ALTER SCHEMA hdb_views OWNER TO postgres;

--
-- Name: intarray; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS intarray WITH SCHEMA public;


--
-- Name: EXTENSION intarray; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION intarray IS 'functions, operators, and index support for 1-D arrays of integers';


--
-- Name: pgcrypto; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS pgcrypto WITH SCHEMA public;


--
-- Name: EXTENSION pgcrypto; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION pgcrypto IS 'cryptographic functions';


--
-- Name: hdb_table_oid_check(); Type: FUNCTION; Schema: hdb_catalog; Owner: postgres
--

CREATE FUNCTION hdb_catalog.hdb_table_oid_check() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
  BEGIN
    IF (EXISTS (SELECT 1 FROM information_schema.tables st WHERE st.table_schema = NEW.table_schema AND st.table_name = NEW.table_name)) THEN
      return NEW;
    ELSE
      RAISE foreign_key_violation using message = 'table_schema, table_name not in information_schema.tables';
      return NULL;
    END IF;
  END;
$$;


ALTER FUNCTION hdb_catalog.hdb_table_oid_check() OWNER TO postgres;

--
-- Name: inject_table_defaults(text, text, text, text); Type: FUNCTION; Schema: hdb_catalog; Owner: postgres
--

CREATE FUNCTION hdb_catalog.inject_table_defaults(view_schema text, view_name text, tab_schema text, tab_name text) RETURNS void
    LANGUAGE plpgsql
    AS $$
    DECLARE
        r RECORD;
    BEGIN
      FOR r IN SELECT column_name, column_default FROM information_schema.columns WHERE table_schema = tab_schema AND table_name = tab_name AND column_default IS NOT NULL LOOP
          EXECUTE format('ALTER VIEW %I.%I ALTER COLUMN %I SET DEFAULT %s;', view_schema, view_name, r.column_name, r.column_default);
      END LOOP;
    END;
$$;


ALTER FUNCTION hdb_catalog.inject_table_defaults(view_schema text, view_name text, tab_schema text, tab_name text) OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: event_invocation_logs; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.event_invocation_logs (
    id text DEFAULT public.gen_random_uuid() NOT NULL,
    event_id text,
    status integer,
    request json,
    response json,
    created_at timestamp without time zone DEFAULT now()
);


ALTER TABLE hdb_catalog.event_invocation_logs OWNER TO postgres;

--
-- Name: event_log; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.event_log (
    id text DEFAULT public.gen_random_uuid() NOT NULL,
    schema_name text NOT NULL,
    table_name text NOT NULL,
    trigger_id text NOT NULL,
    trigger_name text NOT NULL,
    payload jsonb NOT NULL,
    delivered boolean DEFAULT false NOT NULL,
    error boolean DEFAULT false NOT NULL,
    tries integer DEFAULT 0 NOT NULL,
    created_at timestamp without time zone DEFAULT now(),
    locked boolean DEFAULT false NOT NULL,
    next_retry_at timestamp without time zone
);


ALTER TABLE hdb_catalog.event_log OWNER TO postgres;

--
-- Name: event_triggers; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.event_triggers (
    id text DEFAULT public.gen_random_uuid() NOT NULL,
    name text,
    type text NOT NULL,
    schema_name text NOT NULL,
    table_name text NOT NULL,
    configuration json,
    comment text
);


ALTER TABLE hdb_catalog.event_triggers OWNER TO postgres;

--
-- Name: hdb_check_constraint; Type: VIEW; Schema: hdb_catalog; Owner: postgres
--

CREATE VIEW hdb_catalog.hdb_check_constraint AS
 SELECT (n.nspname)::text AS table_schema,
    (ct.relname)::text AS table_name,
    (r.conname)::text AS constraint_name,
    pg_get_constraintdef(r.oid, true) AS "check"
   FROM ((pg_constraint r
     JOIN pg_class ct ON ((r.conrelid = ct.oid)))
     JOIN pg_namespace n ON ((ct.relnamespace = n.oid)))
  WHERE (r.contype = 'c'::"char");


ALTER TABLE hdb_catalog.hdb_check_constraint OWNER TO postgres;

--
-- Name: hdb_foreign_key_constraint; Type: VIEW; Schema: hdb_catalog; Owner: postgres
--

CREATE VIEW hdb_catalog.hdb_foreign_key_constraint AS
 SELECT (q.table_schema)::text AS table_schema,
    (q.table_name)::text AS table_name,
    (q.constraint_name)::text AS constraint_name,
    (min(q.constraint_oid))::integer AS constraint_oid,
    min((q.ref_table_table_schema)::text) AS ref_table_table_schema,
    min((q.ref_table)::text) AS ref_table,
    json_object_agg(ac.attname, afc.attname) AS column_mapping,
    min((q.confupdtype)::text) AS on_update,
    min((q.confdeltype)::text) AS on_delete
   FROM ((( SELECT ctn.nspname AS table_schema,
            ct.relname AS table_name,
            r.conrelid AS table_id,
            r.conname AS constraint_name,
            r.oid AS constraint_oid,
            cftn.nspname AS ref_table_table_schema,
            cft.relname AS ref_table,
            r.confrelid AS ref_table_id,
            r.confupdtype,
            r.confdeltype,
            unnest(r.conkey) AS column_id,
            unnest(r.confkey) AS ref_column_id
           FROM ((((pg_constraint r
             JOIN pg_class ct ON ((r.conrelid = ct.oid)))
             JOIN pg_namespace ctn ON ((ct.relnamespace = ctn.oid)))
             JOIN pg_class cft ON ((r.confrelid = cft.oid)))
             JOIN pg_namespace cftn ON ((cft.relnamespace = cftn.oid)))
          WHERE (r.contype = 'f'::"char")) q
     JOIN pg_attribute ac ON (((q.column_id = ac.attnum) AND (q.table_id = ac.attrelid))))
     JOIN pg_attribute afc ON (((q.ref_column_id = afc.attnum) AND (q.ref_table_id = afc.attrelid))))
  GROUP BY q.table_schema, q.table_name, q.constraint_name;


ALTER TABLE hdb_catalog.hdb_foreign_key_constraint OWNER TO postgres;

--
-- Name: hdb_function; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.hdb_function (
    function_schema text NOT NULL,
    function_name text NOT NULL,
    is_system_defined boolean DEFAULT false
);


ALTER TABLE hdb_catalog.hdb_function OWNER TO postgres;

--
-- Name: hdb_function_agg; Type: VIEW; Schema: hdb_catalog; Owner: postgres
--

CREATE VIEW hdb_catalog.hdb_function_agg AS
 SELECT (p.proname)::text AS function_name,
    (pn.nspname)::text AS function_schema,
        CASE
            WHEN (p.provariadic = (0)::oid) THEN false
            ELSE true
        END AS has_variadic,
        CASE
            WHEN ((p.provolatile)::text = ('i'::character(1))::text) THEN 'IMMUTABLE'::text
            WHEN ((p.provolatile)::text = ('s'::character(1))::text) THEN 'STABLE'::text
            WHEN ((p.provolatile)::text = ('v'::character(1))::text) THEN 'VOLATILE'::text
            ELSE NULL::text
        END AS function_type,
    pg_get_functiondef(p.oid) AS function_definition,
    (rtn.nspname)::text AS return_type_schema,
    (rt.typname)::text AS return_type_name,
        CASE
            WHEN ((rt.typtype)::text = ('b'::character(1))::text) THEN 'BASE'::text
            WHEN ((rt.typtype)::text = ('c'::character(1))::text) THEN 'COMPOSITE'::text
            WHEN ((rt.typtype)::text = ('d'::character(1))::text) THEN 'DOMAIN'::text
            WHEN ((rt.typtype)::text = ('e'::character(1))::text) THEN 'ENUM'::text
            WHEN ((rt.typtype)::text = ('r'::character(1))::text) THEN 'RANGE'::text
            WHEN ((rt.typtype)::text = ('p'::character(1))::text) THEN 'PSUEDO'::text
            ELSE NULL::text
        END AS return_type_type,
    p.proretset AS returns_set,
    ( SELECT COALESCE(json_agg(pt.typname), '[]'::json) AS "coalesce"
           FROM (unnest(COALESCE(p.proallargtypes, (p.proargtypes)::oid[])) WITH ORDINALITY pat(oid, ordinality)
             LEFT JOIN pg_type pt ON ((pt.oid = pat.oid)))) AS input_arg_types,
    to_json(COALESCE(p.proargnames, ARRAY[]::text[])) AS input_arg_names
   FROM (((pg_proc p
     JOIN pg_namespace pn ON ((pn.oid = p.pronamespace)))
     JOIN pg_type rt ON ((rt.oid = p.prorettype)))
     JOIN pg_namespace rtn ON ((rtn.oid = rt.typnamespace)))
  WHERE (((pn.nspname)::text !~~ 'pg_%'::text) AND ((pn.nspname)::text <> ALL (ARRAY['information_schema'::text, 'hdb_catalog'::text, 'hdb_views'::text])) AND (NOT (EXISTS ( SELECT 1
           FROM pg_aggregate
          WHERE ((pg_aggregate.aggfnoid)::oid = p.oid)))));


ALTER TABLE hdb_catalog.hdb_function_agg OWNER TO postgres;

--
-- Name: hdb_permission; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.hdb_permission (
    table_schema text NOT NULL,
    table_name text NOT NULL,
    role_name text NOT NULL,
    perm_type text NOT NULL,
    perm_def jsonb NOT NULL,
    comment text,
    is_system_defined boolean DEFAULT false,
    CONSTRAINT hdb_permission_perm_type_check CHECK ((perm_type = ANY (ARRAY['insert'::text, 'select'::text, 'update'::text, 'delete'::text])))
);


ALTER TABLE hdb_catalog.hdb_permission OWNER TO postgres;

--
-- Name: hdb_permission_agg; Type: VIEW; Schema: hdb_catalog; Owner: postgres
--

CREATE VIEW hdb_catalog.hdb_permission_agg AS
 SELECT hdb_permission.table_schema,
    hdb_permission.table_name,
    hdb_permission.role_name,
    json_object_agg(hdb_permission.perm_type, hdb_permission.perm_def) AS permissions
   FROM hdb_catalog.hdb_permission
  GROUP BY hdb_permission.table_schema, hdb_permission.table_name, hdb_permission.role_name;


ALTER TABLE hdb_catalog.hdb_permission_agg OWNER TO postgres;

--
-- Name: hdb_primary_key; Type: VIEW; Schema: hdb_catalog; Owner: postgres
--

CREATE VIEW hdb_catalog.hdb_primary_key AS
 SELECT tc.table_schema,
    tc.table_name,
    tc.constraint_name,
    json_agg(constraint_column_usage.column_name) AS columns
   FROM (information_schema.table_constraints tc
     JOIN ( SELECT x.tblschema AS table_schema,
            x.tblname AS table_name,
            x.colname AS column_name,
            x.cstrname AS constraint_name
           FROM ( SELECT DISTINCT nr.nspname,
                    r.relname,
                    a.attname,
                    c.conname
                   FROM pg_namespace nr,
                    pg_class r,
                    pg_attribute a,
                    pg_depend d,
                    pg_namespace nc,
                    pg_constraint c
                  WHERE ((nr.oid = r.relnamespace) AND (r.oid = a.attrelid) AND (d.refclassid = ('pg_class'::regclass)::oid) AND (d.refobjid = r.oid) AND (d.refobjsubid = a.attnum) AND (d.classid = ('pg_constraint'::regclass)::oid) AND (d.objid = c.oid) AND (c.connamespace = nc.oid) AND (c.contype = 'c'::"char") AND (r.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])) AND (NOT a.attisdropped))
                UNION ALL
                 SELECT nr.nspname,
                    r.relname,
                    a.attname,
                    c.conname
                   FROM pg_namespace nr,
                    pg_class r,
                    pg_attribute a,
                    pg_namespace nc,
                    pg_constraint c
                  WHERE ((nr.oid = r.relnamespace) AND (r.oid = a.attrelid) AND (nc.oid = c.connamespace) AND (r.oid =
                        CASE c.contype
                            WHEN 'f'::"char" THEN c.confrelid
                            ELSE c.conrelid
                        END) AND (a.attnum = ANY (
                        CASE c.contype
                            WHEN 'f'::"char" THEN c.confkey
                            ELSE c.conkey
                        END)) AND (NOT a.attisdropped) AND (c.contype = ANY (ARRAY['p'::"char", 'u'::"char", 'f'::"char"])) AND (r.relkind = ANY (ARRAY['r'::"char", 'p'::"char"])))) x(tblschema, tblname, colname, cstrname)) constraint_column_usage ON ((((tc.constraint_name)::text = (constraint_column_usage.constraint_name)::text) AND ((tc.table_schema)::text = (constraint_column_usage.table_schema)::text) AND ((tc.table_name)::text = (constraint_column_usage.table_name)::text))))
  WHERE ((tc.constraint_type)::text = 'PRIMARY KEY'::text)
  GROUP BY tc.table_schema, tc.table_name, tc.constraint_name;


ALTER TABLE hdb_catalog.hdb_primary_key OWNER TO postgres;

--
-- Name: hdb_query_template; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.hdb_query_template (
    template_name text NOT NULL,
    template_defn jsonb NOT NULL,
    comment text,
    is_system_defined boolean DEFAULT false
);


ALTER TABLE hdb_catalog.hdb_query_template OWNER TO postgres;

--
-- Name: hdb_relationship; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.hdb_relationship (
    table_schema text NOT NULL,
    table_name text NOT NULL,
    rel_name text NOT NULL,
    rel_type text,
    rel_def jsonb NOT NULL,
    comment text,
    is_system_defined boolean DEFAULT false,
    CONSTRAINT hdb_relationship_rel_type_check CHECK ((rel_type = ANY (ARRAY['object'::text, 'array'::text])))
);


ALTER TABLE hdb_catalog.hdb_relationship OWNER TO postgres;

--
-- Name: hdb_table; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.hdb_table (
    table_schema text NOT NULL,
    table_name text NOT NULL,
    is_system_defined boolean DEFAULT false
);


ALTER TABLE hdb_catalog.hdb_table OWNER TO postgres;

--
-- Name: hdb_unique_constraint; Type: VIEW; Schema: hdb_catalog; Owner: postgres
--

CREATE VIEW hdb_catalog.hdb_unique_constraint AS
 SELECT tc.table_name,
    tc.constraint_schema AS table_schema,
    tc.constraint_name,
    json_agg(kcu.column_name) AS columns
   FROM (information_schema.table_constraints tc
     JOIN information_schema.key_column_usage kcu USING (constraint_schema, constraint_name))
  WHERE ((tc.constraint_type)::text = 'UNIQUE'::text)
  GROUP BY tc.table_name, tc.constraint_schema, tc.constraint_name;


ALTER TABLE hdb_catalog.hdb_unique_constraint OWNER TO postgres;

--
-- Name: hdb_version; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.hdb_version (
    hasura_uuid uuid DEFAULT public.gen_random_uuid() NOT NULL,
    version text NOT NULL,
    upgraded_on timestamp with time zone NOT NULL,
    cli_state jsonb DEFAULT '{}'::jsonb NOT NULL,
    console_state jsonb DEFAULT '{}'::jsonb NOT NULL
);


ALTER TABLE hdb_catalog.hdb_version OWNER TO postgres;

--
-- Name: migration_settings; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.migration_settings (
    setting text NOT NULL,
    value text NOT NULL
);


ALTER TABLE hdb_catalog.migration_settings OWNER TO postgres;

--
-- Name: remote_schemas; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.remote_schemas (
    id bigint NOT NULL,
    name text,
    definition json,
    comment text
);


ALTER TABLE hdb_catalog.remote_schemas OWNER TO postgres;

--
-- Name: remote_schemas_id_seq; Type: SEQUENCE; Schema: hdb_catalog; Owner: postgres
--

CREATE SEQUENCE hdb_catalog.remote_schemas_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE hdb_catalog.remote_schemas_id_seq OWNER TO postgres;

--
-- Name: remote_schemas_id_seq; Type: SEQUENCE OWNED BY; Schema: hdb_catalog; Owner: postgres
--

ALTER SEQUENCE hdb_catalog.remote_schemas_id_seq OWNED BY hdb_catalog.remote_schemas.id;


--
-- Name: schema_migrations; Type: TABLE; Schema: hdb_catalog; Owner: postgres
--

CREATE TABLE hdb_catalog.schema_migrations (
    version bigint NOT NULL,
    dirty boolean NOT NULL
);


ALTER TABLE hdb_catalog.schema_migrations OWNER TO postgres;

--
-- Name: answers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.answers (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    content text NOT NULL,
    question_id uuid NOT NULL,
    session_journey_id uuid NOT NULL
);


ALTER TABLE public.answers OWNER TO postgres;

--
-- Name: TABLE answers; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.answers IS 'The answer to a question within a journey’s session.';


--
-- Name: feelings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.feelings (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    name text NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    is_positive boolean DEFAULT false NOT NULL
);


ALTER TABLE public.feelings OWNER TO postgres;

--
-- Name: TABLE feelings; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.feelings IS 'The emotion/feeling the participant has while working on the task.';


--
-- Name: journey_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.journey_items (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    journey_id uuid NOT NULL,
    "position" integer DEFAULT 0 NOT NULL,
    item_type text NOT NULL,
    item_id uuid NOT NULL
);


ALTER TABLE public.journey_items OWNER TO postgres;

--
-- Name: TABLE journey_items; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.journey_items IS 'A collection of items (tasks, questions, etc) that make up a journey.';


--
-- Name: journeys; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.journeys (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    name text NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.journeys OWNER TO postgres;

--
-- Name: TABLE journeys; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.journeys IS 'A pre-composed set of tasks that can be added to a session.';


--
-- Name: observations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.observations (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    overall_sentiment integer DEFAULT 0,
    on_path boolean,
    notes text,
    started_at timestamp with time zone,
    ended_at timestamp with time zone,
    typing_started_at timestamp with time zone,
    task_id uuid NOT NULL,
    feeling_id uuid,
    session_journey_id uuid NOT NULL,
    prompt_id uuid,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.observations OWNER TO postgres;

--
-- Name: TABLE observations; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.observations IS 'Observer-driven comments on how the participant is progressing through the task. ';


--
-- Name: participants; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.participants (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    name text NOT NULL,
    alias text NOT NULL,
    notes text,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    uid text,
    informed_consent boolean,
    do_not_invite boolean
);


ALTER TABLE public.participants OWNER TO postgres;

--
-- Name: TABLE participants; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.participants IS 'The person being interviewed or observed.';


--
-- Name: projects; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.projects (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    name text NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.projects OWNER TO postgres;

--
-- Name: TABLE projects; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.projects IS 'A named collection of session groups for a single client.';


--
-- Name: prompts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.prompts (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    content text NOT NULL,
    "position" integer DEFAULT 0 NOT NULL,
    task_id uuid NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.prompts OWNER TO postgres;

--
-- Name: TABLE prompts; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.prompts IS 'A helpful cue that aids a user attempting to complete a task.';


--
-- Name: questions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.questions (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    content text NOT NULL
);


ALTER TABLE public.questions OWNER TO postgres;

--
-- Name: TABLE questions; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.questions IS 'A question posed by an observer.';


--
-- Name: ratings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ratings (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    notes text,
    started_at timestamp with time zone,
    ended_at timestamp with time zone,
    task_id uuid NOT NULL,
    session_journey_id uuid NOT NULL,
    scale integer,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.ratings OWNER TO postgres;

--
-- Name: TABLE ratings; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.ratings IS 'A 7-point rating scale to assess how difficult participants find a task.';


--
-- Name: session_groups; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.session_groups (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    name text NOT NULL,
    description text,
    project_id uuid NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now()
);


ALTER TABLE public.session_groups OWNER TO postgres;

--
-- Name: TABLE session_groups; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.session_groups IS 'A named grouping of sessions for a project.';


--
-- Name: session_journeys; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.session_journeys (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    started_at timestamp with time zone,
    ended_at timestamp with time zone,
    "position" integer DEFAULT 0 NOT NULL,
    journey_id uuid NOT NULL,
    session_id uuid NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    sus_scores integer[]
);


ALTER TABLE public.session_journeys OWNER TO postgres;

--
-- Name: TABLE session_journeys; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.session_journeys IS 'The association of a session and journey.';


--
-- Name: session_journeys_sus_score; Type: VIEW; Schema: public; Owner: postgres
--

CREATE VIEW public.session_journeys_sus_score AS
SELECT
    NULL::uuid AS id,
    NULL::numeric AS score;


ALTER TABLE public.session_journeys_sus_score OWNER TO postgres;

--
-- Name: sessions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sessions (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    name text NOT NULL,
    started_at timestamp with time zone,
    ended_at timestamp with time zone,
    session_group_id uuid NOT NULL,
    participant_id uuid NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    location text
);


ALTER TABLE public.sessions OWNER TO postgres;

--
-- Name: TABLE sessions; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.sessions IS 'A participant taking one or more journeys during the course of an interview .';


--
-- Name: tasks; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tasks (
    id uuid DEFAULT public.gen_random_uuid() NOT NULL,
    content text NOT NULL,
    journey_id uuid NOT NULL,
    created_at timestamp with time zone DEFAULT now(),
    updated_at timestamp with time zone DEFAULT now(),
    "position" integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.tasks OWNER TO postgres;

--
-- Name: TABLE tasks; Type: COMMENT; Schema: public; Owner: postgres
--

COMMENT ON TABLE public.tasks IS 'Tasks make up a journey.';


--
-- Name: remote_schemas id; Type: DEFAULT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.remote_schemas ALTER COLUMN id SET DEFAULT nextval('hdb_catalog.remote_schemas_id_seq'::regclass);


--
-- Data for Name: event_invocation_logs; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.event_invocation_logs (id, event_id, status, request, response, created_at) FROM stdin;
\.


--
-- Data for Name: event_log; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.event_log (id, schema_name, table_name, trigger_id, trigger_name, payload, delivered, error, tries, created_at, locked, next_retry_at) FROM stdin;
\.


--
-- Data for Name: event_triggers; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.event_triggers (id, name, type, schema_name, table_name, configuration, comment) FROM stdin;
\.


--
-- Data for Name: hdb_function; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.hdb_function (function_schema, function_name, is_system_defined) FROM stdin;
\.


--
-- Data for Name: hdb_permission; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.hdb_permission (table_schema, table_name, role_name, perm_type, perm_def, comment, is_system_defined) FROM stdin;
\.


--
-- Data for Name: hdb_query_template; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.hdb_query_template (template_name, template_defn, comment, is_system_defined) FROM stdin;
\.


--
-- Data for Name: hdb_relationship; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.hdb_relationship (table_schema, table_name, rel_name, rel_type, rel_def, comment, is_system_defined) FROM stdin;
hdb_catalog	hdb_table	detail	object	{"manual_configuration": {"remote_table": {"name": "tables", "schema": "information_schema"}, "column_mapping": {"table_name": "table_name", "table_schema": "table_schema"}}}	\N	t
hdb_catalog	hdb_table	primary_key	object	{"manual_configuration": {"remote_table": {"name": "hdb_primary_key", "schema": "hdb_catalog"}, "column_mapping": {"table_name": "table_name", "table_schema": "table_schema"}}}	\N	t
hdb_catalog	hdb_table	columns	array	{"manual_configuration": {"remote_table": {"name": "columns", "schema": "information_schema"}, "column_mapping": {"table_name": "table_name", "table_schema": "table_schema"}}}	\N	t
hdb_catalog	hdb_table	foreign_key_constraints	array	{"manual_configuration": {"remote_table": {"name": "hdb_foreign_key_constraint", "schema": "hdb_catalog"}, "column_mapping": {"table_name": "table_name", "table_schema": "table_schema"}}}	\N	t
hdb_catalog	hdb_table	relationships	array	{"manual_configuration": {"remote_table": {"name": "hdb_relationship", "schema": "hdb_catalog"}, "column_mapping": {"table_name": "table_name", "table_schema": "table_schema"}}}	\N	t
hdb_catalog	hdb_table	permissions	array	{"manual_configuration": {"remote_table": {"name": "hdb_permission_agg", "schema": "hdb_catalog"}, "column_mapping": {"table_name": "table_name", "table_schema": "table_schema"}}}	\N	t
hdb_catalog	hdb_table	check_constraints	array	{"manual_configuration": {"remote_table": {"name": "hdb_check_constraint", "schema": "hdb_catalog"}, "column_mapping": {"table_name": "table_name", "table_schema": "table_schema"}}}	\N	t
hdb_catalog	hdb_table	unique_constraints	array	{"manual_configuration": {"remote_table": {"name": "hdb_unique_constraint", "schema": "hdb_catalog"}, "column_mapping": {"table_name": "table_name", "table_schema": "table_schema"}}}	\N	t
hdb_catalog	event_log	trigger	object	{"manual_configuration": {"remote_table": {"name": "event_triggers", "schema": "hdb_catalog"}, "column_mapping": {"trigger_id": "id"}}}	\N	t
hdb_catalog	event_triggers	events	array	{"manual_configuration": {"remote_table": {"name": "event_log", "schema": "hdb_catalog"}, "column_mapping": {"id": "trigger_id"}}}	\N	t
hdb_catalog	event_invocation_logs	event	object	{"foreign_key_constraint_on": "event_id"}	\N	t
hdb_catalog	event_log	logs	array	{"foreign_key_constraint_on": {"table": {"name": "event_invocation_logs", "schema": "hdb_catalog"}, "column": "event_id"}}	\N	t
hdb_catalog	hdb_function_agg	return_table_info	object	{"manual_configuration": {"remote_table": {"name": "hdb_table", "schema": "hdb_catalog"}, "column_mapping": {"return_type_name": "table_name", "return_type_schema": "table_schema"}}}	\N	t
public	sessions	participants	object	{"foreign_key_constraint_on": "participant_id"}	\N	f
public	sessions	session_groups	object	{"foreign_key_constraint_on": "session_group_id"}	\N	f
public	tasks	journey	object	{"foreign_key_constraint_on": "journey_id"}	\N	f
public	prompts	task	object	{"foreign_key_constraint_on": "task_id"}	\N	f
public	session_journeys	journey	object	{"foreign_key_constraint_on": "journey_id"}	\N	f
public	session_journeys	session	object	{"foreign_key_constraint_on": "session_id"}	\N	f
public	ratings	session_journey	object	{"foreign_key_constraint_on": "session_journey_id"}	\N	f
public	ratings	task	object	{"foreign_key_constraint_on": "task_id"}	\N	f
public	observations	feeling	object	{"foreign_key_constraint_on": "feeling_id"}	\N	f
public	observations	prompt	object	{"foreign_key_constraint_on": "prompt_id"}	\N	f
public	observations	session_journey	object	{"foreign_key_constraint_on": "session_journey_id"}	\N	f
public	observations	task	object	{"foreign_key_constraint_on": "task_id"}	\N	f
public	projects	session_groups	array	{"foreign_key_constraint_on": {"table": "session_groups", "column": "project_id"}}	\N	f
public	session_groups	project	object	{"foreign_key_constraint_on": "project_id"}	\N	f
public	session_groups	sessions	array	{"foreign_key_constraint_on": {"table": "sessions", "column": "session_group_id"}}	\N	f
public	journeys	session_journeys	array	{"foreign_key_constraint_on": {"table": "session_journeys", "column": "journey_id"}}	\N	f
public	journeys	tasks	array	{"foreign_key_constraint_on": {"table": "tasks", "column": "journey_id"}}	\N	f
public	participants	sessions	array	{"foreign_key_constraint_on": {"table": "sessions", "column": "participant_id"}}	\N	f
public	sessions	session_journeys	array	{"foreign_key_constraint_on": {"table": "session_journeys", "column": "session_id"}}	\N	f
public	session_journeys	observations	array	{"foreign_key_constraint_on": {"table": "observations", "column": "session_journey_id"}}	\N	f
public	session_journeys	ratings	array	{"foreign_key_constraint_on": {"table": "ratings", "column": "session_journey_id"}}	\N	f
public	feelings	observations	array	{"foreign_key_constraint_on": {"table": "observations", "column": "feeling_id"}}	\N	f
public	prompts	observations	array	{"foreign_key_constraint_on": {"table": "observations", "column": "prompt_id"}}	\N	f
public	tasks	observations	array	{"foreign_key_constraint_on": {"table": "observations", "column": "task_id"}}	\N	f
public	tasks	prompts	array	{"foreign_key_constraint_on": {"table": "prompts", "column": "task_id"}}	\N	f
public	tasks	ratings	array	{"foreign_key_constraint_on": {"table": "ratings", "column": "task_id"}}	\N	f
public	session_journeys	sus_score	object	{"manual_configuration": {"remote_table": "session_journeys_sus_score", "column_mapping": {"id": "id"}}}	\N	f
public	answers	question	object	{"foreign_key_constraint_on": "question_id"}	\N	f
public	answers	session_journeys	object	{"foreign_key_constraint_on": "session_journey_id"}	\N	f
public	questions	answers	array	{"foreign_key_constraint_on": {"table": "answers", "column": "question_id"}}	\N	f
public	session_journeys	answers	array	{"foreign_key_constraint_on": {"table": "answers", "column": "session_journey_id"}}	\N	f
public	journeys	journey_items	array	{"foreign_key_constraint_on": {"table": "journey_items", "column": "journey_id"}}	\N	f
public	journey_items	journey	object	{"foreign_key_constraint_on": "journey_id"}	\N	f
public	journey_items	question	object	{"manual_configuration": {"remote_table": "questions", "column_mapping": {"item_id": "id"}}}	\N	f
public	journey_items	task	object	{"manual_configuration": {"remote_table": "tasks", "column_mapping": {"item_id": "id"}}}	\N	f
\.


--
-- Data for Name: hdb_table; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.hdb_table (table_schema, table_name, is_system_defined) FROM stdin;
hdb_catalog	hdb_table	t
information_schema	tables	t
information_schema	schemata	t
information_schema	views	t
hdb_catalog	hdb_primary_key	t
information_schema	columns	t
hdb_catalog	hdb_foreign_key_constraint	t
hdb_catalog	hdb_relationship	t
hdb_catalog	hdb_permission_agg	t
hdb_catalog	hdb_check_constraint	t
hdb_catalog	hdb_unique_constraint	t
hdb_catalog	hdb_query_template	t
hdb_catalog	event_triggers	t
hdb_catalog	event_log	t
hdb_catalog	event_invocation_logs	t
hdb_catalog	hdb_function_agg	t
hdb_catalog	hdb_function	t
hdb_catalog	remote_schemas	t
hdb_catalog	hdb_version	t
public	projects	f
public	session_groups	f
public	participants	f
public	journeys	f
public	sessions	f
public	tasks	f
public	prompts	f
public	session_journeys	f
public	ratings	f
public	feelings	f
public	observations	f
public	session_journeys_sus_score	f
public	questions	f
public	answers	f
public	journey_items	f
\.


--
-- Data for Name: hdb_version; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.hdb_version (hasura_uuid, version, upgraded_on, cli_state, console_state) FROM stdin;
36403a03-56e2-4956-afe8-df29848b4a1b	9	2019-02-07 18:23:57.919067+00	{}	{"telemetryNotificationShown": true}
\.


--
-- Data for Name: migration_settings; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.migration_settings (setting, value) FROM stdin;
migration_mode	true
\.


--
-- Data for Name: remote_schemas; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.remote_schemas (id, name, definition, comment) FROM stdin;
\.


--
-- Data for Name: schema_migrations; Type: TABLE DATA; Schema: hdb_catalog; Owner: postgres
--

COPY hdb_catalog.schema_migrations (version, dirty) FROM stdin;
1549523942871	f
1549573660174	f
1549573705742	f
1549573788544	f
1549577716216	f
1549578088097	f
1549579364383	f
1549579897436	f
1549579913548	f
1549579928782	f
1549579935811	f
1549579938334	f
1549580179716	f
1549580185312	f
1549580191135	f
1549580207858	f
1549580358440	f
1549580368661	f
1549580408794	f
1549580849987	f
1549580863596	f
1549580871375	f
1549581105821	f
1549581145367	f
1549581156850	f
1549581164515	f
1549581170318	f
1549581396730	f
1549581424630	f
1549581433574	f
1549581444747	f
1549581449083	f
1549581691729	f
1549581858051	f
1549581868275	f
1549581877186	f
1549581884349	f
1549581894925	f
1549581904862	f
1549581908842	f
1549581914521	f
1549581918475	f
1549582700373	f
1549582762874	f
1549582771778	f
1549582829388	f
1549582875326	f
1549582897208	f
1549582921311	f
1549582953597	f
1549583005736	f
1549583023257	f
1549583052716	f
1549583095680	f
1549583126232	f
1549583137330	f
1549583155517	f
1549583203523	f
1549583217532	f
1549583246028	f
1549583251239	f
1549583263782	f
1549583271387	f
1549583281323	f
1549583286315	f
1549583299349	f
1549583304893	f
1549583316226	f
1549583320727	f
1549583333418	f
1549583340072	f
1549583349642	f
1549583355947	f
1549583369308	f
1549583377953	f
1549583386387	f
1549583390748	f
1549583399117	f
1549583403963	f
1549583609974	f
1549660817274	f
1549660833068	f
1549662102886	f
1549662128907	f
1549916379789	f
1550075283656	f
1550083724251	f
1550159940239	f
1550161113973	f
1550161131831	f
1550240540171	f
1550275671424	f
1550275720459	f
1550275734392	f
1550275774928	f
1550275784482	f
1550275794251	f
1550275893402	f
1550278482209	f
1550278497787	f
1550278509441	f
1550278518451	f
1550278528423	f
1550279482042	f
1550279507108	f
1550279888959	f
1550279910964	f
1550279943545	f
1550280010309	f
1550280031181	f
1550280060913	f
1550280070835	f
1550281215585	f
1550281240976	f
1550294184877	f
1550294188337	f
1550294549378	f
1550294572146	f
\.


--
-- Data for Name: answers; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.answers (id, content, question_id, session_journey_id) FROM stdin;
\.


--
-- Data for Name: feelings; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.feelings (id, name, created_at, updated_at, is_positive) FROM stdin;
5a6afa7e-190a-4e07-8718-fac93c8c2657	Afraid	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e7b5ee8a-ec6b-4256-9eb2-a033be8b2f47	Apprehensive	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
060d00e2-701c-4771-b321-2e911ee8d750	Dread	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
0fdcc070-0a39-417c-90e5-fa635b1fe64a	Foreboding	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
c7c5bde7-a4f0-43ec-9d01-759c75812c77	Frightened	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
b535b19a-b5d2-49fc-b04e-fd31bf889de6	Mistrustful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
fbcf307b-6015-43d0-8127-7fb12610f982	Panicked	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
96258721-f9c7-4d78-98ea-a5baf96e49ee	Petrified	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
dccadbf6-a9ab-484e-aeef-12c738eb0054	Scared	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
1fcd1250-5c68-47fd-9d0d-83dd02cacece	Suspicious	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
717ee765-ddbd-4bdc-be8e-acfe1640bf36	Terrified	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
517f4827-5ac1-4634-93b6-f2d7a7a8b44e	Wary	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
f4b9c497-12f7-424b-a541-d2d7cad59a16	Worried	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
491f161d-537d-4109-bf75-5c847e218a2e	Annoyed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
7ee9f563-40cd-4c92-8dd6-00ee88a6a7f2	Aggravated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
586db852-2e8f-44d2-9e47-64b23562be67	Dismayed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
4ac072d4-5091-4410-9957-075528fb37fe	Disgruntled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
dc579ad3-b889-4e5c-86e2-3166ef34f62a	Displeased	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
7bd86ef0-99ec-4d13-b720-9195431eec62	Exasperated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
c55ea820-91b5-40c7-b0aa-65bf68dc901c	Frustrated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
8d678f9d-7172-4b8e-a357-4608d436f8b6	Impatient	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
b65835b7-e47d-494f-a9c2-79495b44e0e7	Irritated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
f8b767c4-31ac-4b23-80db-f7b87550aa4a	Irked	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
de2a927f-94b7-401d-bf18-b2bd57aae0ab	Angry	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
b7c15b47-477a-4b33-99d1-50b3b45532c1	Alert	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
d1e97565-7a03-47f1-a478-0ab98e85ecc1	Curious	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
183af837-a274-48ba-b604-7bbd02f2755e	Enraged	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
d452f3a6-d3c6-47d7-9e21-0985d2fe76e7	Furious	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
edb69efa-7f7d-46f0-a718-20ce38206ded	Incensed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
088129ef-2255-4421-84d0-155220f8b088	Indignant	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
9c01bf17-ddcb-4b4a-bb67-0e1621c33f9a	Irate	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
c1dded62-ee95-4710-b220-b6ca18a346ba	Livid	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
247decac-9235-418a-a171-c3340bc250c1	Outraged	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
b68be31e-0b51-4015-907f-c436bae2aa52	Resentful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
180eecd3-311f-44ed-b5ca-e194720fff39	Aversion	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
d1b80476-ded9-4924-b05a-d14382c691c2	Animosity	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
61f1b945-4f25-45ca-9aff-3be96f1264ee	Appalled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
2df932ce-7dce-4e25-a8c4-275972986b05	Contempt	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
eba0fc0d-fcf7-4343-a6f4-2e171c5d80f4	Disgusted	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
77abce66-6faa-40d1-b331-be2adf1f5e44	Dislike	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
a123a3ca-9002-4b84-ac40-ced0c8228b3e	Hate	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
12cc5caa-ade1-4a7f-84f6-c5d258bb9714	Horrified	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
bdfd3a2a-99f5-40c8-bab6-e3a8f9fd0e37	Hostile	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
a76d6a6e-1d3a-404e-9db2-d6fe6c396e50	Repulsed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
8dea1c09-e856-4891-8632-5c35627c99a5	Confused	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
f6a2530c-a727-4810-84b6-043d833d423e	Ambivalent	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
d7a94583-3f42-4878-b8fd-0317679c9256	Baffled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
fbe98803-43a0-44d6-8d25-d335041069b8	Bewildered	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e0c859ac-7dd3-407f-bdc4-da3855e4670b	Dazed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
d01272cd-a998-48a9-a9c6-7b16bfd62608	Hesitant	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
c3af3c7c-83bc-468a-83ae-ef087483b142	Lost	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
9b342abf-ad8b-461c-9e88-924d5589c4ee	Mystified	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
cf1b7d47-5850-4f78-9434-85289762b67f	Perplexed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
bc2cce25-0a30-4ba1-b181-be8704eff214	Puzzled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
a87a6b85-cd32-4779-9b61-a679421a35bf	Torn	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
cfc0ed61-ade5-4048-8a3c-790d461e3383	Disconnected	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
cb288c0a-9366-4fc4-9ccf-fdc6bf780b94	Alienated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
2c473e97-5db5-4e12-a5e1-105f9d22f546	Aloof	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
142f2e8a-4ac7-4456-bae8-eddd69fed513	Apathetic	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
35c6bbeb-2735-41dd-a21a-27081e2a71b0	Bored	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
588ead54-8ee0-46d4-b72d-23a5c3d7a1d3	Cold	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
724a6791-9149-4db7-a23b-09bfea1810a6	Detached	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
30c1584f-3e65-44e1-9e4a-804afc8112fe	Distant	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
660fa62e-88af-4747-9b2b-81204eec41b2	Distracted	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
61e77b05-5b90-448e-9554-a7a2b7988b8e	Indifferent	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e634329e-4dab-41f8-9e98-dc249ec401e0	Numb	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
c3cbebc9-086f-48f5-92c9-fa38d06048f5	Removed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
6611da29-213f-4816-abd7-54f4a0783f25	Uninterested	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
65e83c0a-f1ac-4b95-b824-c73e78f3617f	Withdrawn	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
c2297e61-7180-4264-85cb-35a75875f88f	Disquiet	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
b458e0a8-4488-4847-b9e9-0a62d5700e12	Agitated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e9f48acf-9bd4-4874-b7df-93ce56fee94b	Alarmed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
cfdb74c5-5a7a-4de3-b37b-265977cc53ae	Discombobulated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
007168cc-ab2c-42aa-bb43-bec64e2ab134	Disconcerted	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
ca6977e2-c235-4e09-9f03-b0c6e45acd66	Disturbed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
3dc20647-76b0-4590-abd9-a4dbd5dc4e11	Perturbed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
8d067cea-74c8-4f88-8b5d-7da370c9b491	Rattled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
9601bf32-f67f-4cb6-8dcd-8699c55acaab	Restless	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
137da3b3-29fd-47e8-a941-fc7864bbc7d7	Shocked	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e12d8944-f2b5-4a7e-921d-27af41820fd2	Startled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
017541f0-164e-486e-916b-64a55bb3b679	Troubled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
bd891952-89df-4487-8e27-00d5781a0bc3	Turbulent	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e1e2abc5-e9e4-4fe8-a9bf-92339ab53106	Turmoil	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
964a3b44-8f9d-41b3-9259-23b205f2b2f7	Uncomfortable	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
0b4bacf5-fab4-41d8-954f-56f1ba76fda5	Uneasy	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
8431aa1d-7211-4397-960a-137d24d81bb3	Unnerved	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
1c570033-3ab3-47b3-9e7e-3fdf5c93987e	Unsettled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
88377a3a-a477-410e-95c1-3647fac2cf6f	Upset	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
836cfc85-98b3-45e5-a3b3-bc68806d4fa1	Embarrassed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
07134d8d-c7f5-4df9-a6e9-08e99f9191e1	Ashamed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
ed440a3b-3234-4f94-ab00-855760eea08a	Chagrined	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
82e3d29a-5b45-4076-9902-7c7d4ba7115d	Flustered	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
90f14fad-465c-4887-bc5e-d9390e58235c	Guilty	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
de66fe8c-09f9-4af2-bafa-5457fa3cb346	Mortified	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
d92f6446-3da2-465e-a6a2-5701b7f7bd95	Self-conscious	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
4d94f81f-eedf-44b5-bb44-8f81bb97deed	Fatigue	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
8c3bedc2-c289-4df0-af2c-791c406a5945	Beat	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
967bb71e-2260-47ee-b3d6-a69eaf981615	Burnt out	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
1b42a27f-a1bc-491a-ae6a-b7d2b7fddd5d	Depleted	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
2c223044-5938-49e5-ab77-d1a59799bd8b	Exhausted	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
adc4d366-797c-454e-933c-bcc37ad25c5b	Lethargic	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
cb820f9e-47a1-4907-b175-0b36c5a069c0	Listless	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
217278c8-b5f8-465d-86d6-bdabaee8bfcc	Sleepy	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
7ee9bf1a-b0d5-48d9-92e9-97e2ee469820	Tired	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
39b92e38-5bb0-49f2-9c8e-12f8b2deb01f	Weary	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
34c2e90e-8c3e-4c66-8c32-dd76187c12a1	Worn out	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
4424a14a-99cc-4884-aa63-a09d2e09d920	Pain	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
71cc2fee-41d7-4a9e-a14c-1f6dc8a55e8c	Agony	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
f1ed914c-a141-47d6-b0d3-41f121914aa4	Anguished	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
2fcce1c0-22a6-4ab3-b754-cfd3e2c519bd	Bereaved	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
f0e47d4a-f707-4c80-87f1-b1beb44a981b	Devastated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
93eabba6-84c8-4641-8e8e-613092470525	Grief	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e93be5dd-4af5-4159-a2a9-73418a968cfd	Heartbroken	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
bb21dc75-dd38-4a96-a82e-d32e32f749b3	Hurt	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
fd4b4189-e50d-404d-a228-6a36cda11917	Lonely	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
bb777942-8050-4e42-8327-59f225595aa2	Miserable	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
534ca93a-839f-4a71-9222-09be5b9b7b5f	Regretful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
14b16b19-725d-45eb-bf3a-fa207c8aafff	Remorseful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
2df1cc29-b86f-41f9-9653-b642a25a6ade	Sad	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
8acccfe9-da77-4927-94be-b8881d88102c	Depressed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
bbe3fa8a-ea72-4afb-bcd5-f2ce6aecee99	Dejected	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
eb8abf91-c4ce-4c7f-9ac6-52710ec101a4	Despair	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
55ef55b5-e6fe-40d6-9f71-9f745e8a3b3f	Despondent	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
39caf672-ff65-4a69-8adc-6a23aa486d7f	Disappointed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
a530bb95-ff28-478c-b711-d513fbd5fbb9	Discouraged	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
74ccc0f1-3257-477f-9ac1-561c5b8d3816	Disheartened	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
0ebd304f-15de-4b10-897c-4c924634ebf2	Forlorn	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
1da9364c-5aac-4887-ac0c-d178ac385de3	Gloomy	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
6c0bb37e-c2e9-4fb9-8f90-45e7b33328fd	Heavy hearted	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
9f32a9ab-4920-4366-b281-92ced95ff4f6	Hopeless	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
44d05077-ab70-4e72-8e4b-b8f510d7fecc	Melancholy	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
10436dbc-f60d-4188-a8ca-5ccc6d013692	Unhappy	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
1129cef9-d2f1-46cf-89e7-464f93711f89	Wretched	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
fb9c4139-56c5-4b96-8998-98196b0d8e41	Tense	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
c0eadad7-d6bb-48b7-a72f-fbbb3d37d227	Anxious	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
91a51a34-245f-4127-bd4d-d94df831f1d9	Cranky	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
ae75def7-436f-4657-a1fe-a6fc58b825ab	Distressed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
26b9991f-9744-4af5-9b7d-471ab3b1149a	Distraught	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
919b8a4c-950b-4aaa-89e4-c64e01e84041	Edgy	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
62b7aacc-7e9c-4adf-9eba-ff3f6c6065a4	Fidgety	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
9f7f53d5-bcfb-45e2-952e-6722aa879523	Frazzled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
566afdb0-33d9-415b-b98f-23017067ed9e	Irritable	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e8cdd2f7-0382-40ee-bac9-fb21543058cf	Jittery	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
478e4f55-86c8-4fae-a4f5-10b58b56bcd2	Nervous	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
e10aba5d-a886-46d6-a4f3-cd85375a5f7d	Overwhelmed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
5d15431a-ca85-4cab-8a58-28880a92ec4b	Stressed out	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
b808f69d-e4a8-4846-83ec-6996be3b88a2	Vulnerable	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
26f0b44b-88f8-46a5-aa02-2914744e64bd	Fragile	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
4b20ed65-ae1c-4aa6-8714-ec0fce6a79d8	Guarded	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
0140d6c7-373a-4a5a-8688-783305e28b92	Helpless	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
07393411-6961-449b-9429-059e5013ac35	Insecure	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
812fca44-ebc2-4d86-9e40-f0122bfbf038	Leery	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
a3bc540c-290f-4e45-81f9-7ad8dff23e22	Reserved	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
f225e9e0-777e-4193-9b36-c54af9b32e2b	Sensitive	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
65d44074-3b0a-4b04-804e-a67d1e295d05	Shaky	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
5ec0d6a5-19a6-47a5-9943-e48da6c0b501	Yearning	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
3dcb4e23-f073-44b9-960c-be05e0231f76	Envious	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
dca23c87-3820-4bce-aefb-8fb839dff3d9	Jealous	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
00f1b2fb-156b-4b1f-bf4a-5b768eabe0e7	Longing	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
12d72a80-61b3-4610-a436-ac7fe8f9b97e	Nostalgic	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
39713fd5-68f2-4cb7-a6e4-73db7edb728c	Pining	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
964c70a4-6574-4cd7-8609-930e5e91d532	Wistful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	f
a672f9be-bf3a-405c-9700-7559cb50e4dc	Engaged	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
bb1c3c6f-2f90-4d2f-9bb8-e9f990377d4a	Fulfilled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
39f6aabf-958c-4014-be4e-7df09c85282a	Engrossed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
befc030c-35b4-4fd2-8afc-b67b21fa3c60	Enchanted	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
41f2ef5c-65d9-4f08-b09c-d5c55f4c7c41	Entranced	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
61b3850d-21d7-4336-805d-6f947844c81e	Fascinated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
77ca7054-ff11-46d0-9190-12ef2c4a63b0	Interested	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
991d19cb-09e3-40ac-ade8-b5b262b434f2	Intrigued	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
a9597f5a-3b4e-48d3-b3cd-c3499a36de28	Involved	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
42626cf5-3977-4a4e-b0b2-ea170285f7b0	Spellbound	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
5635908c-1068-4559-8b8a-3d67bc5bd57b	Stimulated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
c92432bc-d029-439c-bf84-b4cb2231f09f	Hopeful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
49a00da5-0f9e-4e8d-a8e3-2e6fc5257786	Expectant	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
ec37362a-6be6-4b88-b895-5cec9c71bb71	Encouraged	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
14a1d076-2df1-42b4-ad9e-af2cb05c5db7	Optimistic	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
aa96d4ed-f41d-4ffb-9f4c-927ec05fec75	Confident	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
f037c064-a475-41ea-8ff0-1af3d631f221	Empowered	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
4362558f-b162-4187-90ef-f16f382e112e	Open	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
9f1c293b-c320-4786-9226-6f85d29cd5ec	Proud	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
c958c9d4-425e-4178-b6d1-7144d14ce848	Safe	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
7098ea69-0416-4426-ac71-2f377793a74c	Secure	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
66bd0629-24a3-4a00-9713-774b0aa4549f	Excited	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
5a6533eb-3c5b-49d7-860c-4e2f7e04c6da	Amazed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
0bcec0ee-7c7e-40f2-a726-1a09d2deed10	Animated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
01dcd44b-be03-4c35-a910-3005b0883cac	Ardent	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
d4c3a0a0-4842-4618-9997-25398b47819b	Aroused	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
76a5a017-6558-427d-b3fd-827a31156a6c	Astonished	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
28077ad2-9083-41dd-9b4b-c1aeaa971e65	Dazzled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
30be537d-95a3-4846-9e8f-d34033b334b3	Eager	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
14e573e9-cc1d-4464-af2a-f8a39257ec4b	Energetic	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
1bffa109-56df-41be-894d-c44f3e8adc12	Enthusiastic	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
e8255409-3b7c-4f5f-9ca4-84988918e24d	Giddy	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
212a6793-020c-4303-9d7f-715b3712bae3	Invigorated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
1f0b0ecf-a144-48ad-86e3-82178e70ab40	Lively	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
e3d45683-af3c-4aef-a295-83c1422ae8af	Passionate	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
54bc34f4-ed0c-4c8b-898b-71b0abf30644	Surprised	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
2c4182f3-290b-40a6-bcf3-6b74f9aa9745	Vibrant	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
885e77a7-8c5a-4d7b-b982-f6760e8279b1	Grateful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
448cef27-306c-4d9b-a995-16456d8746ea	Appreciative	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
1dccdc1f-167a-4698-87b8-3ae074012731	Moved	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
2397d6f4-c1cd-4cd6-a6ba-cbb372f7453e	Thankful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
7166d9a5-56e3-49a5-9abf-c7146c00b263	Touched	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
956420ef-1523-4ade-b35e-22eb61e37a22	Inspired	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
4835cc06-d672-476b-a499-bc635e1f9373	Awed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
dbf47e05-fb56-4ce5-93d3-c5bebd91481d	Wonder	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
4ed65484-40a3-417e-b2d8-ff62ccf12bf4	Joyful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
6a1dff8f-650e-4c02-b218-5ed9120774b8	Amused	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
d36297a9-b5a3-406b-910e-77a3462b7fe8	Delighted	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
3d69070f-6282-4dd0-b9f2-5404ee7be4f2	Glad	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
8ade248e-8a60-4425-8870-fdf680d388a3	Happy	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
175b92bd-88a9-4a1c-ae8a-0bb9397afd8f	Jubilant	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
b4856e3a-8917-4b13-bba8-9211ddd118e2	Pleased	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
276eaf12-fea8-4095-a404-6884874efd35	Tickled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
5a026f42-ac4f-4dd4-a885-c7d14dcdccca	Exhilarated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
0b5fc3a9-ff86-4e8d-bacb-94a47fbe15b8	Blissful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
72e76408-c353-4a76-ba53-7e9012aaf896	Ecstatic	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
590fca68-6651-458b-9c89-840c807e58f4	Elated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
274d2fc1-340b-438d-8e3e-bbaa1d97af45	Enthralled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
3b7d8f60-b340-4453-a74b-d4ae97b19664	Exuberant	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
b4d89eb5-5f08-4661-b9fd-73decd0c56cf	Radiant	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
24e8bd55-413c-454d-863e-a8b568908823	Rapturous	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
53eb2b16-d29c-4f59-b0f0-1983a105d77c	Thrilled	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
33b524ff-10d1-42f8-94dd-ac7574fe42cc	Peaceful	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
db3e48d4-2bbb-42a5-aa7d-d810f3675337	Calm	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
d0001d2b-df8b-4ddd-a551-17d5283bc3c9	Clear headed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
7ff1704a-6c3f-488c-bdc6-51bc06675c8a	Comfortable	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
e888f065-2b0d-40a4-a64e-343ae73b3fd2	Centered	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
905c9ffe-4c45-47ac-aa2f-02f3b29e2b75	Content	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
62eda6c8-40fc-4a8a-9d44-0182c4e819f4	Equanimous	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
378b84a9-c37d-47e8-b07b-7df305db72cc	Quiet	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
492b1378-0b7e-46a4-b423-02ca27ec40a4	Relaxed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
547f1f31-0664-4c5b-9c5b-0a0a81d84a46	Relieved	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
39be228d-a917-400b-b957-77846ba5188c	Satisfied	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
72870b2b-b245-4bce-8d64-77318e1da6e6	Serene	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
14a2022f-442f-4244-8200-b30ec300ce6b	Still	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
55ff385d-c586-488c-9824-ed3d43857711	Mellow	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
6baf1e79-2a52-4f2e-92d1-b8886debc645	Tranquil	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
52f567a6-b3e2-46b1-a159-f8f94f0f1e56	Trusting	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
ed9403fc-bb4a-4d07-9f68-1f6c165a9cfb	Refreshed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
4987de74-ed26-4849-95dc-d13a48247a19	Enlivened	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
e7a60a3a-c000-4f28-ac7a-359798b0a7c0	Rejuvenated	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
32395555-9270-4149-84d8-19dc5f24d70d	Renewed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
8a3a77a8-5e20-45cb-9e2f-9d0c38277a5b	Rested	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
880de677-41a9-4e30-93e2-e97ef8b948b9	Restored	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
44fb30c8-747c-43f8-8610-d08c26733015	Revived	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
fcb5c53b-5c4b-417e-9f20-469f188512e2	Absorbed	2019-02-13 19:00:33.126148+00	2019-02-13 19:00:33.126148+00	t
\.


--
-- Data for Name: journey_items; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.journey_items (id, journey_id, "position", item_type, item_id) FROM stdin;
\.


--
-- Data for Name: journeys; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.journeys (id, name, created_at, updated_at) FROM stdin;
5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	CEB.com	2019-02-08 20:22:58.473357+00	2019-02-08 20:22:58.473357+00
ab93131d-8ae0-414a-b9c4-b26060317919	Primary Law	2019-02-08 20:26:19.184161+00	2019-02-08 20:26:19.184161+00
11bd7553-7aaf-4b02-9469-b6697ae448e5	OnLaw	2019-02-08 20:29:03.100149+00	2019-02-08 20:29:03.100149+00
a9746b33-2862-4c95-b13a-80ddb4f79c04	Judicata	2019-02-08 20:29:11.601181+00	2019-02-08 20:29:11.601181+00
5feb9c91-7c0d-46ab-a06d-93698182611b	Westlaw	2019-02-08 20:29:18.287503+00	2019-02-08 20:29:18.287503+00
3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	CLE	2019-02-11 16:37:23.346881+00	2019-02-11 16:37:23.346881+00
df8cd2ba-749a-45bd-9af9-f480a1eb2745	AccessLaw	2019-02-12 20:08:04.722855+00	2019-02-12 20:08:04.722855+00
\.


--
-- Data for Name: observations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.observations (id, overall_sentiment, on_path, notes, started_at, ended_at, typing_started_at, task_id, feeling_id, session_journey_id, prompt_id, created_at, updated_at) FROM stdin;
c924deb1-5a8d-40b3-9bc4-4877f5754fa9	1	\N	Searches 'bus & prof code 17200	\N	\N	2018-07-26 12:06:34+00	00660377-776b-476f-988e-68cfea93c325	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:05:26.402343+00	2019-02-13 20:05:26.402343+00
9bea1bd0-8e2f-48c0-bd95-1745eac42962	1	\N	Takes the direct cite.	\N	\N	2018-07-26 12:04:18+00	40b5c601-837e-45a1-a555-a90104f38ea4	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
b0f3d136-605c-4128-b093-33a9236cc264	1	\N	Clicks the top link in ToC.	\N	\N	2018-07-26 12:02:28+00	7f48f143-ffeb-47a6-9b64-69adbc7f3650	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
fb33e914-ccf5-40ee-a5b0-b791f99fbce7	1	\N	Finds table of statutes instantly. 'Layout could be better so it's easier to find' - 'adding more columns, might be a good place for some collapsible things so I could zoom to a certain section.' 'if statutes and regs were separated, right now it's one huge vertical page.	\N	\N	2018-07-26 12:01:55+00	11cf09b7-40e0-4fe9-92dd-75396263cf8f	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
80892b2e-8e14-4bfa-bd34-1ed8ad32f9db	1	\N	Finds word icon instantly.	\N	\N	2018-07-26 11:58:46+00	23a5d534-db90-413b-8b24-38409a36bb44	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
f65b49d6-1210-483c-a2f7-05579c710603	1	\N	Usually forms are in the back/bottom, clicks table of forms.	\N	\N	2018-07-26 11:58:01+00	a343badc-e712-4970-af69-169f7bd0f9c1	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
c7a1f31f-d8fd-46de-9835-60232d43be58	1	\N	Pauses.	\N	\N	2018-07-26 11:55:33+00	399b707f-1113-4613-bc89-5c68435a3b4e	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
b31732e0-a87c-48bc-9676-e2a1f8c5e913	1	\N	PDF or Word download.	\N	\N	2018-07-26 11:45:08+00	47052949-9a9a-4654-8c55-d3e042967adc	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
14d10e87-ee82-4713-88cc-798febcee32b	1	\N	Bankruptcy - rules in a chapter 11 bankruptcy when the debtor needs to assume or reject a lease while in bankruptcy	\N	\N	2018-07-26 11:40:11+00	6b8d3f84-a445-4729-9ba4-85574b759cca	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
e4e9b043-de9a-40d6-8d98-70a562d4e9bf	1	\N	Clicks into real property.	\N	\N	2018-07-26 11:36:24+00	c3c1ac95-e90d-423d-b8fd-0fdfe4ac0107	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
c045a38c-f95c-4779-882f-3653d38bfa79	1	\N	When you click the title name [of chapter] you get the chapter outline, which is a little confusing	\N	\N	2018-07-26 11:35:45+00	2cbea9b1-f6cd-4575-bf24-e72a12b94db5	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
763475f4-111a-4b9b-a209-4a236ff5fab5	1	\N	Clicks TOC. it hides. Hrmph. Not what he expected.	\N	\N	2018-07-26 11:32:10+00	2bb5680d-f63a-4fd2-8d6e-996d0e239db2	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
0835263a-1924-4389-9624-21e148b2ad82	1	\N	I like the different colors that shows what publication it's from - it's just alternating (slightly disappointed)	\N	\N	2018-07-26 11:30:20+00	ea207a89-8e2a-44e8-8485-85123e2d7ad2	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
b84670ec-37a5-479e-b675-5822898d5dc3	1	\N	Just the publications listed on the left	\N	\N	2018-07-26 11:28:06+00	e643c1df-4c8d-4194-9e1d-8564ef01593d	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
279a0477-3f38-49e1-896a-f2305b6d42a1	1	\N	Can drill down and view chapters or sections of practice guides	\N	\N	2018-07-26 11:26:55+00	31a4d089-b234-49c8-b984-cd27492f73a0	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
15c557bd-aa28-4715-9f0e-4a6dfa8c7f95	1	\N	Clicks on 'digital	\N	\N	2018-07-26 11:22:45+00	392a9cb5-1201-4afa-b9d6-0a7218488123	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
8af60fa6-792b-49b3-9695-d1844087e5d1	1	\N	It doesn't break it up to practice areas, but it shows you general requirements and special requirements' - wants color highlights to show how far he has to go and current status.	\N	\N	2018-07-25 12:11:09+00	ed63d689-0dc6-4de6-8988-79fc970001d6	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
33503095-711a-4221-a3be-507ae8d9ff5d	1	\N	Clicks MCLE summary. Sees the MCLE certificate on the right side.	\N	\N	2018-07-25 12:09:24+00	83b68000-aed6-4903-82ef-2a7a7a498d39	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
833d284f-b7c9-4211-b843-b8fd705ff926	1	\N	Find the materials.	\N	\N	2018-07-25 12:08:35+00	57804c11-9538-45a9-8fe1-c7e7acb965b5	28077ad2-9083-41dd-9b4b-c1aeaa971e65	55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	\N	2019-02-13 20:08:15.040337+00	2019-02-13 20:08:15.040337+00
56e8979d-a4d2-40b9-8718-fbfe1b5b5614	1	\N	Find the materials.	\N	\N	2018-07-25 12:08:35+00	79b0f802-f6d0-4947-b98d-7c92f4aa222a	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
69a6f13d-1296-444e-a57d-508e40b13fb9	1	\N	Fine with audio only, but isn't interested in doing CLE on the go. He likes the self study because they 'force you to pay attention and learn' - 'Making it more mobile friendly, I just don't, I think people need to sit down and give it the actual attention it needs	\N	\N	2018-07-25 12:07:28+00	7a118043-b838-433d-ad47-529ab4110b4c	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
77d459d1-1dc9-4085-974e-dd30cdbeaa13	1	\N	doesn't look like it's downloadable, so I'd have to copy and paste it	\N	\N	2018-07-25 12:02:54+00	11a66103-f151-42b5-b502-ce98cd34a0ae	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
326026a0-fb65-416f-a63a-1de5d6bd1983	1	\N	Evaluation tab - clicks survey, 20 second wait.	\N	\N	2018-07-25 12:01:40+00	bdacbb03-9976-4a7f-99ff-b62982600707	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
f4fe5d1f-9a55-4447-8850-539df04cd0eb	1	\N	This segment is almost 22 minutes and if I go to the summary I'd have to add them up' - 80 minutes or so.	\N	\N	2018-07-25 12:00:15+00	7743ee8e-dc63-4cfa-9e12-f6df5223ba77	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
51d92fb0-947e-4513-830d-3eed228c2ec7	1	\N	Does down to tab for materials. Clicks materials. Gets to page, reads the instructions. 'Oh, I'm not sure which one I would downloads... probably all three... I don't know	\N	\N	2018-07-25 11:59:25+00	4ad61aec-85f4-48cb-a46a-f146e8bc6dd5	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
0d9c3510-6d4d-46d6-bb17-a08aea695b32	1	\N	Asked specifically about the video. 'Heggstad petitions, class about it, thought it was really good. Guy sitting at a desk in front of drapes. Actual video was really pretty boring, whether it's the verbal content or video, 90% verbal content 10% video. I spent much more time looking at the documents he was referencing	\N	\N	2018-07-25 11:56:15+00	b86c6e13-63cc-4533-b0ac-08c3a144b6ce	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
0da33143-1175-47b6-b041-b478150965d8	1	\N	Clicks MyCEB. CLE Programs. Yeah, it's right there.	\N	\N	2018-07-25 11:54:03+00	47406669-a0b6-49e7-a325-2a4fe13d0ff5	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
c2c15ea1-1c40-4234-938f-60d200ea376a	1	\N	Knows about left side filters, also finds compliance packages on CLE home page, clicks compliance packages. 'I think it's kind of hard to find that	\N	\N	2018-07-25 11:53:23+00	8e77cef3-e378-43f5-b556-f05a45546f09	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
85a2906a-e5e2-4926-af33-2582447eb024	1	\N	Navigates to CLE programs, then finds compliance packages. Doesn't click it, then Special CLE requirements. Clicks that.	\N	\N	2018-07-25 11:50:10+00	7a03d791-8012-4d6c-bb7f-a893e6b19a3c	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
edb21b9c-f3a6-4c7b-b735-9cbc80abd5be	1	\N	Accidentally hits continue shopping	\N	\N	2018-07-25 11:47:59+00	772dcb9a-7498-4142-bcd4-a408c9aafa8a	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
cd9869e0-f288-4859-9a7d-9a8121c41313	1	\N	It's showing me and on demand class on the top 20 significant cases + legislative changes in 2017, $99 if I don't have the passport	\N	\N	2018-07-25 11:44:05+00	d4f1dd61-d37e-4e98-a09a-8b22b2a96c55	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
753d7437-c35c-4f04-8432-3faef2107c72	1	\N	Expected to be able to enter a topic (subsearch)	\N	\N	2018-07-25 11:41:32+00	9bb39a6b-9605-47c6-b40b-59fc2786f945	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
0490593a-e090-4c2b-8002-6e1113285649	1	\N	Hesitates a bit at the question, then goes to CEB.com, then clicks CLE programs nav, scrolls on the CLE programs page, clicks 'On Demand' and sees product listing.	\N	\N	2018-07-25 11:34:56+00	26d1a530-452e-4b3e-8136-1fb620bed360	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
79c7e053-bc13-4b25-8bed-6fd442176990	1	\N	Says 'all of them' then 'oh, zero' 'I do not have a CLE membership	\N	\N	2018-07-25 11:33:15+00	e67d1509-2aa3-487e-9974-66bf0dd9045b	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
59316145-a0e5-46ce-91d6-ae25d3a94652	1	\N	types ceb.com	\N	\N	2018-07-25 11:28:39+00	70564bd1-df24-4abe-afc4-e4adbc3228cd	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
64b8bc73-59f1-4080-a39d-e269f2458567	1	\N	Clears the search, clicks search in nav, searches for '17200' in all of these words.	\N	\N	2018-07-25 11:24:37+00	cd0bdc67-a4f9-4d2e-bd44-c3533233b123	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
8c70df4a-4507-4b8b-9f45-878c88fd2eee	1	\N	Does a search, gets results successfully.	\N	\N	2018-07-25 11:23:53+00	08420cff-b795-4969-a879-220ccae8eefd	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
dfc474f7-a1b3-4cdc-8197-1cf79612bff8	1	\N	Makes the 'ergh' face, then 'I guess I'd hit available publications' (which is correct).	\N	\N	2018-07-25 11:22:53+00	5a9c47fc-5deb-4f13-9d85-7ce62dd60c86	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
7ee5810e-2968-4902-93b0-b7ed011e12ca	1	\N	Knows to look at the bottom.	\N	\N	2018-07-25 11:21:54+00	d748d075-76aa-4068-80c3-43240a49bf38	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
fe4d13ef-3382-4d6c-8b32-798d8c7426e4	1	\N	Finds a word form instantly.	\N	\N	2018-07-25 11:19:50+00	d4c8bbf4-23f9-4456-ba68-8f8e5cd925ef	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
66fafd42-4b83-4395-b39e-58e82185f0af	1	\N	I'd just go to the index (index of forms, he already knows)	\N	\N	2018-07-25 11:17:44+00	a64bc22b-8882-4094-a9c0-d52d5b60293b	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
1ec23059-60f6-4123-941a-0c083fc83c8d	1	\N	Goes to the case view. 'This is not readable. This is not a readable format. It's just not... it's like a notepad document.	\N	\N	2018-07-25 11:13:50+00	0703f52f-68ec-4687-a74a-c5ce5be4a971	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
93b18d69-7d74-4687-a345-45275add2d96	1	\N	Should be able to download a chapter as a PDF or Word Document.	\N	\N	2018-07-25 11:09:51+00	4cfffff6-6316-4656-951e-92623c54b030	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
a7b88f44-b1f0-4d83-82ca-f145737320a2	1	\N	I don't mind the highlights, I like that, it doesn't bother me. I've never used highlights or Add bookmarks	\N	\N	2018-07-25 11:06:27+00	aac8ec72-0cfc-40df-b84c-685c2395f041	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
5a03d94c-52c2-405a-a67f-4344532fd137	1	\N	Direct prompt to search for unlawful detainer - his results aren't what he expected. He'd want a chapter outline vs 500 references to Eviction defense manual.	\N	\N	2018-07-25 10:59:32+00	e46b8b1a-8415-44f0-b772-76e37eec945c	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
7f983f1c-1647-4251-96eb-76e9c23b6513	1	\N	He doesn't think there's material in OnLaw related to forgery.	\N	\N	2018-07-25 10:53:14+00	e9cc05d7-7f09-420b-9bc2-8df6a58d5051	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
14e57656-8429-461b-9f05-3b2f15a369ae	1	\N	I'm not even really sure what's going on here' referring to the Table of Contents on the left	\N	\N	2018-07-25 10:48:12+00	2d089368-af44-4cbb-920b-a25975f12a6b	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
da474603-ff2b-4517-bb8c-22ff3f1a32be	1	\N	Looks like the whole library	\N	\N	2018-07-25 10:45:45+00	740d3048-a354-4bac-9a26-f955e2032789	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
74c680a1-b662-4e6a-a9d6-e4260cb8b2a5	1	\N	Goes to MyCEB, clicks on OnLaw.	\N	\N	2018-07-25 10:35:22+00	76a2ea12-f7b4-4f59-9399-044f48bcc701	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
251d07fd-9653-4708-8e36-2e0b49f3b160	1	\N	Clicks CLE passport usage. 'Looks like if you go back to this thing CLE passport usage, it seems to indicate which ones are finished, don't know if it keeps a running total on each one.	\N	\N	2018-07-20 15:32:29+00	c500f809-f028-4721-befe-b7099e9d2166	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
9c463ee0-06ec-40c7-bef5-db738ca3f0cc	1	\N	Finds 'MCLE certificate' Clicks one.	\N	\N	2018-07-20 15:30:24+00	b779897f-fda5-4ced-91d2-41a880de21b6	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
8b8c5adf-b0af-4883-87a7-92734b957355	1	\N	Find materials - sees that it's available as a PDF.	\N	\N	2018-07-20 15:29:52+00	58663f00-6446-48ad-8022-3e85d18c8b29	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
2c96e827-ca6c-4144-a780-88eb8ab57178	1	\N	Uses back button repeatedly.	\N	\N	2018-07-20 15:28:58+00	9b1df9b0-3863-49ae-9c3c-26e3e114180c	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
49dfd7c1-1c20-4484-9aa5-9addd9af5e7d	1	\N	Finds transcript. 'Wow'  'Who on earth would want to read this transcript. The text is just rather small	\N	\N	2018-07-20 15:27:48+00	5e707851-ed21-4c48-a123-a548abe60344	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
a36e0422-a179-46f4-91b8-b945d7c28049	1	\N	Scrolls up, scrolls down, finds 'evaluation' clicks survey.	\N	\N	2018-07-20 15:26:26+00	9c109436-77f4-4dc0-ac78-a3bda49befcb	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
4d7a869b-c3ed-4204-be7a-c0f650c70d76	1	\N	Looks like uh 68:26 - does the math.' Saw the runtime in the player and knew it was wrong, used segments.	\N	\N	2018-07-20 15:25:42+00	9c83b812-9ddb-4dbd-9ea0-ab3b027085b2	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
86fb117b-b80f-44c1-b58d-78aa6ac7f11c	1	\N	Finds speakers:	\N	\N	2018-07-20 15:24:16+00	0780db0e-e3a6-43ee-acb6-7554b5f9059a	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
5fbd27ae-eeec-4020-8daf-2e9293804697	1	\N	Finds the PDF icon in the bottom right of the presentation display. Then uses the normal browser save features.	\N	\N	2018-07-20 15:23:29+00	eabfa12e-0063-4203-9720-18ae0ab4eb4e	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
f1c1dd63-5576-4c68-af04-6ea4724904a4	1	\N	Finds enable CC instantly.	\N	\N	2018-07-20 15:22:52+00	d1d9d484-63ce-47e7-aa90-2370812e6383	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
cbb858c7-62b6-4817-adba-53a36edb193a	1	\N	Correctly assumes the content should be on CLE Programs. It isn't	\N	\N	2018-07-20 15:21:26+00	ce1138ed-0cda-48e7-947f-22691c60586b	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
7239dfca-a02e-47ba-be38-99e17f9b1f19	1	\N	Finds specialist prep courses.	\N	\N	2018-07-20 15:20:29+00	5ac799a8-5e78-4b0f-bd2c-ce10c7a0ef7b	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
c7b83a2f-eca0-4ea3-9043-c79f3c59f120	1	\N	Goes to CLE Programs, clicks MCLE summary, clicks access services, clicks CLE Programs, leans forward and looks at the CLE program list. Clicks access services clicks CLE programs, scrolls and looks at the list of items. New tab. Ceb.com.	\N	\N	2018-07-20 15:19:08+00	de984d7b-1104-4909-9da5-bca29c4c1258	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
68cd9b37-c545-4a76-ba4b-6d5447ddc579	1	\N	seems straightforward. presumably there's checkout somewhere	\N	\N	2018-07-20 15:15:31+00	796b74f1-7e8f-455e-b83e-57e242f337bf	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
4953201f-f27b-42a5-8d8b-50f129966462	1	\N	You either find the link or you don't, and if you don't find it then it's going to take you a little bit' 'I don't know if it could be done differently	\N	\N	2018-07-20 15:14:18+00	0bb0db06-1fde-4431-8a89-e09538156673	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
0417eebe-c05e-4bb9-81f4-ef38dafc8a2f	1	\N	Understands that it is $0 because of the scription	\N	\N	2018-07-20 15:12:22+00	c93e998d-e7ee-414c-8350-fe419990acfa	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
7839f59c-78d5-4a62-b234-0a61cfd08519	1	\N	Asked about CLE content on competence. Clicks access services, clicks CLE programs again and is returned to same page.	\N	\N	2018-07-20 15:07:48+00	81020eb2-7f1b-4e56-a1a7-620a034e118a	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
945c66c8-ecb5-40fd-b752-ee724f46a67d	1	\N	Clicks 'my account	\N	\N	2018-07-20 15:06:31+00	2e818181-137a-4776-b81e-4e053e399baf	060d00e2-701c-4771-b321-2e911ee8d750	f831dc90-4763-4946-8a01-b46866e5c142	\N	2019-02-14 15:17:40.341359+00	2019-02-14 15:17:40.341359+00
\.


--
-- Data for Name: participants; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.participants (id, name, alias, notes, created_at, updated_at, uid, informed_consent, do_not_invite) FROM stdin;
9229d731-386d-4117-9c6a-3d3fb8479ae7	Stephanie Walker	poboh	\N	2019-02-08 19:52:17.516518+00	2019-02-08 19:52:17.516518+00	3ed7f7da	\N	\N
ad1ce8bb-2e60-459d-bfb9-3e7d57c52e6a	Justin Hedemark	mitif	Customer T&E Library + 1 CLE	2019-02-08 19:53:04.648687+00	2019-02-08 19:53:04.648687+00	e1a34a40	\N	\N
ee4accee-5894-4787-ab78-3602fed7f70e	Nancy S. Brandt	toronu	Customer -  OnLAW - Crim Library	2019-02-08 19:53:54.917937+00	2019-02-08 19:53:54.917937+00	6c6a40b4	\N	\N
c7e63299-a3c0-433d-9ea4-f9325004caf0	Jason Galek		Customer - 2 OnLAW T&E Titles + some programs	2019-02-08 19:54:26.674551+00	2019-02-08 19:54:26.674551+00	5e07a0d9	\N	\N
cb11138a-90f8-4d5b-8459-b8d184ee8d52	Moustafa Harfoush	gejy	Non-Customer	2019-02-08 19:55:04.31673+00	2019-02-08 19:55:04.31673+00	baa03e26	\N	\N
6718a4c8-08b0-423d-80a0-1cc557118f33	Eduard Meleshinsky	hito	Non-Customer - 1 CLE in 2015 - nothing current	2019-02-08 19:55:41.190206+00	2019-02-08 19:55:41.190206+00	78062de2	\N	\N
7e8275fd-a146-44da-b92f-d53bd969e50f	William Doyle	niliw	Customer - OnLAW - 1 title civil writs	2019-02-08 20:08:08.484397+00	2019-02-08 20:08:08.484397+00	a143648e	\N	\N
aac38cae-c365-4af4-8b4a-318fa16fdb5c	Rosanne Mah	meho	Customer - Former CLE user - taking a break from practicing law since she recently had a baby	2019-02-08 20:10:23.5018+00	2019-02-08 20:10:23.5018+00	ef0c473e	\N	\N
0da60508-9760-4e68-af66-6029b66de2e4	Kathleen Hunt	gam	Customer - T&E print books, no online	2019-02-08 20:11:05.821515+00	2019-02-08 20:11:05.821515+00	fe264d45	\N	\N
38d838e5-4063-40a7-923d-464a13199f76	Grace Koss	hargeli	Customer - CLE Passport power user	2019-02-08 20:12:57.552134+00	2019-02-08 20:12:57.552134+00	75e896e3	\N	\N
17ffe806-7784-4658-a070-40ab29c63a30	Amanda Gordon	denevel	Customer - OnLAW Fam Library	2019-02-08 20:13:36.553031+00	2019-02-08 20:13:36.553031+00	d6bccb01	\N	\N
bcb40d95-e8c3-4680-b3ac-ecff0cebd857	Sally Bergman	wisoto	Customer - 1 CLE in 2015 - nothing current	2019-02-08 20:14:05.084+00	2019-02-08 20:14:05.084+00	5903d767	\N	\N
cb9b3667-c6c5-48de-88fb-cca704af40b3	Jill Bates-Moore	jed	Customer - Current CLE - only EPIC	2019-02-08 20:17:48.257097+00	2019-02-08 20:17:48.257097+00	da87860d	\N	\N
a242e64b-2155-46ee-81c5-2b7968bd659d	Andrew Lurie	zek	Non-Customer	2019-02-08 20:18:10.438016+00	2019-02-08 20:18:10.438016+00	fd66808d	\N	\N
c643216c-f410-42ed-8478-2b74d2b2acc3	Andrew Kapur	fetup	Customer -  Nothing currently	2019-02-08 20:18:43.058304+00	2019-02-08 20:18:43.058304+00	7bc4f561	\N	\N
78560694-309f-437f-a8db-edd8805cc696	John Secrest Richards	supona	Customer - OnLAW Libraries (bus & real prop)	2019-02-08 20:19:42.559042+00	2019-02-08 20:19:42.559042+00	5feedbf2	\N	\N
7e8e648a-bd1d-4646-bfc7-dc1dbdd3a6f7	Eugene Park	werij	Non-Customer	2019-02-08 20:20:13.165882+00	2019-02-08 20:20:13.165882+00	0fc0966c	\N	\N
\.


--
-- Data for Name: projects; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.projects (id, name, created_at, updated_at) FROM stdin;
1ef12ca9-75b5-4821-9ea9-664340f235bb	CEB: UX Testing	2019-02-08 19:07:07.588741+00	2019-02-08 19:07:07.588741+00
\.


--
-- Data for Name: prompts; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.prompts (id, content, "position", task_id, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: questions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.questions (id, content) FROM stdin;
\.


--
-- Data for Name: ratings; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.ratings (id, notes, started_at, ended_at, task_id, session_journey_id, scale, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: session_groups; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.session_groups (id, name, description, project_id, created_at, updated_at) FROM stdin;
2d3f321c-792c-436d-9596-41732bb51c5d	Benchmark	\N	1ef12ca9-75b5-4821-9ea9-664340f235bb	2019-02-11 20:11:26.974865+00	2019-02-11 20:11:26.974865+00
40007b9b-7a25-4e74-9a6e-250536a02c20	Prototype	\N	1ef12ca9-75b5-4821-9ea9-664340f235bb	2019-02-11 20:11:37.034772+00	2019-02-11 20:11:37.034772+00
\.


--
-- Data for Name: session_journeys; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.session_journeys (id, started_at, ended_at, "position", journey_id, session_id, created_at, updated_at, sus_scores) FROM stdin;
7ba79744-1f3e-4b87-a7f2-4ab20e36321f	2019-02-12 18:23:11+00	2019-02-12 18:43:11+00	0	df8cd2ba-749a-45bd-9af9-f480a1eb2745	a44dc882-c0ec-4f31-8e5c-2cc5174e5fa5	2019-02-12 21:08:43.599254+00	2019-02-12 21:08:43.599254+00	\N
55a08bcf-2c55-4342-94ae-7bda5cc8e1ac	2019-02-12 18:43:11+00	2019-02-12 19:23:11+00	0	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	a44dc882-c0ec-4f31-8e5c-2cc5174e5fa5	2019-02-12 21:08:43.599254+00	2019-02-12 21:08:43.599254+00	\N
282fad94-1ec3-460e-8af7-b21c043c2347	2019-02-12 19:23:11+00	2019-02-12 20:23:11+00	0	5feb9c91-7c0d-46ab-a06d-93698182611b	a44dc882-c0ec-4f31-8e5c-2cc5174e5fa5	2019-02-12 21:08:43.599254+00	2019-02-12 21:08:43.599254+00	\N
ff405c41-910f-457a-b940-1ddeccae2660	2019-02-12 16:23:11+00	2019-02-12 17:23:11+00	0	5feb9c91-7c0d-46ab-a06d-93698182611b	5f9cdc7b-aac1-4fd6-ac95-31ebe91b4a7b	2019-02-12 21:08:43.599254+00	2019-02-12 21:08:43.599254+00	\N
f831dc90-4763-4946-8a01-b46866e5c142	2019-02-12 17:23:11+00	2019-02-12 17:43:11+00	0	ab93131d-8ae0-414a-b9c4-b26060317919	5f9cdc7b-aac1-4fd6-ac95-31ebe91b4a7b	2019-02-12 21:08:43.599254+00	2019-02-12 21:08:43.599254+00	\N
de023a5a-2b77-4633-b51d-b470dbcf0faf	2019-02-12 17:43:11+00	2019-02-12 18:23:11+00	0	a9746b33-2862-4c95-b13a-80ddb4f79c04	5f9cdc7b-aac1-4fd6-ac95-31ebe91b4a7b	2019-02-12 21:08:43.599254+00	2019-02-12 21:08:43.599254+00	\N
\.


--
-- Data for Name: sessions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sessions (id, name, started_at, ended_at, session_group_id, participant_id, created_at, updated_at, location) FROM stdin;
a44dc882-c0ec-4f31-8e5c-2cc5174e5fa5	Round1	2019-02-12 18:23:11+00	2019-02-12 20:23:11+00	2d3f321c-792c-436d-9596-41732bb51c5d	ad1ce8bb-2e60-459d-bfb9-3e7d57c52e6a	2019-02-12 18:45:09.977438+00	2019-02-12 18:45:09.977438+00	\N
5f9cdc7b-aac1-4fd6-ac95-31ebe91b4a7b	Round2	2019-02-12 16:23:11+00	2019-02-12 18:23:11+00	2d3f321c-792c-436d-9596-41732bb51c5d	ee4accee-5894-4787-ab78-3602fed7f70e	2019-02-12 18:45:09.977438+00	2019-02-12 18:45:09.977438+00	\N
\.


--
-- Data for Name: tasks; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tasks (id, content, journey_id, created_at, updated_at, "position") FROM stdin;
00660377-776b-476f-988e-68cfea93c325	Can you please sign in to your account with CEB?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	0
40b5c601-837e-45a1-a555-a90104f38ea4	Let’s say you weren’t able to login and needed to gain access to your account, how would you do that?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	1
7f48f143-ffeb-47a6-9b64-69adbc7f3650	Can you please create a new account on CEB.com?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	2
11cf09b7-40e0-4fe9-92dd-75396263cf8f	What is CEB?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	3
23a5d534-db90-413b-8b24-38409a36bb44	What does CEB offer?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	4
a343badc-e712-4970-af69-169f7bd0f9c1	(We know their Practice Areas). Do you use CEB materials for reference? (If yes) Can you show me a couple of the reference items you use? (If no) Can you find CEB materials that you think would be relevant to your practice?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	5
399b707f-1113-4613-bc89-5c68435a3b4e	If you needed to get in touch with CEB, how would you do that?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	6
47052949-9a9a-4654-8c55-d3e042967adc	Let’s say your address has changed, and you need to update it on CEB.com. Can you show me how you would do that?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	7
6b8d3f84-a445-4729-9ba4-85574b759cca	How would you find printed material on \nHandling Unlawful Detainers?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	8
c3c1ac95-e90d-423d-b8fd-0fdfe4ac0107	Can you describe this product? What options are there?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	9
2cbea9b1-f6cd-4575-bf24-e72a12b94db5	(Not logged in) If you wanted to purchase this product, can you show me how you would do that?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	10
2bb5680d-f63a-4fd2-8d6e-996d0e239db2	(Logged in) If you wanted to purchase this product, can you show me how you would do that?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	11
ea207a89-8e2a-44e8-8485-85123e2d7ad2	Let's say you received this invoice (hand them a paper invoice) and wanted to pay it online. Can you show me how you would do that?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	12
e643c1df-4c8d-4194-9e1d-8564ef01593d	Let's say you wanted to provide feedback on the website to CEB. How would you do that?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	13
31a4d089-b234-49c8-b984-cd27492f73a0	If you wanted to read CEB tips for your practice and other short legal guidance material that's published on a regular basis, where would you look? (Blog or Assist to target to Blog)	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	14
392a9cb5-1201-4afa-b9d6-0a7218488123	Can you find a post about Reviewing an Estate Plan?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	15
ed63d689-0dc6-4de6-8988-79fc970001d6	If you wanted to view posts relavant to your area of practice, how would you do that?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	16
83b68000-aed6-4903-82ef-2a7a7a498d39	Have you heard of the new Labor Code section 925? If you wanted to read CEB's short summary of the implications of the change to that part of California Law, what would you do?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	17
57804c11-9538-45a9-8fe1-c7e7acb965b5	Let's say you were still a Law Student — I'm sorry for bringing this up — can you find content that is specific to Law Students on this site?	5d2605fb-7e2d-4bba-a60b-0feaa21e29d7	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	18
79b0f802-f6d0-4947-b98d-7c92f4aa222a	Let's say you wanted to read a simple distillation of recent case law that is relevant to your practice. Can you show me how you would do that with this product? If you could filter these items by practice area, would that be useful? Would you like to receive that information by email on a weekly basis, for example?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	0
7a118043-b838-433d-ad47-529ab4110b4c	If you wanted to check the negative history of a case, how would you do that? (If they don't have one in mind, use Miller v. Filter 2007, 150 Cal.App.4th 652)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	1
11a66103-f151-42b5-b502-ce98cd34a0ae	Do you think this product allows you to find pinpoint citations? Can you show me how you would make a pinpoint citation using this tool?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	2
bdacbb03-9976-4a7f-99ff-b62982600707	Can you please find a 9th Circuit Ct. of Appeals case about trademark infringement? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	3
7743ee8e-dc63-4cfa-9e12-f6df5223ba77	If you needed to find a California Supreme Court case that discusses search and seizure, how would you do that? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	4
4ad61aec-85f4-48cb-a46a-f146e8bc6dd5	How would you find california case law discussing making modifications to an irrevocable trust? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	5
b86c6e13-63cc-4533-b0ac-08c3a144b6ce	If you needed to look up california case law that discusses renegotiating a commercial lease agreement, how would you do that? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	6
47406669-a0b6-49e7-a325-2a4fe13d0ff5	Can you please find a case that outlines the standard of review for a summary judgment motion in California? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	7
8e77cef3-e378-43f5-b556-f05a45546f09	How would you find a case that outlines the standard of review for a motion to suppress (§ 1538.5 motion)? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	8
7a03d791-8012-4d6c-bb7f-a893e6b19a3c	How would you look up a California code section discussing the admissibility of business records?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	9
772dcb9a-7498-4142-bcd4-a408c9aafa8a	Where would you find a california code section discussing the admissibility of a dying declaration? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	10
d4f1dd61-d37e-4e98-a09a-8b22b2a96c55	Let's say you were structuring a trust, and needed to read a California Code section discussing the termination of a conservatorship. How would you find that information? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	11
9bb39a6b-9605-47c6-b40b-59fc2786f945	Let's say you were working with a client to dissolve a business, and wanted to look up a California Code section about the dissolution of a limited liability company. Where would you go to do that? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	12
26d1a530-452e-4b3e-8136-1fb620bed360	Where would you look for Business and Professions Code §17200 that pertains to unfair competition? Can you find the next code section in the chapter? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	13
e67d1509-2aa3-487e-9974-66bf0dd9045b	Let's say you needed to look up 23152(a) in the Vehicle Code for drunk driving - how would you do that? Can you find the next code section in the chapter? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	14
70564bd1-df24-4abe-afc4-e4adbc3228cd	Let's say you need to read Probate Code § 15403 about changing an irrevocable trust. Where would you find that information? Can you find the next code section in the chapter? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	15
cd0bdc67-a4f9-4d2e-bd44-c3533233b123	If you needed to find Corporations Code § 1201(a) that discusses the approval of a merger, how would you do that? Can you find the next code section in the chapter? (AccessLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	16
08420cff-b795-4969-a879-220ccae8eefd	If you wanted to navigate to the chapter that contains this code, how would you do that?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	17
5a9c47fc-5deb-4f13-9d85-7ce62dd60c86	If you needed to view the table of contents for the Business and Professions Code, how would you do that with this product?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	18
d748d075-76aa-4068-80c3-43240a49bf38	Can you show me how you use WestLaw?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	19
d4c8bbf4-23f9-4456-ba68-8f8e5cd925ef	Can you show me how you select Jurisdictions for searches? (WestLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	20
a64bc22b-8882-4094-a9c0-d52d5b60293b	How do you use the fact that you are signing in under a specific client? Is that helpful or unhelpful? Does this do what you expect? How do you use that in your practice?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	21
0703f52f-68ec-4687-a74a-c5ce5be4a971	Do you use folders?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	22
4cfffff6-6316-4656-951e-92623c54b030	How often do you set a Case Alert?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	23
aac8ec72-0cfc-40df-b84c-685c2395f041	Do you use History? (WestLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	24
e46b8b1a-8415-44f0-b772-76e37eec945c	Can you please find a 9th Circuit Ct. of Appeals case about trademark infringement? (WestLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	25
e9cc05d7-7f09-420b-9bc2-8df6a58d5051	How would you find california case law discussing making modifications to an irrevocable trust? (WestLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	26
2d089368-af44-4cbb-920b-a25975f12a6b	If you needed to look up california case law that discusses renegotiating a commercial lease agreement, how would you do that? (WestLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	27
740d3048-a354-4bac-9a26-f955e2032789	How do you share useful items you find with others? (Pincites, cases, etc.) (WestLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	28
76a2ea12-f7b4-4f59-9399-044f48bcc701	How do you obtain citations from this tool? (WestLaw)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	29
c500f809-f028-4721-befe-b7099e9d2166	Can you show me how you use Judicata?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	30
b779897f-fda5-4ced-91d2-41a880de21b6	Can you show me how you select Jurisdictions for searches? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	31
58663f00-6446-48ad-8022-3e85d18c8b29	Do you use History? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	32
9b1df9b0-3863-49ae-9c3c-26e3e114180c	Can you please find a California case about trademark infringement? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	33
5e707851-ed21-4c48-a123-a548abe60344	How would you find california case law discussing making modifications to an irrevocable trust? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	34
9c109436-77f4-4dc0-ac78-a3bda49befcb	If you needed to look up california case law that discusses renegotiating a commercial lease agreement, how would you do that? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	35
9c83b812-9ddb-4dbd-9ea0-ab3b027085b2	What do these search results tell you about case status?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	36
0780db0e-e3a6-43ee-acb6-7554b5f9059a	For one of the cases in these search results, can you tell me how many cases cite to that case, and if the case was distinguished?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	37
eabfa12e-0063-4203-9720-18ae0ab4eb4e	How would you narrow these results?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	38
d1d9d484-63ce-47e7-aa90-2370812e6383	What can you do with the options in the left column? Can you tell me which would be useful to you, and which you don't care about? What order would you like the useful items to appear in?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	39
ce1138ed-0cda-48e7-947f-22691c60586b	Where would you look for Business and Professions Code §17200 that pertains to unfair competition? Can you find the next code section in the chapter? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	40
5ac799a8-5e78-4b0f-bd2c-ce10c7a0ef7b	Let's say you needed to look up 23152(a) in the Vehicle Code for drunk driving - how would you do that? Can you find the next code section in the chapter? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	41
de984d7b-1104-4909-9da5-bca29c4c1258	Let's say you need to read Probate Code § 15403 about changing an irrevocable trust. Where would you find that information? Can you find the next code section in the chapter? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	42
796b74f1-7e8f-455e-b83e-57e242f337bf	If you needed to find Corporations Code § 1201(a) that discusses the approval of a merger, how would you do that? Can you find the next code section in the chapter? (Judicata)	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	43
0bb0db06-1fde-4431-8a89-e09538156673	Please search for a case called 'aguilar vs. atlantic'. Please click the case title.	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	44
c93e998d-e7ee-414c-8350-fe419990acfa	Do you think this case view allows you to easily find the cases that Aguilar is citing favorably or unfavorably?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	45
81020eb2-7f1b-4e56-a1a7-620a034e118a	(If man) Are you colorblind?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	46
2e818181-137a-4776-b81e-4e053e399baf	(Once Color is enabled). What do you think these color highlights mean? Can you find a case that Aguilar is citing favorably?	ab93131d-8ae0-414a-b9c4-b26060317919	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	47
b5c12616-3d98-4113-9c29-7d98a438b3be	Can you show me how you use OnLaw?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	0
25794601-519e-4781-a91c-f8d13abaf772	What do you think you can do with this tool (once on landing page)	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	1
f44bc4cd-6de5-4ec4-8462-e791101cada4	What content do you have access to?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	2
1a5a2032-2aa3-443d-8c19-2d80fde21e9a	Can you please find section 9.4.1 of the publication "California Will Drafting"? From this table of contents on the left, can you describe the structure of the Chapter on Revocation?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	3
5b3d2c5e-52d4-4384-afd5-bf665a111baa	Can you navigate to the chapter that contains this subsection?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	4
106725b8-a017-4ee4-b494-d6fa7e2d0fbe	Do you have a recent matter you handled in mind that we could use for the purposes of this testing?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	5
09ebc000-e3e2-4c42-a284-f0dca053ec80	Can you please find materials that are relevant to that recent client matter?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	6
de690abd-2299-4ea5-a5ad-a08e9e97ccee	How would you find OnLaw titles about an "unlawful detainer"? (Would you like to be able to retain these search results in your OnLaw account?)	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	7
063ffa22-454e-49e0-9582-c5b064d7b9ec	How would you narrow these results? (Search within these results)	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	8
4efcf0c3-c6dd-42aa-b07d-243ec1c2e0da	(On Search result document) How would you turn off these colors? (Referring to the highlights)	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	9
2caae5a1-42a0-441b-8ec1-93490e6cef55	If you needed to share or keep this content, how would you do that? (Discuss: Print, Email, Download)	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	10
eca07201-09c5-414c-9187-9079fd808a09	How would you cite this content if you wanted to include in a brief or a memo?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	11
f50df78e-a7e5-4afd-b8f4-9fa7daf1dba1	Let's say you wanted to keep a reference to this item in OnLaw so you could easily find it again. Can you show me how you would do that? (Bookmarks)	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	12
8ef4e78d-214f-4131-a1d9-b2e99e76d364	Where would you look for a list of forms referenced by this title?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	13
6981f222-a184-472e-8e30-4c6165811a77	Can you please select a form you think would be relevant, and download a copy of that form in a format that you can edit?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	14
bfdfdf16-86f4-4a38-b849-4d20bd1987d4	What if you needed to find a list of the statutes referenced by this title? Can you show me how you would do that?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	15
a5b5db56-3b19-40ba-a8b7-6167a67f2e01	How would you get back to the OnLaw home page, or again see the list of titles you have access to in OnLaw? (Clear search)	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	16
862cf714-5287-4cac-b3ba-59973f1c1187	Can you find all references to Aguilar vs. Atlantic Richfield 25 C4th 826 in OnLaw titles?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	17
a5be55d2-627a-457e-a2b8-543f19ccc6e3	How would you find all OnLaw references to Business & Professions code Section 17200?	11bd7553-7aaf-4b02-9469-b6697ae448e5	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	18
0f8edaed-593b-4671-815e-20c2bc1dce88	Your MCLE deadline is approaching, and you need to get additional MCLE credit. Can you show me how many credits you have now and how many more you need?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	0
41f161f4-0e78-494d-8f5a-98459e0e717d	Can you tell me what CLE items you currently have access to in your account?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	1
312f72a9-8728-4161-bb03-36609b912178	(Starting from signed in CLE display) - Can you show me how you would add an additional CLE content to your account?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	2
74a7c1b4-6c3b-47a0-b38c-dc8bdfb8989a	(Search Results) How would you filter these results?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	3
2e04be4c-760a-4cef-9a9a-94e75aa07283	(Search Results) Can you narrow these results to items that are relevant to you?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	4
a503e94c-c225-4ff8-95f3-d6014e8f2ab8	Can you describe this product page?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	5
c4b8e6af-3177-4064-ae7c-25c0724d7635	How would you purchase this product?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	6
7305bbb1-025c-4fff-b844-0528536e8a8b	How would you find CEB CLE content on Legal Ethics, Competence, and Elimination of Bias?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	7
5391572e-65ad-4f50-b978-c959cf31751c	Does CEB offer compliance packages?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	8
61daa1b3-3bf5-49d9-95cb-8200889a5b2f	Does CEB offer CLE programs for certified specialists?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	9
7c41d8de-7f21-4ce4-bb0c-9f0c8fcd83e7	Let's say you would like to know what live CLE events CEB has scheduled in the near future, how would you get that information? (ask them about the the basic conference detail page)	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	10
3429704a-f3db-45d9-98ae-43994a7e476c	Let's say you'd like to use the CLE content you purchased earlier, can you show me how you would get access to that content?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	11
d5c43c55-69a5-4dce-af86-76a043463d0b	(On Program page) What do you think the purpose of this page is?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	12
c40e5e70-1f9b-4815-a49a-059bddecec3e	(on program page) How would you play this video?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	13
333d2b92-f36a-4ab7-a6c5-7ad61ef82e7a	(on program page) If you needed to view closed captions, how would you do that?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	14
d2ed8620-be2f-4283-acf7-c413ecfef7a0	(program page) How would you download the materials associated with this program?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	15
f62838e7-ebd3-4fa3-86b2-ca3ca0d5ffe5	(program page) Who are the speakers in this program? Can you tell me what their background is?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	16
16279d8d-d438-4fce-8c8f-679899edfb50	(program page) How many segments are in this program?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	17
8f31bffb-5c80-4aba-af4b-9102e3a89adb	(Program page) What is the total length of this program?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	18
33486039-50ca-47f9-aad2-3c93f08f6b17	How would you provide feedback on this program to CEB?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	19
0b71b90f-9952-4183-93be-ad2f4b16f8b3	If you needed to obtain a transcript for this program, how would you do that?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	20
55e27b9b-05e2-4b4a-959a-ad8589a44130	Let's say you had finished watching this program, and wanted to return to the listing of CLE programs in your account, how would you do that?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	21
93b0fb16-acba-45ac-b3c2-6e43b3278759	If you had forgotten to download program materials while viewing this program, and wanted to download them after, how would you do that?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	22
e4b891e6-4515-4064-b92b-c00bf84cf376	How would you obtain evidence of your pariticipation in a course, if you needed to provide documentation? Can you email / view / print it?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	23
3de1d9b0-63cb-4985-9b29-710fd7dec141	How would you see your overall usage of CEB CLE programs?	3cfa8761-15c3-45ad-97ac-c1bdafd0bd1e	2019-02-11 20:55:32.910581+00	2019-02-11 20:55:32.910581+00	24
\.


--
-- Name: remote_schemas_id_seq; Type: SEQUENCE SET; Schema: hdb_catalog; Owner: postgres
--

SELECT pg_catalog.setval('hdb_catalog.remote_schemas_id_seq', 1, false);


--
-- Name: event_invocation_logs event_invocation_logs_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.event_invocation_logs
    ADD CONSTRAINT event_invocation_logs_pkey PRIMARY KEY (id);


--
-- Name: event_log event_log_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.event_log
    ADD CONSTRAINT event_log_pkey PRIMARY KEY (id);


--
-- Name: event_triggers event_triggers_name_key; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.event_triggers
    ADD CONSTRAINT event_triggers_name_key UNIQUE (name);


--
-- Name: event_triggers event_triggers_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.event_triggers
    ADD CONSTRAINT event_triggers_pkey PRIMARY KEY (id);


--
-- Name: hdb_function hdb_function_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.hdb_function
    ADD CONSTRAINT hdb_function_pkey PRIMARY KEY (function_schema, function_name);


--
-- Name: hdb_permission hdb_permission_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.hdb_permission
    ADD CONSTRAINT hdb_permission_pkey PRIMARY KEY (table_schema, table_name, role_name, perm_type);


--
-- Name: hdb_query_template hdb_query_template_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.hdb_query_template
    ADD CONSTRAINT hdb_query_template_pkey PRIMARY KEY (template_name);


--
-- Name: hdb_relationship hdb_relationship_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.hdb_relationship
    ADD CONSTRAINT hdb_relationship_pkey PRIMARY KEY (table_schema, table_name, rel_name);


--
-- Name: hdb_table hdb_table_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.hdb_table
    ADD CONSTRAINT hdb_table_pkey PRIMARY KEY (table_schema, table_name);


--
-- Name: hdb_version hdb_version_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.hdb_version
    ADD CONSTRAINT hdb_version_pkey PRIMARY KEY (hasura_uuid);


--
-- Name: migration_settings migration_settings_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.migration_settings
    ADD CONSTRAINT migration_settings_pkey PRIMARY KEY (setting);


--
-- Name: remote_schemas remote_schemas_name_key; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.remote_schemas
    ADD CONSTRAINT remote_schemas_name_key UNIQUE (name);


--
-- Name: remote_schemas remote_schemas_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.remote_schemas
    ADD CONSTRAINT remote_schemas_pkey PRIMARY KEY (id);


--
-- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.schema_migrations
    ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);


--
-- Name: answers answers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.answers
    ADD CONSTRAINT answers_pkey PRIMARY KEY (id);


--
-- Name: feelings feelings_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.feelings
    ADD CONSTRAINT feelings_name_key UNIQUE (name);


--
-- Name: feelings feelings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.feelings
    ADD CONSTRAINT feelings_pkey PRIMARY KEY (id);


--
-- Name: journey_items journey_items_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.journey_items
    ADD CONSTRAINT journey_items_pkey PRIMARY KEY (id);


--
-- Name: journeys journeys_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.journeys
    ADD CONSTRAINT journeys_name_key UNIQUE (name);


--
-- Name: journeys journeys_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.journeys
    ADD CONSTRAINT journeys_pkey PRIMARY KEY (id);


--
-- Name: observations observations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.observations
    ADD CONSTRAINT observations_pkey PRIMARY KEY (id);


--
-- Name: participants participants_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.participants
    ADD CONSTRAINT participants_pkey PRIMARY KEY (id);


--
-- Name: projects projects_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT projects_name_key UNIQUE (name);


--
-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.projects
    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);


--
-- Name: prompts prompts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.prompts
    ADD CONSTRAINT prompts_pkey PRIMARY KEY (id);


--
-- Name: questions questions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.questions
    ADD CONSTRAINT questions_pkey PRIMARY KEY (id);


--
-- Name: ratings ratings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT ratings_pkey PRIMARY KEY (id);


--
-- Name: session_groups session_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.session_groups
    ADD CONSTRAINT session_groups_pkey PRIMARY KEY (id);


--
-- Name: session_journeys session_journeys_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.session_journeys
    ADD CONSTRAINT session_journeys_pkey PRIMARY KEY (id);


--
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- Name: tasks tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tasks
    ADD CONSTRAINT tasks_pkey PRIMARY KEY (id);


--
-- Name: event_invocation_logs_event_id_idx; Type: INDEX; Schema: hdb_catalog; Owner: postgres
--

CREATE INDEX event_invocation_logs_event_id_idx ON hdb_catalog.event_invocation_logs USING btree (event_id);


--
-- Name: event_log_trigger_id_idx; Type: INDEX; Schema: hdb_catalog; Owner: postgres
--

CREATE INDEX event_log_trigger_id_idx ON hdb_catalog.event_log USING btree (trigger_id);


--
-- Name: hdb_version_one_row; Type: INDEX; Schema: hdb_catalog; Owner: postgres
--

CREATE UNIQUE INDEX hdb_version_one_row ON hdb_catalog.hdb_version USING btree (((version IS NOT NULL)));


--
-- Name: session_journeys_sus_score _RETURN; Type: RULE; Schema: public; Owner: postgres
--

CREATE OR REPLACE VIEW public.session_journeys_sus_score AS
 SELECT subquery.id,
        CASE
            WHEN (subquery.sus_sum > 0) THEN ( SELECT ((( SELECT sum(s.s) AS sum
                       FROM unnest(ARRAY[(subquery.sus_scores[1] - 1), (5 - subquery.sus_scores[2]), (subquery.sus_scores[3] - 1), (5 - subquery.sus_scores[4]), (subquery.sus_scores[5] - 1), (5 - subquery.sus_scores[6]), (subquery.sus_scores[7] - 1), (5 - subquery.sus_scores[8]), (subquery.sus_scores[9] - 1), (5 - subquery.sus_scores[10])]) s(s)))::numeric * 2.5))
            WHEN (subquery.sus_sum = 0) THEN (0)::numeric
            ELSE (0)::numeric
        END AS score
   FROM ( SELECT session_journeys.id,
            session_journeys.sus_scores,
            (( SELECT sum(s.s) AS sum
                   FROM unnest(session_journeys.sus_scores) s(s)))::integer AS sus_sum
           FROM public.session_journeys
          GROUP BY session_journeys.id) subquery;


--
-- Name: hdb_table hdb_table_oid_check; Type: TRIGGER; Schema: hdb_catalog; Owner: postgres
--

CREATE TRIGGER hdb_table_oid_check BEFORE INSERT OR UPDATE ON hdb_catalog.hdb_table FOR EACH ROW EXECUTE PROCEDURE hdb_catalog.hdb_table_oid_check();


--
-- Name: event_invocation_logs event_invocation_logs_event_id_fkey; Type: FK CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.event_invocation_logs
    ADD CONSTRAINT event_invocation_logs_event_id_fkey FOREIGN KEY (event_id) REFERENCES hdb_catalog.event_log(id);


--
-- Name: hdb_permission hdb_permission_table_schema_fkey; Type: FK CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.hdb_permission
    ADD CONSTRAINT hdb_permission_table_schema_fkey FOREIGN KEY (table_schema, table_name) REFERENCES hdb_catalog.hdb_table(table_schema, table_name);


--
-- Name: hdb_relationship hdb_relationship_table_schema_fkey; Type: FK CONSTRAINT; Schema: hdb_catalog; Owner: postgres
--

ALTER TABLE ONLY hdb_catalog.hdb_relationship
    ADD CONSTRAINT hdb_relationship_table_schema_fkey FOREIGN KEY (table_schema, table_name) REFERENCES hdb_catalog.hdb_table(table_schema, table_name);


--
-- Name: answers answers_question_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.answers
    ADD CONSTRAINT answers_question_id_fkey FOREIGN KEY (question_id) REFERENCES public.questions(id);


--
-- Name: answers answers_session_journey_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.answers
    ADD CONSTRAINT answers_session_journey_id_fkey FOREIGN KEY (session_journey_id) REFERENCES public.session_journeys(id);


--
-- Name: journey_items journey_items_journey_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.journey_items
    ADD CONSTRAINT journey_items_journey_id_fkey FOREIGN KEY (journey_id) REFERENCES public.journeys(id);


--
-- Name: observations observations_feeling_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.observations
    ADD CONSTRAINT observations_feeling_id_fkey FOREIGN KEY (feeling_id) REFERENCES public.feelings(id);


--
-- Name: observations observations_prompt_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.observations
    ADD CONSTRAINT observations_prompt_id_fkey FOREIGN KEY (prompt_id) REFERENCES public.prompts(id);


--
-- Name: observations observations_session_journey_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.observations
    ADD CONSTRAINT observations_session_journey_id_fkey FOREIGN KEY (session_journey_id) REFERENCES public.session_journeys(id);


--
-- Name: observations observations_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.observations
    ADD CONSTRAINT observations_task_id_fkey FOREIGN KEY (task_id) REFERENCES public.tasks(id);


--
-- Name: prompts prompts_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.prompts
    ADD CONSTRAINT prompts_task_id_fkey FOREIGN KEY (task_id) REFERENCES public.tasks(id);


--
-- Name: ratings ratings_session_journey_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT ratings_session_journey_id_fkey FOREIGN KEY (session_journey_id) REFERENCES public.session_journeys(id);


--
-- Name: ratings ratings_task_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT ratings_task_id_fkey FOREIGN KEY (task_id) REFERENCES public.tasks(id);


--
-- Name: session_groups session_groups_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.session_groups
    ADD CONSTRAINT session_groups_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id);


--
-- Name: session_journeys session_journeys_journey_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.session_journeys
    ADD CONSTRAINT session_journeys_journey_id_fkey FOREIGN KEY (journey_id) REFERENCES public.journeys(id);


--
-- Name: session_journeys session_journeys_session_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.session_journeys
    ADD CONSTRAINT session_journeys_session_id_fkey FOREIGN KEY (session_id) REFERENCES public.sessions(id);


--
-- Name: sessions sessions_participant_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_participant_id_fkey FOREIGN KEY (participant_id) REFERENCES public.participants(id);


--
-- Name: sessions sessions_session_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_session_group_id_fkey FOREIGN KEY (session_group_id) REFERENCES public.session_groups(id);


--
-- Name: tasks tasks_journey_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tasks
    ADD CONSTRAINT tasks_journey_id_fkey FOREIGN KEY (journey_id) REFERENCES public.journeys(id);


--
-- PostgreSQL database dump complete
--