backup.sql

--
-- PostgreSQL database dump
--

\restrict uoqd7Now35NwkcVrkRXzi1NRLN7IGh6yvK8B9WRXxcmjo2wtWa2IuMBV7NKjI2z

-- Dumped from database version 16.10
-- Dumped by pg_dump version 16.10

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

SET default_tablespace = '';

SET default_table_access_method = heap;

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

CREATE TABLE public.acquisition_execution_study (
    id uuid NOT NULL,
    is_new boolean NOT NULL,
    providers character varying(50)[] NOT NULL,
    rank_position integer,
    linked_at timestamp with time zone NOT NULL,
    execution_id uuid NOT NULL,
    study_id uuid NOT NULL
);


ALTER TABLE public.acquisition_execution_study OWNER TO postgres;

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

CREATE TABLE public.acquisition_search_execution (
    id uuid NOT NULL,
    executed_at timestamp with time zone NOT NULL,
    translated_queries jsonb NOT NULL,
    results_count integer NOT NULL,
    new_studies_count integer NOT NULL,
    status character varying(20) NOT NULL,
    error_details jsonb NOT NULL,
    executed_by_id integer,
    strategy_id bigint NOT NULL
);


ALTER TABLE public.acquisition_search_execution OWNER TO postgres;

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

CREATE TABLE public.acquisition_study (
    uuid uuid NOT NULL,
    title text NOT NULL,
    link character varying(500) NOT NULL,
    source character varying(100) NOT NULL,
    doi character varying(200),
    status character varying(20) NOT NULL,
    authors character varying(200)[],
    abstract text,
    year integer,
    journal character varying(300),
    keywords character varying(100)[],
    pdf_path character varying(500),
    pdf_source character varying(100),
    download_status character varying(50),
    consolidation_status character varying(20),
    field_origins jsonb NOT NULL,
    discovered_at timestamp with time zone NOT NULL,
    enriched_at timestamp with time zone,
    downloaded_at timestamp with time zone,
    failure_reason text,
    page_count integer
);


