--
--





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

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


ALTER TABLE public.auth_group OWNER TO admin;

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

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


ALTER TABLE public.auth_group_id_seq OWNER TO admin;

--
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.auth_group_id_seq OWNED BY public.auth_group.id;


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

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


ALTER TABLE public.auth_group_permissions OWNER TO admin;

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

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


ALTER TABLE public.auth_group_permissions_id_seq OWNER TO admin;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.auth_group_permissions_id_seq OWNED BY public.auth_group_permissions.id;


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

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 admin;

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

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


ALTER TABLE public.auth_permission_id_seq OWNER TO admin;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.auth_permission_id_seq OWNED BY public.auth_permission.id;


--
-- Name: client_compositecompanydocument; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.client_compositecompanydocument (
    id integer NOT NULL,
    file character varying(500) NOT NULL,
    doc_type character varying(100) NOT NULL,
    "position" integer NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    section_company_id integer NOT NULL,
    tag_1_id integer NOT NULL,
    tag_2_id integer NOT NULL
);


ALTER TABLE public.client_compositecompanydocument OWNER TO admin;

--
-- Name: client_compositecompanydocument_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.client_compositecompanydocument_id_seq OWNER TO admin;

--
-- Name: client_compositecompanydocument_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.client_compositecompanydocument_id_seq OWNED BY public.client_compositecompanydocument.id;


--
-- Name: client_compositecompanydocumentclientresponse; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.client_compositecompanydocumentclientresponse (
    id integer NOT NULL,
    comment character varying(2000) NOT NULL,
    file character varying(500) NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    created_at timestamp with time zone NOT NULL,
    document_id integer NOT NULL,
    closed boolean NOT NULL,
    author_id integer NOT NULL
);


ALTER TABLE public.client_compositecompanydocumentclientresponse OWNER TO admin;

--
-- Name: client_compositecompanydocumentclientresponse_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.client_compositecompanydocumentclientresponse_id_seq OWNER TO admin;

--
-- Name: client_compositecompanydocumentclientresponse_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.client_compositecompanydocumentclientresponse_id_seq OWNED BY public.client_compositecompanydocumentclientresponse.id;


--
-- Name: client_compositecompanydocumentclientresponsecomment; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.client_compositecompanydocumentclientresponsecomment (
    id integer NOT NULL,
    comment character varying(2000) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    author_id integer NOT NULL,
    response_id integer NOT NULL,
    file character varying(500) NOT NULL
);


ALTER TABLE public.client_compositecompanydocumentclientresponsecomment OWNER TO admin;

--
-- Name: client_compositecompanydocumentclientresponsecomment_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.client_compositecompanydocumentclientresponsecomment_id_seq OWNER TO admin;

--
-- Name: client_compositecompanydocumentclientresponsecomment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.client_compositecompanydocumentclientresponsecomment_id_seq OWNED BY public.client_compositecompanydocumentclientresponsecomment.id;


--
-- Name: client_compositecompanydocumentconverted; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.client_compositecompanydocumentconverted (
    id integer NOT NULL,
    file character varying(500) NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    document_id integer NOT NULL,
    missing_tags character varying(500) NOT NULL
);


ALTER TABLE public.client_compositecompanydocumentconverted OWNER TO admin;

--
-- Name: client_compositecompanydocumentconverted_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.client_compositecompanydocumentconverted_id_seq OWNER TO admin;

--
-- Name: client_compositecompanydocumentconverted_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.client_compositecompanydocumentconverted_id_seq OWNED BY public.client_compositecompanydocumentconverted.id;


--
-- Name: client_conversionprogress; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.client_conversionprogress (
    file_name character varying(200) NOT NULL,
    progress double precision NOT NULL
);


ALTER TABLE public.client_conversionprogress OWNER TO admin;

--
-- Name: client_sectioncompany; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.client_sectioncompany (
    id integer NOT NULL,
    "position" smallint NOT NULL,
    company_id integer NOT NULL,
    name_postfix_id integer,
    name_prefix_id integer NOT NULL,
    CONSTRAINT client_sectioncompany_position_check CHECK (("position" >= 0))
);


ALTER TABLE public.client_sectioncompany OWNER TO admin;

--
-- Name: client_sectioncompany_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.client_sectioncompany_id_seq OWNER TO admin;

--
-- Name: client_sectioncompany_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.client_sectioncompany_id_seq OWNED BY public.client_sectioncompany.id;


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

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 admin;

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

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


ALTER TABLE public.django_admin_log_id_seq OWNER TO admin;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.django_admin_log_id_seq OWNED BY public.django_admin_log.id;


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

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 admin;

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

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


ALTER TABLE public.django_content_type_id_seq OWNER TO admin;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.django_content_type_id_seq OWNED BY public.django_content_type.id;


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