ALTER TABLE public.acquisition_study OWNER TO postgres;

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

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    name character varying(150) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO postgres;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.auth_group ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.auth_group_permissions (
    id bigint NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO postgres;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.auth_group_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO postgres;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.auth_permission ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.auth_user (
    id integer NOT NULL,
    password character varying(128) NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    username character varying(150) NOT NULL,
    first_name character varying(150) NOT NULL,
    last_name character varying(150) NOT NULL,
    email character varying(254) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE public.auth_user OWNER TO postgres;

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

CREATE TABLE public.auth_user_groups (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO postgres;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.auth_user_groups ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.auth_user ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.auth_user_user_permissions (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO postgres;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.auth_user_user_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_designphase (
    is_active boolean NOT NULL,
    start_date timestamp with time zone NOT NULL,
    end_date timestamp with time zone,
    project_id bigint NOT NULL,
    current_stage character varying(20) NOT NULL
);


ALTER TABLE public.design_designphase OWNER TO postgres;

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

CREATE TABLE public.design_designstagelog (
    id bigint NOT NULL,
    stage character varying(20) NOT NULL,
    start_date timestamp with time zone NOT NULL,
    end_date timestamp with time zone,
    phase_id bigint NOT NULL
);


ALTER TABLE public.design_designstagelog OWNER TO postgres;

--
-- Name: design_designstagelog_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_designstagelog ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_designstagelog_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_designstageplan (
    id bigint NOT NULL,
    stage character varying(20) NOT NULL,
    planned_start_date date NOT NULL,
    planned_end_date date NOT NULL,
    phase_id bigint NOT NULL
);


ALTER TABLE public.design_designstageplan OWNER TO postgres;

--
-- Name: design_designstageplan_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_designstageplan ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_designstageplan_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_eligibilitycriterion (
    id bigint NOT NULL,
    description text NOT NULL,
    motivation text NOT NULL,
    justification text NOT NULL,
    type character varying(10) NOT NULL,
    reviewed_at timestamp with time zone,
    status character varying(10) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    design_phase_id bigint NOT NULL,
    last_modified_by_id integer,
    researcher_id integer,
    reviewed_by_id integer
);


ALTER TABLE public.design_eligibilitycriterion OWNER TO postgres;

--
-- Name: design_eligibilitycriterion_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_eligibilitycriterion ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_eligibilitycriterion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_exclusionterm (
    id bigint NOT NULL,
    term character varying(255) NOT NULL,
    strategy_id bigint NOT NULL
);


ALTER TABLE public.design_exclusionterm OWNER TO postgres;

--
-- Name: design_exclusionterm_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_exclusionterm ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_exclusionterm_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_keyword (
    id bigint NOT NULL,
    project_keyword_id bigint NOT NULL,
    strategy_id bigint NOT NULL
);


ALTER TABLE public.design_keyword OWNER TO postgres;

--
-- Name: design_keyword_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_keyword ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_keyword_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_projectkeyword (
    id bigint NOT NULL,
    term character varying(255) NOT NULL,
    synonyms text NOT NULL,
    design_phase_id bigint NOT NULL
);


ALTER TABLE public.design_projectkeyword OWNER TO postgres;

--
-- Name: design_projectkeyword_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_projectkeyword ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_projectkeyword_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_researchquestion (
    id bigint NOT NULL,
    question text NOT NULL,
    motivation text NOT NULL,
    justification text NOT NULL,
    status character varying(20) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    reviewed_at timestamp with time zone,
    modified_at timestamp with time zone NOT NULL,
    framework_fields jsonb NOT NULL,
    design_phase_id bigint NOT NULL,
    last_modified_by_id integer,
    researcher_id integer,
    reviewed_by_id integer
);


ALTER TABLE public.design_researchquestion OWNER TO postgres;

--
-- Name: design_researchquestion_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_researchquestion ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_researchquestion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_searchstrategy (
    id bigint NOT NULL,
    status character varying(20) NOT NULL,
    final_search_string text NOT NULL,
    json_definition jsonb NOT NULL,
    total_studies_found integer NOT NULL,
    created_at timestamp with time zone NOT NULL,
    created_by_id integer,
    last_modified_by_id integer,
    research_question_id bigint,
    reviewed_by_id integer,
    CONSTRAINT design_searchstrategy_total_studies_found_check CHECK ((total_studies_found >= 0))
);


ALTER TABLE public.design_searchstrategy OWNER TO postgres;

--
-- Name: design_searchstrategy_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_searchstrategy ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_searchstrategy_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.design_searchstrategyversion (
    id bigint NOT NULL,
    version_number integer NOT NULL,
    final_search_string text NOT NULL,
    json_definition jsonb NOT NULL,
    total_found integer NOT NULL,
    status character varying(20) NOT NULL,
    metadata_snapshot jsonb NOT NULL,
    created_at timestamp with time zone NOT NULL,
    created_by_id integer,
    strategy_id bigint NOT NULL,
    justification text,
    CONSTRAINT design_searchstrategyversion_total_found_check CHECK ((total_found >= 0)),
    CONSTRAINT design_searchstrategyversion_version_number_check CHECK ((version_number >= 0))
);


ALTER TABLE public.design_searchstrategyversion OWNER TO postgres;

--
-- Name: design_searchstrategyversion_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.design_searchstrategyversion ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.design_searchstrategyversion_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    content_type_id integer,
    user_id integer NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO postgres;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.django_admin_log ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO postgres;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.django_content_type ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.django_migrations (
    id bigint NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.django_migrations OWNER TO postgres;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.django_migrations ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO postgres;

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

CREATE TABLE public.extraction_extractionphase (
    id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    status character varying(10) NOT NULL,
    start_date date,
    due_date date,
    project_id bigint NOT NULL,
    is_active boolean NOT NULL
);


ALTER TABLE public.extraction_extractionphase OWNER TO postgres;

--
-- Name: extraction_extractionphase_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.extraction_extractionphase ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.extraction_extractionphase_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.extraction_paperextraction (
    id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    status character varying(15) NOT NULL,
    path character varying(500),
    assigned_to_id integer,
    extraction_phase_id bigint NOT NULL,
    study_id uuid
);


ALTER TABLE public.extraction_paperextraction OWNER TO postgres;

--
-- Name: extraction_paperextraction_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.extraction_paperextraction ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.extraction_paperextraction_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.extraction_quote (
    id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    text_fragment text,
    location jsonb NOT NULL,
    created_by_id integer,
    paper_extraction_id bigint
);


ALTER TABLE public.extraction_quote OWNER TO postgres;

--
-- Name: extraction_quote_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.extraction_quote ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.extraction_quote_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.extraction_quote_tags (
    id bigint NOT NULL,
    quote_id bigint NOT NULL,
    tag_id bigint NOT NULL
);


ALTER TABLE public.extraction_quote_tags OWNER TO postgres;

--
-- Name: extraction_quote_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.extraction_quote_tags ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.extraction_quote_tags_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.extraction_tag (
    id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    name character varying(100),
    color character varying(7),
    is_mandatory boolean NOT NULL,
    type character varying(10) NOT NULL,
    status character varying(10) NOT NULL,
    visibility character varying(10) NOT NULL,
    created_by_id integer,
    extraction_phase_id bigint,
    rq_related_id bigint
);


ALTER TABLE public.extraction_tag OWNER TO postgres;

--
-- Name: extraction_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.extraction_tag ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.extraction_tag_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_analysistrace (
    id bigint NOT NULL,
    trace_type character varying(30) NOT NULL,
    ai_proposal jsonb NOT NULL,
    researcher_modifications jsonb NOT NULL,
    final_result jsonb NOT NULL,
    rationale text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    created_by_id integer,
    project_id bigint
);


ALTER TABLE public.interpretation_analysistrace OWNER TO postgres;

--
-- Name: interpretation_analysistrace_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_analysistrace ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_analysistrace_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_codenormalizationproposal (
    id bigint NOT NULL,
    normalized_code character varying(255) NOT NULL,
    original_codes jsonb NOT NULL,
    rationale text NOT NULL,
    status character varying(20) NOT NULL,
    created_by_ai boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    project_id bigint,
    reviewed_by_id integer
);


ALTER TABLE public.interpretation_codenormalizationproposal OWNER TO postgres;

--
-- Name: interpretation_codenormalizationproposal_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_codenormalizationproposal ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_codenormalizationproposal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_conversationtrace (
    id bigint NOT NULL,
    role character varying(20) NOT NULL,
    message text NOT NULL,
    title character varying(255) NOT NULL,
    body text NOT NULL,
    tags character varying(255) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    context_id bigint NOT NULL
);


ALTER TABLE public.interpretation_conversationtrace OWNER TO postgres;

--
-- Name: interpretation_conversationtrace_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_conversationtrace ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_conversationtrace_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_initialcode (
    id bigint NOT NULL,
    code character varying(255) NOT NULL,
    frequency integer NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    project_id bigint
);


ALTER TABLE public.interpretation_initialcode OWNER TO postgres;

--
-- Name: interpretation_initialcode_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_initialcode ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_initialcode_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_interpretationcontext (
    id bigint NOT NULL,
    research_question text NOT NULL,
    theme_name character varying(255) NOT NULL,
    extractions_context jsonb NOT NULL,
    is_active boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    subtheme_id bigint NOT NULL
);


ALTER TABLE public.interpretation_interpretationcontext OWNER TO postgres;

--
-- Name: interpretation_interpretationcontext_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_interpretationcontext ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_interpretationcontext_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_interpretationphase (
    id bigint NOT NULL,
    is_active boolean NOT NULL,
    start_date timestamp with time zone NOT NULL,
    end_date timestamp with time zone,
    project_id bigint NOT NULL
);


ALTER TABLE public.interpretation_interpretationphase OWNER TO postgres;

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

CREATE TABLE public.interpretation_interpretativeproposition (
    id bigint NOT NULL,
    proposition_text text NOT NULL,
    supporting_narrative text NOT NULL,
    status character varying(20) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    conversation_trace_id bigint,
    researcher_id integer,
    subtheme_id bigint NOT NULL
);


ALTER TABLE public.interpretation_interpretativeproposition OWNER TO postgres;

--
-- Name: interpretation_interpretativeproposition_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_interpretativeproposition ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_interpretativeproposition_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_normalizedcode (
    id bigint NOT NULL,
    code character varying(255) NOT NULL,
    original_codes jsonb NOT NULL,
    research_question_focus character varying(100) NOT NULL,
    frequency integer NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    project_id bigint,
    proposal_id bigint
);


ALTER TABLE public.interpretation_normalizedcode OWNER TO postgres;

--
-- Name: interpretation_normalizedcode_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_normalizedcode ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_normalizedcode_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: interpretation_phase_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_interpretationphase ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_phase_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_subtheme (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    central_codes jsonb NOT NULL,
    key_citations jsonb NOT NULL,
    status character varying(30) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    theme_id bigint NOT NULL
);


ALTER TABLE public.interpretation_subtheme OWNER TO postgres;

--
-- Name: interpretation_subtheme_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_subtheme ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_subtheme_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_theme (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    description text NOT NULL,
    research_question text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    created_by_id integer NOT NULL,
    project_id bigint
);


ALTER TABLE public.interpretation_theme OWNER TO postgres;

--
-- Name: interpretation_theme_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_theme ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_theme_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.interpretation_themediscoveryproposal (
    id bigint NOT NULL,
    theme_name character varying(255) NOT NULL,
    theme_description text NOT NULL,
    research_question_focus character varying(100) NOT NULL,
    proposed_subthemes jsonb NOT NULL,
    rationale text NOT NULL,
    status character varying(20) NOT NULL,
    created_by_ai boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    project_id bigint,
    reviewed_by_id integer
);


ALTER TABLE public.interpretation_themediscoveryproposal OWNER TO postgres;

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

CREATE TABLE public.interpretation_themediscoveryproposal_codes_used (
    id bigint NOT NULL,
    themediscoveryproposal_id bigint NOT NULL,
    normalizedcode_id bigint NOT NULL
);


ALTER TABLE public.interpretation_themediscoveryproposal_codes_used OWNER TO postgres;

--
-- Name: interpretation_themediscoveryproposal_codes_used_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_themediscoveryproposal_codes_used ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_themediscoveryproposal_codes_used_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: interpretation_themediscoveryproposal_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.interpretation_themediscoveryproposal ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.interpretation_themediscoveryproposal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.notification_notification (
    id bigint NOT NULL,
    type character varying(50) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    project_id bigint,
    sender_id integer,
    custom_message text NOT NULL,
    is_read boolean NOT NULL,
    recipient_id integer,
    title character varying(200) NOT NULL
);


ALTER TABLE public.notification_notification OWNER TO postgres;

--
-- Name: notification_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.notification_notification ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.notification_notification_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.project_expectedresult (
    id bigint NOT NULL,
    description text NOT NULL,
    project_id bigint NOT NULL
);


ALTER TABLE public.project_expectedresult OWNER TO postgres;

--
-- Name: project_expectedresult_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.project_expectedresult ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.project_expectedresult_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.project_membership (
    id bigint NOT NULL,
    role character varying(20) NOT NULL,
    joined_at timestamp with time zone NOT NULL,
    user_id integer NOT NULL,
    project_id bigint NOT NULL,
    workload_hours integer NOT NULL,
    CONSTRAINT project_membership_workload_hours_check CHECK ((workload_hours >= 0))
);


ALTER TABLE public.project_membership OWNER TO postgres;

--
-- Name: project_membership_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.project_membership ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.project_membership_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.project_project (
    id bigint NOT NULL,
    title character varying(100) NOT NULL,
    summary text NOT NULL,
    motivation text NOT NULL,
    general_objective text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    owner_id integer NOT NULL,
    research_framework_id bigint,
    end_date timestamp with time zone
);


ALTER TABLE public.project_project OWNER TO postgres;

--
-- Name: project_project_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.project_project ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.project_project_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.project_researchframework (
    id bigint NOT NULL,
    name character varying(50) NOT NULL,
    fields_data jsonb NOT NULL,
    assigned_by_id integer NOT NULL
);


ALTER TABLE public.project_researchframework OWNER TO postgres;

--
-- Name: project_researchframework_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.project_researchframework ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.project_researchframework_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.project_specificobjective (
    id bigint NOT NULL,
    description text NOT NULL,
    project_id bigint NOT NULL
);


ALTER TABLE public.project_specificobjective OWNER TO postgres;

--
-- Name: project_specificobjective_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.project_specificobjective ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.project_specificobjective_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.selection_conflictresolution (
    id bigint NOT NULL,
    paper_id character varying(255) NOT NULL,
    final_decision character varying(20),
    resolution_notes text NOT NULL,
    resolved_at timestamp with time zone,
    resolved_by_id integer,
    selection_phase_id bigint NOT NULL,
    created_at timestamp with time zone NOT NULL,
    is_resolved boolean NOT NULL,
    resolution_method character varying(20),
    third_reviewer_id integer,
    stage character varying(20) NOT NULL
);


ALTER TABLE public.selection_conflictresolution OWNER TO postgres;

--
-- Name: selection_conflictresolution_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.selection_conflictresolution ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.selection_conflictresolution_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.selection_paperassignment (
    id bigint NOT NULL,
    paper_id character varying(255) NOT NULL,
    assigned_at timestamp with time zone NOT NULL,
    researcher_id integer NOT NULL,
    selection_phase_id bigint NOT NULL,
    is_third_reviewer boolean NOT NULL,
    stage character varying(20) NOT NULL
);


ALTER TABLE public.selection_paperassignment OWNER TO postgres;

--
-- Name: selection_paperassignment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.selection_paperassignment ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.selection_paperassignment_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.selection_paperreview (
    id bigint NOT NULL,
    decision character varying(20) NOT NULL,
    stage character varying(20) NOT NULL,
    notes text NOT NULL,
    reviewed_at timestamp with time zone NOT NULL,
    assignment_id bigint NOT NULL,
    criterion_id character varying(255),
    criterion_label character varying(500)
);


ALTER TABLE public.selection_paperreview OWNER TO postgres;

--
-- Name: selection_paperreview_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.selection_paperreview ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.selection_paperreview_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


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

CREATE TABLE public.selection_selectionphase (
    project_id bigint NOT NULL,
    status character varying(20) NOT NULL,
    current_stage character varying(30) NOT NULL,
    is_active boolean NOT NULL,
    start_date timestamp with time zone NOT NULL,
    end_date timestamp with time zone,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    discussion_fulltext_end_date timestamp with time zone,
    discussion_fulltext_start_date timestamp with time zone,
    discussion_fulltext_status character varying(20) NOT NULL,
    discussion_metadata_end_date timestamp with time zone,
    discussion_metadata_start_date timestamp with time zone,
    discussion_metadata_status character varying(20) NOT NULL,
    fulltext_overview_end_date timestamp with time zone,
    fulltext_overview_start_date timestamp with time zone,
    fulltext_overview_status character varying(20) NOT NULL,
    fulltext_screening_end_date timestamp with time zone,
    fulltext_screening_start_date timestamp with time zone,
    fulltext_screening_status character varying(20) NOT NULL,
    screening_metadata_end_date timestamp with time zone,
    screening_metadata_start_date timestamp with time zone,
    screening_metadata_status character varying(20) NOT NULL
);


ALTER TABLE public.selection_selectionphase OWNER TO postgres;

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

COPY public.acquisition_execution_study (id, is_new, providers, rank_position, linked_at, execution_id, study_id) FROM stdin;
8e382c3a-2f11-47ed-bb47-d48f51662130	t	{Scopus}	3	2026-01-16 04:14:27.381384+00	e46a271f-e10b-4e98-8c30-b557e0fc7423	9602cb7b-ac67-4388-bfab-bbfc40dabaa5
c3669f32-45e5-4265-a660-be794db96e26	t	{"IEEE Xplore"}	1	2026-01-16 04:14:27.381349+00	e46a271f-e10b-4e98-8c30-b557e0fc7423	04dc65c2-9f4b-477c-bdfe-6911af28ba31
757a2d77-6c0c-424a-9471-2a8c3e1e0c9c	t	{"IEEE Xplore"}	2	2026-01-16 04:14:27.381371+00	e46a271f-e10b-4e98-8c30-b557e0fc7423	5debfe06-0656-4361-8f1a-c99f2b32aee5
\.


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

COPY public.acquisition_search_execution (id, executed_at, translated_queries, results_count, new_studies_count, status, error_details, executed_by_id, strategy_id) FROM stdin;
e46a271f-e10b-4e98-8c30-b557e0fc7423	2026-01-16 04:14:27.379199+00	{"ieee": "(cual AND popular)", "scopus": "TITLE-ABS-KEY(moment)"}	3	3	SUCCESS	{}	1	1
\.


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

COPY public.acquisition_study (uuid, title, link, source, doi, status, authors, abstract, year, journal, keywords, pdf_path, pdf_source, download_status, consolidation_status, field_origins, discovered_at, enriched_at, downloaded_at, failure_reason, page_count) FROM stdin;
9602cb7b-ac67-4388-bfab-bbfc40dabaa5	Pone ser programa operación otras próximo luz central dejar participación	https://russo.com/	Scopus	10.6904/audience-deep	downloaded	{"Tracey Villarreal","Mr. Jacob Friedman DDS","Kelly Farrell","Goyo Catalá"}	Never space get soon trouble center eight. Loss door enter institution manager. Card doctor laugh official must yourself personal. Glass central start computer gun. Mission include another young vote team political.	2017	Grupo Garriga S.L.N.E	{tierra,include,contra}	9602cb7b-ac67-4388-bfab-bbfc40dabaa5/manual/04dc65c2-9f4b-477c-bdfe-6911af28ba31.pdf	manual	texto_completo_disponible	\N	{"doi": "automated", "title": "scopus_api", "pdf_file": "Local Load: Simon Brown - The C4 model for visualising software architecture-Leanpb (2022).pdf"}	2026-01-16 04:14:27.377756+00	\N	\N	\N	0
5debfe06-0656-4361-8f1a-c99f2b32aee5	Drop exactly hotel reflect political dinner apply fight marriage stop everyone whom	http://hnos.com/	IEEE Xplore	10.1671/fast-fight-we-need	downloaded	{"Hilda Caballero Acuña","Kristen Smith","Patricia Francis"}	Travel someone book decision believe business. When cost last start. Important national easy out effect Mr. Member vote try past open have determine. Radio Congress art mission ahead beat evening.	1972	Alimentación Españolas S.L.	{analysis,posición,ten}	papers/5debfe06-0656-4361-8f1a-c99f2b32aee5.pdf	\N	texto_completo_disponible	\N	{"doi": "automated", "title": "scopus_api", "pdf_file": "Local Load: Jesson, Jill_Matheson, Lydia_Lacey, Fiona M - Doing Your Literature Review_ Traditional and Systematic Techniques-Sage Publications (CA) (2011).pdf"}	2026-01-16 04:14:27.375499+00	\N	\N	\N	0
04dc65c2-9f4b-477c-bdfe-6911af28ba31	Hospital siguientes destino natural embargo seguridad efectos más primeros período	https://wells.com/	IEEE Xplore	10.2820/agree-include-since	downloaded	{"Dominga Rosado","Jose Luis Eric Barrios Mariscal"}	Fact budget pressure role. Assume positive movement sometimes according name little business. There election poor particular about blood financial.	1995	Transportes Landa S.L.N.E	{estilo,esos,población,we,carácter}	papers/04dc65c2-9f4b-477c-bdfe-6911af28ba31.pdf	\N	texto_completo_disponible	\N	{"doi": "automated", "title": "scopus_api", "pdf_file": "Local Load: (International Series in Advanced Management Studies) Daniela Andreini, Cristina Bettinelli (auth.) - Business Model Innovation_ From Systematic Literature Review to Future Research Directions-Springe.pdf"}	2026-01-16 04:14:27.371907+00	\N	\N	\N	0
\.


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

COPY public.auth_group (id, name) FROM stdin;
\.


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

COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


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

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can view log entry	1	view_logentry
5	Can add permission	2	add_permission
6	Can change permission	2	change_permission
7	Can delete permission	2	delete_permission
8	Can view permission	2	view_permission
9	Can add group	3	add_group
10	Can change group	3	change_group
11	Can delete group	3	delete_group
12	Can view group	3	view_group
13	Can add user	4	add_user
14	Can change user	4	change_user
15	Can delete user	4	delete_user
16	Can view user	4	view_user
17	Can add content type	5	add_contenttype
18	Can change content type	5	change_contenttype
19	Can delete content type	5	delete_contenttype
20	Can view content type	5	view_contenttype
21	Can add session	6	add_session
22	Can change session	6	change_session
23	Can delete session	6	delete_session
24	Can view session	6	view_session
25	Can add Selection Phase	7	add_selectionphase
26	Can change Selection Phase	7	change_selectionphase
27	Can delete Selection Phase	7	delete_selectionphase
28	Can view Selection Phase	7	view_selectionphase
29	Can add Paper Assignment	8	add_paperassignment
30	Can change Paper Assignment	8	change_paperassignment
31	Can delete Paper Assignment	8	delete_paperassignment
32	Can view Paper Assignment	8	view_paperassignment
33	Can add Paper Review	9	add_paperreview
34	Can change Paper Review	9	change_paperreview
35	Can delete Paper Review	9	delete_paperreview
36	Can view Paper Review	9	view_paperreview
37	Can add Conflict Resolution	10	add_conflictresolution
38	Can change Conflict Resolution	10	change_conflictresolution
39	Can delete Conflict Resolution	10	delete_conflictresolution
40	Can view Conflict Resolution	10	view_conflictresolution
41	Can add Search Execution	11	add_searchexecutionmodel
42	Can change Search Execution	11	change_searchexecutionmodel
43	Can delete Search Execution	11	delete_searchexecutionmodel
44	Can view Search Execution	11	view_searchexecutionmodel
45	Can add Execution-Study Link	12	add_executionstudy
46	Can change Execution-Study Link	12	change_executionstudy
47	Can delete Execution-Study Link	12	delete_executionstudy
48	Can view Execution-Study Link	12	view_executionstudy
49	Can add Study	13	add_studymodel
50	Can change Study	13	change_studymodel
51	Can delete Study	13	delete_studymodel
52	Can view Study	13	view_studymodel
53	Can add notification	14	add_notification
54	Can change notification	14	change_notification
55	Can delete notification	14	delete_notification
56	Can view notification	14	view_notification
\.


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

COPY public.auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
1	pbkdf2_sha256$1000000$IQZ4kctWSFd53DqKII9uFM$A91PKtiK+XzhmWJ8BdyCywh0YiuFVEEU9kIXA3ZlN+0=	2026-01-18 17:56:12.600644+00	f	jlusalazar	Jonathan	Salazar	jonathan282salazar@gmail.com	f	t	2026-01-16 02:31:55.911038+00
2	pbkdf2_sha256$1000000$rrkmUJXYHE8vbARUi3VREs$T2fcZAOHvLmpUQfAREC4F3V8NXzNaTjn6ajQl6qB1Co=	2026-01-16 22:37:18.665396+00	f	yalba	Y	A	y@gmail.com	f	t	2026-01-16 02:32:53.112828+00
\.


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

COPY public.auth_user_groups (id, user_id, group_id) FROM stdin;
\.


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

COPY public.auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


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

COPY public.design_designphase (is_active, start_date, end_date, project_id, current_stage) FROM stdin;
f	2026-01-16 00:00:00+00	2026-01-16 04:00:25.581636+00	1	FINISHED
\.


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

COPY public.design_designstagelog (id, stage, start_date, end_date, phase_id) FROM stdin;
1	RQ_DISCUSSION	2026-01-16 03:13:50.022009+00	2026-01-16 03:14:03.680658+00	1
2	CRITERIA_DEFINITION	2026-01-16 03:14:03.687353+00	2026-01-16 03:14:33.932524+00	1
3	SEARCH_STRATEGY	2026-01-16 03:14:33.939742+00	2026-01-16 04:00:25.578598+00	1
\.


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

COPY public.design_designstageplan (id, stage, planned_start_date, planned_end_date, phase_id) FROM stdin;
1	RQ_CREATION	2026-01-16	2026-01-17	1
2	RQ_DISCUSSION	2026-01-16	2026-01-19	1
3	CRITERIA_DEFINITION	2026-01-16	2026-01-21	1
4	SEARCH_STRATEGY	2026-01-16	2026-01-23	1
\.


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

COPY public.design_eligibilitycriterion (id, description, motivation, justification, type, reviewed_at, status, created_at, updated_at, design_phase_id, last_modified_by_id, researcher_id, reviewed_by_id) FROM stdin;
1	CI 1		Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	INCLUSION	2026-01-16 03:14:23.88446+00	APPROVED	2026-01-16 03:14:13.585458+00	2026-01-16 03:14:23.884567+00	1	\N	1	1
2	CE 1		Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	EXCLUSION	2026-01-16 03:14:26.285694+00	APPROVED	2026-01-16 03:14:20.142234+00	2026-01-16 03:14:26.285793+00	1	1	1	1
\.


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

COPY public.design_exclusionterm (id, term, strategy_id) FROM stdin;
\.


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

COPY public.design_keyword (id, project_keyword_id, strategy_id) FROM stdin;
\.


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

COPY public.design_projectkeyword (id, term, synonyms, design_phase_id) FROM stdin;
1	Software	SW	1
\.


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

COPY public.design_researchquestion (id, question, motivation, justification, status, created_at, reviewed_at, modified_at, framework_fields, design_phase_id, last_modified_by_id, researcher_id, reviewed_by_id) FROM stdin;
2	Where is this?	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	APPROVED	2026-01-16 03:13:07.081864+00	2026-01-16 03:13:59.184308+00	2026-01-16 03:13:21.374522+00	{"Outcome": "Lorem", "Comparison": "ipsum", "Population": "dolor", "Intervention": " sit"}	1	\N	1	1
1	What is this?	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	APPROVED	2026-01-16 03:12:08.01803+00	2026-01-16 03:14:01.544811+00	2026-01-16 03:12:58.681151+00	{"Outcome": "Lorem", "Comparison": "ipsum", "Population": "dolor", "Intervention": " sit"}	1	\N	1	1
\.


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

COPY public.design_searchstrategy (id, status, final_search_string, json_definition, total_studies_found, created_at, created_by_id, last_modified_by_id, research_question_id, reviewed_by_id) FROM stdin;
1	DRAFT	("Software" OR "SW")	{"exclusions": [], "main_terms": [{"term": "Software", "synonyms": ["SW"]}]}	0	2026-01-16 03:12:08.027394+00	\N	1	1	\N
2	APPROVED	("Software" OR "SW")	{"exclusions": [], "main_terms": [{"term": "Software", "synonyms": ["S.W."]}]}	0	2026-01-16 03:13:07.090364+00	\N	1	2	1
\.


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

COPY public.design_searchstrategyversion (id, version_number, final_search_string, json_definition, total_found, status, metadata_snapshot, created_at, created_by_id, strategy_id, justification) FROM stdin;
2	2	("Software" OR "SW")	{"exclusions": [], "main_terms": [{"term": "Software", "synonyms": ["SW"]}]}	0	APPROVED	{"keywords": [], "exclusions": []}	2026-01-16 03:16:09.835041+00	1	2	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.\r\n\r\n
3	1	("Software" OR "SW")	{"exclusions": [], "main_terms": [{"term": "Software", "synonyms": ["SW"]}]}	0	REJECTED	{"keywords": [], "exclusions": []}	2026-01-16 03:21:03.444704+00	1	1	\N
1	1	("Software" OR "SW" OR "Software")	{"exclusions": [], "main_terms": [{"term": "Software", "synonyms": ["SW", "Software"]}]}	0	REJECTED	{"keywords": [], "exclusions": []}	2026-01-16 03:15:41.306958+00	1	2	\N
\.


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

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.


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

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	group
4	auth	user
5	contenttypes	contenttype
6	sessions	session
7	selection	selectionphase
8	selection	paperassignment
9	selection	paperreview
10	selection	conflictresolution
11	acquisition	searchexecutionmodel
12	acquisition	executionstudy
13	acquisition	studymodel
14	notification	notification
\.


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

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2026-01-16 02:17:30.139166+00
2	auth	0001_initial	2026-01-16 02:17:30.223733+00
3	project	0001_initial	2026-01-16 02:17:30.32342+00
4	design	0001_initial	2026-01-16 02:17:30.535215+00
5	acquisition	0001_initial	2026-01-16 02:17:30.73067+00
6	acquisition	0002_studymodel_page_count	2026-01-16 02:17:30.736428+00
7	admin	0001_initial	2026-01-16 02:17:30.774633+00
8	admin	0002_logentry_remove_auto_add	2026-01-16 02:17:30.788933+00
9	admin	0003_logentry_add_action_flag_choices	2026-01-16 02:17:30.804855+00
10	contenttypes	0002_remove_content_type_name	2026-01-16 02:17:30.83731+00
11	auth	0002_alter_permission_name_max_length	2026-01-16 02:17:30.859829+00
12	auth	0003_alter_user_email_max_length	2026-01-16 02:17:30.876801+00
13	auth	0004_alter_user_username_opts	2026-01-16 02:17:30.89268+00
14	auth	0005_alter_user_last_login_null	2026-01-16 02:17:30.910906+00
15	auth	0006_require_contenttypes_0002	2026-01-16 02:17:30.912873+00
16	auth	0007_alter_validators_add_error_messages	2026-01-16 02:17:30.934312+00
17	auth	0008_alter_user_username_max_length	2026-01-16 02:17:30.959593+00
18	auth	0009_alter_user_last_name_max_length	2026-01-16 02:17:30.976765+00
19	auth	0010_alter_group_name_max_length	2026-01-16 02:17:31.002109+00
20	auth	0011_update_proxy_permissions	2026-01-16 02:17:31.022253+00
21	auth	0012_alter_user_first_name_max_length	2026-01-16 02:17:31.039279+00
22	design	0002_searchstrategyversion_justification	2026-01-16 02:17:31.057043+00
23	design	0003_designphase_fecha_inicio_creacion_pregunta	2026-01-16 02:17:31.070684+00
24	design	0004_remove_designphase_fecha_inicio_creacion_pregunta_and_more	2026-01-16 02:17:31.149316+00
25	project	0002_project_end_date	2026-01-16 02:17:31.166507+00
26	project	0003_membership_workload_hours	2026-01-16 02:17:31.189461+00
27	extraction	0001_initial	2026-01-16 02:17:31.373854+00
28	extraction	0002_extractionphase_is_active	2026-01-16 02:17:31.388948+00
29	interpretation	0001_initial	2026-01-16 02:17:31.801867+00
30	notification	0001_initial	2026-01-16 02:17:31.851229+00
31	notification	0002_add_recipient_title_custom_message_is_read	2026-01-16 02:17:32.107323+00
32	selection	0001_initial	2026-01-16 02:17:32.292267+00
33	selection	0002_paperreview_criterion_id	2026-01-16 02:17:32.299714+00
34	selection	0003_paperreview_criterion_label	2026-01-16 02:17:32.311389+00
35	selection	0004_alter_conflictresolution_unique_together_and_more	2026-01-16 02:17:32.574265+00
36	selection	0005_alter_conflictresolution_unique_together_and_more	2026-01-16 02:17:33.01247+00
37	sessions	0001_initial	2026-01-16 02:17:33.026751+00
38	interpretation	0002_theme_project	2026-01-18 17:55:46.798898+00
39	interpretation	0003_interpretationphase	2026-01-18 17:55:46.871328+00
40	interpretation	0004_alter_interpretationphase_table	2026-01-18 17:55:46.896068+00
\.


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

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
\.


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

COPY public.extraction_extractionphase (id, created_at, updated_at, status, start_date, due_date, project_id, is_active) FROM stdin;
1	2026-01-16 05:35:07.900687+00	2026-01-18 06:34:30.565169+00	OPEN	2026-01-18	2026-01-31	1	f
\.


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

COPY public.extraction_paperextraction (id, created_at, updated_at, status, path, assigned_to_id, extraction_phase_id, study_id) FROM stdin;
7	2026-01-16 07:05:10.857359+00	2026-01-17 05:47:02.945161+00	IN_PROGRESS	http://localhost:9000/adn4research-bucket/papers/5debfe06-0656-4361-8f1a-c99f2b32aee5.pdf	1	1	5debfe06-0656-4361-8f1a-c99f2b32aee5
8	2026-01-16 07:05:10.865976+00	2026-01-17 06:32:56.048432+00	IN_PROGRESS	9602cb7b-ac67-4388-bfab-bbfc40dabaa5/manual/04dc65c2-9f4b-477c-bdfe-6911af28ba31.pdf	2	1	9602cb7b-ac67-4388-bfab-bbfc40dabaa5
\.


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

COPY public.extraction_quote (id, created_at, updated_at, text_fragment, location, created_by_id, paper_extraction_id) FROM stdin;
4	2026-01-16 18:08:29.593743+00	2026-01-16 18:08:29.593856+00	Apart from any fair dealing for the purposes of research or\nprivate study, or criticism or review, as permitted under the\nCopyright, Designs and Patents Act, 1988, this publication\nmay be reproduced, stored or transmitted in any form, or by\nany means, only with the prior permission in writing of the\npublishers, or in the case of reprographic reproduction,\nin accordance with the terms of licences issued by the\nCopyright Licensing Agency. Enquiries concerning\nreproduction outside those terms should be sent to the\npublishers	{"page": 5}	1	7
8	2026-01-16 19:44:17.797625+00	2026-01-16 19:44:17.797647+00	About the Authors ix\nAcknowledgements x\nINTRODuCTION 1\nWho is this book for? 1\nHow is this book different? 1\nThe rationale and history behind the contributions from\nresearchers and from an information specialist 2\nFeatures of the book 4\nLayout of the book 5\nPART I Getting Information 7\n1 PRELIMINARIES 9\nWhat is a literature review? 9\nTerminology used in this book 10\nDifferent styles of review 13\nTwo styles or approaches 14\nA critical approach 16\nKnowledge and literature 16\nWhy and when will you need to review the literature? 17\nThe research question and the literature review 18\nWhat is appropriate literature? 20\nChoosing which style of review: a traditional narrative\nreview or a systematic review? 23\nProject management 24\nSummary 25	{"page": 6}	1	7
9	2026-01-16 19:45:05.174847+00	2026-01-16 19:45:05.174879+00	FROM MAKING NOTES TO WRITING 58\nIntroduction 58\nNote-making 59\nFrom notes to writing 62\nWriting: critical writing and types of argument 66\nMaking a value judgement and bias 66\nSummary 69	{"page": 7}	1	7
11	2026-01-16 19:53:32.367658+00	2026-01-16 19:53:32.367682+00	THE SYSTEMATIC REVIEW 103\nOverview 103\nDefinitions 104\nDevelopment of the review protocol 109\nFormulating the review question 110\nDocumenting your progress 111\nLocating studies and sources of information 113\nSelecting studies: inclusion and exclusion criteria 115\nAppraisal – assessing the quality of research	{"page": 8}	1	7
12	2026-01-16 19:55:48.469478+00	2026-01-16 19:55:48.469518+00	META-ANALYSIS 128\nOverview 128\nWhat is meta-analysis? 129\nCan I use meta-analysis to summarise the results of my\nsystematic review? 131\nundertaking your meta-analysis 138\nDisplaying the results of a meta-analysis 139\nIs your meta-analysis free from bias? 140\nPerforming a sensitivity analysis 143\nSummary	{"page": 8}	1	7
13	2026-01-16 19:56:26.016584+00	2026-01-16 19:56:26.016631+00	SAGE Publications India Pvt Ltd\nB1/I1 Mohan Cooperative Industrial Area\nMathura Road, New Delhi 110 044\nIndia	{"page": 5}	1	7
14	2026-01-16 21:57:36.449755+00	2026-01-16 21:57:36.451955+00	Publications	{"page": 5}	1	7
17	2026-01-17 05:45:19.65359+00	2026-01-17 05:45:19.653605+00	Why is referencing important?	{"page": 8}	1	7
20	2026-01-18 06:36:37.955314+00	2026-01-18 06:36:37.955359+00	ix 1: Further Reading 156\nAppendix 2: Critical Review Checklist 157\nAppendix 3: Systematic Review – Online Resources 159\nAppendix 4: Resources for Meta-analysis 160\nGlossary 161\nReferences 166	{"page": 9}	1	7
21	2026-01-18 06:36:44.474833+00	2026-01-18 06:36:44.474899+00	Several people helped us in compiling this book.\nKatie Jesson drew the diagrams in Chapters 5, 6, and 7. Rob Pocock drew\nthe Gantt chart	{"page": 11}	1	7
22	2026-01-18 06:37:00.812704+00	2026-01-18 06:37:00.812726+00	Wiley-Blackwell, for Tuch, C. and O’Sullivan, N. (2007) The impact of acquisitions on firm per-\nformance: A review of the evidence. International Journal of Management Reviews 9(2):\n141–170.\nWiley, for the use of Gourlay, S. (2006) Conceptualizing knowledge creation: a critique of\nNonaka’s theory. Journal of Management Studies 43(7): 1415–1436.\nWiley, for the use of Smallbone, T. (2005) How can domestic households become part of the\nsolution to England’s recycling problems? Business Strategy and the Environment 14:\n110–122.\nBMJ Publishing Group Ltd, for Lewis, S. and Clarke, M. (2001) Forest plots: trying to see\nthe wood and the trees. British Medical Journal 322(7300): 1479–1480, and Sutton,\nA.J. et al. (2000) Empirical assessment of effect of publication bias on met-analyses British	{"page": 11}	1	7
\.


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

COPY public.extraction_quote_tags (id, quote_id, tag_id) FROM stdin;
4	4	6
10	8	9
11	9	6
13	11	6
14	11	7
15	12	9
16	13	6
17	14	5
20	17	9
23	20	6
24	21	9
25	22	8
\.


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

COPY public.extraction_tag (id, created_at, updated_at, name, color, is_mandatory, type, status, visibility, created_by_id, extraction_phase_id, rq_related_id) FROM stdin;
5	2026-01-16 17:52:34.957103+00	2026-01-16 17:52:34.958476+00	Codigo RQ1	#6366f1	t	DEDUCTIVE	APPROVED	PUBLIC	1	1	1
6	2026-01-16 17:53:06.532956+00	2026-01-16 17:53:36.037922+00	Codigo Extra 1	#ff00a2	f	DEDUCTIVE	APPROVED	PUBLIC	1	1	\N
7	2026-01-16 17:56:09.431964+00	2026-01-16 17:56:09.432+00	Codigo RQ 1 -2	#6366f1	t	DEDUCTIVE	APPROVED	PUBLIC	1	1	1
8	2026-01-16 19:00:36.640477+00	2026-01-16 19:00:36.640514+00	Inductivo Researcher 2	#00FBFF	f	INDUCTIVE	PENDING	PRIVATE	1	1	\N
9	2026-01-16 19:44:12.818001+00	2026-01-16 19:44:12.818071+00	Inductivo Creation	#F901CB	f	INDUCTIVE	PENDING	PRIVATE	1	1	\N
10	2026-01-18 07:20:15.966254+00	2026-01-18 07:20:15.966893+00	Codigo RQ2	#6366f1	t	DEDUCTIVE	APPROVED	PUBLIC	1	1	2
\.


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

COPY public.interpretation_analysistrace (id, trace_type, ai_proposal, researcher_modifications, final_result, rationale, created_at, created_by_id, project_id) FROM stdin;
\.


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

COPY public.interpretation_codenormalizationproposal (id, normalized_code, original_codes, rationale, status, created_by_ai, created_at, modified_at, project_id, reviewed_by_id) FROM stdin;
\.


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

COPY public.interpretation_conversationtrace (id, role, message, title, body, tags, created_at, context_id) FROM stdin;
\.


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

COPY public.interpretation_initialcode (id, code, frequency, created_at, modified_at, project_id) FROM stdin;
\.


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

COPY public.interpretation_interpretationcontext (id, research_question, theme_name, extractions_context, is_active, created_at, modified_at, subtheme_id) FROM stdin;
\.


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

COPY public.interpretation_interpretationphase (id, is_active, start_date, end_date, project_id) FROM stdin;
1	t	2026-01-18 17:56:35.367232+00	\N	1
\.


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

COPY public.interpretation_interpretativeproposition (id, proposition_text, supporting_narrative, status, created_at, modified_at, conversation_trace_id, researcher_id, subtheme_id) FROM stdin;
\.


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

COPY public.interpretation_normalizedcode (id, code, original_codes, research_question_focus, frequency, created_at, modified_at, project_id, proposal_id) FROM stdin;
\.


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

COPY public.interpretation_subtheme (id, name, central_codes, key_citations, status, created_at, modified_at, theme_id) FROM stdin;
\.


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

COPY public.interpretation_theme (id, name, description, research_question, created_at, modified_at, created_by_id, project_id) FROM stdin;
\.


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

COPY public.interpretation_themediscoveryproposal (id, theme_name, theme_description, research_question_focus, proposed_subthemes, rationale, status, created_by_ai, created_at, modified_at, project_id, reviewed_by_id) FROM stdin;
\.


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

COPY public.interpretation_themediscoveryproposal_codes_used (id, themediscoveryproposal_id, normalizedcode_id) FROM stdin;
\.


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

COPY public.notification_notification (id, type, created_at, project_id, sender_id, custom_message, is_read, recipient_id, title) FROM stdin;
\.


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

COPY public.project_expectedresult (id, description, project_id) FROM stdin;
1	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel.	1
\.


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

COPY public.project_membership (id, role, joined_at, user_id, project_id, workload_hours) FROM stdin;
1	OWNER	2026-01-16 03:11:11.51895+00	1	1	3
2	RESEARCHER	2026-01-16 03:11:11.522105+00	2	1	2
\.


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

COPY public.project_project (id, title, summary, motivation, general_objective, created_at, updated_at, owner_id, research_framework_id, end_date) FROM stdin;
1	Test Project	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel.	2026-01-16 03:11:11.498809+00	2026-01-16 03:11:11.49882+00	1	1	2026-01-30 00:00:00+00
\.


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

COPY public.project_researchframework (id, name, fields_data, assigned_by_id) FROM stdin;
1	PICO	{"Outcome": "", "Comparison": "", "Population": "", "Intervention": ""}	1
\.


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

COPY public.project_specificobjective (id, description, project_id) FROM stdin;
1	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	1
2	Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam.	1
3	Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia.	1
\.


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

COPY public.selection_conflictresolution (id, paper_id, final_decision, resolution_notes, resolved_at, resolved_by_id, selection_phase_id, created_at, is_resolved, resolution_method, third_reviewer_id, stage) FROM stdin;
\.


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

COPY public.selection_paperassignment (id, paper_id, assigned_at, researcher_id, selection_phase_id, is_third_reviewer, stage) FROM stdin;
21	9602cb7b-ac67-4388-bfab-bbfc40dabaa5	2026-01-16 04:14:47.114467+00	1	1	f	SCREENING
22	5debfe06-0656-4361-8f1a-c99f2b32aee5	2026-01-16 04:14:47.117111+00	1	1	f	SCREENING
23	04dc65c2-9f4b-477c-bdfe-6911af28ba31	2026-01-16 04:14:47.118914+00	1	1	f	SCREENING
24	9602cb7b-ac67-4388-bfab-bbfc40dabaa5	2026-01-16 04:14:47.121695+00	2	1	f	SCREENING
25	5debfe06-0656-4361-8f1a-c99f2b32aee5	2026-01-16 04:14:47.123047+00	2	1	f	SCREENING
26	04dc65c2-9f4b-477c-bdfe-6911af28ba31	2026-01-16 04:14:47.124364+00	2	1	f	SCREENING
27	5debfe06-0656-4361-8f1a-c99f2b32aee5	2026-01-16 04:32:24.397591+00	2	1	f	FULLTEXT
28	9602cb7b-ac67-4388-bfab-bbfc40dabaa5	2026-01-16 04:32:24.400702+00	2	1	f	FULLTEXT
29	5debfe06-0656-4361-8f1a-c99f2b32aee5	2026-01-16 04:32:24.403423+00	1	1	f	FULLTEXT
30	9602cb7b-ac67-4388-bfab-bbfc40dabaa5	2026-01-16 04:32:24.404735+00	1	1	f	FULLTEXT
\.


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

COPY public.selection_paperreview (id, decision, stage, notes, reviewed_at, assignment_id, criterion_id, criterion_label) FROM stdin;
1	INCLUDED	SCREENING	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia	2026-01-16 04:15:03.261319+00	21	1	CI 1
2	INCLUDED	SCREENING	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia	2026-01-16 04:15:10.425184+00	22	1	CI 1
3	EXCLUDED	SCREENING	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia	2026-01-16 04:15:16.446582+00	23	2	CE 1
4	EXCLUDED	SCREENING	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia	2026-01-16 04:15:48.35489+00	26	OUT_OF_SCOPE	Estudio fuera de foco
5	INCLUDED	SCREENING	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia	2026-01-16 04:15:53.458318+00	25	1	CI 1
6	INCLUDED	SCREENING	Lorem ipsum dolor sit amet consectetur adipiscing elit placerat cubilia, ridiculus leo quisque in per erat vel. Litora dictum augue est dignissim vitae orci ullamcorper viverra, lobortis pellentesque curabitur sem at volutpat facilisis mauris, velit potenti ridiculus rutrum nam venenatis etiam. Dictum interdum arcu ultrices habitasse nibh non mus vulputate, est aenean blandit at bibendum aliquet tincidunt, class taciti ac fusce magna ante conubia	2026-01-16 04:15:57.302303+00	24	1	CI 1
7	INCLUDED	FULL_TEXT		2026-01-16 05:16:38.863192+00	29	1	CI 1
8	INCLUDED	FULL_TEXT		2026-01-16 05:16:51.730107+00	30	1	CI 1
9	INCLUDED	FULL_TEXT		2026-01-16 05:17:00.583806+00	27	1	CI 1
10	INCLUDED	FULL_TEXT		2026-01-16 05:17:12.974635+00	28	1	CI 1
\.


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

COPY public.selection_selectionphase (project_id, status, current_stage, is_active, start_date, end_date, created_at, updated_at, discussion_fulltext_end_date, discussion_fulltext_start_date, discussion_fulltext_status, discussion_metadata_end_date, discussion_metadata_start_date, discussion_metadata_status, fulltext_overview_end_date, fulltext_overview_start_date, fulltext_overview_status, fulltext_screening_end_date, fulltext_screening_start_date, fulltext_screening_status, screening_metadata_end_date, screening_metadata_start_date, screening_metadata_status) FROM stdin;
1	ON_GOING	FULLTEXT_OVERVIEW	t	2026-01-16 04:01:28.320303+00	\N	2026-01-16 04:01:28.32032+00	2026-01-16 04:32:24.405934+00	\N	\N	NOT_STARTED	\N	\N	COMPLETED	\N	\N	NOT_STARTED	\N	\N	IN_PROGRESS	\N	\N	COMPLETED
\.


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_group_id_seq', 1, false);


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 1, false);


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_permission_id_seq', 56, true);


--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_user_groups_id_seq', 1, false);


--
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_user_id_seq', 2, true);


--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.auth_user_user_permissions_id_seq', 1, false);


--
-- Name: design_designstagelog_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.design_designstagelog_id_seq', 3, true);


--
-- Name: design_designstageplan_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.design_designstageplan_id_seq', 4, true);


--
-- Name: design_eligibilitycriterion_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.design_eligibilitycriterion_id_seq', 2, true);


--
-- Name: design_exclusionterm_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.design_exclusionterm_id_seq', 1, false);


--
-- Name: design_keyword_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.design_keyword_id_seq', 1, false);


--
-- Name: design_projectkeyword_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: design_researchquestion_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.design_researchquestion_id_seq', 2, true);


--
-- Name: design_searchstrategy_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.design_searchstrategy_id_seq', 2, true);


--
-- Name: design_searchstrategyversion_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.design_searchstrategyversion_id_seq', 3, true);


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 1, false);


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_content_type_id_seq', 14, true);


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.django_migrations_id_seq', 40, true);


--
-- Name: extraction_extractionphase_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: extraction_paperextraction_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.extraction_paperextraction_id_seq', 8, true);


--
-- Name: extraction_quote_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.extraction_quote_id_seq', 22, true);


--
-- Name: extraction_quote_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.extraction_quote_tags_id_seq', 25, true);


--
-- Name: extraction_tag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.extraction_tag_id_seq', 10, true);


--
-- Name: interpretation_analysistrace_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_analysistrace_id_seq', 1, false);


--
-- Name: interpretation_codenormalizationproposal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_codenormalizationproposal_id_seq', 1, false);


--
-- Name: interpretation_conversationtrace_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_conversationtrace_id_seq', 1, false);


--
-- Name: interpretation_initialcode_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_initialcode_id_seq', 1, false);


--
-- Name: interpretation_interpretationcontext_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_interpretationcontext_id_seq', 1, false);


--
-- Name: interpretation_interpretativeproposition_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_interpretativeproposition_id_seq', 1, false);


--
-- Name: interpretation_normalizedcode_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_normalizedcode_id_seq', 1, false);


--
-- Name: interpretation_phase_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: interpretation_subtheme_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_subtheme_id_seq', 1, false);


--
-- Name: interpretation_theme_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_theme_id_seq', 1, false);


--
-- Name: interpretation_themediscoveryproposal_codes_used_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_themediscoveryproposal_codes_used_id_seq', 1, false);


--
-- Name: interpretation_themediscoveryproposal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.interpretation_themediscoveryproposal_id_seq', 1, false);


--
-- Name: notification_notification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.notification_notification_id_seq', 1, false);


--
-- Name: project_expectedresult_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: project_membership_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.project_membership_id_seq', 2, true);


--
-- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: project_researchframework_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

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


--
-- Name: project_specificobjective_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.project_specificobjective_id_seq', 3, true);


--
-- Name: selection_conflictresolution_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.selection_conflictresolution_id_seq', 1, false);


--
-- Name: selection_paperassignment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.selection_paperassignment_id_seq', 30, true);


--
-- Name: selection_paperreview_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.selection_paperreview_id_seq', 10, true);


--
-- Name: acquisition_execution_study acquisition_execution_study_execution_id_study_id_42d2dd6c_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acquisition_execution_study
    ADD CONSTRAINT acquisition_execution_study_execution_id_study_id_42d2dd6c_uniq UNIQUE (execution_id, study_id);


--
-- Name: acquisition_execution_study acquisition_execution_study_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acquisition_execution_study
    ADD CONSTRAINT acquisition_execution_study_pkey PRIMARY KEY (id);


--
-- Name: acquisition_search_execution acquisition_search_execution_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acquisition_search_execution
    ADD CONSTRAINT acquisition_search_execution_pkey PRIMARY KEY (id);


--
-- Name: acquisition_study acquisition_study_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acquisition_study
    ADD CONSTRAINT acquisition_study_pkey PRIMARY KEY (uuid);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);


--
-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);


--
-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- Name: design_designphase design_designphase_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_designphase
    ADD CONSTRAINT design_designphase_pkey PRIMARY KEY (project_id);


--
-- Name: design_designstagelog design_designstagelog_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_designstagelog
    ADD CONSTRAINT design_designstagelog_pkey PRIMARY KEY (id);


--
-- Name: design_designstageplan design_designstageplan_phase_id_stage_f6222385_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_designstageplan
    ADD CONSTRAINT design_designstageplan_phase_id_stage_f6222385_uniq UNIQUE (phase_id, stage);


--
-- Name: design_designstageplan design_designstageplan_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_designstageplan
    ADD CONSTRAINT design_designstageplan_pkey PRIMARY KEY (id);


--
-- Name: design_eligibilitycriterion design_eligibilitycriterion_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_eligibilitycriterion
    ADD CONSTRAINT design_eligibilitycriterion_pkey PRIMARY KEY (id);


--
-- Name: design_exclusionterm design_exclusionterm_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_exclusionterm
    ADD CONSTRAINT design_exclusionterm_pkey PRIMARY KEY (id);


--
-- Name: design_keyword design_keyword_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_keyword
    ADD CONSTRAINT design_keyword_pkey PRIMARY KEY (id);


--
-- Name: design_projectkeyword design_projectkeyword_design_phase_id_term_d546df72_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_projectkeyword
    ADD CONSTRAINT design_projectkeyword_design_phase_id_term_d546df72_uniq UNIQUE (design_phase_id, term);


--
-- Name: design_projectkeyword design_projectkeyword_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_projectkeyword
    ADD CONSTRAINT design_projectkeyword_pkey PRIMARY KEY (id);


--
-- Name: design_researchquestion design_researchquestion_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_researchquestion
    ADD CONSTRAINT design_researchquestion_pkey PRIMARY KEY (id);


--
-- Name: design_searchstrategy design_searchstrategy_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategy
    ADD CONSTRAINT design_searchstrategy_pkey PRIMARY KEY (id);


--
-- Name: design_searchstrategyversion design_searchstrategyver_strategy_id_version_numb_9d99ee6b_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategyversion
    ADD CONSTRAINT design_searchstrategyver_strategy_id_version_numb_9d99ee6b_uniq UNIQUE (strategy_id, version_number);


--
-- Name: design_searchstrategyversion design_searchstrategyversion_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategyversion
    ADD CONSTRAINT design_searchstrategyversion_pkey PRIMARY KEY (id);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: extraction_extractionphase extraction_extractionphase_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_extractionphase
    ADD CONSTRAINT extraction_extractionphase_pkey PRIMARY KEY (id);


--
-- Name: extraction_paperextraction extraction_paperextracti_study_id_extraction_phas_ace7e207_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_paperextraction
    ADD CONSTRAINT extraction_paperextracti_study_id_extraction_phas_ace7e207_uniq UNIQUE (study_id, extraction_phase_id);


--
-- Name: extraction_paperextraction extraction_paperextraction_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_paperextraction
    ADD CONSTRAINT extraction_paperextraction_pkey PRIMARY KEY (id);


--
-- Name: extraction_quote extraction_quote_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_quote
    ADD CONSTRAINT extraction_quote_pkey PRIMARY KEY (id);


--
-- Name: extraction_quote_tags extraction_quote_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_quote_tags
    ADD CONSTRAINT extraction_quote_tags_pkey PRIMARY KEY (id);


--
-- Name: extraction_quote_tags extraction_quote_tags_quote_id_tag_id_5a369d9a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_quote_tags
    ADD CONSTRAINT extraction_quote_tags_quote_id_tag_id_5a369d9a_uniq UNIQUE (quote_id, tag_id);


--
-- Name: extraction_tag extraction_tag_extraction_phase_id_name_6f4049e6_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_tag
    ADD CONSTRAINT extraction_tag_extraction_phase_id_name_6f4049e6_uniq UNIQUE (extraction_phase_id, name);


--
-- Name: extraction_tag extraction_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_tag
    ADD CONSTRAINT extraction_tag_pkey PRIMARY KEY (id);


--
-- Name: interpretation_analysistrace interpretation_analysistrace_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_analysistrace
    ADD CONSTRAINT interpretation_analysistrace_pkey PRIMARY KEY (id);


--
-- Name: interpretation_codenormalizationproposal interpretation_codenormalizationproposal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_codenormalizationproposal
    ADD CONSTRAINT interpretation_codenormalizationproposal_pkey PRIMARY KEY (id);


--
-- Name: interpretation_conversationtrace interpretation_conversationtrace_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_conversationtrace
    ADD CONSTRAINT interpretation_conversationtrace_pkey PRIMARY KEY (id);


--
-- Name: interpretation_initialcode interpretation_initialcode_code_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_initialcode
    ADD CONSTRAINT interpretation_initialcode_code_key UNIQUE (code);


--
-- Name: interpretation_initialcode interpretation_initialcode_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_initialcode
    ADD CONSTRAINT interpretation_initialcode_pkey PRIMARY KEY (id);


--
-- Name: interpretation_interpretationcontext interpretation_interpretationcontext_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretationcontext
    ADD CONSTRAINT interpretation_interpretationcontext_pkey PRIMARY KEY (id);


--
-- Name: interpretation_interpretationcontext interpretation_interpretationcontext_subtheme_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretationcontext
    ADD CONSTRAINT interpretation_interpretationcontext_subtheme_id_key UNIQUE (subtheme_id);


--
-- Name: interpretation_interpretativeproposition interpretation_interpretativeproposition_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretativeproposition
    ADD CONSTRAINT interpretation_interpretativeproposition_pkey PRIMARY KEY (id);


--
-- Name: interpretation_normalizedcode interpretation_normalizedcode_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_normalizedcode
    ADD CONSTRAINT interpretation_normalizedcode_pkey PRIMARY KEY (id);


--
-- Name: interpretation_interpretationphase interpretation_phase_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretationphase
    ADD CONSTRAINT interpretation_phase_pkey PRIMARY KEY (id);


--
-- Name: interpretation_interpretationphase interpretation_phase_project_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretationphase
    ADD CONSTRAINT interpretation_phase_project_id_key UNIQUE (project_id);


--
-- Name: interpretation_subtheme interpretation_subtheme_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_subtheme
    ADD CONSTRAINT interpretation_subtheme_pkey PRIMARY KEY (id);


--
-- Name: interpretation_theme interpretation_theme_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_theme
    ADD CONSTRAINT interpretation_theme_pkey PRIMARY KEY (id);


--
-- Name: interpretation_themediscoveryproposal_codes_used interpretation_themedisc_themediscoveryproposal_i_e0c67ed4_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_themediscoveryproposal_codes_used
    ADD CONSTRAINT interpretation_themedisc_themediscoveryproposal_i_e0c67ed4_uniq UNIQUE (themediscoveryproposal_id, normalizedcode_id);


--
-- Name: interpretation_themediscoveryproposal_codes_used interpretation_themediscoveryproposal_codes_used_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_themediscoveryproposal_codes_used
    ADD CONSTRAINT interpretation_themediscoveryproposal_codes_used_pkey PRIMARY KEY (id);


--
-- Name: interpretation_themediscoveryproposal interpretation_themediscoveryproposal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_themediscoveryproposal
    ADD CONSTRAINT interpretation_themediscoveryproposal_pkey PRIMARY KEY (id);


--
-- Name: notification_notification notification_notification_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_notification
    ADD CONSTRAINT notification_notification_pkey PRIMARY KEY (id);


--
-- Name: project_expectedresult project_expectedresult_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_expectedresult
    ADD CONSTRAINT project_expectedresult_pkey PRIMARY KEY (id);


--
-- Name: project_membership project_membership_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_membership
    ADD CONSTRAINT project_membership_pkey PRIMARY KEY (id);


--
-- Name: project_membership project_membership_project_id_user_id_3dd1c005_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_membership
    ADD CONSTRAINT project_membership_project_id_user_id_3dd1c005_uniq UNIQUE (project_id, user_id);


--
-- Name: project_project project_project_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_project
    ADD CONSTRAINT project_project_pkey PRIMARY KEY (id);


--
-- Name: project_researchframework project_researchframework_name_assigned_by_id_f28c404a_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_researchframework
    ADD CONSTRAINT project_researchframework_name_assigned_by_id_f28c404a_uniq UNIQUE (name, assigned_by_id);


--
-- Name: project_researchframework project_researchframework_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_researchframework
    ADD CONSTRAINT project_researchframework_pkey PRIMARY KEY (id);


--
-- Name: project_specificobjective project_specificobjective_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_specificobjective
    ADD CONSTRAINT project_specificobjective_pkey PRIMARY KEY (id);


--
-- Name: selection_conflictresolution selection_conflictresolu_selection_phase_id_paper_0f926fd8_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_conflictresolution
    ADD CONSTRAINT selection_conflictresolu_selection_phase_id_paper_0f926fd8_uniq UNIQUE (selection_phase_id, paper_id, stage);


--
-- Name: selection_conflictresolution selection_conflictresolution_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_conflictresolution
    ADD CONSTRAINT selection_conflictresolution_pkey PRIMARY KEY (id);


--
-- Name: selection_paperassignment selection_paperassignmen_selection_phase_id_paper_86d4c8fa_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_paperassignment
    ADD CONSTRAINT selection_paperassignmen_selection_phase_id_paper_86d4c8fa_uniq UNIQUE (selection_phase_id, paper_id, researcher_id, stage);


--
-- Name: selection_paperassignment selection_paperassignment_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_paperassignment
    ADD CONSTRAINT selection_paperassignment_pkey PRIMARY KEY (id);


--
-- Name: selection_paperreview selection_paperreview_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_paperreview
    ADD CONSTRAINT selection_paperreview_pkey PRIMARY KEY (id);


--
-- Name: selection_selectionphase selection_selectionphase_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_selectionphase
    ADD CONSTRAINT selection_selectionphase_pkey PRIMARY KEY (project_id);


--
-- Name: acquisition_doi_a7fad2_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_doi_a7fad2_idx ON public.acquisition_study USING btree (doi);


--
-- Name: acquisition_execute_3e30f0_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_execute_3e30f0_idx ON public.acquisition_search_execution USING btree (executed_by_id, executed_at DESC);


--
-- Name: acquisition_executi_d70717_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_executi_d70717_idx ON public.acquisition_execution_study USING btree (execution_id, is_new);


--
-- Name: acquisition_execution_study_execution_id_e11114d6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_execution_study_execution_id_e11114d6 ON public.acquisition_execution_study USING btree (execution_id);


--
-- Name: acquisition_execution_study_study_id_9fa0774b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_execution_study_study_id_9fa0774b ON public.acquisition_execution_study USING btree (study_id);


--
-- Name: acquisition_search_execution_executed_by_id_195902da; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_search_execution_executed_by_id_195902da ON public.acquisition_search_execution USING btree (executed_by_id);


--
-- Name: acquisition_search_execution_strategy_id_6332a6ee; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_search_execution_strategy_id_6332a6ee ON public.acquisition_search_execution USING btree (strategy_id);


--
-- Name: acquisition_source_43e6d1_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_source_43e6d1_idx ON public.acquisition_study USING btree (source, title);


--
-- Name: acquisition_status_a5df28_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_status_a5df28_idx ON public.acquisition_study USING btree (status);


--
-- Name: acquisition_strateg_073e3b_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_strateg_073e3b_idx ON public.acquisition_search_execution USING btree (strategy_id, executed_at DESC);


--
-- Name: acquisition_study_doi_faf841c6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_study_doi_faf841c6 ON public.acquisition_study USING btree (doi);


--
-- Name: acquisition_study_doi_faf841c6_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_study_doi_faf841c6_like ON public.acquisition_study USING btree (doi varchar_pattern_ops);


--
-- Name: acquisition_study_i_d65d4b_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_study_i_d65d4b_idx ON public.acquisition_execution_study USING btree (study_id);


--
-- Name: acquisition_study_status_67216e21; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_study_status_67216e21 ON public.acquisition_study USING btree (status);


--
-- Name: acquisition_study_status_67216e21_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_study_status_67216e21_like ON public.acquisition_study USING btree (status varchar_pattern_ops);


--
-- Name: acquisition_study_year_398e9477; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_study_year_398e9477 ON public.acquisition_study USING btree (year);


--
-- Name: acquisition_year_f6b04e_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX acquisition_year_f6b04e_idx ON public.acquisition_study USING btree (year);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


--
-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);


--
-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops);


--
-- Name: design_designstagelog_phase_id_be4b9409; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_designstagelog_phase_id_be4b9409 ON public.design_designstagelog USING btree (phase_id);


--
-- Name: design_designstageplan_phase_id_eb14f9c8; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_designstageplan_phase_id_eb14f9c8 ON public.design_designstageplan USING btree (phase_id);


--
-- Name: design_eligibilitycriterion_design_phase_id_fdb27ca8; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_eligibilitycriterion_design_phase_id_fdb27ca8 ON public.design_eligibilitycriterion USING btree (design_phase_id);


--
-- Name: design_eligibilitycriterion_last_modified_by_id_900da8a3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_eligibilitycriterion_last_modified_by_id_900da8a3 ON public.design_eligibilitycriterion USING btree (last_modified_by_id);


--
-- Name: design_eligibilitycriterion_researcher_id_31d0c9f7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_eligibilitycriterion_researcher_id_31d0c9f7 ON public.design_eligibilitycriterion USING btree (researcher_id);


--
-- Name: design_eligibilitycriterion_reviewed_by_id_24f5ea89; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_eligibilitycriterion_reviewed_by_id_24f5ea89 ON public.design_eligibilitycriterion USING btree (reviewed_by_id);


--
-- Name: design_exclusionterm_strategy_id_b6a087ee; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_exclusionterm_strategy_id_b6a087ee ON public.design_exclusionterm USING btree (strategy_id);