CREATE TABLE public.django_migrations (
    id integer 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 admin;

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

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


ALTER TABLE public.django_migrations_id_seq OWNER TO admin;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.django_migrations_id_seq OWNED BY public.django_migrations.id;

--
-- Name: qmds_companyuserinvitation; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.qmds_companyuserinvitation (
    id integer NOT NULL,
    company_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.qmds_companyuserinvitation OWNER TO admin;

--
-- Name: qmds_companyuserinvitation_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.qmds_companyuserinvitation_id_seq OWNER TO admin;

--
-- Name: qmds_companyuserinvitation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.qmds_companyuserinvitation_id_seq OWNED BY public.qmds_companyuserinvitation.id;


--
-- Name: qmds_converteddocument; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.qmds_converteddocument (
    source_id integer NOT NULL,
    file character varying(500) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    user_id integer NOT NULL,
    missing_tags character varying(500) NOT NULL
);


ALTER TABLE public.qmds_converteddocument OWNER TO admin;

--
-- Name: qmds_document; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.qmds_document (
    id integer NOT NULL,
    original_file_name character varying(500) NOT NULL,
    file character varying(500) NOT NULL,
    doc_id character varying(50) NOT NULL,
    parent_dir character varying(200) NOT NULL,
    fixed boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.qmds_document OWNER TO admin;

--
-- Name: qmds_document_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.qmds_document_id_seq OWNER TO admin;

--
-- Name: qmds_document_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.qmds_document_id_seq OWNED BY public.qmds_document.id;


--
-- Name: qmds_tag; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.qmds_tag (
    id integer NOT NULL,
    tag character varying(200) NOT NULL,
    tag_type character varying(50) NOT NULL,
    instruction_en character varying(500) NOT NULL,
    default_value_en character varying(500) NOT NULL,
    doc_type character varying(500) NOT NULL,
    value_type character varying(500) NOT NULL,
    comment_en character varying(500) NOT NULL,
    related_document character varying(200) NOT NULL,
    "position" integer NOT NULL,
    parent_id integer,
    comment_de character varying(500) NOT NULL,
    default_value_de character varying(500) NOT NULL,
    instruction_de character varying(500) NOT NULL,
    CONSTRAINT qmds_tag_position_check CHECK (("position" >= 0))
);


ALTER TABLE public.qmds_tag OWNER TO admin;

--
-- Name: qmds_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.qmds_tag_id_seq OWNER TO admin;

--
-- Name: qmds_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.qmds_tag_id_seq OWNED BY public.qmds_tag.id;


--
-- Name: qmds_tagsourcefile; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.qmds_tagsourcefile (
    original_file_name character varying(500) NOT NULL,
    file character varying(500) NOT NULL,
    chosen boolean NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL
);


ALTER TABLE public.qmds_tagsourcefile OWNER TO admin;

--
-- Name: qmds_user_groups; Type: TABLE; Schema: public; Owner: admin
--

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


ALTER TABLE public.qmds_user_groups OWNER TO admin;

--
-- Name: qmds_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.qmds_user_groups_id_seq OWNER TO admin;

--
-- Name: qmds_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.qmds_user_groups_id_seq OWNED BY public.qmds_user_groups.id;


--
-- Name: qmds_user_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.qmds_user_id_seq OWNER TO admin;

--
-- Name: qmds_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.qmds_user_id_seq OWNED BY public.qmds_user.id;


--
-- Name: qmds_user_user_permissions; Type: TABLE; Schema: public; Owner: admin
--

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


ALTER TABLE public.qmds_user_user_permissions OWNER TO admin;

--
-- Name: qmds_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.qmds_user_user_permissions_id_seq OWNER TO admin;

--
-- Name: qmds_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.qmds_user_user_permissions_id_seq OWNED BY public.qmds_user_user_permissions.id;


--
-- Name: questioning_compositedocument; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.questioning_compositedocument (
    id integer NOT NULL,
    file character varying(500) NOT NULL,
    doc_type character varying(100) NOT NULL,
    "position" integer NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    section_id integer NOT NULL,
    tag_1_id integer NOT NULL,
    tag_2_id integer NOT NULL
);


ALTER TABLE public.questioning_compositedocument OWNER TO admin;

--
-- Name: questioning_compositedocument_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.questioning_compositedocument_id_seq OWNER TO admin;

--
-- Name: questioning_compositedocument_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.questioning_compositedocument_id_seq OWNED BY public.questioning_compositedocument.id;


--
-- Name: questioning_compositedocumentconverted; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.questioning_compositedocumentconverted (
    id integer NOT NULL,
    file character varying(500) NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    document_id integer NOT NULL,
    missing_tags character varying(500) NOT NULL
);


ALTER TABLE public.questioning_compositedocumentconverted OWNER TO admin;

--
-- Name: questioning_compositedocumentconverted_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.questioning_compositedocumentconverted_id_seq OWNER TO admin;

--
-- Name: questioning_compositedocumentconverted_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.questioning_compositedocumentconverted_id_seq OWNED BY public.questioning_compositedocumentconverted.id;


--
-- Name: questioning_question; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.questioning_question (
    id integer NOT NULL,
    topic character varying(150) NOT NULL,
    question character varying(300) NOT NULL,
    answers character varying(400)[] NOT NULL,
    correct integer[] NOT NULL,
    comment character varying(300) NOT NULL,
    source_id integer NOT NULL
);


ALTER TABLE public.questioning_question OWNER TO admin;

--
-- Name: questioning_question_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.questioning_question_id_seq OWNER TO admin;

--
-- Name: questioning_question_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.questioning_question_id_seq OWNED BY public.questioning_question.id;


--
-- Name: questioning_question_projects; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.questioning_question_projects (
    id integer NOT NULL,
    question_id integer NOT NULL,
    project_id integer NOT NULL
);


ALTER TABLE public.questioning_question_projects OWNER TO admin;

--
-- Name: questioning_question_projects_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.questioning_question_projects_id_seq OWNER TO admin;

--
-- Name: questioning_question_projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.questioning_question_projects_id_seq OWNED BY public.questioning_question_projects.id;


--
-- Name: questioning_questionssourcefile; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.questioning_questionssourcefile (
    id integer NOT NULL,
    file character varying(500) NOT NULL,
    created_at timestamp with time zone NOT NULL
);


ALTER TABLE public.questioning_questionssourcefile OWNER TO admin;

--
-- Name: questioning_questionssourcefile_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.questioning_questionssourcefile_id_seq OWNER TO admin;

--
-- Name: questioning_questionssourcefile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.questioning_questionssourcefile_id_seq OWNED BY public.questioning_questionssourcefile.id;


--
-- Name: questioning_resulttest; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.questioning_resulttest (
    id integer NOT NULL,
    result double precision NOT NULL,
    created_at timestamp with time zone NOT NULL,
    testee_id integer NOT NULL,
    duration double precision NOT NULL
);


ALTER TABLE public.questioning_resulttest OWNER TO admin;

--
-- Name: questioning_resulttest_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.questioning_resulttest_id_seq OWNER TO admin;

--
-- Name: questioning_resulttest_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.questioning_resulttest_id_seq OWNED BY public.questioning_resulttest.id;


--
-- Name: questioning_section; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.questioning_section (
    id integer NOT NULL,
    "position" smallint NOT NULL,
    name_postfix_id integer,
    name_prefix_id integer NOT NULL,
    project_id integer NOT NULL,
    CONSTRAINT questioning_section_position_check CHECK (("position" >= 0))
);


ALTER TABLE public.questioning_section OWNER TO admin;

--
-- Name: questioning_section_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.questioning_section_id_seq OWNER TO admin;

--
-- Name: questioning_section_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.questioning_section_id_seq OWNED BY public.questioning_section.id;


--
-- Name: web_company; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.web_company (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    company_name character varying(100) NOT NULL,
    company_orientation character varying(50) NOT NULL,
    address character varying(200) NOT NULL,
    plz character varying(20) NOT NULL,
    city character varying(200) NOT NULL,
    country character varying(2) NOT NULL,
    logo character varying(100),
    company_type character varying(50) NOT NULL,
    user_id integer NOT NULL,
    language character varying(50) NOT NULL
);


ALTER TABLE public.web_company OWNER TO admin;

--
-- Name: web_company_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.web_company_id_seq OWNER TO admin;

--
-- Name: web_company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.web_company_id_seq OWNED BY public.web_company.id;


--
-- Name: web_company_staff; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.web_company_staff (
    id integer NOT NULL,
    company_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.web_company_staff OWNER TO admin;

--
-- Name: web_company_staff_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.web_company_staff_id_seq OWNER TO admin;

--
-- Name: web_company_staff_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.web_company_staff_id_seq OWNED BY public.web_company_staff.id;


--
-- Name: web_order; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.web_order (
    id integer NOT NULL,
    description character varying(200) NOT NULL,
    created timestamp with time zone NOT NULL,
    price double precision,
    company_id integer NOT NULL
);


ALTER TABLE public.web_order OWNER TO admin;

--
-- Name: web_order_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.web_order_id_seq OWNER TO admin;

--
-- Name: web_order_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.web_order_id_seq OWNED BY public.web_order.id;


--
-- Name: web_project; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.web_project (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    description character varying(500) NOT NULL,
    status character varying(100) NOT NULL,
    language character varying(50) NOT NULL
);


ALTER TABLE public.web_project OWNER TO admin;

--
-- Name: web_project_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.web_project_id_seq OWNER TO admin;

--
-- Name: web_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.web_project_id_seq OWNED BY public.web_project.id;


--
-- Name: web_tagmap; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.web_tagmap (
    id integer NOT NULL,
    value character varying(500) NOT NULL,
    project_id integer NOT NULL,
    tag_id integer NOT NULL
);


ALTER TABLE public.web_tagmap OWNER TO admin;

--
-- Name: web_tagmap_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.web_tagmap_id_seq OWNER TO admin;

--
-- Name: web_tagmap_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.web_tagmap_id_seq OWNED BY public.web_tagmap.id;


--
-- Name: web_tagmapcompany; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.web_tagmapcompany (
    id integer NOT NULL,
    value character varying(500) NOT NULL,
    accepted boolean NOT NULL,
    company_id integer NOT NULL,
    project_id integer NOT NULL,
    tag_id integer NOT NULL
);


ALTER TABLE public.web_tagmapcompany OWNER TO admin;

--
-- Name: web_tagmapcompany_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.web_tagmapcompany_id_seq OWNER TO admin;

--
-- Name: web_tagmapcompany_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.web_tagmapcompany_id_seq OWNED BY public.web_tagmapcompany.id;


--
-- Name: web_trainingmaterial; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.web_trainingmaterial (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    description character varying(300) NOT NULL,
    file character varying(100) NOT NULL,
    type character varying(20) NOT NULL
);


ALTER TABLE public.web_trainingmaterial OWNER TO admin;

--
-- Name: web_trainingmaterial_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.web_trainingmaterial_id_seq OWNER TO admin;

--
-- Name: web_trainingmaterial_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.web_trainingmaterial_id_seq OWNED BY public.web_trainingmaterial.id;


--
-- Name: web_trainingmaterial_projects; Type: TABLE; Schema: public; Owner: admin
--

CREATE TABLE public.web_trainingmaterial_projects (
    id integer NOT NULL,
    trainingmaterial_id integer NOT NULL,
    project_id integer NOT NULL
);


ALTER TABLE public.web_trainingmaterial_projects OWNER TO admin;

--
-- Name: web_trainingmaterial_project_id_seq; Type: SEQUENCE; Schema: public; Owner: admin
--

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


ALTER TABLE public.web_trainingmaterial_project_id_seq OWNER TO admin;

--
-- Name: web_trainingmaterial_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: admin
--

ALTER SEQUENCE public.web_trainingmaterial_project_id_seq OWNED BY public.web_trainingmaterial_projects.id;


--
-- Name: auth_group id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: auth_group_permissions id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: auth_permission id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: client_compositecompanydocument id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: client_compositecompanydocumentclientresponse id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: client_compositecompanydocumentclientresponsecomment id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: client_compositecompanydocumentconverted id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: client_sectioncompany id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: django_admin_log id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: django_content_type id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: django_migrations id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: qmds_companyuserinvitation id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: qmds_document id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: qmds_tag id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: qmds_user_groups id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: qmds_user_user_permissions id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: questioning_compositedocument id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: questioning_compositedocumentconverted id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: questioning_question id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: questioning_question_projects id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: questioning_questionssourcefile id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: questioning_resulttest id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: questioning_section id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: web_company id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: web_company_staff id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: web_order id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: web_project id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: web_tagmap id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: web_tagmapcompany id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: web_trainingmaterial id; Type: DEFAULT; Schema: public; Owner: admin
--

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


--
-- Name: web_trainingmaterial_projects id; Type: DEFAULT; Schema: public; Owner: admin
--

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


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

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


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

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


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

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 content type	4	add_contenttype
14	Can change content type	4	change_contenttype
15	Can delete content type	4	delete_contenttype
16	Can view content type	4	view_contenttype
17	Can add session	5	add_session
18	Can change session	5	change_session
19	Can delete session	5	delete_session
20	Can view session	5	view_session
21	Can add user	6	add_user
22	Can change user	6	change_user
23	Can delete user	6	delete_user
24	Can view user	6	view_user
25	Can add tag	7	add_tag
26	Can change tag	7	change_tag
27	Can delete tag	7	delete_tag
28	Can view tag	7	view_tag
29	Can add document	8	add_document
30	Can change document	8	change_document
31	Can delete document	8	delete_document
32	Can view document	8	view_document
33	Can add company	9	add_company
34	Can change company	9	change_company
35	Can delete company	9	delete_company
36	Can view company	9	view_company
37	Can add tag map	10	add_tagmap
38	Can change tag map	10	change_tagmap
39	Can delete tag map	10	delete_tagmap
40	Can view tag map	10	view_tagmap
41	Can add order	11	add_order
42	Can change order	11	change_order
43	Can delete order	11	delete_order
44	Can view order	11	view_order
45	Can add employee	12	add_employee
46	Can change employee	12	change_employee
47	Can delete employee	12	delete_employee
48	Can view employee	12	view_employee
49	Can add converted document	13	add_converteddocument
50	Can change converted document	13	change_converteddocument
51	Can delete converted document	13	delete_converteddocument
52	Can view converted document	13	view_converteddocument
53	Can add tag source file	14	add_tagsourcefile
54	Can change tag source file	14	change_tagsourcefile
55	Can delete tag source file	14	delete_tagsourcefile
56	Can view tag source file	14	view_tagsourcefile
57	Can add composite document	15	add_compositedocument
58	Can change composite document	15	change_compositedocument
59	Can delete composite document	15	delete_compositedocument
60	Can view composite document	15	view_compositedocument
61	Can add composite document converted	16	add_compositedocumentconverted
62	Can change composite document converted	16	change_compositedocumentconverted
63	Can delete composite document converted	16	delete_compositedocumentconverted
64	Can view composite document converted	16	view_compositedocumentconverted
65	Can add section	17	add_section
66	Can change section	17	change_section
67	Can delete section	17	delete_section
68	Can view section	17	view_section
69	Can add project	18	add_project
70	Can change project	18	change_project
71	Can delete project	18	delete_project
72	Can view project	18	view_project
73	Can add tag map company	19	add_tagmapcompany
74	Can change tag map company	19	change_tagmapcompany
75	Can delete tag map company	19	delete_tagmapcompany
76	Can view tag map company	19	view_tagmapcompany
77	Can add composite company document	20	add_compositecompanydocument
78	Can change composite company document	20	change_compositecompanydocument
79	Can delete composite company document	20	delete_compositecompanydocument
80	Can view composite company document	20	view_compositecompanydocument
81	Can add section company	21	add_sectioncompany
82	Can change section company	21	change_sectioncompany
83	Can delete section company	21	delete_sectioncompany
84	Can view section company	21	view_sectioncompany
85	Can add composite company document converted	22	add_compositecompanydocumentconverted
86	Can change composite company document converted	22	change_compositecompanydocumentconverted
87	Can delete composite company document converted	22	delete_compositecompanydocumentconverted
88	Can view composite company document converted	22	view_compositecompanydocumentconverted
89	Can add conversion progress	23	add_conversionprogress
90	Can change conversion progress	23	change_conversionprogress
91	Can delete conversion progress	23	delete_conversionprogress
92	Can view conversion progress	23	view_conversionprogress
93	Can add company user invitation	24	add_companyuserinvitation
94	Can change company user invitation	24	change_companyuserinvitation
95	Can delete company user invitation	24	delete_companyuserinvitation
96	Can view company user invitation	24	view_companyuserinvitation
97	Can add question	25	add_question
98	Can change question	25	change_question
99	Can delete question	25	delete_question
100	Can view question	25	view_question
101	Can add questions source file	26	add_questionssourcefile
102	Can change questions source file	26	change_questionssourcefile
103	Can delete questions source file	26	delete_questionssourcefile
104	Can view questions source file	26	view_questionssourcefile
105	Can add result test	27	add_resulttest
106	Can change result test	27	change_resulttest
107	Can delete result test	27	delete_resulttest
108	Can view result test	27	view_resulttest
109	Can add training material	28	add_trainingmaterial
110	Can change training material	28	change_trainingmaterial
111	Can delete training material	28	delete_trainingmaterial
112	Can view training material	28	view_trainingmaterial
113	Can add composite company document client response	29	add_compositecompanydocumentclientresponse
114	Can change composite company document client response	29	change_compositecompanydocumentclientresponse
115	Can delete composite company document client response	29	delete_compositecompanydocumentclientresponse
116	Can view composite company document client response	29	view_compositecompanydocumentclientresponse
117	Can add composite company document client response comment	30	add_compositecompanydocumentclientresponsecomment
118	Can change composite company document client response comment	30	change_compositecompanydocumentclientresponsecomment
119	Can delete composite company document client response comment	30	delete_compositecompanydocumentclientresponsecomment
120	Can view composite company document client response comment	30	view_compositecompanydocumentclientresponsecomment
\.


--
-- Data for Name: client_compositecompanydocument; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.client_compositecompanydocument (id, file, doc_type, "position", updated_at, section_company_id, tag_1_id, tag_2_id) FROM stdin;
2916	composite_company/Quality_Manual_4x387aX.docx	1	67	2023-08-21 14:52:38.670193+02	832	7571	7608
2917	composite_company/Quality_Commitment_sUMjm7c_Ew8bxU3.docx	3	69	2023-08-21 14:52:38.680909+02	832	7571	7610
2918	composite_company/Organigram_pCTPyUT_bYQKF6K.docx	3	68	2023-08-21 14:52:38.687732+02	832	7571	7609
2152	composite_company/MD-01_Quality_Commitment_appendix_E6uRGah_C4VBF66.docx	3	51	2023-02-14 13:57:25.952815+01	620	5768	5769
2153	composite_company/MD-01_Organigram_appendix_dapm3m2_bMisEJv.docx	3	50	2023-02-14 13:57:25.968876+01	620	5768	5767
2154	composite_company/MD-01_Quality_Manual_YZjPXuH_u8VDuYs.docx	1	0	2023-02-14 13:57:25.992202+01	620	5768	5761
2155	composite_company/SOP-03_Quality_Plan-AL_4d6xcmh_LIkr1MX.docx	1	0	2023-02-14 13:57:26.011043+01	621	5840	5838
2156	composite_company/SOP-04_Management_Review-AL_P2KnnhV.docx	1	0	2023-02-14 13:57:26.03165+01	622	5764	5765
2157	composite_company/Change_impact_assessment_SMEs_Matrix_Appendix_Zpc5Bfl_7iXbQTE.docx	3	53	2023-02-14 13:57:26.050245+01	623	5766	5763
2158	composite_company/Change_Tracker_Form_W5NmPj9_d2VEVlx.docx	2	55	2023-02-14 13:57:26.061785+01	623	5766	5771
2159	composite_company/Change_Form_UZBr62g_dOqtt1P.docx	2	52	2023-02-14 13:57:26.070041+01	623	5766	5762
2160	composite_company/SOP-05_Change_Management-AL_rC8QEdi.docx	1	0	2023-02-14 13:57:26.08137+01	623	5766	5770
2161	composite_company/Quality_Investigation_and_Assessment_Tools_Appendix_IQXShwt_Hr3bvyh.docx	3	59	2023-02-14 13:57:26.132348+01	624	5778	5779
2162	composite_company/Deviation_and_Nonconformance_Notification_Form_ouxgY8r_AJOR98B.docx	2	54	2023-02-14 13:57:26.140315+01	624	5778	5774
2163	composite_company/Deviations_and_Nonconformances_Tracker_ye2g3PT_glKvOKs.docx	2	57	2023-02-14 13:57:26.148025+01	624	5778	5777
2164	composite_company/Deviation_and_Nonconformance_Report_Form_zGcdyFm_QBRvFSy.docx	2	56	2023-02-14 13:57:26.158608+01	624	5778	5775
2165	composite_company/SOP_Deviation_and_Nonconformity_Management-AL_79PKFCd.docx	1	0	2023-02-14 13:57:26.167398+01	624	5778	5772
2166	composite_company/SOP_CAPA_Management_XKMrZ3A_YZtll4Z.docx	1	0	2023-02-14 13:57:26.180059+01	625	5781	5773
2167	composite_company/CAPA_Report_gdk6Qr0_K48cSOp.docx	2	62	2023-02-14 13:57:26.188016+01	625	5781	5776
2168	composite_company/CAPA_Request_kcwK0PH_s90dvMv.docx	2	61	2023-02-14 13:57:26.196571+01	625	5781	5780
2169	composite_company/CAPA_Tracker_XKUhPXo_87l9yjb.docx	2	63	2023-02-14 13:57:26.205449+01	625	5781	5782
2170	composite_company/SOP_Audits_Management_new_flsxFDQ_s9soZdc.docx	1	0	2023-02-14 13:57:26.225344+01	626	5792	5784
2171	composite_company/Internal_Audits_Programme_AH6Mob6.docx	2	60	2023-02-14 13:57:26.234568+01	626	5792	5787
2172	composite_company/External_Audits_Programmme_Bxseulx.docx	2	64	2023-02-14 13:57:26.246264+01	626	5792	5789
2173	composite_company/Audit_Report_Ox1CrvD_RjvTlbB.docx	2	67	2023-02-14 13:57:26.255073+01	626	5792	5793
2174	composite_company/Audit_Plan_mCCT2nv_hYoLvlk.docx	2	65	2023-02-14 13:57:26.262648+01	626	5792	5791
2175	composite_company/Auditors_List_VqktGdJ_bIWBiG8.docx	2	58	2023-02-14 13:57:26.271092+01	626	5792	5786
2176	composite_company/SOP_QRM-AL_87xw79V.docx	1	0	2023-02-14 13:57:26.291186+01	627	5783	5795
2177	composite_company/FMEA_Template_FONUo2a_U9dl7Kr.docx	2	66	2023-02-14 13:57:26.301637+01	627	5783	5785
2178	composite_company/Training_Record_z0gM7RS_14xzYyv.docx	2	72	2023-02-14 13:57:26.315312+01	628	5800	5788
2179	composite_company/Annual_Training_Plan_uolzFkt_ZJvduJg.docx	2	70	2023-02-14 13:57:26.323491+01	628	5800	5799
2180	composite_company/SOP_Training_YwkrViJ_omsXPjG.docx	1	0	2023-02-14 13:57:26.330362+01	628	5800	5790
2181	composite_company/Training_Matrix_9x4NzA7_2YBgHKm.docx	2	68	2023-02-14 13:57:26.337248+01	628	5800	5797
2182	composite_company/APQR_Annual_Plan_aqLArfG_tsgF98s.docx	2	69	2023-02-14 13:57:26.350834+01	629	5802	5801
2183	composite_company/APQR_Report_kJIkry3_vLXyB6X.docx	2	75	2023-02-14 13:57:26.36491+01	629	5802	5803
2184	composite_company/SOP_APQR_ccOIKdD_VbadJzc.docx	1	0	2023-02-14 13:57:26.372766+01	629	5802	5796
2185	composite_company/Complaint_Notification_TMTfWct_OxtMuio.docx	2	74	2023-02-14 13:57:26.386415+01	630	5814	5798
2186	composite_company/Complaint_Investigation_Report_81xAsDE_x9C0pxM.docx	2	80	2023-02-14 13:57:26.393927+01	630	5814	5811
2187	composite_company/Recall_Committee_Members_FxBtgM7_XLwG60V.docx	2	81	2023-02-14 13:57:26.40029+01	630	5814	5808
2188	composite_company/Complaint_Investigation_Plan_gmYhegN_8sNL34B.docx	2	77	2023-02-14 13:57:26.40672+01	630	5814	5809
2189	composite_company/Complaint_Preliminary_Assessment_kwGgka2_Q13GzRr.docx	2	76	2023-02-14 13:57:26.414+01	630	5814	5807
2190	composite_company/Recall_Report_O3ICcZF_6CpuKOH.docx	2	85	2023-02-14 13:57:26.420409+01	630	5814	5813
2191	composite_company/SOP_Complaints_and_Recalls_3SDnI6N_DxhvliX.docx	1	0	2023-02-14 13:57:26.426677+01	630	5814	5805
2192	composite_company/Recall_Statement_PisMWEQ_eeCATsr.docx	2	82	2023-02-14 13:57:26.433292+01	630	5814	5815
2193	composite_company/Complaints_Log_f8naStH_X7g6YnL.docx	2	71	2023-02-14 13:57:26.443747+01	630	5814	5804
2194	composite_company/Supplier_Evaluation_PPM8bvQ_UMaYb1d.docx	2	78	2023-02-14 13:57:26.456732+01	631	5834	5806
2195	composite_company/SOP-13_Supplier_Management_op6cHTd_K63CvTX.docx	1	0	2023-02-14 13:57:26.464094+01	631	5834	5835
2196	composite_company/Supplier_Self_Assessment_dOHHmE8_guYhZpF.docx	2	73	2023-02-14 13:57:26.482528+01	631	5834	5818
2197	composite_company/Supplier_List_UOhEybj_ZIRBNsJ.docx	2	83	2023-02-14 13:57:26.49457+01	631	5834	5760
2198	composite_company/Quality_Assurance_Agreement_Zl5pRXz_mOXnNlV.docx	2	79	2023-02-14 13:57:26.513075+01	631	5834	5812
2199	composite_company/SOP-14_Material_Management_PGsJLPb_7Hu5c2v.docx	1	0	2023-02-14 13:57:26.531659+01	632	5794	5810
2200	composite_company/Documents_for_the_Material_Assessment_vZB0d69_bA7lrYy.docx	3	87	2023-02-14 13:57:26.541693+01	632	5794	5816
2201	composite_company/Material_User_Requirement_Specification_vIVxxvy_WpnD1a0.docx	2	86	2023-02-14 13:57:26.551611+01	632	5794	5819
2202	composite_company/Material_Qualification_Status_List_MQSL_ian4S54_aNg4lPu.docx	2	84	2023-02-14 13:57:26.560402+01	632	5794	5817
2203	composite_company/SOP_Computerized_Systems_ErqqpiV.docx	1	0	2023-02-14 13:57:26.579736+01	633	5820	5821
2204	composite_company/Archiving_register_uP1Ei66_SvVk4oc.docx	2	89	2023-02-14 13:57:26.598054+01	634	5832	5829
2205	composite_company/Document_Loan_Request_dN5AOOQ_hgOjY3f.docx	2	90	2023-02-14 13:57:26.607083+01	634	5832	5831
2206	composite_company/Document_Destruction_Request_yaM7D3B_tF6m82m.docx	2	91	2023-02-14 13:57:26.615658+01	634	5832	5823
2207	composite_company/SOP-16_Archiving_7VNt55l_RXlAXZL.docx	1	0	2023-02-14 13:57:26.624108+01	634	5832	5827
2208	composite_company/Archiving_Request_Form_vo4oDyz_w6xNRY0.docx	2	88	2023-02-14 13:57:26.633415+01	634	5832	5828
2211	composite_company/SOP-01_and_WI_Form_B4mZwQM_dIsIgkV.docx	2	93	2023-02-14 13:57:26.671692+01	636	5822	5833
2212	composite_company/SOP-01_Master_Copies_Log_ffprFJX.docx	2	94	2023-02-14 13:57:26.678787+01	636	5822	5837
2213	composite_company/SOP-01_Controlled_Copies_Log_DieNl1I.docx	2	95	2023-02-14 13:57:26.685651+01	636	5822	5825
2214	composite_company/SOP-01_Document_Change_Request_Form_U5HHpK3_sfHTw8F.docx	2	92	2023-02-14 13:57:26.691957+01	636	5822	5826
2919	composite_company/SOP-01_Documentation_Management_cZOJASJ_e7Hv9qX.docx	1	70	2023-08-21 14:52:38.702202+02	833	7572	7573
2920	composite_company/SOP-01_Controlled_Copies_Log_1GrkO3y_63S0Zpb.docx	2	71	2023-08-21 14:52:38.709452+02	833	7572	7611
2921	composite_company/SOP-01_Document_Change_Request_Form_iBm8y3c_MsApqEf.docx	2	72	2023-08-21 14:52:38.721589+02	833	7572	7574
2922	composite_company/SOP-01_Master_Copies_Log_FnKX1QX_UsaxAbt.docx	2	73	2023-08-21 14:52:38.732982+02	833	7572	7612
2923	composite_company/SOP-01_and_WI_Form_9car3U1_toEVVwo.docx	2	74	2023-08-21 14:52:38.743131+02	833	7572	7613
2924	composite_company/SOP-02_Good_Documentation_Practice_ksZGW2E_fAM1v0w.docx	1	75	2023-08-21 14:52:38.755103+02	834	7576	7614
2925	composite_company/Signatures_and_Initials_664Tlac.docx	2	76	2023-08-21 14:52:38.761546+02	834	7576	7615
2926	composite_company/SOP-03_Quality_Plan_GWud0zj_s4VT6KH.docx	1	77	2023-08-21 14:52:38.776317+02	835	7555	7616
2927	composite_company/SOP-04_Management_Review_BXQx62B_HejuULZ.docx	1	78	2023-08-21 14:52:38.789061+02	836	7575	7617
2928	composite_company/SOP-05_Change_Management_IF2Hug7_ZeFNCLX.docx	1	79	2023-08-21 14:52:38.804575+02	837	7580	7578
2929	composite_company/Change_Form_py1BwX2_WP4eU8o.docx	2	80	2023-08-21 14:52:38.812428+02	837	7580	7577
2930	composite_company/Change_Tracker_Form_ISnq3LV_8vCtWdS.docx	2	81	2023-08-21 14:52:38.818885+02	837	7580	7579
2931	composite_company/SOP_Deviation_and_Nonconformity_Management_kXRY9by_n4d8Xyr.docx	1	82	2023-08-21 14:52:38.830683+02	838	7568	7564
2932	composite_company/Quality_Investigation_and_Assessment_Tools_Appendix_nkOJA9g_8qjWlHW.docx	3	83	2023-08-21 14:52:38.871132+02	838	7568	7618
2933	composite_company/Deviation_and_Nonconformity_Notification_Form_HxDm1uM_80BwzfE.docx	2	84	2023-08-21 14:52:38.87821+02	838	7568	7566
2934	composite_company/Deviation_and_Nonconformity_Investigation_Report_Form_d3bFvlq.docx	2	85	2023-08-21 14:52:38.891592+02	838	7568	7581
2935	composite_company/Deviation_and_Nonconformity_Tracker_mcYoZcp.docx	2	86	2023-08-21 14:52:38.904452+02	838	7568	7567
2936	composite_company/CAPA_Request_5fPAWK0_vYtgERV.docx	2	89	2023-08-21 14:52:38.91952+02	839	7585	7583
2937	composite_company/CAPA_Tracker_1bGUVbD_9uzAlgX.docx	2	90	2023-08-21 14:52:38.926075+02	839	7585	7584
2938	composite_company/SOP_CAPA_Management_dI2WrTd_IzZ6trW.docx	1	87	2023-08-21 14:52:38.9329+02	839	7585	7582
2939	composite_company/CAPA_Report_AhrEE2L_Rtp6Dci.docx	2	88	2023-08-21 14:52:38.941237+02	839	7585	7565
2940	composite_company/SOP_Audits_Management_VCIgzdT_wILPBIY.docx	1	91	2023-08-21 14:52:38.954349+02	840	7590	7587
2941	composite_company/Audit_Plan_18x5nlL_uO0EuLx.docx	2	92	2023-08-21 14:52:38.962695+02	840	7590	7586
2942	composite_company/Audit_Report_hjIAWt6_P0hjhJ7.docx	2	93	2023-08-21 14:52:38.970955+02	840	7590	7588
2943	composite_company/Auditors_List_ZoRvK0Z_4IbOZIo.docx	2	94	2023-08-21 14:52:38.978459+02	840	7590	7589
2944	composite_company/External_Audits_Programmme_DAabr50_IMe28jC.docx	2	95	2023-08-21 14:52:38.985326+02	840	7590	7619
2945	composite_company/Internal_Audits_Programme_N06nLyq_WpE8QoG.docx	2	96	2023-08-21 14:52:38.992696+02	840	7590	7620
2946	composite_company/SOP_QRM_1XwHxCp_5AFIMQw.docx	1	97	2023-08-21 14:52:39.005668+02	841	7623	7622
2947	composite_company/FMEA_Template_twZREJ3_7jVIpTs.docx	2	98	2023-08-21 14:52:39.01251+02	841	7623	7624
2948	composite_company/SOP_Training_cQhcTrH_Se38a1n.docx	1	99	2023-08-21 14:52:39.02634+02	842	7592	7625
2949	composite_company/Training_Matrix_j1m2hoL_sJwcpLm.docx	2	100	2023-08-21 14:52:39.03382+02	842	7592	7626
2950	composite_company/Annual_Training_Plan_bsrflD3_iD4CeUi.docx	2	101	2023-08-21 14:52:39.040717+02	842	7592	7627
2951	composite_company/Training_Record_q7bNP70_ovGNo0M.docx	2	102	2023-08-21 14:52:39.048296+02	842	7592	7628
2952	composite_company/SOP_Complaints_and_Recalls_Management_wIyXq7c.docx	1	103	2023-08-21 14:52:39.061973+02	843	7637	7630
2953	composite_company/Complaint_Notification_sTvcSQB_EgDRnob.docx	2	104	2023-08-21 14:52:39.068993+02	843	7637	7591
2954	composite_company/Complaint_Preliminary_Assessment_EevqYk2_e3xWSoX.docx	2	105	2023-08-21 14:52:39.075193+02	843	7637	7561
2955	composite_company/Complaint_Investigation_Plan_hg5tXSS_ICQieJL.docx	2	106	2023-08-21 14:52:39.081433+02	843	7637	7562
2956	composite_company/Complaint_Investigation_Report_C9bFDDi_BGJzhzH.docx	2	107	2023-08-21 14:52:39.088064+02	843	7637	7559
2957	composite_company/Complaints_Log_no8LPs8_Pv554Xj.docx	2	108	2023-08-21 14:52:39.095361+02	843	7637	7560
2958	composite_company/Recall_Committee_Members_RNzb127_LzRQRKX.docx	2	109	2023-08-21 14:52:39.103142+02	843	7637	7635
2959	composite_company/Recall_Report_JG8JVZU_J7UWDsF.docx	2	110	2023-08-21 14:52:39.109961+02	843	7637	7636
2960	composite_company/Recall_Statement_FhHDnsa_gNMIgpW.docx	2	111	2023-08-21 14:52:39.11808+02	843	7637	7638
2961	composite_company/SOP_Suppliers_Customers_Management_PzoIWPO.docx	1	112	2023-08-21 14:52:39.136304+02	844	7607	7639
2962	composite_company/Supplier_Customer_Evaluation_d0Cjn0I.docx	2	113	2023-08-21 14:52:39.145645+02	844	7607	7604
2963	composite_company/Quality_Assurance_Agreement_gEQy4yZ_07icDTE.docx	2	114	2023-08-21 14:52:39.153597+02	844	7607	7605
2964	composite_company/Supplier_Customer_Self_Assessment_YT05wxi.docx	2	115	2023-08-21 14:52:39.166051+02	844	7607	7606
2965	composite_company/Qualified_Supplier_Customer_List_8O3DzzA.docx	2	116	2023-08-21 14:52:39.173437+02	844	7607	7621
2966	composite_company/SOP_Computerized_Systems_Lifecycle_Management_GDOZynT_MqStgvT.docx	1	117	2023-08-21 14:52:39.185272+02	845	7629	7563
2967	composite_company/SOP-16_Archiving_BVSysfc_2QzNmiD.docx	1	118	2023-08-21 14:52:39.197934+02	846	7570	7569
2968	composite_company/Archiving_register_I0CzL3Y_ijMChi0.docx	2	119	2023-08-21 14:52:39.204514+02	846	7570	7631
2969	composite_company/Archiving_Request_Form_NemuiHr_886JHNh.docx	2	120	2023-08-21 14:52:39.215351+02	846	7570	7632
2970	composite_company/Document_Destruction_Request_FE7gh4E_PSHN29I.docx	2	121	2023-08-21 14:52:39.2249+02	846	7570	7633
2971	composite_company/Document_Loan_Request_fDmpSHX_h8x4ez1.docx	2	122	2023-08-21 14:52:39.232122+02	846	7570	7634
2972	composite_company/SOP_Deviation_and_Nonconformity_Management_s8xlsuC.docx	1	113	2023-09-07 08:55:27.285115+02	847	7738	7736
2973	composite_company/Quality_Investigation_and_Assessment_Tools_Appendix_LkVmUT3.docx	3	119	2023-09-07 08:55:27.315165+02	847	7738	7737
2974	composite_company/Deviation_and_Nonconformity_Notification_Form_cx2Zpe4.docx	2	120	2023-09-07 08:55:27.324491+02	847	7738	7733
2975	composite_company/Deviation_and_Nonconformity_Report_Form_Ew66DzI.docx	2	121	2023-09-07 08:55:27.335234+02	847	7738	7734
2976	composite_company/Deviations_and_Nonconformity_Tracker_gLmwHzk.docx	2	122	2023-09-07 08:55:27.345337+02	847	7738	7656
2215	composite_company/SOP-01_Documentation_Management_URDf0Ja_yRD3kKR.docx	1	0	2023-02-14 13:57:26.698442+01	636	5822	5824
\.


--
-- Data for Name: client_compositecompanydocumentclientresponse; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.client_compositecompanydocumentclientresponse (id, comment, file, updated_at, created_at, document_id, closed, author_id) FROM stdin;
\.


--
-- Data for Name: client_compositecompanydocumentclientresponsecomment; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.client_compositecompanydocumentclientresponsecomment (id, comment, created_at, author_id, response_id, file) FROM stdin;
\.


--
-- Data for Name: client_compositecompanydocumentconverted; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.client_compositecompanydocumentconverted (id, file, updated_at, document_id, missing_tags) FROM stdin;
1366	composite_company/converted/CAPA_Report_gdk6Qr0_K48cSOp.docx	2023-02-14 14:19:02.804308+01	2167	
1370	composite_company/converted/CAPA_Request_kcwK0PH_s90dvMv.docx	2023-02-14 14:19:05.542269+01	2168	
1372	composite_company/converted/FMEA_Template_FONUo2a_U9dl7Kr.docx	2023-02-14 14:19:05.921058+01	2177	
1376	composite_company/converted/Change_impact_assessment_SMEs_Matrix_Appendix_Zpc5Bfl_7iXbQTE.docx	2023-02-14 14:19:10.204433+01	2157	
1380	composite_company/converted/APQR_Annual_Plan_aqLArfG_tsgF98s.docx	2023-02-14 14:19:14.777281+01	2182	
1383	composite_company/converted/Training_Record_z0gM7RS_14xzYyv.docx	2023-02-14 14:19:25.405039+01	2178	
1386	composite_company/converted/CAPA_Tracker_XKUhPXo_87l9yjb.docx	2023-02-14 14:19:27.498803+01	2169	
1392	composite_company/converted/Change_Tracker_Form_W5NmPj9_d2VEVlx.docx	2023-02-14 14:19:28.29644+01	2158	
1395	composite_company/converted/APQR_Report_kJIkry3_vLXyB6X.docx	2023-02-14 14:19:30.081494+01	2183	
1396	composite_company/converted/Annual_Training_Plan_uolzFkt_ZJvduJg.docx	2023-02-14 14:19:34.891053+01	2179	
1400	composite_company/converted/SOP_Audits_Management_new_flsxFDQ_s9soZdc.docx	2023-02-14 14:19:35.923998+01	2170	
1405	composite_company/converted/SOP_APQR_ccOIKdD_VbadJzc.docx	2023-02-14 14:19:36.186278+01	2184	
1407	composite_company/converted/Complaint_Preliminary_Assessment_kwGgka2_Q13GzRr.docx	2023-02-14 14:19:36.650191+01	2189	
1408	composite_company/converted/Change_Form_UZBr62g_dOqtt1P.docx	2023-02-14 14:19:36.665109+01	2159	
1412	composite_company/converted/SOP_Training_YwkrViJ_omsXPjG.docx	2023-02-14 14:19:42.895166+01	2180	
1415	composite_company/converted/Internal_Audits_Programme_AH6Mob6.docx	2023-02-14 14:19:43.711594+01	2171	
1417	composite_company/converted/SOP-05_Change_Management-AL_rC8QEdi.docx	2023-02-14 14:19:43.733035+01	2160	
1419	composite_company/converted/Recall_Report_O3ICcZF_6CpuKOH.docx	2023-02-14 14:19:44.535227+01	2190	
1420	composite_company/converted/Complaint_Notification_TMTfWct_OxtMuio.docx	2023-02-14 14:19:45.056649+01	2185	
1424	composite_company/converted/Training_Matrix_9x4NzA7_2YBgHKm.docx	2023-02-14 14:19:53.355773+01	2181	
1426	composite_company/converted/Quality_Investigation_and_Assessment_Tools_Appendix_IQXShwt_Hr3bvyh.docx	2023-02-14 14:19:55.625032+01	2161	
1427	composite_company/converted/Complaint_Investigation_Report_81xAsDE_x9C0pxM.docx	2023-02-14 14:19:55.702983+01	2186	
1428	composite_company/converted/SOP_Complaints_and_Recalls_3SDnI6N_DxhvliX.docx	2023-02-14 14:19:56.055384+01	2191	
1871	composite_company/converted/CAPA_Request_5fPAWK0_vYtgERV.docx	2023-08-21 14:54:41.386445+02	2936	
1875	composite_company/converted/SOP_Computerized_Systems_Lifecycle_Management_GDOZynT_MqStgvT.docx	2023-08-21 14:54:42.262754+02	2966	
1879	composite_company/converted/Document_Loan_Request_fDmpSHX_h8x4ez1.docx	2023-08-21 14:54:43.28659+02	2971	
1884	composite_company/converted/SOP-16_Archiving_BVSysfc_2QzNmiD.docx	2023-08-21 14:54:46.697035+02	2967	
1886	composite_company/converted/CAPA_Tracker_1bGUVbD_9uzAlgX.docx	2023-08-21 14:54:47.513626+02	2937	
1888	composite_company/converted/Supplier_Customer_Evaluation_d0Cjn0I.docx	2023-08-21 14:54:47.809491+02	2962	
1892	composite_company/converted/SOP_Complaints_and_Recalls_Management_wIyXq7c.docx	2023-08-21 14:54:48.242515+02	2952	
1897	composite_company/converted/SOP-01_Documentation_Management_cZOJASJ_e7Hv9qX.docx	2023-08-21 14:54:54.785469+02	2919	
1903	composite_company/converted/Complaint_Notification_sTvcSQB_EgDRnob.docx	2023-08-21 14:55:02.72539+02	2953	
1907	composite_company/converted/SOP-01_Controlled_Copies_Log_1GrkO3y_63S0Zpb.docx	2023-08-21 14:55:05.655336+02	2920	
1909	composite_company/converted/Quality_Assurance_Agreement_gEQy4yZ_07icDTE.docx	2023-08-21 14:55:07.039639+02	2963	
1914	composite_company/converted/Complaint_Preliminary_Assessment_EevqYk2_e3xWSoX.docx	2023-08-21 14:55:07.654888+02	2954	
1923	composite_company/converted/Complaint_Investigation_Plan_hg5tXSS_ICQieJL.docx	2023-08-21 14:55:16.448372+02	2955	
1925	composite_company/converted/Supplier_Customer_Self_Assessment_YT05wxi.docx	2023-08-21 14:55:19.48451+02	2964	
1926	composite_company/converted/Qualified_Supplier_Customer_List_8O3DzzA.docx	2023-08-21 14:55:19.619775+02	2965	
1927	composite_company/converted/SOP_Deviation_and_Nonconformity_Management_s8xlsuC.docx	2023-09-07 08:56:01.982134+02	2972	
1928	composite_company/converted/Quality_Investigation_and_Assessment_Tools_Appendix_LkVmUT3.docx	2023-09-07 08:56:02.379056+02	2973	
1929	composite_company/converted/Deviation_and_Nonconformity_Notification_Form_cx2Zpe4.docx	2023-09-07 08:56:02.667655+02	2974	
1930	composite_company/converted/Deviation_and_Nonconformity_Report_Form_Ew66DzI.docx	2023-09-07 08:56:03.030048+02	2975	
1931	composite_company/converted/Deviations_and_Nonconformity_Tracker_gLmwHzk.docx	2023-09-07 08:56:03.299226+02	2976	
1367	composite_company/converted/MD-01_Quality_Commitment_appendix_E6uRGah_C4VBF66.docx	2023-02-14 14:19:03.097361+01	2152	
1369	composite_company/converted/MD-01_Organigram_appendix_dapm3m2_bMisEJv.docx	2023-02-14 14:19:05.354423+01	2153	
1373	composite_company/converted/Material_Qualification_Status_List_MQSL_ian4S54_aNg4lPu.docx	2023-02-14 14:19:05.991073+01	2202	
1377	composite_company/converted/Recall_Statement_PisMWEQ_eeCATsr.docx	2023-02-14 14:19:10.760608+01	2192	
1381	composite_company/converted/SOP_Computerized_Systems_ErqqpiV.docx	2023-02-14 14:19:22.487795+01	2203	
1382	composite_company/converted/MD-01_Quality_Manual_YZjPXuH_u8VDuYs.docx	2023-02-14 14:19:23.233147+01	2154	
1387	composite_company/converted/Complaints_Log_f8naStH_X7g6YnL.docx	2023-02-14 14:19:27.573194+01	2193	
1393	composite_company/converted/SOP-03_Quality_Plan-AL_4d6xcmh_LIkr1MX.docx	2023-02-14 14:19:28.391929+01	2155	
1394	composite_company/converted/Archiving_register_uP1Ei66_SvVk4oc.docx	2023-02-14 14:19:28.410339+01	2204	
1398	composite_company/converted/SOP-04_Management_Review-AL_P2KnnhV.docx	2023-02-14 14:19:35.485252+01	2156	
1403	composite_company/converted/Supplier_Evaluation_PPM8bvQ_UMaYb1d.docx	2023-02-14 14:19:36.149639+01	2194	
1404	composite_company/converted/Document_Loan_Request_dN5AOOQ_hgOjY3f.docx	2023-02-14 14:19:36.145048+01	2205	
1413	composite_company/converted/SOP-13_Supplier_Management_op6cHTd_K63CvTX.docx	2023-02-14 14:19:43.015891+01	2195	
1416	composite_company/converted/Document_Destruction_Request_yaM7D3B_tF6m82m.docx	2023-02-14 14:19:43.717604+01	2206	
1421	composite_company/converted/SOP-01_and_WI_Form_B4mZwQM_dIsIgkV.docx	2023-02-14 14:19:47.011115+01	2211	
1429	composite_company/converted/Supplier_Self_Assessment_dOHHmE8_guYhZpF.docx	2023-02-14 14:19:56.256353+01	2196	
1872	composite_company/converted/SOP-03_Quality_Plan_GWud0zj_s4VT6KH.docx	2023-08-21 14:54:41.997809+02	2926	
1876	composite_company/converted/SOP_Deviation_and_Nonconformity_Management_kXRY9by_n4d8Xyr.docx	2023-08-21 14:54:42.521865+02	2931	
1880	composite_company/converted/Complaint_Investigation_Report_C9bFDDi_BGJzhzH.docx	2023-08-21 14:54:43.344029+02	2956	
1885	composite_company/converted/SOP-04_Management_Review_BXQx62B_HejuULZ.docx	2023-08-21 14:54:46.856361+02	2927	
1889	composite_company/converted/SOP-01_Master_Copies_Log_FnKX1QX_UsaxAbt.docx	2023-08-21 14:54:47.815072+02	2922	
1893	composite_company/converted/FMEA_Template_twZREJ3_7jVIpTs.docx	2023-08-21 14:54:48.476344+02	2947	
1896	composite_company/converted/SOP-01_and_WI_Form_9car3U1_toEVVwo.docx	2023-08-21 14:54:54.284739+02	2923	
1898	composite_company/converted/SOP_CAPA_Management_dI2WrTd_IzZ6trW.docx	2023-08-21 14:54:55.11365+02	2938	
1900	composite_company/converted/SOP_Training_cQhcTrH_Se38a1n.docx	2023-08-21 14:55:02.099348+02	2948	
1905	composite_company/converted/CAPA_Report_AhrEE2L_Rtp6Dci.docx	2023-08-21 14:55:03.602437+02	2939	
1906	composite_company/converted/SOP-02_Good_Documentation_Practice_ksZGW2E_fAM1v0w.docx	2023-08-21 14:55:05.62944+02	2924	
1912	composite_company/converted/Training_Matrix_j1m2hoL_sJwcpLm.docx	2023-08-21 14:55:07.529241+02	2949	
1915	composite_company/converted/SOP_Audits_Management_VCIgzdT_wILPBIY.docx	2023-08-21 14:55:07.675671+02	2940	
1917	composite_company/converted/Signatures_and_Initials_664Tlac.docx	2023-08-21 14:55:09.831033+02	2925	
1921	composite_company/converted/Annual_Training_Plan_bsrflD3_iD4CeUi.docx	2023-08-21 14:55:16.429953+02	2950	
1368	composite_company/converted/Supplier_List_UOhEybj_ZIRBNsJ.docx	2023-02-14 14:19:03.603589+01	2197	
1374	composite_company/converted/SOP-01_Master_Copies_Log_ffprFJX.docx	2023-02-14 14:19:06.121971+01	2212	
1378	composite_company/converted/Deviation_and_Nonconformance_Notification_Form_ouxgY8r_AJOR98B.docx	2023-02-14 14:19:12.49005+01	2162	
1384	composite_company/converted/SOP-01_Controlled_Copies_Log_DieNl1I.docx	2023-02-14 14:19:27.131846+01	2213	
1390	composite_company/converted/Deviations_and_Nonconformances_Tracker_ye2g3PT_glKvOKs.docx	2023-02-14 14:19:28.152047+01	2163	
1391	composite_company/converted/Quality_Assurance_Agreement_Zl5pRXz_mOXnNlV.docx	2023-02-14 14:19:28.272746+01	2198	
1397	composite_company/converted/SOP-14_Material_Management_PGsJLPb_7Hu5c2v.docx	2023-02-14 14:19:35.328995+01	2199	
1401	composite_company/converted/Deviation_and_Nonconformance_Report_Form_zGcdyFm_QBRvFSy.docx	2023-02-14 14:19:35.979755+01	2164	
1402	composite_company/converted/Audit_Plan_mCCT2nv_hYoLvlk.docx	2023-02-14 14:19:36.085254+01	2174	
1406	composite_company/converted/SOP-01_Document_Change_Request_Form_U5HHpK3_sfHTw8F.docx	2023-02-14 14:19:36.410966+01	2214	
1409	composite_company/converted/Documents_for_the_Material_Assessment_vZB0d69_bA7lrYy.docx	2023-02-14 14:19:41.169402+01	2200	
1410	composite_company/converted/SOP_Deviation_and_Nonconformity_Management-AL_79PKFCd.docx	2023-02-14 14:19:42.194666+01	2165	
1414	composite_company/converted/Auditors_List_VqktGdJ_bIWBiG8.docx	2023-02-14 14:19:43.357719+01	2175	
1418	composite_company/converted/SOP-01_Documentation_Management_URDf0Ja_yRD3kKR.docx	2023-02-14 14:19:43.737085+01	2215	
1422	composite_company/converted/Material_User_Requirement_Specification_vIVxxvy_WpnD1a0.docx	2023-02-14 14:19:52.891223+01	2201	
1423	composite_company/converted/SOP_CAPA_Management_XKMrZ3A_YZtll4Z.docx	2023-02-14 14:19:52.896158+01	2166	
1425	composite_company/converted/SOP_QRM-AL_87xw79V.docx	2023-02-14 14:19:53.562277+01	2176	
1873	composite_company/converted/Quality_Manual_4x387aX.docx	2023-08-21 14:54:42.036619+02	2916	
1877	composite_company/converted/Audit_Plan_18x5nlL_uO0EuLx.docx	2023-08-21 14:54:42.9764+02	2941	
1881	composite_company/converted/SOP_QRM_1XwHxCp_5AFIMQw.docx	2023-08-21 14:54:43.525311+02	2946	
1883	composite_company/converted/Quality_Commitment_sUMjm7c_Ew8bxU3.docx	2023-08-21 14:54:44.47741+02	2917	
1887	composite_company/converted/Organigram_pCTPyUT_bYQKF6K.docx	2023-08-21 14:54:47.557464+02	2918	
1890	composite_company/converted/Complaints_Log_no8LPs8_Pv554Xj.docx	2023-08-21 14:54:48.017437+02	2957	
1894	composite_company/converted/Quality_Investigation_and_Assessment_Tools_Appendix_nkOJA9g_8qjWlHW.docx	2023-08-21 14:54:48.4793+02	2932	
1899	composite_company/converted/Archiving_register_I0CzL3Y_ijMChi0.docx	2023-08-21 14:55:01.728613+02	2968	
1901	composite_company/converted/Recall_Committee_Members_RNzb127_LzRQRKX.docx	2023-08-21 14:55:02.120555+02	2958	
1902	composite_company/converted/Deviation_and_Nonconformity_Notification_Form_HxDm1uM_80BwzfE.docx	2023-08-21 14:55:02.28716+02	2933	
1910	composite_company/converted/Archiving_Request_Form_NemuiHr_886JHNh.docx	2023-08-21 14:55:07.273141+02	2969	
1911	composite_company/converted/Recall_Report_JG8JVZU_J7UWDsF.docx	2023-08-21 14:55:07.520368+02	2959	
1913	composite_company/converted/Deviation_and_Nonconformity_Investigation_Report_Form_d3bFvlq.docx	2023-08-21 14:55:07.620639+02	2934	
1919	composite_company/converted/Deviation_and_Nonconformity_Tracker_mcYoZcp.docx	2023-08-21 14:55:16.050084+02	2935	
1920	composite_company/converted/Document_Destruction_Request_FE7gh4E_PSHN29I.docx	2023-08-21 14:55:16.358197+02	2970	
1922	composite_company/converted/Recall_Statement_FhHDnsa_gNMIgpW.docx	2023-08-21 14:55:16.431196+02	2960	
1371	composite_company/converted/SOP-16_Archiving_7VNt55l_RXlAXZL.docx	2023-02-14 14:19:05.70334+01	2207	
1375	composite_company/converted/External_Audits_Programmme_Bxseulx.docx	2023-02-14 14:19:06.179019+01	2172	
1379	composite_company/converted/Recall_Committee_Members_FxBtgM7_XLwG60V.docx	2023-02-14 14:19:12.554046+01	2187	
1385	composite_company/converted/Archiving_Request_Form_vo4oDyz_w6xNRY0.docx	2023-02-14 14:19:27.3506+01	2208	
1388	composite_company/converted/Audit_Report_Ox1CrvD_RjvTlbB.docx	2023-02-14 14:19:27.574023+01	2173	
1389	composite_company/converted/Complaint_Investigation_Plan_gmYhegN_8sNL34B.docx	2023-02-14 14:19:27.886797+01	2188	
1874	composite_company/converted/SOP_Suppliers_Customers_Management_PzoIWPO.docx	2023-08-21 14:54:42.185418+02	2961	
1878	composite_company/converted/SOP-01_Document_Change_Request_Form_iBm8y3c_MsApqEf.docx	2023-08-21 14:54:42.977316+02	2921	
1882	composite_company/converted/Training_Record_q7bNP70_ovGNo0M.docx	2023-08-21 14:54:43.558909+02	2951	
1891	composite_company/converted/Audit_Report_hjIAWt6_P0hjhJ7.docx	2023-08-21 14:54:48.176789+02	2942	
1895	composite_company/converted/SOP-05_Change_Management_IF2Hug7_ZeFNCLX.docx	2023-08-21 14:54:53.672995+02	2928	
1904	composite_company/converted/Auditors_List_ZoRvK0Z_4IbOZIo.docx	2023-08-21 14:55:03.224662+02	2943	
1908	composite_company/converted/Change_Form_py1BwX2_WP4eU8o.docx	2023-08-21 14:55:06.102099+02	2929	
1916	composite_company/converted/External_Audits_Programmme_DAabr50_IMe28jC.docx	2023-08-21 14:55:08.274734+02	2944	
1918	composite_company/converted/Change_Tracker_Form_ISnq3LV_8vCtWdS.docx	2023-08-21 14:55:15.038102+02	2930	
1924	composite_company/converted/Internal_Audits_Programme_N06nLyq_WpE8QoG.docx	2023-08-21 14:55:19.066377+02	2945	
\.


--
-- Data for Name: client_conversionprogress; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.client_conversionprogress (file_name, progress) FROM stdin;
Quality_Commitment_S3KQ4mI.docx	0.1
SOP-05_Change_Management_MQ2HiHN_SLB2YGi.docx	0.1
\.


--
-- Data for Name: client_sectioncompany; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.client_sectioncompany (id, "position", company_id, name_postfix_id, name_prefix_id) FROM stdin;
832	1	1	7608	7571
833	1	1	7573	7572
834	1	1	7614	7576
835	1	1	7616	7555
836	1	1	7617	7575
837	1	1	7578	7580
838	1	1	7564	7568
839	1	1	7582	7585
840	1	1	7587	7590
841	1	1	7622	7623
842	1	1	7625	7592
843	1	1	7630	7637
844	1	1	7639	7607
845	1	1	7563	7629
846	1	1	7569	7570
847	1	2	7736	7738
620	0	3	5761	5768
621	3	3	5838	5840
622	4	3	5765	5764
623	5	3	5770	5766
624	6	3	5772	5778
625	7	3	5773	5781
626	8	3	5784	5792
627	9	3	5795	5783
628	10	3	5790	5800
629	11	3	5796	5802
630	12	3	5805	5814
631	13	3	5835	5834
632	14	3	5810	5794
633	15	3	5821	5820
634	16	3	5827	5832
636	1	3	5824	5822
\.


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

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
1	2022-10-22 12:05:11.381+02	1069	<Doc46_EffectiveDate>	3		7	2
2	2022-10-22 12:05:11.384+02	1070	<Doc46_PrintedDate>	3		7	2
3	2022-10-22 12:05:11.385+02	1085	<Doc47_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
4	2022-10-22 12:05:11.386+02	1086	<Doc47_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
5	2022-10-22 12:05:11.387+02	1087	<Doc47_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
6	2022-10-22 12:05:11.388+02	1088	<Doc47_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
7	2022-10-22 12:05:11.39+02	1084	<Doc47_ApprovalFlow_Approver_Employee04>	3		7	2
8	2022-10-22 12:05:11.391+02	1081	<Doc47_ApprovalFlow_Author_Employee01>	3		7	2
9	2022-10-22 12:05:11.392+02	1083	<Doc47_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
10	2022-10-22 12:05:11.393+02	1082	<Doc47_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
11	2022-10-22 12:05:11.394+02	1079	<Doc47_EffectiveDate>	3		7	2
12	2022-10-22 12:05:11.395+02	1080	<Doc47_PrintedDate>	3		7	2
13	2022-10-22 12:05:11.395+02	1095	<Doc48_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
14	2022-10-22 12:05:11.396+02	1096	<Doc48_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
15	2022-10-22 12:05:11.397+02	1097	<Doc48_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
16	2022-10-22 12:05:11.398+02	1098	<Doc48_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
17	2022-10-22 12:05:11.399+02	1094	<Doc48_ApprovalFlow_Approver_Employee04>	3		7	2
18	2022-10-22 12:05:11.399+02	1091	<Doc48_ApprovalFlow_Author_Employee01>	3		7	2
19	2022-10-22 12:05:11.4+02	1093	<Doc48_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
20	2022-10-22 12:05:11.401+02	1092	<Doc48_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
21	2022-10-22 12:05:11.402+02	1089	<Doc48_EffectiveDate>	3		7	2
22	2022-10-22 12:05:11.403+02	1090	<Doc48_PrintedDate>	3		7	2
23	2022-10-22 12:05:11.403+02	1105	<Doc49_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
24	2022-10-22 12:05:11.404+02	1106	<Doc49_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
25	2022-10-22 12:05:11.405+02	1107	<Doc49_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
26	2022-10-22 12:05:11.406+02	1108	<Doc49_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
27	2022-10-22 12:05:11.406+02	1104	<Doc49_ApprovalFlow_Approver_Employee04>	3		7	2
28	2022-10-22 12:05:11.407+02	1101	<Doc49_ApprovalFlow_Author_Employee01>	3		7	2
29	2022-10-22 12:05:11.408+02	1103	<Doc49_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
30	2022-10-22 12:05:11.409+02	1102	<Doc49_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
31	2022-10-22 12:05:11.41+02	1099	<Doc49_EffectiveDate>	3		7	2
32	2022-10-22 12:05:11.41+02	1100	<Doc49_PrintedDate>	3		7	2
33	2022-10-22 12:05:11.411+02	1115	<Doc50_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
34	2022-10-22 12:05:11.412+02	1116	<Doc50_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
35	2022-10-22 12:05:11.412+02	1117	<Doc50_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
36	2022-10-22 12:05:11.413+02	1118	<Doc50_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
37	2022-10-22 12:05:11.413+02	1114	<Doc50_ApprovalFlow_Approver_Employee04>	3		7	2
38	2022-10-22 12:05:11.414+02	1111	<Doc50_ApprovalFlow_Author_Employee01>	3		7	2
39	2022-10-22 12:05:11.415+02	1113	<Doc50_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
40	2022-10-22 12:05:11.415+02	1112	<Doc50_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
41	2022-10-22 12:05:11.416+02	1109	<Doc50_EffectiveDate>	3		7	2
42	2022-10-22 12:05:11.417+02	1110	<Doc50_PrintedDate>	3		7	2
43	2022-10-22 12:05:11.417+02	1125	<Doc51_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
44	2022-10-22 12:05:11.418+02	1126	<Doc51_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
45	2022-10-22 12:05:11.419+02	1127	<Doc51_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
46	2022-10-22 12:05:11.419+02	1128	<Doc51_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
47	2022-10-22 12:05:11.42+02	1124	<Doc51_ApprovalFlow_Approver_Employee04>	3		7	2
48	2022-10-22 12:05:11.42+02	1121	<Doc51_ApprovalFlow_Author_Employee01>	3		7	2
49	2022-10-22 12:05:11.421+02	1123	<Doc51_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
50	2022-10-22 12:05:11.422+02	1122	<Doc51_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
51	2022-10-22 12:05:11.422+02	1119	<Doc51_EffectiveDate>	3		7	2
52	2022-10-22 12:05:11.423+02	1120	<Doc51_PrintedDate>	3		7	2
53	2022-10-22 12:05:11.423+02	621	<Doc6_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
54	2022-10-22 12:05:11.424+02	622	<Doc6_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
55	2022-10-22 12:05:11.425+02	623	<Doc6_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
56	2022-10-22 12:05:11.425+02	624	<Doc6_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
57	2022-10-22 12:05:11.426+02	620	<Doc6_ApprovalFlow_Approver_Employee04>	3		7	2
58	2022-10-22 12:05:11.427+02	619	<Doc6_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
59	2022-10-22 12:05:11.427+02	585	<QualityCommitmentQuote>	3		7	2
60	2022-10-22 12:05:11.428+02	1129	<Top_DataManagementRole>	3		7	2
61	2022-10-22 12:05:11.428+02	1130	<Top_QualityManagementRole>	3		7	2
62	2022-10-22 12:05:11.429+02	1138	<aaaaa>	3		7	2
63	2022-10-22 12:05:11.429+02	566	<today>	3		7	2
64	2022-10-22 12:05:11.43+02	1139	s	3		7	2
65	2022-10-22 12:05:31.202+02	568	<COMPANYNAME>	3		7	2
66	2022-10-22 12:05:31.203+02	569	<CompanyLogo>	3		7	2
67	2022-10-22 12:05:31.204+02	575	<CompanyMainFunction03>	3		7	2
68	2022-10-22 12:05:31.205+02	567	<CompanyName>	3		7	2
69	2022-10-22 12:05:31.205+02	715	<CompanyRules_English01>	3		7	2
70	2022-10-22 12:05:31.206+02	717	<CompanyRules_English02>	3		7	2
71	2022-10-22 12:05:31.206+02	719	<CompanyRules_English03>	3		7	2
72	2022-10-22 12:05:31.207+02	721	<CompanyRules_English04>	3		7	2
73	2022-10-22 12:05:31.208+02	723	<CompanyRules_English05>	3		7	2
74	2022-10-22 12:05:31.208+02	725	<CompanyRules_English06>	3		7	2
75	2022-10-22 12:05:31.209+02	727	<CompanyRules_English07>	3		7	2
76	2022-10-22 12:05:31.209+02	729	<CompanyRules_English08>	3		7	2
77	2022-10-22 12:05:31.21+02	731	<CompanyRules_English09>	3		7	2
78	2022-10-22 12:05:31.21+02	733	<CompanyRules_English10>	3		7	2
79	2022-10-22 12:05:31.211+02	735	<CompanyRules_English11>	3		7	2
80	2022-10-22 12:05:31.211+02	737	<CompanyRules_English12>	3		7	2
81	2022-10-22 12:05:31.212+02	739	<CompanyRules_English13>	3		7	2
82	2022-10-22 12:05:31.212+02	741	<CompanyRules_English14>	3		7	2
83	2022-10-22 12:05:31.212+02	716	<CompanyRules_German01>	3		7	2
84	2022-10-22 12:05:31.213+02	718	<CompanyRules_German02>	3		7	2
85	2022-10-22 12:05:31.213+02	720	<CompanyRules_German03>	3		7	2
86	2022-10-22 12:05:31.214+02	722	<CompanyRules_German04>	3		7	2
87	2022-10-22 12:05:31.214+02	724	<CompanyRules_German05>	3		7	2
88	2022-10-22 12:05:31.215+02	726	<CompanyRules_German06>	3		7	2
89	2022-10-22 12:05:31.216+02	728	<CompanyRules_German07>	3		7	2
90	2022-10-22 12:05:31.216+02	730	<CompanyRules_German08>	3		7	2
91	2022-10-22 12:05:31.216+02	732	<CompanyRules_German09>	3		7	2
92	2022-10-22 12:05:31.217+02	734	<CompanyRules_German10>	3		7	2
93	2022-10-22 12:05:31.217+02	736	<CompanyRules_German11>	3		7	2
94	2022-10-22 12:05:31.218+02	738	<CompanyRules_German12>	3		7	2
95	2022-10-22 12:05:31.219+02	740	<CompanyRules_German13>	3		7	2
96	2022-10-22 12:05:31.219+02	742	<CompanyRules_German14>	3		7	2
97	2022-10-22 12:05:31.22+02	570	<CompanyTypeName>	3		7	2
98	2022-10-22 12:05:31.22+02	581	<Doc01_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
99	2022-10-22 12:05:31.221+02	582	<Doc01_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
100	2022-10-22 12:05:31.221+02	583	<Doc01_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
101	2022-10-22 12:05:31.222+02	584	<Doc01_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
102	2022-10-22 12:05:31.222+02	580	<Doc01_ApprovalFlow_Approver_Employee04>	3		7	2
103	2022-10-22 12:05:31.223+02	577	<Doc01_ApprovalFlow_Author_Employee01>	3		7	2
104	2022-10-22 12:05:31.223+02	579	<Doc01_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
105	2022-10-22 12:05:31.224+02	578	<Doc01_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
106	2022-10-22 12:05:31.226+02	576	<Doc01_CompanyQualityManagementSystem>	3		7	2
107	2022-10-22 12:05:31.227+02	571	<Doc01_EffectiveDate>	3		7	2
108	2022-10-22 12:05:31.227+02	572	<Doc01_PrintedDate>	3		7	2
109	2022-10-22 12:05:31.228+02	586	<Doc02_EmployeeName01>	3		7	2
110	2022-10-22 12:05:31.228+02	587	<Doc02_JobTitle_Employee01>	3		7	2
111	2022-10-22 12:05:31.229+02	588	<Doc03_Date>	3		7	2
112	2022-10-22 12:05:31.229+02	590	<Doc03_EmployeeName01>	3		7	2
113	2022-10-22 12:05:31.23+02	591	<Doc03_JobTitle_Employee01>	3		7	2
114	2022-10-22 12:05:31.23+02	589	<Doc03_Year>	3		7	2
115	2022-10-22 12:05:31.23+02	599	<Doc04_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
116	2022-10-22 12:05:31.231+02	600	<Doc04_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
117	2022-10-22 12:05:31.231+02	601	<Doc04_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
118	2022-10-22 12:05:31.232+02	602	<Doc04_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
119	2022-10-22 12:05:31.232+02	598	<Doc04_ApprovalFlow_Approver_Employee04>	3		7	2
120	2022-10-22 12:05:31.233+02	595	<Doc04_ApprovalFlow_Author_Employee01>	3		7	2
121	2022-10-22 12:05:31.233+02	597	<Doc04_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
122	2022-10-22 12:05:31.234+02	596	<Doc04_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
123	2022-10-22 12:05:31.234+02	592	<Doc04_EffectiveDate>	3		7	2
124	2022-10-22 12:05:31.234+02	593	<Doc04_PrintedDate>	3		7	2
125	2022-10-22 12:05:31.235+02	594	<Doc04_ValidDate>	3		7	2
126	2022-10-22 12:05:31.235+02	610	<Doc05_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
127	2022-10-22 12:05:31.236+02	611	<Doc05_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
128	2022-10-22 12:05:31.236+02	612	<Doc05_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
129	2022-10-22 12:05:31.237+02	613	<Doc05_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
130	2022-10-22 12:05:31.237+02	609	<Doc05_ApprovalFlow_Approver_Employee04>	3		7	2
131	2022-10-22 12:05:31.237+02	606	<Doc05_ApprovalFlow_Author_Employee01>	3		7	2
132	2022-10-22 12:05:31.238+02	608	<Doc05_ApprovalFlow_ComplianceInspector_Employee3>	3		7	2
133	2022-10-22 12:05:31.239+02	607	<Doc05_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
134	2022-10-22 12:05:31.239+02	603	<Doc05_EffectiveDate>	3		7	2
135	2022-10-22 12:05:31.24+02	604	<Doc05_PrintedDate>	3		7	2
136	2022-10-22 12:05:31.24+02	605	<Doc05_ValidDate>	3		7	2
137	2022-10-22 12:05:31.241+02	617	<Doc06_ApprovalFlow_Author_Employee01>	3		7	2
138	2022-10-22 12:05:31.241+02	618	<Doc06_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
139	2022-10-22 12:05:31.241+02	614	<Doc06_EffectiveDate>	3		7	2
140	2022-10-22 12:05:31.242+02	615	<Doc06_PrintedDate>	3		7	2
141	2022-10-22 12:05:31.242+02	616	<Doc06_ValidDate>	3		7	2
142	2022-10-22 12:05:31.243+02	633	<Doc07_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
143	2022-10-22 12:05:31.243+02	634	<Doc07_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
144	2022-10-22 12:05:31.243+02	635	<Doc07_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
145	2022-10-22 12:05:31.244+02	636	<Doc07_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
146	2022-10-22 12:05:31.244+02	632	<Doc07_ApprovalFlow_Approver_Employee04>	3		7	2
147	2022-10-22 12:05:31.245+02	629	<Doc07_ApprovalFlow_Author_Employee01>	3		7	2
148	2022-10-22 12:05:31.245+02	631	<Doc07_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
149	2022-10-22 12:05:31.245+02	630	<Doc07_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
150	2022-10-22 12:05:31.246+02	625	<Doc07_EffectiveDate>	3		7	2
151	2022-10-22 12:05:31.246+02	626	<Doc07_PrintedDate>	3		7	2
152	2022-10-22 12:05:31.247+02	627	<Doc07_ValidDate_Version01>	3		7	2
153	2022-10-22 12:05:31.247+02	628	<Doc07_ValidDate_Version02>	3		7	2
154	2022-10-22 12:05:31.247+02	643	<Doc08_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
155	2022-10-22 12:05:31.248+02	644	<Doc08_ApprovalFlow_ApprovalDate_Employee02>	3		7	2
156	2022-10-22 12:05:31.248+02	645	<Doc08_ApprovalFlow_ApprovalDate_Employee03>	3		7	2
157	2022-10-22 12:05:31.249+02	646	<Doc08_ApprovalFlow_ApprovalDate_Employee04>	3		7	2
158	2022-10-22 12:05:31.249+02	642	<Doc08_ApprovalFlow_Approver_Employee04>	3		7	2
159	2022-10-22 12:05:31.25+02	639	<Doc08_ApprovalFlow_Author_Employee01>	3		7	2
160	2022-10-22 12:05:31.25+02	641	<Doc08_ApprovalFlow_ComplianceInspector_Employee03>	3		7	2
161	2022-10-22 12:05:31.251+02	640	<Doc08_ApprovalFlow_TechnicalReviewer_Employee02>	3		7	2
162	2022-10-22 12:05:31.251+02	637	<Doc08_EffectiveDate>	3		7	2
163	2022-10-22 12:05:31.251+02	638	<Doc08_PrintedDate>	3		7	2
164	2022-10-22 12:05:31.252+02	657	<Doc09_ApprovalFlow_ApprovalDate_Employee01>	3		7	2
165	2022-10-22 14:37:30.018+02	Web Form Questionaire 2 2.xlsx	Web Form Questionaire 2 2.xlsx	3		14	2
166	2022-10-22 15:45:17.156+02	341	doc_uploads/01.MD-001 Quality Management Handbook/Organigram_Q1RP6HC.docx	3		8	2
167	2022-10-22 15:45:17.16+02	343	doc_uploads/01.MD-001 Quality Management Handbook/Quality_Commitment_0JFFzxc.docx	3		8	2
168	2022-10-22 15:45:17.164+02	342	doc_uploads/01.MD-001 Quality Management Handbook/Quality_Management_Handbook_rJBW8Q7.docx	3		8	2
169	2022-10-22 15:45:17.167+02	362	doc_uploads/02.SOP-QM-0901 Document Creation, Revision, Obsolescence and Control/SOP-QM-0901_Document_Creation_Revision_Obsolescence_and_Control_hkmL2sB.docx	3		8	2
170	2022-10-22 15:45:17.17+02	364	doc_uploads/02.SOP-QM-0901 Document Creation, Revision, Obsolescence and Control/SOP-QM-0901.A01_Flowchart_Diagram_50bE819.docx	3		8	2
171	2022-10-22 15:45:17.173+02	363	doc_uploads/02.SOP-QM-0901 Document Creation, Revision, Obsolescence and Control/SOP-QM-0901.A02_Template_Document_Change_Request_Form_POuPXhF.docx	3		8	2
172	2022-10-22 15:45:17.177+02	366	doc_uploads/Test-Doc-Quasy_AjtK3ES.docx	3		8	2
173	2022-10-22 15:45:17.18+02	351	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902_Qualification_and_Training_6wSO3H9.docx	3		8	2
174	2022-10-22 15:45:17.184+02	352	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902.A01_Training_Matrix_N5kQJWn.docx	3		8	2
175	2022-10-22 15:45:17.187+02	350	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902.A02_Template_Annual_Training_Plan_qLQgWxW.docx	3		8	2
176	2022-10-22 15:45:17.19+02	349	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902.A03_Template_Training_Record_tQoVncK.docx	3		8	2
177	2022-10-22 15:45:17.193+02	355	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902.A04_Template_Job_Description_HvNchI3.docx	3		8	2
178	2022-10-22 15:45:17.195+02	353	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902.A05_Template_Orientation_Plan_WOK2gf7.docx	3		8	2
179	2022-10-22 15:45:17.198+02	357	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902.A06_Template_On-the-job_Training_6qyipQK.docx	3		8	2
180	2022-10-22 15:45:17.2+02	356	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902.A07_Log_Sheet_for_Visitors_osHmlvh.docx	3		8	2
181	2022-10-22 15:45:17.202+02	354	doc_uploads/03.SOP-QM-0902 Qualification and Training/SOP-QM-0902.A08_Directive_for_Laboratory_Visitors_YeSm8tq.docx	3		8	2
182	2022-10-22 15:45:17.204+02	329	doc_uploads/04.SOP-QM-0903 Signature Rules at CompanyName/SOP-QM-0903_Signature_Rules_at_CompanyName_Vdu2eqR.docx	3		8	2
183	2022-10-22 15:45:17.207+02	328	doc_uploads/04.SOP-QM-0903 Signature Rules at CompanyName/SOP-QM-0903.A01_Template_Signature_and_Initials_cEJOrF2.docx	3		8	2
184	2022-10-22 15:45:17.21+02	348	doc_uploads/05.SOP-QM-0904 Good Documentation Practice/SOP-QM-0904_Good_Documentation_Practice_SGwlkEx.docx	3		8	2
185	2022-10-22 15:45:17.213+02	324	doc_uploads/06.SOP-QM-0907 Quality Risk Management/SOP-QM-0907_Quality_Risk_Management_1Ykw9Gg.docx	3		8	2
186	2022-10-22 15:45:17.217+02	325	doc_uploads/06.SOP-QM-0907 Quality Risk Management/SOP-QM-0907.A01_FMEA_Template_uBEJCW3.docx	3		8	2
187	2022-10-22 15:45:17.219+02	358	doc_uploads/07.SOP-QM-0911 Deviation Management/SOP-QM-0911_Deviation_Management_YQLbTVF.docx	3		8	2
188	2022-10-22 15:45:17.222+02	360	doc_uploads/07.SOP-QM-0911 Deviation Management/SOP-QM-0911.A01_Deviation_Notification_5f0QmJb.docx	3		8	2
189	2022-10-22 15:45:17.224+02	361	doc_uploads/07.SOP-QM-0911 Deviation Management/SOP-QM-0911.A02_Deviation_Report_77rToNb.docx	3		8	2
190	2022-10-22 15:45:17.226+02	359	doc_uploads/07.SOP-QM-0911 Deviation Management/SOP-QM-0911.A03_Quality_Investigation_and_Assessment_Tools_MoDVoY3.docx	3		8	2
191	2022-10-22 15:45:17.228+02	344	doc_uploads/08.SOP-QM-0912 CAPA Management/SOP-QM-0912_CAPA_Management_M3gctxj.docx	3		8	2
192	2022-10-22 15:45:17.23+02	346	doc_uploads/08.SOP-QM-0912 CAPA Management/SOP-QM-0912.A01_CAPA_Report_DSwMTil.docx	3		8	2
193	2022-10-22 15:45:17.233+02	347	doc_uploads/08.SOP-QM-0912 CAPA Management/SOP-QM-0912.A02_CAPA_Effectiveness_Check_Report_JooAt9E.docx	3		8	2
194	2022-10-22 15:45:17.235+02	345	doc_uploads/08.SOP-QM-0912 CAPA Management/SOP-QM-0912.A03_CAPA_Tracker_JWpLhXB.docx	3		8	2
195	2022-10-22 15:45:17.237+02	367	doc_uploads/Test-Doc-Quasy_iZr4bFp.docx	3		8	2
196	2022-10-22 15:45:17.239+02	327	doc_uploads/09.SOP-QM-0918 Management Review/SOP-QM-0918_Management_Review_kVF0PGs.docx	3		8	2
197	2022-10-22 15:45:17.241+02	322	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919_Internal_Audit_Bl5MKyy.docx	3		8	2
198	2022-10-22 15:45:17.243+02	318	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A01_Annual_Internal_Audits_Schedule_sntwPA6.docx	3		8	2
199	2022-10-22 15:45:17.245+02	317	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A02_Internal_Audit_Announcement_ZWliSbL.docx	3		8	2
200	2022-10-22 15:45:17.248+02	319	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A03_List_of_Certified_Auditors_for_Internal_Audits_Tm4vGwZ.docx	3		8	2
201	2022-10-22 15:45:17.25+02	314	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A04_Internal_Audit_Plan_Ix1vKPW.docx	3		8	2
202	2022-10-22 15:45:17.252+02	321	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A05_Audit_Checklist_1UrIX0f.docx	3		8	2
203	2022-10-22 15:45:17.254+02	320	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A06_Internal_Audits_Logbook_aCRyd6n.docx	3		8	2
204	2022-10-22 15:45:17.256+02	323	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A07_Internal_Audit_Execution_PA5xxkp.docx	3		8	2
205	2022-10-22 15:45:17.258+02	315	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A08_Internal_Audit_Report_Cw31gu3.docx	3		8	2
206	2022-10-22 15:45:17.261+02	316	doc_uploads/10.SOP-QM-0919 Internal Audit/SOP-QM-0919.A09_Compliance_Report_khG12o5.docx	3		8	2
207	2022-10-22 15:45:17.263+02	335	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921_Complaints_and_Recalls_BCynqwz.docx	3		8	2
208	2022-10-22 15:45:17.265+02	340	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A01_Complaint_Receipt_Template_CaZRDwn.docx	3		8	2
209	2022-10-22 15:45:17.267+02	330	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A02_Complaint_Preliminary_Assessment_dpt2FuQ.docx	3		8	2
210	2022-10-22 15:45:17.269+02	337	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A03_Complaints_Logbook_o90gXDk.docx	3		8	2
211	2022-10-22 15:45:17.272+02	332	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A04_Complaint_Investigation_Plan_ChKFXZ6.docx	3		8	2
212	2022-10-22 15:45:17.274+02	331	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A05_Examples_of_market_complaint_with_the_guideline_for_investigation_1qmCPTc.docx	3		8	2
213	2022-10-22 15:45:17.276+02	333	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A06_Complaint_Investigation_Report_ftolVTA.docx	3		8	2
214	2022-10-22 15:45:17.277+02	336	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A07_List_of_Recall_Committee_Members_nC0zy3r.docx	3		8	2
215	2022-10-22 15:45:17.279+02	338	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A08_Product_Recall_Statement_8LMVNBj.docx	3		8	2
216	2022-10-22 15:45:17.281+02	339	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A09_Product_Recall_Status_B4rLK0e.docx	3		8	2
217	2022-10-22 15:45:17.283+02	334	doc_uploads/11.SOP-QM-0921 Complaints and Recalls/SOP-QM-0921.A10_Recall_Final_Report_cdMob1D.docx	3		8	2
218	2022-10-22 15:45:17.285+02	326	doc_uploads/12.SOP-RD-0581 Computerized Systems Lifecycle Management/SOP-RD-0581_Computerized_Systems_Lifecycle_Management_NOZBOlJ.docx	3		8	2
219	2022-10-22 15:45:38.763+02	Web Form Questionaire.xlsx	Web Form Questionaire.xlsx	3		14	2
220	2022-10-22 15:45:38.766+02	Web Form Questionaire 2.xlsx	Web Form Questionaire 2.xlsx	3		14	2
221	2023-01-23 00:31:06.187359+01	4	test@quasy.com	1	[{"added": {}}]	6	3
222	2023-05-11 07:53:58.613638+02	5	test@test.com	3		6	3
223	2023-10-22 22:24:55.769493+02	7	guenther.eder@gmail.com	3		6	3
224	2023-10-22 22:26:50.122141+02	8	guenther.eder@gmail.com	3		6	3
225	2023-10-22 22:29:14.282497+02	9	guenther.eder@gmail.com	3		6	3
226	2023-10-22 22:50:43.844807+02	10	guenther.eder@gmail.com	3		6	3
227	2023-10-22 22:53:03.404401+02	11	guenther.eder@gmail.com	3		6	3
\.


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

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	group
4	contenttypes	contenttype
5	sessions	session
6	qmds	user
7	qmds	tag
8	qmds	document
9	web	company
10	web	tagmap
11	web	order
12	web	employee
13	qmds	converteddocument
14	qmds	tagsourcefile
15	questioning	compositedocument
16	questioning	compositedocumentconverted
17	questioning	section
18	web	project
19	web	tagmapcompany
20	client	compositecompanydocument
21	client	sectioncompany
22	client	compositecompanydocumentconverted
23	client	conversionprogress
24	qmds	companyuserinvitation
25	questioning	question
26	questioning	questionssourcefile
27	questioning	resulttest
28	web	trainingmaterial
29	client	compositecompanydocumentclientresponse
30	client	compositecompanydocumentclientresponsecomment
\.


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

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2023-01-16 23:49:31.481876+01
2	contenttypes	0002_remove_content_type_name	2023-01-16 23:49:31.497616+01
3	auth	0001_initial	2023-01-16 23:49:31.557655+01
4	auth	0002_alter_permission_name_max_length	2023-01-16 23:49:31.565614+01
5	auth	0003_alter_user_email_max_length	2023-01-16 23:49:31.574749+01
6	auth	0004_alter_user_username_opts	2023-01-16 23:49:31.586341+01
7	auth	0005_alter_user_last_login_null	2023-01-16 23:49:31.595004+01
8	auth	0006_require_contenttypes_0002	2023-01-16 23:49:31.597748+01
9	auth	0007_alter_validators_add_error_messages	2023-01-16 23:49:31.607877+01
10	auth	0008_alter_user_username_max_length	2023-01-16 23:49:31.617293+01
11	auth	0009_alter_user_last_name_max_length	2023-01-16 23:49:31.629549+01
12	auth	0010_alter_group_name_max_length	2023-01-16 23:49:31.639854+01
13	auth	0011_update_proxy_permissions	2023-01-16 23:49:31.650134+01
14	auth	0012_alter_user_first_name_max_length	2023-01-16 23:49:31.664439+01
15	qmds	0001_initial	2023-01-16 23:49:31.80031+01
16	admin	0001_initial	2023-01-16 23:49:31.82919+01
17	admin	0002_logentry_remove_auto_add	2023-01-16 23:49:31.850276+01
18	admin	0003_logentry_add_action_flag_choices	2023-01-16 23:49:31.869406+01
19	web	0001_initial	2023-01-16 23:49:32.044215+01
20	client	0001_initial	2023-01-16 23:49:32.078884+01
21	client	0002_initial	2023-01-16 23:49:32.283948+01
22	questioning	0001_initial	2023-01-16 23:49:32.518284+01
23	sessions	0001_initial	2023-01-16 23:49:32.532927+01
24	qmds	0002_user_view_as_user	2023-02-05 18:48:12.718922+01
25	web	0002_company_staff	2023-02-05 23:49:03.521485+01
26	qmds	0003_auto_20230205_2221	2023-02-05 23:49:03.587608+01
27	qmds	0004_companyuserinvitation	2023-02-05 23:49:03.636625+01
28	client	0003_compositecompanydocumentconverted_missing_tags	2023-02-08 00:08:50.915675+01
29	qmds	0005_converteddocument_missing_tags	2023-02-08 00:08:50.93918+01
30	questioning	0002_compositedocumentconverted_missing_tags	2023-02-08 00:08:50.948645+01
31	questioning	0003_question	2023-03-03 09:37:37.501657+01
32	questioning	0004_questionssourcefile	2023-03-03 09:37:37.516005+01
33	questioning	0005_alter_question_correct	2023-03-03 09:37:37.535774+01
34	questioning	0006_alter_question_correct	2023-03-03 09:37:37.55299+01
35	questioning	0007_question_source	2023-03-03 09:37:37.57056+01
36	questioning	0008_resulttest	2023-03-20 00:39:43.189896+01
37	questioning	0009_resulttest_duration	2023-03-20 00:39:43.220771+01
38	web	0003_project_status	2023-03-25 18:04:46.363563+01
39	web	0004_alter_project_status	2023-03-25 18:04:46.402291+01
40	qmds	0006_alter_tag_tag	2023-03-25 18:37:19.499645+01
41	qmds	0007_auto_20230417_0107	2023-04-17 01:10:21.57056+02
42	web	0005_trainingmaterial	2023-04-28 00:22:14.266358+02
43	web	0006_rename_project_trainingmaterial_projects	2023-04-28 00:22:14.277382+02
44	web	0007_trainingmaterial_type	2023-05-15 01:09:49.721951+02
45	questioning	0010_question_project	2023-05-21 18:17:21.054653+02
46	questioning	0011_auto_20230521_1631	2023-05-21 18:17:21.215771+02
47	client	0004_compositecompanydocumentclientresponse_and_more	2023-08-06 19:09:06.092452+02
48	client	0005_compositecompanydocumentclientresponse_closed	2023-08-06 19:09:06.110148+02
49	client	0006_compositecompanydocumentclientresponse_author	2023-08-06 19:09:06.155577+02
50	client	0007_compositecompanydocumentclientresponsecomment_file	2023-08-06 19:09:06.17804+02
51	qmds	0008_rename_comment_tag_comment_en_and_more	2024-01-07 16:40:25.827224+01
52	qmds	0009_tag_comment_de_tag_default_value_de_and_more	2024-01-07 16:40:25.869339+01
53	web	0008_company_language_project_language	2024-01-07 16:40:25.920128+01
54	web	0009_alter_company_language_alter_project_language	2024-01-07 16:40:25.97613+01
\.


--
-- Data for Name: qmds_companyuserinvitation; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.qmds_companyuserinvitation (id, company_id, user_id) FROM stdin;
\.


--
-- Data for Name: qmds_converteddocument; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.qmds_converteddocument (source_id, file, created_at, updated_at, user_id, missing_tags) FROM stdin;
369	doc_converted/Quality_Management_Handbook.docx	2022-10-22 16:14:33.611+02	2022-10-22 16:14:33.611+02	2	
370	doc_converted/SOP-TEST_New_Tags.docx	2022-10-22 16:06:21.34+02	2022-10-22 16:06:21.34+02	2	
\.


--
-- Data for Name: qmds_document; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.qmds_document (id, original_file_name, file, doc_id, parent_dir, fixed, created_at, updated_at, user_id) FROM stdin;
369	Quality Management Handbook.docx	doc_uploads/Quality_Manual_wnx6mSK.docx			f	2022-10-22 15:53:32.115+02	2022-10-24 07:14:25.723+02	2
370	SOP-TEST New Tags.docx	doc_uploads/SOP-TEST_New_Tags.docx	SOP-TEST		f	2022-10-22 15:54:59.613+02	2022-11-14 08:22:41.787+01	2
\.


--
-- Data for Name: qmds_tag; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.qmds_tag (id, tag, tag_type, instruction_en, default_value_en, doc_type, value_type, comment_en, related_document, "position", parent_id, comment_de, default_value_de, instruction_de) FROM stdin;
4849	MaterialManagementCode	1	Specify document code of your Material Management SOP, if needed	SOP-14	4	1		SOP-14 Material Management	15	\N			
4853	SuppliersCode	1	Specify document code of your Outsourced activities Management SOP, if needed	SOP-13	4	1		SOP-13 Supplier Management	14	\N			
4850	QRM_Code	1	Specify document code of your Quality Risk Management SOP, if needed	SOP-09	4	1		SOP-09 Quality Risk Management	10	\N			
4847	GDCPCode	1	Specify document code of your Good Documentation Practice SOP, if needed	SOP-02	4	1		SOP-02 Good Documentation Practice	3	\N			
4883	DCR_Title	3		Document Change Request	2	1		SOP-01 Documentation Management	1	4846			
4889	DocMngmtTitle	3	Specify the Name of your Documentation Management SOP, if needed	Documentation Management	1	1		SOP-01 Documentation Management	1	4846			
4841	CAPA_Code	1	Specify document code of your CAPA Management SOP, if needed	SOP-07	4	1		SOP-07 CAPA Management	8	\N			
4840	AuditsInspectionsCode	1	Specify document code of your Self inspections and Audits Management SOP, if needed	SOP-08	4	1		SOP-08 Audits	9	\N			
4851	QualityManualCode	1	Specify document code of your Quality Manual document, if needed	MD-01	4	1		MD-01 Quality Manual	1	\N			
4843	CompSystemsCode	1	Specify document code of your Computerized Systems Management SOP, if needed	SOP-15	4	1		SOP-15 Computerized Systems Management	16	\N			
4842	ChangeManagementCode	1	Specify document code of your Change Management SOP, if needed	SOP-05	4	1		SOP-05 Change Management	6	\N			
4888	Deviation_Nonconformity_Tracker	3		04 Form "Deviations and Nonconformity Tracker"	2	1		SOP-06 Deviation Management	1	4845			
4846	DocMngmtCode	1	Specify document code of your Documentation Management SOP, if needed	SOP-01	4	1		SOP-01 Documentation Management	2	\N			
4845	DevMng_Code	1		SOP-06	4	1		SOP-06 Deviation Management	7	\N			
4855	APQR_AnnualPlan	3		APQR Annual Plan	2	1		SOP-11 Annual Product Quality Review	1	4838			
4856	APQR_Report	3		APQR Report	2	1		SOP-11 Annual Product Quality Review	1	4838			
4857	APQR_Title	3	Specify the Name of your Annual Product Quality Review SOP, if needed	Annual Product Quality Review	1	1		SOP-11 Annual Product Quality Review	1	4838			
4848	ManagementReviewCode	1	Specify document code of your Management Review SOP, if needed	SOP-04	4	1		SOP-04 Management Review	5	\N			
4859	AuditPlan	3	Specify the Name of your Audit Plan Form, if needed	Audit Plan	2	1		SOP-08 Audits	1	4840			
4860	AuditReport	3		Audit Report	2	1		SOP-08 Audits	1	4840			
4861	AuditorsList	3		Auditors List	2	1		SOP-08 Audits	1	4840			
4862	AuditsInspectionsTitle	3	Specify the Name of your Self inspections and Audits Management SOP, if needed	Audits Management	1	1		SOP-08 Audits	1	4840			
4864	CAPA_Report	3		CAPA Report	2	1		SOP-07 CAPA Management	1	4841			
4865	CAPA_Request	3		CAPA Request	2	1		SOP-07 CAPA Management	1	4841			
4866	CAPA_Title	3	Specify the Name of your CAPA Management SOP, if needed	CAPA Management	1	1		SOP-07 CAPA Management	1	4841			
4867	CAPA_Tracker	3		CAPA Tracker	2	1		SOP-07 CAPA Management	1	4841			
4868	CEO	4	Who is the highest-ranking executive in your Organization, whose primary responsibilities include establishing the vision, making major corporate decisions, managing the overall operations and resources of the company?	e.g., CEO	4	1		role	1	\N			
4869	ChangeControlForm	3		Change	2	1		SOP-05 Change Management	1	4842			
4870	ChangeManagementTitle	3	Specify the Name of your Change Management SOP, if needed	Change Management	1	1		SOP-05 Change Management	1	4842			
4871	ChangeSMEsMatrix	3		Change impact assessment SMEs Matrix	3	1		SOP-05 Change Management	1	4842			
4872	ChangesTracker	3		Changes Tracker	2	1		SOP-05 Change Management	1	4842			
4873	CompSystemsManager	4	Who is responsible for Computerized Systems in your Organization?	e.g., Electronic Data Manager	4	1		role	1	\N			
4874	CompSystemsTitle	3	Specify the Name of your Computerized Systems Management SOP, if needed	Computerized Systems Management	1	1		SOP-15 Computerized Systems Management	1	4843			
4875	CompanyLogo	2	Organisation Logo		4	1		general	1	\N			
4876	CompanyName	2	Organisation Name	Organisation Name	4	1		general	1	\N			
4877	ComplaintNotification	3		Complaint Notification	2	1		SOP-12 Complaints and Recalls Management	1	4844			
4878	ComplaintPrelimAssess	3		Complaint Preliminary Assessment	2	1		SOP-12 Complaints and Recalls Management	1	4844			
4879	Complaint_Investigation_Plan	3		Complaint Investigation Plan	2	1		SOP-12 Complaints and Recalls Management	1	4844			
4880	Complaint_Investigation_Report	3		Complaint Investigation Report	2	1		SOP-12 Complaints and Recalls Management	1	4844			
4881	ComplaintsLog	3		Complaints Log	2	1		SOP-12 Complaints and Recalls Management	1	4844			
4882	ComplaintsRecallsTitle	3	Specify the Name of your Complaints and Recalls Management SOP, if needed	Complaints and Recalls Management	1	1		SOP-12 Complaints and Recalls Management	1	4844			
4858	ArchivingTitle	3		Archiving	1	1		SOP-16 Archiving	1	4839			
4886	DevNotificationTitle	3		01 Form "Deviation and Nonconformity Notification"	2	1		SOP-06 Deviation Management	1	4845			
4887	DevReportTitle	3		02 Form "Deviation and Nonconformity Investigation Report"	2	1		SOP-06 Deviation Management	1	4845			
4852	QualityPlanCode	1	Specify document code of your Quality Plan SOP, if needed	SOP-03	4	1		SOP-03 Quality Plan	4	\N			
4884	DevInvestToolsTitle	3		03 Appendix "Quality Investigation and Assessment Tools"	3	1		SOP-06 Deviation Management	1	4845			
4885	DevMng_Title	3		Deviation and Nonconformity Management	1	1		SOP-06 Deviation Management	1	4845			
4839	ArchivingCode	1		SOP-16	4	1		SOP-16 Archiving	17	\N			
4890	EDMS_Title	2	What Electronic Document Management System do you use or plan to use to manage Documents in your organization.	[Electronic Document Management System]	4	1		general	1	\N			
4891	EffectiveDate	2	Specify actual Effective Date for all listed Documents in your Organization		4	3		general	1	\N			
4854	TrainingCode	1	Specify document code of your Training Management SOP, if needed	SOP-10	4	1		SOP-10 Training Management	11	\N			
4893	FMEA_Form	3		Failure Mode Effects Analysis (FMEA)	2	1		SOP-09 Quality Risk Management	1	4850			
4894	FOOTER	2	Specify the Main Document standard Footer (page bottom part)	[Printed Main Documents are valid only on the date of printing. Printed Appendices for recording are valid only when issued by the assigned responsible employee with date and Initials, either as handwriting on the first page of printouts or as watermarks in protected digital documents. <Printing Date and Time>”.]	4	1		general	1	\N			
4940	SignaturesInitials	3		Signatures and Initials	2	1			1	4847			
4892	External_Audits_Programme	3		External Audits Programme	2	1		SOP-08 Audits	1	4840			
4897	LegalAdress	2	What is a registered Organisation address?	[concatenation of adress, city, postal code, country in one textual field]	4	1		general	1	\N			
4898	ManagementReviewTitle	3	Specify the Name of your Management Review SOP, if needed	Management Review	1	1		SOP-04 Management Review	1	4848			
4899	Manufacturing_Head	4	Who is the highest-ranking executive in your Manufacturing Department?	e.g., Manufacturing Head	4	1		role	1	\N			
4900	MaterialManagementTitle	3	Specify the Name of your Complaints and Material Management SOP, if needed	Material Management	1	1		SOP-14 Material Management	1	4849			
4901	OperationalAdress	2	What is address of your Organization where the main operational activities for the production of your products or services are carried out?	[concatenation of adress, city, postal code, country in one textual field]	4	1		general	1	\N			
4902	OrganigramTitle	3		Organigram	3	1		MD-01 Quality Manual	1	4851			
4903	ProdServList	2	What products and/or services does your Organization produce or plan to produce?	[Products/services categories list]	4	1		general	1	\N			
4904	QC_Head	4	Who is the highest-ranking executive in your Quality Control laboratory?	e.g., QC Head	4	1		role	1	\N			
4905	QRM_Title	3	Specify the Name of your Quality Risk Management SOP, if needed	Quality Risk Management	1	1		SOP-09 Quality Risk Management	1	4850			
4906	QualityCommitmentTitle	3	Specify the Name of your Quality Commitment document, if needed	Quality Commitment	3	1		MD-01 Quality Manual	1	4851			
4907	QualityDesignee1	4	Who is the deputy Head of your Quality Organization?	e.g., Quality Management Director Deputy	4	1		role	1	\N			
4908	QualityDesignee2	4	Specify the third operational level designee in your Quality Organization	e.g., Quality Specialist	4	1		role	1	\N			
4909	QualityManualTitle	3	Specify the Name of your Quality Manual document, if needed	Quality Manual	1	1		MD-01 Quality Manual	1	4851			
4910	QualityOrganizationHead	4	Who leads your Quality Organization?	e.g., Quality Management Director	4	1		role	1	\N			
4911	QualityPlanTitle	3	Specify the Name of your Quality Plan SOP, if needed	Quality Plan	1	1		SOP-03 Quality Plan	1	4852			
4912	RCC_Members	3		Recall Committee Members	2	1		SOP-12 Complaints and Recalls Management	1	4844			
4913	Recall_Report	3		Recall Report	2	1		SOP-12 Complaints and Recalls Management	1	4844			
4914	Recall_Statement	3		Recall Statement	2	1		SOP-12 Complaints and Recalls Management	1	4844			
4915	RegulatoryAffairs_Head	4	Who is the highest-ranking executive in your Regulatory Affairs Department?	e.g., Regulatory Affairs Head	4	1		role	1	\N			
4923	TrainingMatrix	3		Training Matrix	2	1		SOP-10 Training Management	1	4854			
4917	SupplierEvaluation	3		Supplier Evaluation	2	1		SOP-13 Supplier Management	1	4853			
4918	SupplierQAA	3		Quality Assurance Agreement	2	1		SOP-13 Supplier Management	1	4853			
4919	SupplierSelfAssessment	3		Supplier Self Assessment	2	1		SOP-13 Supplier Management	1	4853			
4920	SuppliersList	3		Qualified Supplier List	2	1		SOP-13 Supplier Management	1	4853			
4921	SuppliersTitle	3	Specify the Name of your Outsourced activities Management SOP, if needed	Supplier Management	1	1		SOP-13 Supplier Management	1	4853			
4922	TrainingCoordinator	4	Who supports your Quality Organization Lead for facilitating the implementation, monitoring of activities related to the training and qualification of personnel in your organization?	e.g., Training QA Specialist	4	1		role	1	\N			
4924	TrainingPlan	3		Annual Training Plan	2	1		SOP-10 Training Management	1	4854			
4925	TrainingRecord	3		Training Record	2	1		SOP-10 Training Management	1	4854			
4926	TrainingTitle	3	Specify the Name of your Training Management SOP, if needed	Training Management	1	1		SOP-10 Training Management	1	4854			
4937	MasterCopyLog	3		Master Copies Log	2	1			1	4846			
4927	Material_List	3		Material Qualification Status List (MQSL)	2	1			1	4849			
4928	Material_URS	3		Material User Requirement Specification (MURS)	2	1			1	4849			
4929	Material_Assessment_Docs	3		Documents for the Material Assessment	3	1			1	4849			
4930	Archivarius	4	Who supports your Quality Organization Lead in activities related to the archiving of documents in your organization?	e.g., Archiving Specialist	4	1			1	\N			
4933	Document_Loan_Request	3		Document Loan Request	2	1			1	4839			
4934	Document_Destruction_Request	3		Document Destruction Request	2	1			1	4839			
4932	Archiving_Register	3		Archiving Register	2	1			1	4839			
4896	Internal_Audits_Programme	3		Internal Audits Programme	2	1		SOP-08 Audits	1	4840			
4916	SOP_WI_FormTitle	3		SOP and WI	2	1		SOP-01 Documentation Management	1	4846			
4938	ContrCopyLog	3		Controlled Copies Log	2	1			1	4846			
4944	GDCPTitle	3		Good Documentation Practice	1	1			1	4847			
4931	Archiving_Request	3		Archiving Request	2	1			1	4839			
4838	APQR_Code	1	Specify document code of your Annual Product Quality Review SOP, if needed	SOP-11	4	1		SOP-11 Annual Product Quality Review	12	\N			
4844	ComplaintsRecallsCode	1	Specify document code of your Complaints and Recalls Management SOP, if needed	SOP-12	4	1		SOP-12 Complaints and Recalls Management	13	\N			
\.


--
-- Data for Name: qmds_tagsourcefile; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.qmds_tagsourcefile (original_file_name, file, chosen, created_at, updated_at) FROM stdin;
BaseTagsFull-221213.xlsx	source/BaseTagsFull-221213_H3bXa6t.xlsx	f	2022-12-13 19:16:33.005+01	2024-01-07 16:42:45.637094+01
BaseTagsFull-221213_1413.xlsx	source/BaseTagsFull-221213_1413.xlsx	f	2022-12-13 14:21:44.863+01	2024-01-07 16:42:45.640429+01
BaseTagsFull-221213_1623 affected.xlsx	source/BaseTagsFull-221213_1623_affected.xlsx	f	2022-12-13 16:36:29.061+01	2024-01-07 16:42:45.64357+01
BaseTagsFull-221213_2007.xlsx	source/BaseTagsFull-221213_2007.xlsx	f	2022-12-13 20:09:06.212+01	2024-01-07 16:42:45.64529+01
Web Form Questionaire (2).xlsx	source/Web_Form_Questionaire_2.xlsx	f	2022-11-04 03:02:00.818+01	2024-01-07 16:42:45.647421+01
Web Form Questionaire.xlsx	source/Web_Form_Questionaire_asO6Tz7.xlsx	f	2022-10-22 15:51:35.634+02	2024-01-07 16:42:45.648583+01
BaseTagsFull-290123_1034.xlsx	source/BaseTagsFull-290123_1034.xlsx	f	2023-01-29 16:34:07.600938+01	2024-01-07 16:42:45.649603+01
BaseTagsFull-070124_1641.xlsx	source/BaseTagsFull-070124_1641.xlsx	t	2024-01-07 16:42:45.65482+01	2024-01-07 16:42:45.65484+01
\.


--
-- Data for Name: qmds_user_groups; Type: TABLE DATA; Schema: public; Owner: admin
--

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


--
-- Data for Name: qmds_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: admin
--

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


--
-- Data for Name: questioning_compositedocument; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.questioning_compositedocument (id, file, doc_type, "position", updated_at, section_id, tag_1_id, tag_2_id) FROM stdin;
355	composite/External_Audits_Programmme.docx	2	26	2023-09-07 08:50:25.171011+02	125	8827	8825
354	composite/Internal_Audits_Programme.docx	2	22	2023-09-07 08:50:25.16572+02	125	8827	8826
368	composite/Complaint_Notification_TMTfWct.docx	2	36	2023-09-07 08:50:25.182902+02	130	8758	8740
384	composite/Documents_for_the_Material_Assessment_vZB0d69.docx	3	49	2023-09-07 08:50:25.202361+02	132	8713	8794
400	composite/SOP-13_Supplier_Management_op6cHTd.docx	1	12	2023-09-07 08:50:25.153826+02	131	8717	8786
396	composite/Document_Destruction_Request_yaM7D3B.docx	2	53	2023-09-07 08:50:25.207254+02	136	8805	8804
364	composite/SOP_APQR_ccOIKdD.docx	1	14	2023-09-07 08:50:25.156062+02	128	8757	8721
421		3	60	2023-09-07 08:50:25.214968+02	144	8707	8734
358	composite/SOP_QRM-AL.docx	1	3	2023-09-07 08:50:25.142995+02	126	8714	8770
348	composite/SOP_CAPA_Management_XKMrZ3A.docx	1	0	2023-09-07 08:50:25.139516+02	123	8706	8729
385	composite/SOP_Computerized_Systems_ErqqpiV.docx	1	4	2023-09-07 08:50:25.144041+02	133	8807	8806
357	composite/Audit_Report_Ox1CrvD.docx	2	29	2023-09-07 08:50:25.174776+02	125	8827	8822
392	composite/SOP-16_Archiving_7VNt55l.docx	1	5	2023-09-07 08:50:25.14532+02	136	8805	8800
381	composite/SOP-14_Material_Management_PGsJLPb.docx	1	6	2023-09-07 08:50:25.146516+02	132	8713	8765
333	composite/MD-01_Quality_Manual_YZjPXuH.docx	1	7	2023-09-07 08:50:25.147698+02	115	8715	8774
373	composite/Recall_Committee_Members_FxBtgM7.docx	2	43	2023-09-07 08:50:25.193621+02	130	8758	8777
360	composite/SOP_Training_YwkrViJ.docx	1	8	2023-09-07 08:50:25.148903+02	127	8718	8791
372	composite/Complaints_Log_f8naStH.docx	2	34	2023-09-07 08:50:25.180658+02	130	8758	8744
359	composite/FMEA_Template_FONUo2a.docx	2	28	2023-09-07 08:50:25.173568+02	126	8714	8756
352	composite/SOP_Audits_Management_new_flsxFDQ.docx	1	9	2023-09-07 08:50:25.150444+02	125	8827	8824
343	composite/SOP_Deviation_and_Nonconformity_Management-AL.docx	1	10	2023-09-07 08:50:25.15164+02	122	8813	8808
375	composite/Recall_Statement_PisMWEQ.docx	2	45	2023-09-07 08:50:25.196471+02	130	8758	8779
335	composite/SOP-04_Management_Review-AL.docx	1	11	2023-09-07 08:50:25.152742+02	118	8712	8763
412	composite/SOP-03_Quality_Plan-AL_4d6xcmh.docx	1	13	2023-09-07 08:50:25.154981+02	141	8838	8837
336	composite/MD-01_Organigram_appendix_dapm3m2.docx	3	15	2023-09-07 08:50:25.157248+02	115	8715	8767
422		2	61	2023-09-07 08:50:25.216017+02	144	8707	8735
407	composite/SOP-01_Controlled_Copies_Log.docx	2	57	2023-09-07 08:50:25.21173+02	139	8835	8834
510	composite/Quality_Manual_4x387aX.docx	1	62	2023-09-07 08:50:25.217094+02	231	9935	9998
349	composite/CAPA_Report_gdk6Qr0.docx	2	24	2023-09-07 08:50:25.168487+02	123	8706	8727
351	composite/CAPA_Tracker_XKUhPXo.docx	2	25	2023-09-07 08:50:25.169783+02	123	8706	8730
337	composite/MD-01_Quality_Commitment_appendix_E6uRGah.docx	3	16	2023-09-07 08:50:25.158362+02	115	8715	8771
370	composite/Complaint_Investigation_Plan_gmYhegN.docx	2	39	2023-09-07 08:50:25.186415+02	130	8758	8742
393	composite/Archiving_Request_Form_vo4oDyz.docx	2	50	2023-09-07 08:50:25.203715+02	136	8805	8801
344	composite/Deviation_and_Nonconformance_Notification_Form_ouxgY8r.docx	2	17	2023-09-07 08:50:25.159447+02	122	8813	8809
365	composite/APQR_Annual_Plan_aqLArfG.docx	2	31	2023-09-07 08:50:25.17705+02	128	8757	8719
345	composite/Deviation_and_Nonconformance_Report_Form_zGcdyFm.docx	2	18	2023-09-07 08:50:25.160627+02	122	8813	8810
361	composite/Training_Matrix_9x4NzA7.docx	2	30	2023-09-07 08:50:25.175893+02	127	8718	8788
346	composite/Deviations_and_Nonconformances_Tracker_ye2g3PT.docx	2	19	2023-09-07 08:50:25.161801+02	122	8813	8811
353	composite/Auditors_List_VqktGdJ.docx	2	20	2023-09-07 08:50:25.163037+02	125	8827	8823
374	composite/Recall_Report_O3ICcZF.docx	2	48	2023-09-07 08:50:25.200859+02	130	8758	8778
347	composite/Quality_Investigation_and_Assessment_Tools_Appendix_IQXShwt.docx	3	21	2023-09-07 08:50:25.164498+02	122	8813	8812
350	composite/CAPA_Request_kcwK0PH.docx	2	23	2023-09-07 08:50:25.167295+02	123	8706	8728
366	composite/APQR_Report_kJIkry3.docx	2	37	2023-09-07 08:50:25.184056+02	128	8757	8720
356	composite/Audit_Plan_mCCT2nv.docx	2	27	2023-09-07 08:50:25.172277+02	125	8827	8821
404	composite/SOP-01_Document_Change_Request_Form_U5HHpK3.docx	2	54	2023-09-07 08:50:25.208306+02	139	8835	8830
362	composite/Annual_Training_Plan_uolzFkt.docx	2	32	2023-09-07 08:50:25.17829+02	127	8718	8789
378	composite/Quality_Assurance_Agreement_Zl5pRXz.docx	2	41	2023-09-07 08:50:25.190185+02	131	8717	8783
363	composite/Training_Record_z0gM7RS.docx	2	33	2023-09-07 08:50:25.179437+02	127	8718	8790
371	composite/Complaint_Investigation_Report_81xAsDE.docx	2	42	2023-09-07 08:50:25.192212+02	130	8758	8743
379	composite/Supplier_Self_Assessment_dOHHmE8.docx	2	35	2023-09-07 08:50:25.181746+02	131	8717	8784
369	composite/Complaint_Preliminary_Assessment_kwGgka2.docx	2	38	2023-09-07 08:50:25.185201+02	130	8758	8741
377	composite/Supplier_Evaluation_PPM8bvQ.docx	2	40	2023-09-07 08:50:25.188023+02	131	8717	8782
380	composite/Supplier_List_UOhEybj.docx	2	44	2023-09-07 08:50:25.195116+02	131	8717	8785
405	composite/SOP-01_and_WI_Form_B4mZwQM.docx	2	55	2023-09-07 08:50:25.209544+02	139	8835	8833
382	composite/Material_Qualification_Status_List_MQSL_ian4S54.docx	2	46	2023-09-07 08:50:25.197856+02	132	8713	8792
383	composite/Material_User_Requirement_Specification_vIVxxvy.docx	2	47	2023-09-07 08:50:25.199322+02	132	8713	8793
394	composite/Archiving_register_uP1Ei66.docx	2	51	2023-09-07 08:50:25.204907+02	136	8805	8802
395	composite/Document_Loan_Request_dN5AOOQ.docx	2	52	2023-09-07 08:50:25.206047+02	136	8805	8803
406	composite/SOP-01_Master_Copies_Log.docx	2	56	2023-09-07 08:50:25.210656+02	139	8835	8832
419		1	58	2023-09-07 08:50:25.212844+02	144	8707	8733
420		2	59	2023-09-07 08:50:25.213914+02	144	8707	8732
367	composite/SOP_Complaints_and_Recalls_3SDnI6N.docx	1	1	2023-09-07 08:50:25.140694+02	130	8758	8745
403	composite/SOP-01_Documentation_Management_URDf0Ja.docx	1	2	2023-09-07 08:50:25.141854+02	139	8835	8831
511	composite/Organigram_pCTPyUT.docx	3	63	2023-09-07 08:50:25.218119+02	231	9935	9991
512	composite/Quality_Commitment_sUMjm7c.docx	3	64	2023-09-07 08:50:25.219161+02	231	9935	9995
524	composite/Change_Tracker_Form_ISnq3LV.docx	2	76	2023-09-07 08:50:25.231768+02	236	9938	9961
525	composite/SOP_Deviation_and_Nonconformity_Management_kXRY9by.docx	1	77	2023-09-07 08:50:25.232897+02	237	9943	9973
526	composite/Quality_Investigation_and_Assessment_Tools_Appendix_nkOJA9g.docx	3	78	2023-09-07 08:50:25.23398+02	237	9943	9977
527	composite/Deviation_and_Nonconformity_Notification_Form_HxDm1uM.docx	2	79	2023-09-07 08:50:25.235021+02	237	9943	9974
534	composite/SOP_Audits_Management_VCIgzdT.docx	1	86	2023-09-07 08:50:25.242397+02	239	9934	9952
535	composite/Audit_Plan_18x5nlL.docx	2	87	2023-09-07 08:50:25.243432+02	239	9934	9949
536	composite/Audit_Report_hjIAWt6.docx	2	88	2023-09-07 08:50:25.244476+02	239	9934	9950
545	composite/Training_Record_q7bNP70.docx	2	97	2023-09-07 08:50:25.254035+02	241	9933	10013
546	composite/SOP_Complaints_and_Recalls_Management_7Udz7os.docx	1	98	2023-09-07 08:50:25.255081+02	242	10023	9971
547	composite/Complaint_Notification_sTvcSQB.docx	2	99	2023-09-07 08:50:25.256138+02	242	10023	9966
548	composite/Complaint_Preliminary_Assessment_EevqYk2.docx	2	100	2023-09-07 08:50:25.25727+02	242	10023	9967
549	composite/Complaint_Investigation_Plan_hg5tXSS.docx	2	101	2023-09-07 08:50:25.258306+02	242	10023	9968
550	composite/Complaint_Investigation_Report_C9bFDDi.docx	2	102	2023-09-07 08:50:25.259366+02	242	10023	9969
551	composite/Complaints_Log_no8LPs8.docx	2	103	2023-09-07 08:50:25.260448+02	242	10023	9970
552	composite/Recall_Committee_Members_RNzb127.docx	2	104	2023-09-07 08:50:25.261553+02	242	10023	10001
553	composite/Recall_Report_JG8JVZU.docx	2	105	2023-09-07 08:50:25.262637+02	242	10023	10002
554	composite/Recall_Statement_FhHDnsa.docx	2	106	2023-09-07 08:50:25.263717+02	242	10023	10003
514	composite/SOP-01_Controlled_Copies_Log_1GrkO3y.docx	2	66	2023-09-07 08:50:25.221274+02	232	9948	10026
555	composite/SOP_Suppliers_Customers_Management.docx	1	107	2023-09-07 08:50:25.264877+02	243	9932	10010
556	composite/Supplier_Customer_Evaluation.docx	2	108	2023-09-07 08:50:25.266379+02	243	9932	10006
557	composite/Quality_Assurance_Agreement_gEQy4yZ.docx	2	109	2023-09-07 08:50:25.267485+02	243	9932	10007
558	composite/Supplier_Customer_Self_Assessment.docx	2	110	2023-09-07 08:50:25.268549+02	243	9932	10008
559	composite/Qualified_Supplier_Customer_List.docx	2	111	2023-09-07 08:50:25.269759+02	243	9932	10009
560	composite/SOP_Computerized_Systems_Lifecycle_Management_GDOZynT.docx	1	112	2023-09-07 08:50:25.270847+02	244	9978	9963
561	composite/SOP-16_Archiving_BVSysfc.docx	1	114	2023-09-07 08:50:25.273222+02	245	9940	9972
565	composite/Document_Loan_Request_fDmpSHX.docx	2	118	2023-09-07 08:50:25.277657+02	245	9940	10020
566	composite/SOP_Deviation_and_Nonconformity_Management_s8xlsuC.docx	1	113	2023-09-07 08:52:42.490439+02	246	10043	10076
567	composite/Quality_Investigation_and_Assessment_Tools_Appendix_LkVmUT3.docx	3	119	2023-09-07 08:52:59.784009+02	246	10043	10075
515	composite/SOP-01_Document_Change_Request_Form_iBm8y3c.docx	2	67	2023-09-07 08:50:25.222279+02	232	9948	9936
516	composite/SOP-01_Master_Copies_Log_FnKX1QX.docx	2	68	2023-09-07 08:50:25.223273+02	232	9948	10015
517	composite/SOP-01_and_WI_Form_9car3U1.docx	2	69	2023-09-07 08:50:25.224356+02	232	9948	10025
518	composite/SOP-02_Good_Documentation_Practice_ksZGW2E.docx	1	70	2023-09-07 08:50:25.225464+02	233	9942	10027
568	composite/Deviation_and_Nonconformity_Notification_Form_cx2Zpe4.docx	2	120	2023-09-07 08:53:08.962597+02	246	10043	10072
569	composite/Deviation_and_Nonconformity_Report_Form_Ew66DzI.docx	2	121	2023-09-07 08:53:19.878677+02	246	10043	10073
570	composite/Deviations_and_Nonconformity_Tracker_gLmwHzk.docx	2	122	2023-09-07 08:53:27.666686+02	246	10043	10041
562	composite/Archiving_register_I0CzL3Y.docx	2	115	2023-09-07 08:50:25.274379+02	245	9940	10022
513	composite/SOP-01_Documentation_Management_cZOJASJ.docx	1	65	2023-09-07 08:50:25.220139+02	232	9948	9937
519	composite/Signatures_and_Initials.docx	2	71	2023-09-07 08:50:25.226502+02	233	9942	9984
537	composite/Auditors_List_ZoRvK0Z.docx	2	89	2023-09-07 08:50:25.24553+02	239	9934	9951
520	composite/SOP-03_Quality_Plan_GWud0zj.docx	1	72	2023-09-07 08:50:25.227521+02	234	9931	10000
521	composite/SOP-04_Management_Review_BXQx62B.docx	1	73	2023-09-07 08:50:25.228539+02	235	9944	9987
522	composite/SOP-05_Change_Management_IF2Hug7.docx	1	74	2023-09-07 08:50:25.22961+02	236	9938	9959
523	composite/Change_Form_py1BwX2.docx	2	75	2023-09-07 08:50:25.230697+02	236	9938	9958
528	composite/Deviation_and_Nonconformity_Investigation_Report_Form.docx	2	80	2023-09-07 08:50:25.236145+02	237	9943	9975
529	composite/Deviation_and_Nonconformity_Tracker.docx	2	81	2023-09-07 08:50:25.237185+02	237	9943	9976
530	composite/SOP_CAPA_Management_dI2WrTd.docx	1	82	2023-09-07 08:50:25.238196+02	238	9939	9955
531	composite/CAPA_Report_AhrEE2L.docx	2	83	2023-09-07 08:50:25.239216+02	238	9939	9953
532	composite/CAPA_Request_5fPAWK0.docx	2	84	2023-09-07 08:50:25.240237+02	238	9939	9954
533	composite/CAPA_Tracker_1bGUVbD.docx	2	85	2023-09-07 08:50:25.241356+02	238	9939	9956
538	composite/External_Audits_Programmme_DAabr50.docx	2	90	2023-09-07 08:50:25.246615+02	239	9934	9985
539	composite/Internal_Audits_Programme_N06nLyq.docx	2	91	2023-09-07 08:50:25.247646+02	239	9934	10024
540	composite/SOP_QRM_1XwHxCp.docx	1	92	2023-09-07 08:50:25.248711+02	240	9981	9994
542	composite/SOP_Training_cQhcTrH.docx	1	94	2023-09-07 08:50:25.250827+02	241	9933	10014
543	composite/Training_Matrix_j1m2hoL.docx	2	95	2023-09-07 08:50:25.251862+02	241	9933	10005
563	composite/Archiving_Request_Form_NemuiHr.docx	2	116	2023-09-07 08:50:25.275451+02	245	9940	10028
564	composite/Document_Destruction_Request_FE7gh4E.docx	2	117	2023-09-07 08:50:25.276524+02	245	9940	10021
544	composite/Annual_Training_Plan_bsrflD3.docx	2	96	2023-09-07 08:50:25.253003+02	241	9933	10012
541	composite/FMEA_Template_Qo4hXUs.docx	2	93	2024-01-23 10:49:01.569851+01	240	9981	9982
\.


--
-- Data for Name: questioning_compositedocumentconverted; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.questioning_compositedocumentconverted (id, file, updated_at, document_id, missing_tags) FROM stdin;
32	composite/converted/Recall_Report_O3ICcZF.docx	2023-02-01 11:23:41.643923+01	374	
33	composite/converted/SOP_Complaints_and_Recalls_3SDnI6N.docx	2023-02-01 11:23:49.747297+01	367	
36	composite/converted/SOP-16_Archiving_7VNt55l.docx	2023-02-01 13:00:08.051752+01	392	
37	composite/converted/Archiving_Request_Form_vo4oDyz.docx	2023-02-01 13:12:30.769819+01	393	
38	composite/converted/SOP-01_Document_Change_Request_Form_U5HHpK3.docx	2023-02-07 10:02:22.350387+01	404	
41	composite/converted/SOP-03_Quality_Plan-AL_4d6xcmh.docx	2023-02-07 10:18:07.131922+01	412	
43	composite/converted/SOP-01_Documentation_Management_URDf0Ja.docx	2023-02-08 09:16:59.857612+01	403	
44	composite/converted/Supplier_Self_Assessment_dOHHmE8.docx	2023-02-08 09:25:49.8273+01	379	
47	composite/converted/FMEA_Template_FONUo2a.docx	2023-02-08 10:30:29.066821+01	359	
48	composite/converted/SOP-13_Supplier_Management_op6cHTd_fsuh1X5.docx	2023-02-08 10:31:01.086477+01	400	
49	composite/converted/SOP-14_Material_Management_PGsJLPb.docx	2023-02-08 10:41:08.212323+01	381	
51	composite/converted/SOP-04_Management_Review-AL.docx	2023-03-01 11:39:23.646217+01	335	
59	composite/converted/Quality_Manual_4x387aX.docx	2023-08-21 14:51:41.722551+02	510	
60	composite/converted/SOP_QRM_1XwHxCp.docx	2024-01-23 10:49:08.425486+01	540	
61	composite/converted/FMEA_Template_Qo4hXUs.docx	2024-01-23 10:49:13.766044+01	541	
\.


--
-- Data for Name: questioning_question; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.questioning_question (id, topic, question, answers, correct, comment, source_id) FROM stdin;
19	SOP-02 Good Manufacturing Practise	Choose the correct date and time in accordance with GDocP?	{"\t28.01.2023 8:30 p.m.","\t01/28/2023 20:30","\t28.01.2023 20:30","\t28/01/2023 20:30"}	{2,3}		2
20	SOP-02 Good Manufacturing Practise	Can you use outdated and/or obsolete documents?	{"\tYES, you can, it doesn't matter","\tNO, you shall use only valid documents"}	{1}		2
21	SOP-03 Quality Plan	What is the intent of the Quality Plan?	{"\tOutline an action plan for improvements in the GxP areas","\tReflect the organization's quality improvement strategies and strategic goals","\tGive a clear QM direction for the next year"}	{0,1,2}		2
22	SOP-03 Quality Plan	Which Key Quality Indicators (KQI) may be used?	{"\tDeviations (% Repeat Deviations/total, % overdue/total)","\tCAPA (% overdue/total, % overall efficacy)","\tChange Controls (% overdue/initiated)","\tOOS (% confirmed/total product lots produced)","\tOverall Spent","\tPO cycle time","\tReclamation rate"}	{0,1,2,3}		2
23	SOP-04 Management Review	What are inputs reviewed and assessed during QMS Management Review	{"\tComplaints","\tDeviations","\tRevenue Development","\tNew upscale initiatives"}	{0,1}		2
24	SOP-04 Management Review	What are typical outputs of Management Review? 	{"\tActions for improvements of the QMS, the processes and/or the product","\tAllocation or Relocation of resources","\tUpdates of the Quality Policy or objectives, if required"}	{0,1,2}		2
25	SOP-05 Change Management	When do you need a Change Control as outlined in this procedure?	{"\tWhenever a change to system, equipment, process, facility or utility is planned that may impact a validated system","\tWhen you correct wrong entries in a batch record","\tWhen you need to amend a report"}	{0}		2
26	SOP-05 Change Management	Can you start executing the Change Control if the implementation plan is still under review?	{"\tYES","\tNO, execution may not proceed until final implementation plan approval has been obtained"}	{1}		2
27	SOP-06 Deviation & Nonconformity Management	Which of the following Deviations/Nonconformity requires a risk assessment?	{"\tMinor","\tMajor","\tCritical"}	{1,2}		2
28	SOP-06 Deviation & Nonconformity Management	What constitutes a Deviation or Nonconformity? 	{"\tDeparture from an approved instruction or standard","\tPattern or statistical set of data indicating a shift or the respective data","\tNon-fulfillment of a predefined requirement"}	{0}		2
29	SOP-07 CAPA Management	What is a CAPA?	{"\tA Complaint","\tAbbreviation for Corrective action and preventive action","\tCustomer Acquisition and Pricing Analysis","\tFailure Analysis Method"}	{1}		2
30	SOP-07 CAPA Management	What are (potential) CAPA Triggers? 	{"\tAudit Findings","\tProcess performance metrics","\tNew packaging material","\tNew equipment"}	{0,1}		2
31	SOP-08 Audits Management	What do we call the schedule of all audits planning during one year? 	{"\tAudit Scope","\tAudit Programme","\tAudit Plan"}	{1}		2
32	SOP-08 Audits Management	What are the responsibilities of an Auditor?	{"\tProvides access to the facilities and evidential material as requested","\tPlans and carries out audit","\tCollects evidence and gathers information"}	{1,2}		2
33	SOP-09 Quality Risk Management	What is an FMEA? 	{"\tFailure Mode and Effects Analysis","\tFailure Management Existence Assessment","\tIt is a systematic, proactive method for evaluating a process to identify where and how it might fail and to assess the relative impact of different Failures, in order to identify the parts of the process that are most in need of change"}	{0,2}		2
34	SOP-09 Quality Risk Management	Risk Control as outlined in this SOP consists of …?	{"\tRisk Evaluation","\tRisk Reduction","\tRisk Acceptance","\tRisk Review "}	{1,2}		2
35	SOP-10 Training Management	Reasons for retraining?	{"\tMissed training date","\tTrainer has a bad day","\tLess than 50% of correct answers"}	{0,2}		2
36	SOP-10 Training Management	Approved Training methods?	{"\tSelf-study","\tClassroom training","\tOn-the-job training"}	{0,1,2}		2
37	SOP-11 APQR	What is an APQR?	{"\tAssets, price, and quality ratio","\tAsia Pacific Quality Register","\tA consolidated term of annual product reviews and product quality reviews"}	{2}		2
38	SOP-11 APQR	How often are APQRs usually created?	{"\tRisk-based ","\tAnnually ","\tBiannually "}	{1}		2
39	SOP-12 Complaints & Recalls	How is a reliable recall system verified? 	{"\tMock Recalls","\tRecall execution in the respective year","\tProcedure checks"}	{0,1}		2
40	SOP-12 Complaints & Recalls	What is a Class 1 Complaint? 	{"\tAn issue that is potentially life-threatening","\tInternal Complaint","\tRoutine Complaint for testing the system"}	{0}		2
41	SOP-13 Supplier Management	What is the Basis for the Classification of a Supplier?	{"\tUsage","\tReputation","\tRevenue","\tRisk"}	{3}		2
18	SOP-01 Documentation Management	Reasons for Main Document changes?	{"Annual review","every 2 years","Implementation of approved changes in the process","Maintenance so the Main Documents are up the date"}	{0,1,2}		2
42	SOP-13 Supplier Management	The source of truth on the qualification status of a supplier is?	{"\tApproved Wish List","\tApproved Supplier List","\tQuality Technical Agreement"}	{1}		2
43	SOP-14 Material Management	Can Material be ordered before the MQ is complete?	{"\tYES, you can Pre-order the material ","\tNO"}	{0}		2
44	SOP-14 Material Management	What is the purpose of a Material User Requirement Specification?	{"\tAllow identifying if there are comparable materials in the system","\tIdentify clear expectations by the requester","\tTo outline the relevant requirements that material needs to fulfill, along with nice to haves","\tIs the basis for the specification to test against"}	{0,1,2,3}		2
45	SOP-15 Computerized Systems Lifecycle Management	Whats the basis for the Risk Categorization for computerized systems? 	{"\tGMP","\tGAMP","\tGIMP","\tGCP","\tGITP"}	{1}		2
46	SOP-15 Computerized Systems Lifecycle Management	What is the SMART rule? 	{"\tFollowing the smartest and leanest way to get to a validated system","\tUsing requirements that are specific, measurable, attributable, relevant and time-bound","\tFollowing an agile and flexible approach, like a SMART car in a city "}	{1}		2
47	SOP-16 Archiving	Can you regain access after a document is archived?	{"\tNO, it remains contained. Information requests are processed by the archiver","\tYES, by using the Document Loan Request Form","\tYES, if you gain access clearance evaluation"}	{1}		2
48	SOP-16 Archiving	Who initiates the archiving process?	{"\tQuality Manager","\tDocument owner or designee","\tManagement","\tInitiation is triggered by a date"}	{1}		2
17	SOP-01 Documentation Management	What does SOP mean?	{"A written instruction describing the individual/specific steps of recurring operations","including the materials and methods to be used","Abbreviation for Standard Operating Procedure","Contains the mandatory","approved description of a company-specific work process","the materials and equipment required to carry it out","and the responsibilities involved","Failure Analysis Method"}	{1,2}		2
\.


--
-- Data for Name: questioning_question_projects; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.questioning_question_projects (id, question_id, project_id) FROM stdin;
\.


--
-- Data for Name: questioning_questionssourcefile; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.questioning_questionssourcefile (id, file, created_at) FROM stdin;
2	questions/questions_source_CHZOPbm.xlsx	2023-03-03 10:17:51.633165+01
\.


--
-- Data for Name: questioning_resulttest; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.questioning_resulttest (id, result, created_at, testee_id, duration) FROM stdin;
1	18.51851851851852	2023-03-20 01:49:34.527853+01	3	0.21058666666666664
2	0	2023-03-24 12:24:34.847388+01	3	0
3	56.666666666666664	2023-03-24 12:27:06.309313+01	3	0.75727165
4	0	2023-03-24 12:36:42.134801+01	3	0
5	0	2023-03-24 12:36:51.232083+01	3	0
6	0	2023-03-24 12:37:09.421957+01	3	0
7	37.03703703703704	2023-03-25 18:55:26.340418+01	3	0.28704323333333337
8	87.5	2023-03-30 15:59:51.056957+02	3	1.9408529166666668
9	0	2023-03-30 16:02:09.815798+02	3	0
10	12.5	2023-03-30 16:02:13.801985+02	3	0.2940817333333333
11	0	2023-06-20 12:13:59.605336+02	3	0
12	0	2023-06-20 14:38:00.390606+02	3	0
13	0	2023-06-20 15:02:51.923679+02	3	0
14	0	2023-06-20 15:02:54.607235+02	3	0
\.


--
-- Data for Name: questioning_section; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.questioning_section (id, "position", name_postfix_id, name_prefix_id, project_id) FROM stdin;
115	0	8774	8715	7
231	1	9998	9935	11
232	1	9937	9948	11
233	1	10027	9942	11
234	1	10000	9931	11
235	1	9987	9944	11
236	1	9959	9938	11
237	1	9973	9943	11
238	1	9955	9939	11
239	1	9952	9934	11
240	1	9994	9981	11
241	1	10014	9933	11
242	1	9971	10023	11
243	1	10010	9932	11
244	1	9963	9978	11
245	1	9972	9940	11
246	1	10076	10043	12
139	19	8831	8835	7
141	20	8837	8838	7
118	21	8763	8712	7
144	22	8733	8707	7
122	23	8808	8813	7
123	24	8729	8706	7
125	25	8824	8827	7
126	26	8770	8714	7
127	27	8791	8718	7
128	28	8721	8757	7
130	29	8745	8758	7
131	30	8786	8717	7
132	31	8765	8713	7
133	32	8806	8807	7
136	33	8800	8805	7
\.


--
-- Data for Name: web_company; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.web_company (id, name, company_name, company_orientation, address, plz, city, country, logo, company_type, user_id, language) FROM stdin;
3		Company CDE	1	Building 235	00000	Sunset Street	BS	uploads/LOGO_CDE_OByFDpe.png	AG	3	1
4		default name	1					quasy-logo.png	AG	3	1
5		default name	1					quasy-logo.png	AG	3	1
6		Umbrella Corporation	1	1 Umbrella Drive	68168	Raccoon City, MO	US	uploads/images.png	AG	3	1
7		default name	1					quasy-logo.png	AG	3	1
2			1	Building 234	1234567	Sunset avenue	BH	uploads/LOGO.jpg	AG	3	1
1		Grau Pharma GmbH	1	Jordangasse 7/12	1010	Vienna	AT	uploads/GrauPharma-Logo._JPG.JPG	GmbH	2	1
\.


--
-- Data for Name: web_company_staff; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.web_company_staff (id, company_id, user_id) FROM stdin;
1	2	12
\.


--
-- Data for Name: web_order; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.web_order (id, description, created, price, company_id) FROM stdin;
\.


--
-- Data for Name: web_project; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.web_project (id, name, description, status, language) FROM stdin;
12	Forms numbering test	Forms	2	1
7	Full Run	Full Run	1	1
11	GDP	GDP	2	1
\.


--
-- Data for Name: web_tagmap; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.web_tagmap (id, value, project_id, tag_id) FROM stdin;
10030	SOP-14	12	4849
10031	SOP-13	12	4853
10032	SOP-09	12	4850
10033	SOP-02	12	4847
10034	Document Change Request	12	4883
10035	Documentation Management	12	4889
10036	SOP-07	12	4841
10037	SOP-08	12	4840
10038	MD-01	12	4851
10039	SOP-15	12	4843
8731	e.g., CEO	7	4868
8736	e.g., Electronic Data Manager	7	4873
10040	SOP-05	12	4842
8738		7	4875
8739	Organisation Name	7	4876
10042	SOP-01	12	4846
10044	APQR Annual Plan	12	4855
10045	APQR Report	12	4856
10046	Annual Product Quality Review	12	4857
10047	SOP-04	12	4848
8753	[Electronic Document Management System]	7	4890
8754		7	4891
10041	04 Form "Deviations and Nonconformity Tracker"	12	4888
8759	[Printed Main Documents are valid only on the date of printing. Printed Appendices for recording are valid only when issued by the assigned responsible employee with date and Initials, either as handwriting on the first page of printouts or as watermarks in protected digital documents. <Printing Date and Time>”.]	7	4894
9931	SOP-03	11	4852
8762	[concatenation of adress, city, postal code, country in one textual field]	7	4897
8764	e.g., Manufacturing Head	7	4899
8766	[concatenation of adress, city, postal code, country in one textual field]	7	4901
8768	[Products/services categories list]	7	4903
8769	e.g., QC Head	7	4904
8772	e.g., Quality Management Director Deputy	7	4907
8773	e.g., Quality Specialist	7	4908
8775	e.g., Quality Management Director	7	4910
8780	e.g., Regulatory Affairs Head	7	4915
8787	e.g., Training QA Specialist	7	4922
8795	e.g., Archiving Specialist	7	4930
8785	Qualified Supplier List	7	4920
8774	Quality Manual	7	4909
8735	Changes Tracker	7	4872
8707	SOP-05	7	4842
8712	SOP-04	7	4848
8763	Management Review	7	4898
8733	Change Management	7	4870
8767	Organigram	7	4902
8715	MD-01	7	4851
8771	Quality Commitment	7	4906
8734	Change impact assessment SMEs Matrix	7	4871
8808	Deviation and Nonconformity Management	7	4885
8729	CAPA Management	7	4866
8809	Deviation and Nonconformity Notification	7	4886
8810	Deviation and Nonconformity Investigation Report	7	4887
8727	CAPA Report	7	4864
8811	Deviations and Nonconformity Tracker	7	4888
8813	SOP-06	7	4845
8812	Quality Investigation and Assessment Tools	7	4884
8728	CAPA Request	7	4865
8706	SOP-07	7	4841
8730	CAPA Tracker	7	4867
8714	SOP-09	7	4850
8824	Audits Management	7	4862
8756	Failure Mode Effects Analysis (FMEA)	7	4893
8823	Auditors List	7	4861
8826	Internal Audits Programme	7	4896
8790	Training Record	7	4925
8825	External Audits Programme	7	4892
8791	Training Management	7	4926
8821	Audit Plan	7	4859
8827	SOP-08	7	4840
8822	Audit Report	7	4860
8713	SOP-14	7	4849
8770	Quality Risk Management	7	4905
8721	Annual Product Quality Review	7	4857
8788	Training Matrix	7	4923
8740	Complaint Notification	7	4877
8789	Annual Training Plan	7	4924
8718	SOP-10	7	4854
8719	APQR Annual Plan	7	4855
8757	SOP-11	7	4838
8720	APQR Report	7	4856
8744	Complaints Log	7	4881
8745	Complaints and Recalls Management	7	4882
8782	Supplier Evaluation	7	4917
8741	Complaint Preliminary Assessment	7	4878
8777	Recall Committee Members	7	4912
8742	Complaint Investigation Plan	7	4879
8765	Material Management	7	4900
8743	Complaint Investigation Report	7	4880
8783	Quality Assurance Agreement	7	4918
8778	Recall Report	7	4913
8758	SOP-12	7	4844
8779	Recall Statement	7	4914
8794	Documents for the Material Assessment	7	4929
8792	Material Qualification Status List (MQSL)	7	4927
8784	Supplier Self Assessment	7	4919
8793	Material User Requirement Specification (MURS)	7	4928
8807	SOP-15	7	4843
8806	Computerized Systems Management	7	4874
8835	SOP-01	7	4846
8804	Document Destruction Request	7	4934
8831	Documentation Management	7	4889
8834	Controlled Copies Log	7	4938
8830	Document Change Request	7	4883
8800	Archiving	7	4858
8801	Archiving Request	7	4931
8802	Archiving Register	7	4932
8732	Change	7	4869
8803	Document Loan Request	7	4933
8805	SOP-16	7	4839
8833	SOP and WI	7	4916
8717	SOP-13	7	4853
8786	Supplier Management	7	4921
8711	SOP-02	7	4847
8832	Master Copies Log	7	4937
8837	Quality Plan	7	4911
8838	SOP-03	7	4852
10048	Audit Plan	12	4859
10049	Audit Report	12	4860
10050	Auditors List	12	4861
10051	Audits Management	12	4862
10052	CAPA Report	12	4864
10053	CAPA Request	12	4865
10054	CAPA Management	12	4866
10055	CAPA Tracker	12	4867
10056	e.g., CEO	12	4868
10057	Change	12	4869
10058	Change Management	12	4870
10059	Change impact assessment SMEs Matrix	12	4871
10060	Changes Tracker	12	4872
10061	e.g., Electronic Data Manager	12	4873
10062	Computerized Systems Management	12	4874
10063		12	4875
10064	Organisation Name	12	4876
10065	Complaint Notification	12	4877
10066	Complaint Preliminary Assessment	12	4878
10067	Complaint Investigation Plan	12	4879
10068	Complaint Investigation Report	12	4880
10069	Complaints Log	12	4881
10070	Complaints and Recalls Management	12	4882
10071	Archiving	12	4858
10074	SOP-03	12	4852
10077	SOP-16	12	4839
10078	[Electronic Document Management System]	12	4890
10079		12	4891
10080	SOP-10	12	4854
10081	Failure Mode Effects Analysis (FMEA)	12	4893
10082	[Printed Main Documents are valid only on the date of printing. Printed Appendices for recording are valid only when issued by the assigned responsible employee with date and Initials, either as handwriting on the first page of printouts or as watermarks in protected digital documents. <Printing Date and Time>”.]	12	4894
10083	Signatures and Initials	12	4940
10084	External Audits Programme	12	4892
10085	[concatenation of adress, city, postal code, country in one textual field]	12	4897
10086	Management Review	12	4898
10087	e.g., Manufacturing Head	12	4899
10088	Material Management	12	4900
10089	[concatenation of adress, city, postal code, country in one textual field]	12	4901
10090	Organigram	12	4902
10091	[Products/services categories list]	12	4903
10092	e.g., QC Head	12	4904
10093	Quality Risk Management	12	4905
10094	Quality Commitment	12	4906
10095	e.g., Quality Management Director Deputy	12	4907
10096	e.g., Quality Specialist	12	4908
10097	Quality Manual	12	4909
10098	e.g., Quality Management Director	12	4910
10099	Quality Plan	12	4911
10100	Recall Committee Members	12	4912
10101	Recall Report	12	4913
10102	Recall Statement	12	4914
10103	e.g., Regulatory Affairs Head	12	4915
10104	Training Matrix	12	4923
10105	Supplier Evaluation	12	4917
10106	Quality Assurance Agreement	12	4918
10107	Supplier Self Assessment	12	4919
10108	Qualified Supplier List	12	4920
10109	Supplier Management	12	4921
10110	e.g., Training QA Specialist	12	4922
10111	Annual Training Plan	12	4924
10112	Training Record	12	4925
10113	Training Management	12	4926
10114	Master Copies Log	12	4937
10115	Material Qualification Status List (MQSL)	12	4927
10116	Material User Requirement Specification (MURS)	12	4928
10117	Documents for the Material Assessment	12	4929
10118	e.g., Archiving Specialist	12	4930
10119	Document Loan Request	12	4933
10120	Document Destruction Request	12	4934
10121	Archiving Register	12	4932
10122	Internal Audits Programme	12	4896
10123	SOP and WI	12	4916
10124	Controlled Copies Log	12	4938
10125	Good Documentation Practice	12	4944
10126	Archiving Request	12	4931
10127	SOP-11	12	4838
10072	01 Form "Deviation and Nonconformity Notification"	12	4886
10073	02 Form "Deviation and Nonconformity Investigation Report"	12	4887
9957	e.g., CEO	11	4868
9964		11	4875
9965	Organisation Name	11	4876
9969	Complaint Investigation Report	11	4880
9970	Complaints Log	11	4881
9967	Complaint Preliminary Assessment	11	4878
9968	Complaint Investigation Plan	11	4879
9963	Computerized Systems Lifecycle Management	11	4874
9973	Deviation and Nonconformity Management	11	4885
9953	CAPA Report	11	4864
9974	Deviation and Nonconformity Notification	11	4886
9976	Deviation and Nonconformity Tracker	11	4888
9943	SOP-06	11	4845
9972	Archiving	11	4858
9940	SOP-14	11	4839
9935	MD-01	11	4851
9948	SOP-01	11	4846
9937	Documentation Management	11	4889
9936	Document Change Request	11	4883
9944	SOP-04	11	4848
9942	SOP-02	11	4847
9958	Change	11	4869
9959	Change Management	11	4870
9961	Changes Tracker	11	4872
9938	SOP-05	11	4842
9975	Deviation and Nonconformity Investigation Report	11	4887
9955	CAPA Management	11	4866
9954	CAPA Request	11	4865
9956	CAPA Tracker	11	4867
9939	SOP-07	11	4841
9949	Audit Plan	11	4859
9952	Audits Management	11	4862
9950	Audit Report	11	4860
9951	Auditors List	11	4861
9934	SOP-08	11	4840
9966	Complaint Notification	11	4877
9933	SOP-10	11	4854
9979	[Electronic Document Management System]	11	4890
9980		11	4891
9983	[Printed Main Documents are valid only on the date of printing. Printed Appendices for recording are valid only when issued by the assigned responsible employee with date and Initials, either as handwriting on the first page of printouts or as watermarks in protected digital documents. <Printing Date and Time>”.]	11	4894
9986	[concatenation of adress, city, postal code, country in one textual field]	11	4897
10128	SOP-12	12	4844
9990	[concatenation of adress, city, postal code, country in one textual field]	11	4901
9992	[Products/services categories list]	11	4903
10076	Deviation and Nonconformity Management	12	4885
9996	e.g., Quality Management Director Deputy	11	4907
9997	e.g., Quality Specialist	11	4908
9999	e.g., Quality Management Director	11	4910
10011	e.g., Training QA Specialist	11	4922
10075	03 Appendix "Quality Investigation and Assessment Tools"	12	4884
10019	e.g., Archiving Specialist	11	4930
10043	SOP-06	12	4845
10006	Suppliers, Customers Evaluation	11	4917
10007	Quality Assurance Agreement	11	4918
10008	Suppliers, Customers Self Assessment	11	4919
9932	SOP-12	11	4853
9998	Quality Manual	11	4909
9991	Organigram	11	4902
9995	Quality Commitment	11	4906
10026	Controlled Copies Log	11	4938
10015	Master Copies Log	11	4937
10025	SOP and WI	11	4916
10027	Good Documentation Practice	11	4944
9984	Signatures and Initials	11	4940
10000	Quality Plan	11	4911
9987	Management Review	11	4898
9977	Quality Investigation and Assessment Tools	11	4884
9985	External Audits Programme	11	4892
10024	Internal Audits Programme	11	4896
10009	Qualified Suppliers, Customers List	11	4920
9994	Quality Risk Management	11	4905
9981	SOP-09	11	4850
9982	Failure Mode Effects Analysis (FMEA)	11	4893
10014	Training Management	11	4926
10005	Training Matrix	11	4923
10012	Annual Training Plan	11	4924
10013	Training Record	11	4925
9978	SOP-13	11	4843
9971	Complaints and Recalls Management	11	4882
10022	Archiving Register	11	4932
10028	Archiving Request	11	4931
10021	Document Destruction Request	11	4934
10020	Document Loan Request	11	4933
10001	Recall Committee Members	11	4912
10002	Recall Report	11	4913
10023	SOP-11	11	4844
10003	Recall Statement	11	4914
10010	Suppliers, Customers Management	11	4921
\.


--
-- Data for Name: web_tagmapcompany; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.web_tagmapcompany (id, value, accepted, company_id, project_id, tag_id) FROM stdin;
7555	SOP-03	f	1	11	4852
7559	Complaint Investigation Report	f	1	11	4880
7560	Complaints Log	f	1	11	4881
7561	Complaint Preliminary Assessment	f	1	11	4878
7562	Complaint Investigation Plan	f	1	11	4879
7563	Computerized Systems Lifecycle Management	f	1	11	4874
7564	Deviation and Nonconformity Management	f	1	11	4885
7565	CAPA Report	f	1	11	4864
7566	Deviation and Nonconformity Notification	f	1	11	4886
7567	Deviation and Nonconformity Tracker	f	1	11	4888
7568	SOP-06	f	1	11	4845
7569	Archiving	f	1	11	4858
7570	SOP-14	f	1	11	4839
7571	MD-01	f	1	11	4851
7572	SOP-01	f	1	11	4846
7573	Documentation Management	f	1	11	4889
7574	Document Change Request	f	1	11	4883
7575	SOP-04	f	1	11	4848
7576	SOP-02	f	1	11	4847
7577	Change	f	1	11	4869
7578	Change Management	f	1	11	4870
7579	Changes Tracker	f	1	11	4872
7580	SOP-05	f	1	11	4842
7581	Deviation and Nonconformity Investigation Report	f	1	11	4887
7582	CAPA Management	f	1	11	4866
7583	CAPA Request	f	1	11	4865
7584	CAPA Tracker	f	1	11	4867
7585	SOP-07	f	1	11	4841
7586	Audit Plan	f	1	11	4859
7587	Audits Management	f	1	11	4862
7588	Audit Report	f	1	11	4860
7589	Auditors List	f	1	11	4861
7590	SOP-08	f	1	11	4840
7591	Complaint Notification	f	1	11	4877
7592	SOP-10	f	1	11	4854
7604	Suppliers, Customers Evaluation	f	1	11	4917
7605	Quality Assurance Agreement	f	1	11	4918
7606	Suppliers, Customers Self Assessment	f	1	11	4919
7607	SOP-12	f	1	11	4853
7608	Quality Manual	f	1	11	4909
7609	Organigram	f	1	11	4902
7610	Quality Commitment	f	1	11	4906
7611	Controlled Copies Log	f	1	11	4938
7612	Master Copies Log	f	1	11	4937
7613	SOP and WI	f	1	11	4916
7614	Good Documentation Practice	f	1	11	4944
7615	Signatures and Initials	f	1	11	4940
7616	Quality Plan	f	1	11	4911
7617	Management Review	f	1	11	4898
7618	Quality Investigation and Assessment Tools	f	1	11	4884
7619	External Audits Programme	f	1	11	4892
7620	Internal Audits Programme	f	1	11	4896
7621	Qualified Suppliers, Customers List	f	1	11	4920
7622	Quality Risk Management	f	1	11	4905
7623	SOP-09	f	1	11	4850
7624	Failure Mode Effects Analysis (FMEA)	f	1	11	4893
7625	Training Management	f	1	11	4926
7626	Training Matrix	f	1	11	4923
7627	Annual Training Plan	f	1	11	4924
7628	Training Record	f	1	11	4925
7629	SOP-13	f	1	11	4843
7630	Complaints and Recalls Management	f	1	11	4882
7631	Archiving Register	f	1	11	4932
7632	Archiving Request	f	1	11	4931
7633	Document Destruction Request	f	1	11	4934
7634	Document Loan Request	f	1	11	4933
7635	Recall Committee Members	f	1	11	4912
7636	Recall Report	f	1	11	4913
7637	SOP-11	f	1	11	4844
7638	Recall Statement	f	1	11	4914
7639	Suppliers, Customers Management	f	1	11	4921
7593	[Electronic Document Management System]	t	1	11	4890
7556	Chief Executive Officer	t	1	11	4868
7599	Chief Operating Officer	t	1	11	4907
7600	Managing Director Tradelaw	t	1	11	4908
7601	Managing Director Tradelaw	t	1	11	4910
7602	Managing Director Tradelaw	t	1	11	4922
7603	Managing Director Tradelaw	t	1	11	4930
7645	Documentation Management	f	2	12	4889
7558	Grau Pharma GmbH	t	1	11	4876
7594	2023-09-01	t	1	11	4891
7595	[Printed Main Documents are valid only on the date of printing. Printed Appendices for recording are valid only when issued by the assigned responsible employee with date and Initials, either as handwriting on the first page of printouts or as watermarks in protected digital documents. <Printing Date and Time>”.]	t	1	11	4894
7596	Jordangasse 7/12, 1010 Vienna, Austria	t	1	11	4897
7597	Jordangasse 7/12, 1010 Vienna, Austria	t	1	11	4901
7598	Not defined yet.................................................	t	1	11	4903
7640	SOP-14	f	2	12	4849
7641	SOP-13	f	2	12	4853
7642	SOP-09	f	2	12	4850
7643	SOP-02	f	2	12	4847
7644	Document Change Request	f	2	12	4883
7646	SOP-07	f	2	12	4841
7647	SOP-08	f	2	12	4840
7648	MD-01	f	2	12	4851
7649	SOP-15	f	2	12	4843
7650	SOP-05	f	2	12	4842
7651	SOP-01	f	2	12	4846
7652	APQR Annual Plan	f	2	12	4855
7653	APQR Report	f	2	12	4856
5745	Company CDE	t	3	7	4876
5742	e.g., CEO	t	3	7	4868
5743	e.g., Electronic Data Manager	t	3	7	4873
7654	Annual Product Quality Review	f	2	12	4857
5746	[Electronic Document Management System]	t	3	7	4890
5747		t	3	7	4891
5744	/var/www/test.geder.at/media/uploads/LOGO_CDE_OByFDpe.png	t	3	7	4875
7655	SOP-04	f	2	12	4848
7656	04 Form "Deviations and Nonconformity Tracker"	f	2	12	4888
7657	Audit Plan	f	2	12	4859
7658	Audit Report	f	2	12	4860
7659	Auditors List	f	2	12	4861
7660	Audits Management	f	2	12	4862
7661	CAPA Report	f	2	12	4864
7662	CAPA Request	f	2	12	4865
7663	CAPA Management	f	2	12	4866
5760	Qualified Supplier List	f	3	7	4920
5761	Quality Manual	f	3	7	4909
5762	Change	f	3	7	4869
5763	Change impact assessment SMEs Matrix	f	3	7	4871
5764	SOP-04	f	3	7	4848
5765	Management Review	f	3	7	4898
5766	SOP-05	f	3	7	4842
5767	Organigram	f	3	7	4902
5768	MD-01	f	3	7	4851
5769	Quality Commitment	f	3	7	4906
5770	Change Management	f	3	7	4870
5771	Changes Tracker	f	3	7	4872
5772	Deviation and Nonconformity Management	f	3	7	4885
5773	CAPA Management	f	3	7	4866
5774	Deviation and Nonconformity Notification	f	3	7	4886
5775	Deviation and Nonconformity Investigation Report	f	3	7	4887
5776	CAPA Report	f	3	7	4864
5777	Deviations and Nonconformity Tracker	f	3	7	4888
5778	SOP-06	f	3	7	4845
5779	Quality Investigation and Assessment Tools	f	3	7	4884
5780	CAPA Request	f	3	7	4865
5781	SOP-07	f	3	7	4841
5782	CAPA Tracker	f	3	7	4867
5783	SOP-09	f	3	7	4850
5784	Audits Management	f	3	7	4862
5785	Failure Mode Effects Analysis (FMEA)	f	3	7	4893
5786	Auditors List	f	3	7	4861
5787	Internal Audits Programme	f	3	7	4896
5788	Training Record	f	3	7	4925
5789	External Audits Programme	f	3	7	4892
5790	Training Management	f	3	7	4926
5791	Audit Plan	f	3	7	4859
5792	SOP-08	f	3	7	4840
5793	Audit Report	f	3	7	4860
5794	SOP-14	f	3	7	4849
5795	Quality Risk Management	f	3	7	4905
5796	Annual Product Quality Review	f	3	7	4857
5797	Training Matrix	f	3	7	4923
5798	Complaint Notification	f	3	7	4877
5799	Annual Training Plan	f	3	7	4924
5800	SOP-10	f	3	7	4854
5801	APQR Annual Plan	f	3	7	4855
5802	SOP-11	f	3	7	4838
5803	APQR Report	f	3	7	4856
5804	Complaints Log	f	3	7	4881
5805	Complaints and Recalls Management	f	3	7	4882
5806	Supplier Evaluation	f	3	7	4917
5807	Complaint Preliminary Assessment	f	3	7	4878
5808	Recall Committee Members	f	3	7	4912
5809	Complaint Investigation Plan	f	3	7	4879
5810	Material Management	f	3	7	4900
5811	Complaint Investigation Report	f	3	7	4880
5812	Quality Assurance Agreement	f	3	7	4918
5813	Recall Report	f	3	7	4913
5814	SOP-12	f	3	7	4844
5815	Recall Statement	f	3	7	4914
5816	Documents for the Material Assessment	f	3	7	4929
5817	Material Qualification Status List (MQSL)	f	3	7	4927
5818	Supplier Self Assessment	f	3	7	4919
5819	Material User Requirement Specification (MURS)	f	3	7	4928
5820	SOP-15	f	3	7	4843
5821	Computerized Systems Management	f	3	7	4874
5822	SOP-01	f	3	7	4846
5823	Document Destruction Request	f	3	7	4934
5824	Documentation Management	f	3	7	4889
5825	Controlled Copies Log	f	3	7	4938
5826	Document Change Request	f	3	7	4883
5827	Archiving	f	3	7	4858
5828	Archiving Request	f	3	7	4931
5829	Archiving Register	f	3	7	4932
7664	CAPA Tracker	f	2	12	4867
5831	Document Loan Request	f	3	7	4933
5832	SOP-16	f	3	7	4839
5833	SOP and WI	f	3	7	4916
5834	SOP-13	f	3	7	4853
5748	[Printed Main Documents are valid only on the date of printing. Printed Appendices for recording are valid only when issued by the assigned responsible employee with date and Initials, either as handwriting on the first page of printouts or as watermarks in protected digital documents. <Printing Date and Time>”.]	t	3	7	4894
5749	Building 235, 00000 Sunset Street, Bahamas	t	3	7	4897
5751	Building 235, 00000 Sunset Street, Bahamas	t	3	7	4901
5752	[Products/services categories list]	t	3	7	4903
7666	Change	f	2	12	4869
7667	Change Management	f	2	12	4870
7668	Change impact assessment SMEs Matrix	f	2	12	4871
7669	Changes Tracker	f	2	12	4872
7671	Computerized Systems Management	f	2	12	4874
7674	Complaint Notification	f	2	12	4877
7675	Complaint Preliminary Assessment	f	2	12	4878
7676	Complaint Investigation Plan	f	2	12	4879
7677	Complaint Investigation Report	f	2	12	4880
7678	Complaints Log	f	2	12	4881
7665	e.g., CEO	t	2	12	4868
7670	e.g., Electronic Data Manager	t	2	12	4873
7673		t	2	12	4876
5835	Supplier Management	f	3	7	4921
5837	Master Copies Log	f	3	7	4937
5838	Quality Plan	f	3	7	4911
5839	SOP-02	f	3	7	4847
5840	SOP-03	f	3	7	4852
5750	e.g., Manufacturing Head	t	3	7	4899
5753	e.g., QC Head	t	3	7	4904
5754	e.g., Quality Management Director Deputy	t	3	7	4907
5755	e.g., Quality Specialist	t	3	7	4908
5756	e.g., Quality Management Director	t	3	7	4910
5757	e.g., Regulatory Affairs Head	t	3	7	4915
5758	e.g., Training QA Specialist	t	3	7	4922
5759	e.g., Archiving Specialist	t	3	7	4930
7679	Complaints and Recalls Management	f	2	12	4882
7680	Archiving	f	2	12	4858
7681	SOP-03	f	2	12	4852
7682	SOP-16	f	2	12	4839
7685	SOP-10	f	2	12	4854
7686	Failure Mode Effects Analysis (FMEA)	f	2	12	4893
7688	Signatures and Initials	f	2	12	4940
7689	External Audits Programme	f	2	12	4892
7691	Management Review	f	2	12	4898
7693	Material Management	f	2	12	4900
7695	Organigram	f	2	12	4902
7698	Quality Risk Management	f	2	12	4905
7699	Quality Commitment	f	2	12	4906
7702	Quality Manual	f	2	12	4909
7704	Quality Plan	f	2	12	4911
7705	Recall Committee Members	f	2	12	4912
7706	Recall Report	f	2	12	4913
7707	Recall Statement	f	2	12	4914
7709	Training Matrix	f	2	12	4923
7710	Supplier Evaluation	f	2	12	4917
7711	Quality Assurance Agreement	f	2	12	4918
7712	Supplier Self Assessment	f	2	12	4919
7713	Qualified Supplier List	f	2	12	4920
7714	Supplier Management	f	2	12	4921
7716	Annual Training Plan	f	2	12	4924
7717	Training Record	f	2	12	4925
7718	Training Management	f	2	12	4926
7719	Master Copies Log	f	2	12	4937
7720	Material Qualification Status List (MQSL)	f	2	12	4927
7721	Material User Requirement Specification (MURS)	f	2	12	4928
7722	Documents for the Material Assessment	f	2	12	4929
7724	Document Loan Request	f	2	12	4933
7725	Document Destruction Request	f	2	12	4934
7726	Archiving Register	f	2	12	4932
7727	Internal Audits Programme	f	2	12	4896
7728	SOP and WI	f	2	12	4916
7729	Controlled Copies Log	f	2	12	4938
7730	Good Documentation Practice	f	2	12	4944
7731	Archiving Request	f	2	12	4931
7732	SOP-11	f	2	12	4838
7733	01 Form "Deviation and Nonconformity Notification"	f	2	12	4886
7734	02 Form "Deviation and Nonconformity Investigation Report"	f	2	12	4887
7735	SOP-12	f	2	12	4844
7736	Deviation and Nonconformity Management	f	2	12	4885
7737	03 Appendix "Quality Investigation and Assessment Tools"	f	2	12	4884
7738	SOP-06	f	2	12	4845
7692	e.g., Manufacturing Head	t	2	12	4899
7697	e.g., QC Head	t	2	12	4904
7700	e.g., Quality Management Director Deputy	t	2	12	4907
7701	e.g., Quality Specialist	t	2	12	4908
7703	e.g., Quality Management Director	t	2	12	4910
7708	e.g., Regulatory Affairs Head	t	2	12	4915
7715	e.g., Training QA Specialist	t	2	12	4922
7723	e.g., Archiving Specialist	t	2	12	4930
7683	[Electronic Document Management System]	t	2	12	4890
7684		t	2	12	4891
7687	[Printed Main Documents are valid only on the date of printing. Printed Appendices for recording are valid only when issued by the assigned responsible employee with date and Initials, either as handwriting on the first page of printouts or as watermarks in protected digital documents. <Printing Date and Time>”.]	t	2	12	4894
7690	Building 234, 1234567 Sunset avenue, Bahrain	t	2	12	4897
7694	Building 234, 1234567 Sunset avenue, Bahrain	t	2	12	4901
7696	[Products/services categories list]	t	2	12	4903
7672	/var/www/quasy.net/media/uploads/LOGO.jpg	t	2	12	4875
7557	/var/www/quasy.net/media/uploads/GrauPharma-Logo._JPG.JPG	t	1	11	4875
\.


--
-- Data for Name: web_trainingmaterial; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.web_trainingmaterial (id, name, description, file, type) FROM stdin;
6	iso9001		training_materials/ISO_9000_EN.pdf	1
7	iso9001_2		training_materials/ISO_9000_EN_Hu02I3q.pdf	1
\.


--
-- Data for Name: web_trainingmaterial_projects; Type: TABLE DATA; Schema: public; Owner: admin
--

COPY public.web_trainingmaterial_projects (id, trainingmaterial_id, project_id) FROM stdin;
16	6	11
17	7	11
18	7	12
19	7	7
\.



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

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: admin
--

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: admin
--

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: admin
--

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: admin
--

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: admin
--

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


--
-- Name: client_compositecompanydocument client_compositecompanydocument_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocument
    ADD CONSTRAINT client_compositecompanydocument_pkey PRIMARY KEY (id);


--
-- Name: client_compositecompanydocumentclientresponse client_compositecompanydocumentclientresponse_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocumentclientresponse
    ADD CONSTRAINT client_compositecompanydocumentclientresponse_pkey PRIMARY KEY (id);


--
-- Name: client_compositecompanydocumentclientresponsecomment client_compositecompanydocumentclientresponsecomment_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocumentclientresponsecomment
    ADD CONSTRAINT client_compositecompanydocumentclientresponsecomment_pkey PRIMARY KEY (id);


--
-- Name: client_compositecompanydocumentconverted client_compositecompanydocumentconverted_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocumentconverted
    ADD CONSTRAINT client_compositecompanydocumentconverted_pkey PRIMARY KEY (id);


--
-- Name: client_conversionprogress client_conversionprogress_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_conversionprogress
    ADD CONSTRAINT client_conversionprogress_pkey PRIMARY KEY (file_name);


--
-- Name: client_sectioncompany client_sectioncompany_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_sectioncompany
    ADD CONSTRAINT client_sectioncompany_pkey PRIMARY KEY (id);


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

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: admin
--

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: admin
--

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: admin
--

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


--
-- Name: qmds_companyuserinvitation qmds_companyuserinvitation_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_companyuserinvitation
    ADD CONSTRAINT qmds_companyuserinvitation_pkey PRIMARY KEY (id);


--
-- Name: qmds_converteddocument qmds_converteddocument_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_converteddocument
    ADD CONSTRAINT qmds_converteddocument_pkey PRIMARY KEY (source_id);


--
-- Name: qmds_document qmds_document_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_document
    ADD CONSTRAINT qmds_document_pkey PRIMARY KEY (id);


--
-- Name: qmds_tag qmds_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_tag
    ADD CONSTRAINT qmds_tag_pkey PRIMARY KEY (id);


--
-- Name: qmds_tagsourcefile qmds_tagsourcefile_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_tagsourcefile
    ADD CONSTRAINT qmds_tagsourcefile_pkey PRIMARY KEY (original_file_name);


--
-- Name: qmds_user_groups qmds_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_user_groups
    ADD CONSTRAINT qmds_user_groups_pkey PRIMARY KEY (id);


--
-- Name: qmds_user_groups qmds_user_groups_user_id_group_id_2fdc6617_uniq; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_user_groups
    ADD CONSTRAINT qmds_user_groups_user_id_group_id_2fdc6617_uniq UNIQUE (user_id, group_id);


--
-- Name: qmds_user_user_permissions qmds_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_user_user_permissions
    ADD CONSTRAINT qmds_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: qmds_user_user_permissions qmds_user_user_permissions_user_id_permission_id_8a20a896_uniq; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_user_user_permissions
    ADD CONSTRAINT qmds_user_user_permissions_user_id_permission_id_8a20a896_uniq UNIQUE (user_id, permission_id);


--
-- Name: questioning_compositedocument questioning_compositedocument_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_compositedocument
    ADD CONSTRAINT questioning_compositedocument_pkey PRIMARY KEY (id);


--
-- Name: questioning_compositedocumentconverted questioning_compositedocumentconverted_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_compositedocumentconverted
    ADD CONSTRAINT questioning_compositedocumentconverted_pkey PRIMARY KEY (id);


--
-- Name: questioning_question questioning_question_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_question
    ADD CONSTRAINT questioning_question_pkey PRIMARY KEY (id);


--
-- Name: questioning_question_projects questioning_question_pro_question_id_project_id_b94d4c79_uniq; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_question_projects
    ADD CONSTRAINT questioning_question_pro_question_id_project_id_b94d4c79_uniq UNIQUE (question_id, project_id);


--
-- Name: questioning_question_projects questioning_question_projects_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_question_projects
    ADD CONSTRAINT questioning_question_projects_pkey PRIMARY KEY (id);


--
-- Name: questioning_questionssourcefile questioning_questionssourcefile_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_questionssourcefile
    ADD CONSTRAINT questioning_questionssourcefile_pkey PRIMARY KEY (id);


--
-- Name: questioning_resulttest questioning_resulttest_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_resulttest
    ADD CONSTRAINT questioning_resulttest_pkey PRIMARY KEY (id);


--
-- Name: questioning_section questioning_section_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_section
    ADD CONSTRAINT questioning_section_pkey PRIMARY KEY (id);


--
-- Name: web_company web_company_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_company
    ADD CONSTRAINT web_company_pkey PRIMARY KEY (id);


--
-- Name: web_company_staff web_company_staff_company_id_user_id_279bf56a_uniq; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_company_staff
    ADD CONSTRAINT web_company_staff_company_id_user_id_279bf56a_uniq UNIQUE (company_id, user_id);


--
-- Name: web_company_staff web_company_staff_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_company_staff
    ADD CONSTRAINT web_company_staff_pkey PRIMARY KEY (id);


--
-- Name: web_order web_order_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_order
    ADD CONSTRAINT web_order_pkey PRIMARY KEY (id);


--
-- Name: web_project web_project_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_project
    ADD CONSTRAINT web_project_pkey PRIMARY KEY (id);


--
-- Name: web_tagmap web_tagmap_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_tagmap
    ADD CONSTRAINT web_tagmap_pkey PRIMARY KEY (id);


--
-- Name: web_tagmapcompany web_tagmapcompany_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_tagmapcompany
    ADD CONSTRAINT web_tagmapcompany_pkey PRIMARY KEY (id);


--
-- Name: web_trainingmaterial web_trainingmaterial_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_trainingmaterial
    ADD CONSTRAINT web_trainingmaterial_pkey PRIMARY KEY (id);


--
-- Name: web_trainingmaterial_projects web_trainingmaterial_pro_trainingmaterial_id_proj_ec8980c1_uniq; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_trainingmaterial_projects
    ADD CONSTRAINT web_trainingmaterial_pro_trainingmaterial_id_proj_ec8980c1_uniq UNIQUE (trainingmaterial_id, project_id);


--
-- Name: web_trainingmaterial_projects web_trainingmaterial_project_pkey; Type: CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_trainingmaterial_projects
    ADD CONSTRAINT web_trainingmaterial_project_pkey PRIMARY KEY (id);


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

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: admin
--

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: admin
--

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: admin
--

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


--
-- Name: client_compositecompanydoc_author_id_7d89cfb9; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_compositecompanydoc_author_id_7d89cfb9 ON public.client_compositecompanydocumentclientresponse USING btree (author_id);


--
-- Name: client_compositecompanydoc_author_id_fce58d3d; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_compositecompanydoc_author_id_fce58d3d ON public.client_compositecompanydocumentclientresponsecomment USING btree (author_id);


--
-- Name: client_compositecompanydoc_document_id_f9d71675; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_compositecompanydoc_document_id_f9d71675 ON public.client_compositecompanydocumentclientresponse USING btree (document_id);


--
-- Name: client_compositecompanydoc_response_id_580bdcb7; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_compositecompanydoc_response_id_580bdcb7 ON public.client_compositecompanydocumentclientresponsecomment USING btree (response_id);


--
-- Name: client_compositecompanydocument_section_company_id_3ef4e601; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_compositecompanydocument_section_company_id_3ef4e601 ON public.client_compositecompanydocument USING btree (section_company_id);


--
-- Name: client_compositecompanydocument_tag_1_id_2bb8c802; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_compositecompanydocument_tag_1_id_2bb8c802 ON public.client_compositecompanydocument USING btree (tag_1_id);


--
-- Name: client_compositecompanydocument_tag_2_id_98ed15bc; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_compositecompanydocument_tag_2_id_98ed15bc ON public.client_compositecompanydocument USING btree (tag_2_id);


--
-- Name: client_compositecompanydocumentconverted_document_id_6c2adee3; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_compositecompanydocumentconverted_document_id_6c2adee3 ON public.client_compositecompanydocumentconverted USING btree (document_id);


--
-- Name: client_conversionprogress_file_name_f0292322_like; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_conversionprogress_file_name_f0292322_like ON public.client_conversionprogress USING btree (file_name varchar_pattern_ops);


--
-- Name: client_sectioncompany_company_id_c4886025; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_sectioncompany_company_id_c4886025 ON public.client_sectioncompany USING btree (company_id);


--
-- Name: client_sectioncompany_name_postfix_id_3b5f3365; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_sectioncompany_name_postfix_id_3b5f3365 ON public.client_sectioncompany USING btree (name_postfix_id);


--
-- Name: client_sectioncompany_name_prefix_id_6a3884ed; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX client_sectioncompany_name_prefix_id_6a3884ed ON public.client_sectioncompany USING btree (name_prefix_id);


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

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: admin
--

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


--
-- Name: qmds_companyuserinvitation_company_id_e3020659; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_companyuserinvitation_company_id_e3020659 ON public.qmds_companyuserinvitation USING btree (company_id);


--
-- Name: qmds_companyuserinvitation_user_id_b182b1ea; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_companyuserinvitation_user_id_b182b1ea ON public.qmds_companyuserinvitation USING btree (user_id);


--
-- Name: qmds_converteddocument_user_id_ac1ea853; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_converteddocument_user_id_ac1ea853 ON public.qmds_converteddocument USING btree (user_id);


--
-- Name: qmds_document_user_id_1abd7b6a; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_document_user_id_1abd7b6a ON public.qmds_document USING btree (user_id);


--
-- Name: qmds_tag_parent_id_1107857b; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_tag_parent_id_1107857b ON public.qmds_tag USING btree (parent_id);


--
-- Name: qmds_tagsourcefile_original_file_name_125568e5_like; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_tagsourcefile_original_file_name_125568e5_like ON public.qmds_tagsourcefile USING btree (original_file_name varchar_pattern_ops);


--
-- Name: qmds_user_groups_group_id_a6b9dd5c; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_user_groups_group_id_a6b9dd5c ON public.qmds_user_groups USING btree (group_id);


--
-- Name: qmds_user_groups_user_id_62443a14; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_user_groups_user_id_62443a14 ON public.qmds_user_groups USING btree (user_id);


--
-- Name: qmds_user_user_permissions_permission_id_5245603f; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_user_user_permissions_permission_id_5245603f ON public.qmds_user_user_permissions USING btree (permission_id);


--
-- Name: qmds_user_user_permissions_user_id_e5da25e9; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX qmds_user_user_permissions_user_id_e5da25e9 ON public.qmds_user_user_permissions USING btree (user_id);


--
-- Name: questioning_compositedocument_section_id_655e5506; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_compositedocument_section_id_655e5506 ON public.questioning_compositedocument USING btree (section_id);


--
-- Name: questioning_compositedocument_tag_1_id_58d79711; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_compositedocument_tag_1_id_58d79711 ON public.questioning_compositedocument USING btree (tag_1_id);


--
-- Name: questioning_compositedocument_tag_2_id_7506c747; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_compositedocument_tag_2_id_7506c747 ON public.questioning_compositedocument USING btree (tag_2_id);


--
-- Name: questioning_compositedocumentconverted_document_id_72cd6ef1; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_compositedocumentconverted_document_id_72cd6ef1 ON public.questioning_compositedocumentconverted USING btree (document_id);


--
-- Name: questioning_question_projects_project_id_8352b15c; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_question_projects_project_id_8352b15c ON public.questioning_question_projects USING btree (project_id);


--
-- Name: questioning_question_projects_question_id_e47cfaa1; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_question_projects_question_id_e47cfaa1 ON public.questioning_question_projects USING btree (question_id);


--
-- Name: questioning_question_source_id_5def12f9; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_question_source_id_5def12f9 ON public.questioning_question USING btree (source_id);


--
-- Name: questioning_resulttest_testee_id_dc04e6cf; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_resulttest_testee_id_dc04e6cf ON public.questioning_resulttest USING btree (testee_id);


--
-- Name: questioning_section_name_postfix_id_b8c45945; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_section_name_postfix_id_b8c45945 ON public.questioning_section USING btree (name_postfix_id);


--
-- Name: questioning_section_name_prefix_id_ba79fe13; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_section_name_prefix_id_ba79fe13 ON public.questioning_section USING btree (name_prefix_id);


--
-- Name: questioning_section_project_id_67310f16; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX questioning_section_project_id_67310f16 ON public.questioning_section USING btree (project_id);


--
-- Name: web_company_staff_company_id_1b5efa47; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_company_staff_company_id_1b5efa47 ON public.web_company_staff USING btree (company_id);


--
-- Name: web_company_staff_user_id_e7557248; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_company_staff_user_id_e7557248 ON public.web_company_staff USING btree (user_id);


--
-- Name: web_company_user_id_b956bc4b; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_company_user_id_b956bc4b ON public.web_company USING btree (user_id);


--
-- Name: web_order_company_id_7f5c96f9; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_order_company_id_7f5c96f9 ON public.web_order USING btree (company_id);


--
-- Name: web_tagmap_project_id_3b0854a0; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_tagmap_project_id_3b0854a0 ON public.web_tagmap USING btree (project_id);


--
-- Name: web_tagmap_tag_id_d700644f; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_tagmap_tag_id_d700644f ON public.web_tagmap USING btree (tag_id);


--
-- Name: web_tagmapcompany_company_id_a8df3f7d; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_tagmapcompany_company_id_a8df3f7d ON public.web_tagmapcompany USING btree (company_id);


--
-- Name: web_tagmapcompany_project_id_f5d46be8; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_tagmapcompany_project_id_f5d46be8 ON public.web_tagmapcompany USING btree (project_id);


--
-- Name: web_tagmapcompany_tag_id_1f26203c; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_tagmapcompany_tag_id_1f26203c ON public.web_tagmapcompany USING btree (tag_id);


--
-- Name: web_trainingmaterial_project_project_id_c4785210; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_trainingmaterial_project_project_id_c4785210 ON public.web_trainingmaterial_projects USING btree (project_id);


--
-- Name: web_trainingmaterial_project_trainingmaterial_id_5c15c110; Type: INDEX; Schema: public; Owner: admin
--

CREATE INDEX web_trainingmaterial_project_trainingmaterial_id_5c15c110 ON public.web_trainingmaterial_projects USING btree (trainingmaterial_id);


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

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: admin
--

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: admin
--

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: client_compositecompanydocumentclientresponse client_compositecomp_author_id_7d89cfb9_fk_qmds_user; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocumentclientresponse
    ADD CONSTRAINT client_compositecomp_author_id_7d89cfb9_fk_qmds_user FOREIGN KEY (author_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_compositecompanydocumentclientresponsecomment client_compositecomp_author_id_fce58d3d_fk_qmds_user; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocumentclientresponsecomment
    ADD CONSTRAINT client_compositecomp_author_id_fce58d3d_fk_qmds_user FOREIGN KEY (author_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_compositecompanydocumentconverted client_compositecomp_document_id_6c2adee3_fk_client_co; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocumentconverted
    ADD CONSTRAINT client_compositecomp_document_id_6c2adee3_fk_client_co FOREIGN KEY (document_id) REFERENCES public.client_compositecompanydocument(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_compositecompanydocumentclientresponse client_compositecomp_document_id_f9d71675_fk_client_co; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocumentclientresponse
    ADD CONSTRAINT client_compositecomp_document_id_f9d71675_fk_client_co FOREIGN KEY (document_id) REFERENCES public.client_compositecompanydocument(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_compositecompanydocumentclientresponsecomment client_compositecomp_response_id_580bdcb7_fk_client_co; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocumentclientresponsecomment
    ADD CONSTRAINT client_compositecomp_response_id_580bdcb7_fk_client_co FOREIGN KEY (response_id) REFERENCES public.client_compositecompanydocumentclientresponse(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_compositecompanydocument client_compositecomp_section_company_id_3ef4e601_fk_client_se; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocument
    ADD CONSTRAINT client_compositecomp_section_company_id_3ef4e601_fk_client_se FOREIGN KEY (section_company_id) REFERENCES public.client_sectioncompany(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_compositecompanydocument client_compositecomp_tag_1_id_2bb8c802_fk_web_tagma; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocument
    ADD CONSTRAINT client_compositecomp_tag_1_id_2bb8c802_fk_web_tagma FOREIGN KEY (tag_1_id) REFERENCES public.web_tagmapcompany(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_compositecompanydocument client_compositecomp_tag_2_id_98ed15bc_fk_web_tagma; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_compositecompanydocument
    ADD CONSTRAINT client_compositecomp_tag_2_id_98ed15bc_fk_web_tagma FOREIGN KEY (tag_2_id) REFERENCES public.web_tagmapcompany(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_sectioncompany client_sectioncompan_name_postfix_id_3b5f3365_fk_web_tagma; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_sectioncompany
    ADD CONSTRAINT client_sectioncompan_name_postfix_id_3b5f3365_fk_web_tagma FOREIGN KEY (name_postfix_id) REFERENCES public.web_tagmapcompany(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_sectioncompany client_sectioncompan_name_prefix_id_6a3884ed_fk_web_tagma; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_sectioncompany
    ADD CONSTRAINT client_sectioncompan_name_prefix_id_6a3884ed_fk_web_tagma FOREIGN KEY (name_prefix_id) REFERENCES public.web_tagmapcompany(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: client_sectioncompany client_sectioncompany_company_id_c4886025_fk_web_company_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.client_sectioncompany
    ADD CONSTRAINT client_sectioncompany_company_id_c4886025_fk_web_company_id FOREIGN KEY (company_id) REFERENCES public.web_company(id) DEFERRABLE INITIALLY DEFERRED;


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

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_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

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


--
-- Name: qmds_companyuserinvitation qmds_companyuserinvi_company_id_e3020659_fk_web_compa; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_companyuserinvitation
    ADD CONSTRAINT qmds_companyuserinvi_company_id_e3020659_fk_web_compa FOREIGN KEY (company_id) REFERENCES public.web_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: qmds_companyuserinvitation qmds_companyuserinvitation_user_id_b182b1ea_fk_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_companyuserinvitation
    ADD CONSTRAINT qmds_companyuserinvitation_user_id_b182b1ea_fk_qmds_user_id FOREIGN KEY (user_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: qmds_converteddocument qmds_converteddocument_source_id_73744bf0_fk_qmds_document_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_converteddocument
    ADD CONSTRAINT qmds_converteddocument_source_id_73744bf0_fk_qmds_document_id FOREIGN KEY (source_id) REFERENCES public.qmds_document(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: qmds_converteddocument qmds_converteddocument_user_id_ac1ea853_fk_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_converteddocument
    ADD CONSTRAINT qmds_converteddocument_user_id_ac1ea853_fk_qmds_user_id FOREIGN KEY (user_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: qmds_document qmds_document_user_id_1abd7b6a_fk_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_document
    ADD CONSTRAINT qmds_document_user_id_1abd7b6a_fk_qmds_user_id FOREIGN KEY (user_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: qmds_tag qmds_tag_parent_id_1107857b_fk_qmds_tag_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_tag
    ADD CONSTRAINT qmds_tag_parent_id_1107857b_fk_qmds_tag_id FOREIGN KEY (parent_id) REFERENCES public.qmds_tag(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: qmds_user_groups qmds_user_groups_group_id_a6b9dd5c_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

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


--
-- Name: qmds_user_groups qmds_user_groups_user_id_62443a14_fk_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_user_groups
    ADD CONSTRAINT qmds_user_groups_user_id_62443a14_fk_qmds_user_id FOREIGN KEY (user_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: qmds_user_user_permissions qmds_user_user_permi_permission_id_5245603f_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

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


--
-- Name: qmds_user_user_permissions qmds_user_user_permissions_user_id_e5da25e9_fk_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.qmds_user_user_permissions
    ADD CONSTRAINT qmds_user_user_permissions_user_id_e5da25e9_fk_qmds_user_id FOREIGN KEY (user_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_compositedocumentconverted questioning_composit_document_id_72cd6ef1_fk_questioni; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_compositedocumentconverted
    ADD CONSTRAINT questioning_composit_document_id_72cd6ef1_fk_questioni FOREIGN KEY (document_id) REFERENCES public.questioning_compositedocument(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_compositedocument questioning_composit_section_id_655e5506_fk_questioni; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_compositedocument
    ADD CONSTRAINT questioning_composit_section_id_655e5506_fk_questioni FOREIGN KEY (section_id) REFERENCES public.questioning_section(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_compositedocument questioning_composit_tag_1_id_58d79711_fk_web_tagma; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_compositedocument
    ADD CONSTRAINT questioning_composit_tag_1_id_58d79711_fk_web_tagma FOREIGN KEY (tag_1_id) REFERENCES public.web_tagmap(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_compositedocument questioning_composit_tag_2_id_7506c747_fk_web_tagma; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_compositedocument
    ADD CONSTRAINT questioning_composit_tag_2_id_7506c747_fk_web_tagma FOREIGN KEY (tag_2_id) REFERENCES public.web_tagmap(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_question_projects questioning_question_project_id_8352b15c_fk_web_proje; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_question_projects
    ADD CONSTRAINT questioning_question_project_id_8352b15c_fk_web_proje FOREIGN KEY (project_id) REFERENCES public.web_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_question_projects questioning_question_question_id_e47cfaa1_fk_questioni; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_question_projects
    ADD CONSTRAINT questioning_question_question_id_e47cfaa1_fk_questioni FOREIGN KEY (question_id) REFERENCES public.questioning_question(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_question questioning_question_source_id_5def12f9_fk_questioni; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_question
    ADD CONSTRAINT questioning_question_source_id_5def12f9_fk_questioni FOREIGN KEY (source_id) REFERENCES public.questioning_questionssourcefile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_resulttest questioning_resulttest_testee_id_dc04e6cf_fk_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_resulttest
    ADD CONSTRAINT questioning_resulttest_testee_id_dc04e6cf_fk_qmds_user_id FOREIGN KEY (testee_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_section questioning_section_name_postfix_id_b8c45945_fk_web_tagmap_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_section
    ADD CONSTRAINT questioning_section_name_postfix_id_b8c45945_fk_web_tagmap_id FOREIGN KEY (name_postfix_id) REFERENCES public.web_tagmap(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_section questioning_section_name_prefix_id_ba79fe13_fk_web_tagmap_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_section
    ADD CONSTRAINT questioning_section_name_prefix_id_ba79fe13_fk_web_tagmap_id FOREIGN KEY (name_prefix_id) REFERENCES public.web_tagmap(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: questioning_section questioning_section_project_id_67310f16_fk_web_project_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.questioning_section
    ADD CONSTRAINT questioning_section_project_id_67310f16_fk_web_project_id FOREIGN KEY (project_id) REFERENCES public.web_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_company_staff web_company_staff_company_id_1b5efa47_fk_web_company_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_company_staff
    ADD CONSTRAINT web_company_staff_company_id_1b5efa47_fk_web_company_id FOREIGN KEY (company_id) REFERENCES public.web_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_company_staff web_company_staff_user_id_e7557248_fk_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_company_staff
    ADD CONSTRAINT web_company_staff_user_id_e7557248_fk_qmds_user_id FOREIGN KEY (user_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_company web_company_user_id_b956bc4b_fk_qmds_user_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_company
    ADD CONSTRAINT web_company_user_id_b956bc4b_fk_qmds_user_id FOREIGN KEY (user_id) REFERENCES public.qmds_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_order web_order_company_id_7f5c96f9_fk_web_company_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_order
    ADD CONSTRAINT web_order_company_id_7f5c96f9_fk_web_company_id FOREIGN KEY (company_id) REFERENCES public.web_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_tagmap web_tagmap_project_id_3b0854a0_fk_web_project_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_tagmap
    ADD CONSTRAINT web_tagmap_project_id_3b0854a0_fk_web_project_id FOREIGN KEY (project_id) REFERENCES public.web_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_tagmap web_tagmap_tag_id_d700644f_fk_qmds_tag_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_tagmap
    ADD CONSTRAINT web_tagmap_tag_id_d700644f_fk_qmds_tag_id FOREIGN KEY (tag_id) REFERENCES public.qmds_tag(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_tagmapcompany web_tagmapcompany_company_id_a8df3f7d_fk_web_company_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_tagmapcompany
    ADD CONSTRAINT web_tagmapcompany_company_id_a8df3f7d_fk_web_company_id FOREIGN KEY (company_id) REFERENCES public.web_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_tagmapcompany web_tagmapcompany_project_id_f5d46be8_fk_web_project_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_tagmapcompany
    ADD CONSTRAINT web_tagmapcompany_project_id_f5d46be8_fk_web_project_id FOREIGN KEY (project_id) REFERENCES public.web_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_tagmapcompany web_tagmapcompany_tag_id_1f26203c_fk_qmds_tag_id; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_tagmapcompany
    ADD CONSTRAINT web_tagmapcompany_tag_id_1f26203c_fk_qmds_tag_id FOREIGN KEY (tag_id) REFERENCES public.qmds_tag(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_trainingmaterial_projects web_trainingmaterial_project_id_c4785210_fk_web_proje; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_trainingmaterial_projects
    ADD CONSTRAINT web_trainingmaterial_project_id_c4785210_fk_web_proje FOREIGN KEY (project_id) REFERENCES public.web_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: web_trainingmaterial_projects web_trainingmaterial_trainingmaterial_id_5c15c110_fk_web_train; Type: FK CONSTRAINT; Schema: public; Owner: admin
--

ALTER TABLE ONLY public.web_trainingmaterial_projects
    ADD CONSTRAINT web_trainingmaterial_trainingmaterial_id_5c15c110_fk_web_train FOREIGN KEY (trainingmaterial_id) REFERENCES public.web_trainingmaterial(id) DEFERRABLE INITIALLY DEFERRED;


--
--