--
-- Name: design_keyword_project_keyword_id_dd4bd00c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_keyword_project_keyword_id_dd4bd00c ON public.design_keyword USING btree (project_keyword_id);


--
-- Name: design_keyword_strategy_id_e3de75fb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_keyword_strategy_id_e3de75fb ON public.design_keyword USING btree (strategy_id);


--
-- Name: design_projectkeyword_design_phase_id_785c66ce; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_projectkeyword_design_phase_id_785c66ce ON public.design_projectkeyword USING btree (design_phase_id);


--
-- Name: design_researchquestion_design_phase_id_0c287714; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_researchquestion_design_phase_id_0c287714 ON public.design_researchquestion USING btree (design_phase_id);


--
-- Name: design_researchquestion_last_modified_by_id_6ab80505; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_researchquestion_last_modified_by_id_6ab80505 ON public.design_researchquestion USING btree (last_modified_by_id);


--
-- Name: design_researchquestion_researcher_id_cbe036aa; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_researchquestion_researcher_id_cbe036aa ON public.design_researchquestion USING btree (researcher_id);


--
-- Name: design_researchquestion_reviewed_by_id_0a1f13bb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_researchquestion_reviewed_by_id_0a1f13bb ON public.design_researchquestion USING btree (reviewed_by_id);


--
-- Name: design_searchstrategy_created_by_id_1cf240ae; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_searchstrategy_created_by_id_1cf240ae ON public.design_searchstrategy USING btree (created_by_id);


--
-- Name: design_searchstrategy_last_modified_by_id_d2e5ee57; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_searchstrategy_last_modified_by_id_d2e5ee57 ON public.design_searchstrategy USING btree (last_modified_by_id);


--
-- Name: design_searchstrategy_research_question_id_e693f1f6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_searchstrategy_research_question_id_e693f1f6 ON public.design_searchstrategy USING btree (research_question_id);


--
-- Name: design_searchstrategy_reviewed_by_id_b5fe1ae9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_searchstrategy_reviewed_by_id_b5fe1ae9 ON public.design_searchstrategy USING btree (reviewed_by_id);


--
-- Name: design_searchstrategyversion_created_by_id_a5b0412f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_searchstrategyversion_created_by_id_a5b0412f ON public.design_searchstrategyversion USING btree (created_by_id);


--
-- Name: design_searchstrategyversion_strategy_id_c30485bd; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX design_searchstrategyversion_strategy_id_c30485bd ON public.design_searchstrategyversion USING btree (strategy_id);


--
-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);


--
-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);


--
-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: extraction_extractionphase_project_id_7df4ba5a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_extractionphase_project_id_7df4ba5a ON public.extraction_extractionphase USING btree (project_id);


--
-- Name: extraction_paperextraction_assigned_to_id_c506a2aa; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_paperextraction_assigned_to_id_c506a2aa ON public.extraction_paperextraction USING btree (assigned_to_id);


--
-- Name: extraction_paperextraction_extraction_phase_id_3940c7b0; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_paperextraction_extraction_phase_id_3940c7b0 ON public.extraction_paperextraction USING btree (extraction_phase_id);


--
-- Name: extraction_paperextraction_study_id_421286bb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_paperextraction_study_id_421286bb ON public.extraction_paperextraction USING btree (study_id);


--
-- Name: extraction_quote_created_by_id_3f16a41a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_quote_created_by_id_3f16a41a ON public.extraction_quote USING btree (created_by_id);


--
-- Name: extraction_quote_paper_extraction_id_95e6463f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_quote_paper_extraction_id_95e6463f ON public.extraction_quote USING btree (paper_extraction_id);


--
-- Name: extraction_quote_tags_quote_id_9c1fec46; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_quote_tags_quote_id_9c1fec46 ON public.extraction_quote_tags USING btree (quote_id);


--
-- Name: extraction_quote_tags_tag_id_856fd930; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_quote_tags_tag_id_856fd930 ON public.extraction_quote_tags USING btree (tag_id);


--
-- Name: extraction_tag_created_by_id_3688b30e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_tag_created_by_id_3688b30e ON public.extraction_tag USING btree (created_by_id);


--
-- Name: extraction_tag_extraction_phase_id_56cc6070; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_tag_extraction_phase_id_56cc6070 ON public.extraction_tag USING btree (extraction_phase_id);


--
-- Name: extraction_tag_rq_related_id_197f00cc; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX extraction_tag_rq_related_id_197f00cc ON public.extraction_tag USING btree (rq_related_id);


--
-- Name: interpretation_analysistrace_created_by_id_cc033d24; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_analysistrace_created_by_id_cc033d24 ON public.interpretation_analysistrace USING btree (created_by_id);


--
-- Name: interpretation_analysistrace_project_id_c0ab7c37; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_analysistrace_project_id_c0ab7c37 ON public.interpretation_analysistrace USING btree (project_id);


--
-- Name: interpretation_codenormali_reviewed_by_id_7ad62778; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_codenormali_reviewed_by_id_7ad62778 ON public.interpretation_codenormalizationproposal USING btree (reviewed_by_id);


--
-- Name: interpretation_codenormalizationproposal_project_id_ba94a65f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_codenormalizationproposal_project_id_ba94a65f ON public.interpretation_codenormalizationproposal USING btree (project_id);


--
-- Name: interpretation_conversationtrace_context_id_d85d79ad; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_conversationtrace_context_id_d85d79ad ON public.interpretation_conversationtrace USING btree (context_id);


--
-- Name: interpretation_initialcode_code_276fb729_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_initialcode_code_276fb729_like ON public.interpretation_initialcode USING btree (code varchar_pattern_ops);


--
-- Name: interpretation_initialcode_project_id_5aee32bb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_initialcode_project_id_5aee32bb ON public.interpretation_initialcode USING btree (project_id);


--
-- Name: interpretation_interpretat_conversation_trace_id_45c18d32; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_interpretat_conversation_trace_id_45c18d32 ON public.interpretation_interpretativeproposition USING btree (conversation_trace_id);


--
-- Name: interpretation_interpretativeproposition_researcher_id_34144a36; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_interpretativeproposition_researcher_id_34144a36 ON public.interpretation_interpretativeproposition USING btree (researcher_id);


--
-- Name: interpretation_interpretativeproposition_subtheme_id_09d5c2b0; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_interpretativeproposition_subtheme_id_09d5c2b0 ON public.interpretation_interpretativeproposition USING btree (subtheme_id);


--
-- Name: interpretation_normalizedcode_project_id_11cc913c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_normalizedcode_project_id_11cc913c ON public.interpretation_normalizedcode USING btree (project_id);


--
-- Name: interpretation_normalizedcode_proposal_id_1e417e4d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_normalizedcode_proposal_id_1e417e4d ON public.interpretation_normalizedcode USING btree (proposal_id);


--
-- Name: interpretation_subtheme_theme_id_7c51c77a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_subtheme_theme_id_7c51c77a ON public.interpretation_subtheme USING btree (theme_id);


--
-- Name: interpretation_theme_created_by_id_b53b7aca; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_theme_created_by_id_b53b7aca ON public.interpretation_theme USING btree (created_by_id);


--
-- Name: interpretation_theme_project_id_bc17867a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_theme_project_id_bc17867a ON public.interpretation_theme USING btree (project_id);


--
-- Name: interpretation_themediscov_normalizedcode_id_32dc24f3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_themediscov_normalizedcode_id_32dc24f3 ON public.interpretation_themediscoveryproposal_codes_used USING btree (normalizedcode_id);


--
-- Name: interpretation_themediscov_themediscoveryproposal_id_62a20986; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_themediscov_themediscoveryproposal_id_62a20986 ON public.interpretation_themediscoveryproposal_codes_used USING btree (themediscoveryproposal_id);


--
-- Name: interpretation_themediscoveryproposal_project_id_8be87c0d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_themediscoveryproposal_project_id_8be87c0d ON public.interpretation_themediscoveryproposal USING btree (project_id);


--
-- Name: interpretation_themediscoveryproposal_reviewed_by_id_f31dc897; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX interpretation_themediscoveryproposal_reviewed_by_id_f31dc897 ON public.interpretation_themediscoveryproposal USING btree (reviewed_by_id);


--
-- Name: notification_notification_project_id_1472e88c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX notification_notification_project_id_1472e88c ON public.notification_notification USING btree (project_id);


--
-- Name: notification_notification_recipient_id_e4007781; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX notification_notification_recipient_id_e4007781 ON public.notification_notification USING btree (recipient_id);


--
-- Name: notification_notification_sender_id_1f59f8e1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX notification_notification_sender_id_1f59f8e1 ON public.notification_notification USING btree (sender_id);


--
-- Name: project_expectedresult_project_id_959534c8; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX project_expectedresult_project_id_959534c8 ON public.project_expectedresult USING btree (project_id);


--
-- Name: project_membership_project_id_9fe9cb1e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX project_membership_project_id_9fe9cb1e ON public.project_membership USING btree (project_id);


--
-- Name: project_membership_user_id_5e2854b2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX project_membership_user_id_5e2854b2 ON public.project_membership USING btree (user_id);


--
-- Name: project_project_owner_id_d43b0a83; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX project_project_owner_id_d43b0a83 ON public.project_project USING btree (owner_id);


--
-- Name: project_project_research_framework_id_a920df58; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX project_project_research_framework_id_a920df58 ON public.project_project USING btree (research_framework_id);


--
-- Name: project_researchframework_assigned_by_id_6f7b27ed; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX project_researchframework_assigned_by_id_6f7b27ed ON public.project_researchframework USING btree (assigned_by_id);


--
-- Name: project_specificobjective_project_id_9cd05eaf; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX project_specificobjective_project_id_9cd05eaf ON public.project_specificobjective USING btree (project_id);


--
-- Name: selection_conflictresolution_resolved_by_id_69bef5a9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX selection_conflictresolution_resolved_by_id_69bef5a9 ON public.selection_conflictresolution USING btree (resolved_by_id);


--
-- Name: selection_conflictresolution_selection_phase_id_7679606a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX selection_conflictresolution_selection_phase_id_7679606a ON public.selection_conflictresolution USING btree (selection_phase_id);


--
-- Name: selection_conflictresolution_third_reviewer_id_2f1e5e91; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX selection_conflictresolution_third_reviewer_id_2f1e5e91 ON public.selection_conflictresolution USING btree (third_reviewer_id);


--
-- Name: selection_paperassignment_researcher_id_e59b7e4c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX selection_paperassignment_researcher_id_e59b7e4c ON public.selection_paperassignment USING btree (researcher_id);


--
-- Name: selection_paperassignment_selection_phase_id_94ee7241; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX selection_paperassignment_selection_phase_id_94ee7241 ON public.selection_paperassignment USING btree (selection_phase_id);


--
-- Name: selection_paperreview_assignment_id_341d3bd1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX selection_paperreview_assignment_id_341d3bd1 ON public.selection_paperreview USING btree (assignment_id);


--
-- Name: acquisition_execution_study acquisition_executio_execution_id_e11114d6_fk_acquisiti; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acquisition_execution_study
    ADD CONSTRAINT acquisition_executio_execution_id_e11114d6_fk_acquisiti FOREIGN KEY (execution_id) REFERENCES public.acquisition_search_execution(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: acquisition_execution_study acquisition_executio_study_id_9fa0774b_fk_acquisiti; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acquisition_execution_study
    ADD CONSTRAINT acquisition_executio_study_id_9fa0774b_fk_acquisiti FOREIGN KEY (study_id) REFERENCES public.acquisition_study(uuid) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: acquisition_search_execution acquisition_search_e_executed_by_id_195902da_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acquisition_search_execution
    ADD CONSTRAINT acquisition_search_e_executed_by_id_195902da_fk_auth_user FOREIGN KEY (executed_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: acquisition_search_execution acquisition_search_e_strategy_id_6332a6ee_fk_design_se; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.acquisition_search_execution
    ADD CONSTRAINT acquisition_search_e_strategy_id_6332a6ee_fk_design_se FOREIGN KEY (strategy_id) REFERENCES public.design_searchstrategy(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_designphase design_designphase_project_id_9aa5724b_fk_project_project_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_designphase
    ADD CONSTRAINT design_designphase_project_id_9aa5724b_fk_project_project_id FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_designstagelog design_designstagelo_phase_id_be4b9409_fk_design_de; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_designstagelog
    ADD CONSTRAINT design_designstagelo_phase_id_be4b9409_fk_design_de FOREIGN KEY (phase_id) REFERENCES public.design_designphase(project_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_designstageplan design_designstagepl_phase_id_eb14f9c8_fk_design_de; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_designstageplan
    ADD CONSTRAINT design_designstagepl_phase_id_eb14f9c8_fk_design_de FOREIGN KEY (phase_id) REFERENCES public.design_designphase(project_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_eligibilitycriterion design_eligibilitycr_design_phase_id_fdb27ca8_fk_design_de; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_eligibilitycriterion
    ADD CONSTRAINT design_eligibilitycr_design_phase_id_fdb27ca8_fk_design_de FOREIGN KEY (design_phase_id) REFERENCES public.design_designphase(project_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_eligibilitycriterion design_eligibilitycr_last_modified_by_id_900da8a3_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_eligibilitycriterion
    ADD CONSTRAINT design_eligibilitycr_last_modified_by_id_900da8a3_fk_auth_user FOREIGN KEY (last_modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_eligibilitycriterion design_eligibilitycr_researcher_id_31d0c9f7_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_eligibilitycriterion
    ADD CONSTRAINT design_eligibilitycr_researcher_id_31d0c9f7_fk_auth_user FOREIGN KEY (researcher_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_eligibilitycriterion design_eligibilitycr_reviewed_by_id_24f5ea89_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_eligibilitycriterion
    ADD CONSTRAINT design_eligibilitycr_reviewed_by_id_24f5ea89_fk_auth_user FOREIGN KEY (reviewed_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_exclusionterm design_exclusionterm_strategy_id_b6a087ee_fk_design_se; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_exclusionterm
    ADD CONSTRAINT design_exclusionterm_strategy_id_b6a087ee_fk_design_se FOREIGN KEY (strategy_id) REFERENCES public.design_searchstrategy(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_keyword design_keyword_project_keyword_id_dd4bd00c_fk_design_pr; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_keyword
    ADD CONSTRAINT design_keyword_project_keyword_id_dd4bd00c_fk_design_pr FOREIGN KEY (project_keyword_id) REFERENCES public.design_projectkeyword(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_keyword design_keyword_strategy_id_e3de75fb_fk_design_searchstrategy_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_keyword
    ADD CONSTRAINT design_keyword_strategy_id_e3de75fb_fk_design_searchstrategy_id FOREIGN KEY (strategy_id) REFERENCES public.design_searchstrategy(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_projectkeyword design_projectkeywor_design_phase_id_785c66ce_fk_design_de; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_projectkeyword
    ADD CONSTRAINT design_projectkeywor_design_phase_id_785c66ce_fk_design_de FOREIGN KEY (design_phase_id) REFERENCES public.design_designphase(project_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_researchquestion design_researchquest_design_phase_id_0c287714_fk_design_de; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_researchquestion
    ADD CONSTRAINT design_researchquest_design_phase_id_0c287714_fk_design_de FOREIGN KEY (design_phase_id) REFERENCES public.design_designphase(project_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_researchquestion design_researchquest_last_modified_by_id_6ab80505_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_researchquestion
    ADD CONSTRAINT design_researchquest_last_modified_by_id_6ab80505_fk_auth_user FOREIGN KEY (last_modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_researchquestion design_researchquestion_researcher_id_cbe036aa_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_researchquestion
    ADD CONSTRAINT design_researchquestion_researcher_id_cbe036aa_fk_auth_user_id FOREIGN KEY (researcher_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_researchquestion design_researchquestion_reviewed_by_id_0a1f13bb_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_researchquestion
    ADD CONSTRAINT design_researchquestion_reviewed_by_id_0a1f13bb_fk_auth_user_id FOREIGN KEY (reviewed_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_searchstrategyversion design_searchstrateg_created_by_id_a5b0412f_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategyversion
    ADD CONSTRAINT design_searchstrateg_created_by_id_a5b0412f_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_searchstrategy design_searchstrateg_last_modified_by_id_d2e5ee57_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategy
    ADD CONSTRAINT design_searchstrateg_last_modified_by_id_d2e5ee57_fk_auth_user FOREIGN KEY (last_modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_searchstrategy design_searchstrateg_research_question_id_e693f1f6_fk_design_re; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategy
    ADD CONSTRAINT design_searchstrateg_research_question_id_e693f1f6_fk_design_re FOREIGN KEY (research_question_id) REFERENCES public.design_researchquestion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_searchstrategyversion design_searchstrateg_strategy_id_c30485bd_fk_design_se; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategyversion
    ADD CONSTRAINT design_searchstrateg_strategy_id_c30485bd_fk_design_se FOREIGN KEY (strategy_id) REFERENCES public.design_searchstrategy(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_searchstrategy design_searchstrategy_created_by_id_1cf240ae_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategy
    ADD CONSTRAINT design_searchstrategy_created_by_id_1cf240ae_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: design_searchstrategy design_searchstrategy_reviewed_by_id_b5fe1ae9_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.design_searchstrategy
    ADD CONSTRAINT design_searchstrategy_reviewed_by_id_b5fe1ae9_fk_auth_user_id FOREIGN KEY (reviewed_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_extractionphase extraction_extractio_project_id_7df4ba5a_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_extractionphase
    ADD CONSTRAINT extraction_extractio_project_id_7df4ba5a_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_paperextraction extraction_paperextr_assigned_to_id_c506a2aa_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_paperextraction
    ADD CONSTRAINT extraction_paperextr_assigned_to_id_c506a2aa_fk_auth_user FOREIGN KEY (assigned_to_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_paperextraction extraction_paperextr_extraction_phase_id_3940c7b0_fk_extractio; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_paperextraction
    ADD CONSTRAINT extraction_paperextr_extraction_phase_id_3940c7b0_fk_extractio FOREIGN KEY (extraction_phase_id) REFERENCES public.extraction_extractionphase(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_paperextraction extraction_paperextr_study_id_421286bb_fk_acquisiti; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_paperextraction
    ADD CONSTRAINT extraction_paperextr_study_id_421286bb_fk_acquisiti FOREIGN KEY (study_id) REFERENCES public.acquisition_study(uuid) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_quote extraction_quote_created_by_id_3f16a41a_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_quote
    ADD CONSTRAINT extraction_quote_created_by_id_3f16a41a_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_quote extraction_quote_paper_extraction_id_95e6463f_fk_extractio; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_quote
    ADD CONSTRAINT extraction_quote_paper_extraction_id_95e6463f_fk_extractio FOREIGN KEY (paper_extraction_id) REFERENCES public.extraction_paperextraction(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_quote_tags extraction_quote_tags_quote_id_9c1fec46_fk_extraction_quote_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_quote_tags
    ADD CONSTRAINT extraction_quote_tags_quote_id_9c1fec46_fk_extraction_quote_id FOREIGN KEY (quote_id) REFERENCES public.extraction_quote(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_quote_tags extraction_quote_tags_tag_id_856fd930_fk_extraction_tag_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_quote_tags
    ADD CONSTRAINT extraction_quote_tags_tag_id_856fd930_fk_extraction_tag_id FOREIGN KEY (tag_id) REFERENCES public.extraction_tag(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_tag extraction_tag_created_by_id_3688b30e_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_tag
    ADD CONSTRAINT extraction_tag_created_by_id_3688b30e_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_tag extraction_tag_extraction_phase_id_56cc6070_fk_extractio; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_tag
    ADD CONSTRAINT extraction_tag_extraction_phase_id_56cc6070_fk_extractio FOREIGN KEY (extraction_phase_id) REFERENCES public.extraction_extractionphase(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: extraction_tag extraction_tag_rq_related_id_197f00cc_fk_design_re; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.extraction_tag
    ADD CONSTRAINT extraction_tag_rq_related_id_197f00cc_fk_design_re FOREIGN KEY (rq_related_id) REFERENCES public.design_researchquestion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_analysistrace interpretation_analy_created_by_id_cc033d24_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_analysistrace
    ADD CONSTRAINT interpretation_analy_created_by_id_cc033d24_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_analysistrace interpretation_analy_project_id_c0ab7c37_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_analysistrace
    ADD CONSTRAINT interpretation_analy_project_id_c0ab7c37_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_codenormalizationproposal interpretation_coden_project_id_ba94a65f_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_codenormalizationproposal
    ADD CONSTRAINT interpretation_coden_project_id_ba94a65f_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_codenormalizationproposal interpretation_coden_reviewed_by_id_7ad62778_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_codenormalizationproposal
    ADD CONSTRAINT interpretation_coden_reviewed_by_id_7ad62778_fk_auth_user FOREIGN KEY (reviewed_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_conversationtrace interpretation_conve_context_id_d85d79ad_fk_interpret; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_conversationtrace
    ADD CONSTRAINT interpretation_conve_context_id_d85d79ad_fk_interpret FOREIGN KEY (context_id) REFERENCES public.interpretation_interpretationcontext(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_initialcode interpretation_initi_project_id_5aee32bb_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_initialcode
    ADD CONSTRAINT interpretation_initi_project_id_5aee32bb_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_interpretativeproposition interpretation_inter_conversation_trace_i_45c18d32_fk_interpret; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretativeproposition
    ADD CONSTRAINT interpretation_inter_conversation_trace_i_45c18d32_fk_interpret FOREIGN KEY (conversation_trace_id) REFERENCES public.interpretation_conversationtrace(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_interpretativeproposition interpretation_inter_researcher_id_34144a36_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretativeproposition
    ADD CONSTRAINT interpretation_inter_researcher_id_34144a36_fk_auth_user FOREIGN KEY (researcher_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_interpretativeproposition interpretation_inter_subtheme_id_09d5c2b0_fk_interpret; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretativeproposition
    ADD CONSTRAINT interpretation_inter_subtheme_id_09d5c2b0_fk_interpret FOREIGN KEY (subtheme_id) REFERENCES public.interpretation_subtheme(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_interpretationcontext interpretation_inter_subtheme_id_a92861f7_fk_interpret; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretationcontext
    ADD CONSTRAINT interpretation_inter_subtheme_id_a92861f7_fk_interpret FOREIGN KEY (subtheme_id) REFERENCES public.interpretation_subtheme(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_normalizedcode interpretation_norma_project_id_11cc913c_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_normalizedcode
    ADD CONSTRAINT interpretation_norma_project_id_11cc913c_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_normalizedcode interpretation_norma_proposal_id_1e417e4d_fk_interpret; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_normalizedcode
    ADD CONSTRAINT interpretation_norma_proposal_id_1e417e4d_fk_interpret FOREIGN KEY (proposal_id) REFERENCES public.interpretation_codenormalizationproposal(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_interpretationphase interpretation_phase_project_id_676189b3_fk_project_project_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_interpretationphase
    ADD CONSTRAINT interpretation_phase_project_id_676189b3_fk_project_project_id FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_subtheme interpretation_subth_theme_id_7c51c77a_fk_interpret; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_subtheme
    ADD CONSTRAINT interpretation_subth_theme_id_7c51c77a_fk_interpret FOREIGN KEY (theme_id) REFERENCES public.interpretation_theme(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_theme interpretation_theme_created_by_id_b53b7aca_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_theme
    ADD CONSTRAINT interpretation_theme_created_by_id_b53b7aca_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_themediscoveryproposal_codes_used interpretation_theme_normalizedcode_id_32dc24f3_fk_interpret; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_themediscoveryproposal_codes_used
    ADD CONSTRAINT interpretation_theme_normalizedcode_id_32dc24f3_fk_interpret FOREIGN KEY (normalizedcode_id) REFERENCES public.interpretation_normalizedcode(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_themediscoveryproposal interpretation_theme_project_id_8be87c0d_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_themediscoveryproposal
    ADD CONSTRAINT interpretation_theme_project_id_8be87c0d_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_theme interpretation_theme_project_id_bc17867a_fk_project_project_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_theme
    ADD CONSTRAINT interpretation_theme_project_id_bc17867a_fk_project_project_id FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_themediscoveryproposal interpretation_theme_reviewed_by_id_f31dc897_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_themediscoveryproposal
    ADD CONSTRAINT interpretation_theme_reviewed_by_id_f31dc897_fk_auth_user FOREIGN KEY (reviewed_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: interpretation_themediscoveryproposal_codes_used interpretation_theme_themediscoverypropos_62a20986_fk_interpret; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.interpretation_themediscoveryproposal_codes_used
    ADD CONSTRAINT interpretation_theme_themediscoverypropos_62a20986_fk_interpret FOREIGN KEY (themediscoveryproposal_id) REFERENCES public.interpretation_themediscoveryproposal(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: notification_notification notification_notific_project_id_1472e88c_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_notification
    ADD CONSTRAINT notification_notific_project_id_1472e88c_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: notification_notification notification_notification_recipient_id_e4007781_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_notification
    ADD CONSTRAINT notification_notification_recipient_id_e4007781_fk_auth_user_id FOREIGN KEY (recipient_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: notification_notification notification_notification_sender_id_1f59f8e1_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.notification_notification
    ADD CONSTRAINT notification_notification_sender_id_1f59f8e1_fk_auth_user_id FOREIGN KEY (sender_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: project_expectedresult project_expectedresu_project_id_959534c8_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_expectedresult
    ADD CONSTRAINT project_expectedresu_project_id_959534c8_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: project_membership project_membership_project_id_9fe9cb1e_fk_project_project_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_membership
    ADD CONSTRAINT project_membership_project_id_9fe9cb1e_fk_project_project_id FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: project_membership project_membership_user_id_5e2854b2_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_membership
    ADD CONSTRAINT project_membership_user_id_5e2854b2_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: project_project project_project_owner_id_d43b0a83_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_project
    ADD CONSTRAINT project_project_owner_id_d43b0a83_fk_auth_user_id FOREIGN KEY (owner_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: project_project project_project_research_framework_i_a920df58_fk_project_r; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_project
    ADD CONSTRAINT project_project_research_framework_i_a920df58_fk_project_r FOREIGN KEY (research_framework_id) REFERENCES public.project_researchframework(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: project_researchframework project_researchfram_assigned_by_id_6f7b27ed_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_researchframework
    ADD CONSTRAINT project_researchfram_assigned_by_id_6f7b27ed_fk_auth_user FOREIGN KEY (assigned_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: project_specificobjective project_specificobje_project_id_9cd05eaf_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.project_specificobjective
    ADD CONSTRAINT project_specificobje_project_id_9cd05eaf_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: selection_conflictresolution selection_conflictre_resolved_by_id_69bef5a9_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_conflictresolution
    ADD CONSTRAINT selection_conflictre_resolved_by_id_69bef5a9_fk_auth_user FOREIGN KEY (resolved_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: selection_conflictresolution selection_conflictre_selection_phase_id_7679606a_fk_selection; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_conflictresolution
    ADD CONSTRAINT selection_conflictre_selection_phase_id_7679606a_fk_selection FOREIGN KEY (selection_phase_id) REFERENCES public.selection_selectionphase(project_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: selection_conflictresolution selection_conflictre_third_reviewer_id_2f1e5e91_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_conflictresolution
    ADD CONSTRAINT selection_conflictre_third_reviewer_id_2f1e5e91_fk_auth_user FOREIGN KEY (third_reviewer_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: selection_paperassignment selection_paperassig_researcher_id_e59b7e4c_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_paperassignment
    ADD CONSTRAINT selection_paperassig_researcher_id_e59b7e4c_fk_auth_user FOREIGN KEY (researcher_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: selection_paperassignment selection_paperassig_selection_phase_id_94ee7241_fk_selection; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_paperassignment
    ADD CONSTRAINT selection_paperassig_selection_phase_id_94ee7241_fk_selection FOREIGN KEY (selection_phase_id) REFERENCES public.selection_selectionphase(project_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: selection_paperreview selection_paperrevie_assignment_id_341d3bd1_fk_selection; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_paperreview
    ADD CONSTRAINT selection_paperrevie_assignment_id_341d3bd1_fk_selection FOREIGN KEY (assignment_id) REFERENCES public.selection_paperassignment(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: selection_selectionphase selection_selectionp_project_id_a3ebbd1f_fk_project_p; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.selection_selectionphase
    ADD CONSTRAINT selection_selectionp_project_id_a3ebbd1f_fk_project_p FOREIGN KEY (project_id) REFERENCES public.project_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- PostgreSQL database dump complete
--

\unrestrict uoqd7Now35NwkcVrkRXzi1NRLN7IGh6yvK8B9WRXxcmjo2wtWa2IuMBV7NKjI2z