--
--





--
-- Name: assets; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.assets (
    id bigint NOT NULL,
    user_id integer,
    original_filename character varying(255) NOT NULL,
    filename character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.assets OWNER TO wsp;

--
-- Name: assets_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.assets_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.assets_id_seq OWNER TO wsp;

--
-- Name: assets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.assets_id_seq OWNED BY public.assets.id;


--
-- Name: audit01; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.audit01 (
    id bigint NOT NULL,
    audit_id bigint NOT NULL,
    audit01_umum_i integer,
    audit01_umum_i_comment text,
    audit01_umum_ii integer,
    audit01_umum_ii_comment text,
    audit01_umum_iii integer,
    audit01_umum_iii_comment text,
    audit01_umum_iv integer,
    audit01_umum_iv_comment text,
    audit01_modul1_1 integer,
    audit01_modul1_1_comment text,
    audit01_modul1_2 integer,
    audit01_modul1_2_comment text,
    audit01_modul1_3 integer,
    audit01_modul1_3_comment text,
    audit01_modul1_4 integer,
    audit01_modul1_4_comment text,
    audit01_modul1_5 integer,
    audit01_modul1_5_comment text,
    audit01_modul1_6 integer,
    audit01_modul1_6_comment text,
    audit01_modul1_7 integer,
    audit01_modul1_7_comment text,
    audit01_modul1_8 integer,
    audit01_modul1_8_comment text,
    audit01_modul1_9 integer,
    audit01_modul1_9_comment text,
    audit01_modul1_10 integer,
    audit01_modul1_10_comment text,
    audit01_modul1_11 integer,
    audit01_modul1_11_comment text,
    audit01_modul1_12 integer,
    audit01_modul1_12_comment text,
    audit01_modul1_13 integer,
    audit01_modul1_13_comment text,
    audit01_modul1_14 integer,
    audit01_modul1_14_comment text,
    audit01_modul1_15 integer,
    audit01_modul1_15_comment text,
    audit01_modul2_1 integer,
    audit01_modul2_1_comment text,
    audit01_modul2_2 integer,
    audit01_modul2_2_comment text,
    audit01_modul2_3 integer,
    audit01_modul2_3_comment text,
    audit01_modul2_4 integer,
    audit01_modul2_4_comment text,
    audit01_modul2_5 integer,
    audit01_modul2_5_comment text,
    audit01_modul2_6 integer,
    audit01_modul2_6_comment text,
    audit01_modul2_7 integer,
    audit01_modul2_7_comment text,
    audit01_modul2_8 integer,
    audit01_modul2_8_comment text,
    audit01_modul2_9 integer,
    audit01_modul2_9_comment text,
    audit01_modul3_1 integer,
    audit01_modul3_1_comment text,
    audit01_modul3_2 integer,
    audit01_modul3_2_comment text,
    audit01_modul3_3 integer,
    audit01_modul3_3_comment text,
    audit01_modul3_4 integer,
    audit01_modul3_4_comment text,
    audit01_modul3_5 integer,
    audit01_modul3_5_comment text,
    audit01_modul3_6 integer,
    audit01_modul3_6_comment text,
    audit01_modul3_7 integer,
    audit01_modul3_7_comment text,
    audit01_modul4_1 integer,
    audit01_modul4_1_comment text,
    audit01_modul4_2 integer,
    audit01_modul4_2_comment text,
    audit01_modul5_1 integer,
    audit01_modul5_1_comment text,
    audit01_modul5_2 integer,
    audit01_modul5_2_comment text,
    audit01_modul5_3 integer,
    audit01_modul5_3_comment text,
    audit01_modul5_4 integer,
    audit01_modul5_4_comment text,
    audit01_modul6_1 integer,
    audit01_modul6_1_comment text,
    audit01_modul6_2 integer,
    audit01_modul6_2_comment text,
    audit01_modul7_1 integer,
    audit01_modul7_1_comment text,
    audit01_modul7_2 integer,
    audit01_modul7_2_comment text,
    audit01_modul7_3 integer,
    audit01_modul7_3_comment text,
    audit01_modul7_4 integer,
    audit01_modul7_4_comment text,
    audit01_modul7_5 integer,
    audit01_modul7_5_comment text,
    audit01_modul7_6 integer,
    audit01_modul7_6_comment text,
    audit01_modul7_7 integer,
    audit01_modul7_7_comment text,
    audit01_modul8_1 integer,
    audit01_modul8_1_comment text,
    audit01_modul8_2 integer,
    audit01_modul8_2_comment text,
    audit01_modul8_3 integer,
    audit01_modul8_3_comment text,
    audit01_modul8_4 integer,
    audit01_modul8_4_comment text,
    audit01_modul8_5 integer,
    audit01_modul8_5_comment text,
    audit01_modul9_1 integer,
    audit01_modul9_1_comment text,
    audit01_modul9_2 integer,
    audit01_modul9_2_comment text,
    audit01_modul9_3 integer,
    audit01_modul9_3_comment text,
    audit01_modul9_4 integer,
    audit01_modul9_4_comment text,
    audit01_modul9_5 integer,
    audit01_modul9_5_comment text,
    audit01_modul9_6 integer,
    audit01_modul9_6_comment text,
    audit01_modul9_7 integer,
    audit01_modul9_7_comment text,
    audit01_modul9_8 integer,
    audit01_modul9_8_comment text,
    audit01_modul10_1 integer,
    audit01_modul10_1_comment text,
    audit01_modul10_2 integer,
    audit01_modul10_2_comment text,
    audit01_modul10_3 integer,
    audit01_modul10_3_comment text,
    audit01_modul10_4 integer,
    audit01_modul10_4_comment text,
    audit01_modul11_1 integer,
    audit01_modul11_1_comment text,
    audit01_modul11_2 integer,
    audit01_modul11_2_comment text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.audit01 OWNER TO wsp;

--
-- Name: audit01_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.audit01_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.audit01_id_seq OWNER TO wsp;

--
-- Name: audit01_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.audit01_id_seq OWNED BY public.audit01.id;


--
-- Name: audit02; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.audit02 (
    id bigint NOT NULL,
    audit_id bigint NOT NULL,
    audit02_umum_i integer,
    audit02_umum_i_comment text,
    audit02_umum_ii integer,
    audit02_umum_ii_comment text,
    audit02_umum_iii integer,
    audit02_umum_iii_comment text,
    audit02_modul1_1a integer,
    audit02_modul1_1a_comment text,
    audit02_modul1_1b integer,
    audit02_modul1_1b_comment text,
    audit02_modul1_2a integer,
    audit02_modul1_2a_comment text,
    audit02_modul1_3a integer,
    audit02_modul1_3a_comment text,
    audit02_modul1_4a integer,
    audit02_modul1_4a_comment text,
    audit02_modul1_5a integer,
    audit02_modul1_5a_comment text,
    audit02_modul1_6a integer,
    audit02_modul1_6a_comment text,
    audit02_modul1_8a integer,
    audit02_modul1_8a_comment text,
    audit02_modul1_9a integer,
    audit02_modul1_9a_comment text,
    audit02_modul1_9b integer,
    audit02_modul1_9b_comment text,
    audit02_modul1_7c integer,
    audit02_modul1_7c_comment text,
    audit02_modul1_10a integer,
    audit02_modul1_10a_comment text,
    audit02_modul1_11 integer,
    audit02_modul1_11_comment text,
    audit02_modul1_12a integer,
    audit02_modul1_12a_comment text,
    audit02_modul1_13a integer,
    audit02_modul1_13a_comment text,
    audit02_modul1_14a integer,
    audit02_modul1_14a_comment text,
    audit02_modul2_1a integer,
    audit02_modul2_1a_comment text,
    audit02_modul2_2a integer,
    audit02_modul2_2a_comment text,
    audit02_modul2_3a integer,
    audit02_modul2_3a_comment text,
    audit02_modul2_4a integer,
    audit02_modul2_4a_comment text,
    audit02_modul2_5a integer,
    audit02_modul2_5a_comment text,
    audit02_modul2_5b integer,
    audit02_modul2_5b_comment text,
    audit02_modul2_6a integer,
    audit02_modul2_6a_comment text,
    audit02_modul2_7a integer,
    audit02_modul2_7a_comment text,
    audit02_modul2_8a integer,
    audit02_modul2_8a_comment text,
    audit02_modul2_9a integer,
    audit02_modul2_9a_comment text,
    audit02_modul3_1a integer,
    audit02_modul3_1a_comment text,
    audit02_modul3_1b integer,
    audit02_modul3_1b_comment text,
    audit02_modul3_1c integer,
    audit02_modul3_1c_comment text,
    audit02_modul3_2a integer,
    audit02_modul3_2a_comment text,
    audit02_modul3_3a6a integer,
    audit02_modul3_3a6a_comment text,
    audit02_modul3_7a integer,
    audit02_modul3_7a_comment text,
    audit02_modul4_1a integer,
    audit02_modul4_1a_comment text,
    audit02_modul4_1b integer,
    audit02_modul4_1b_comment text,
    audit02_modul4_2a integer,
    audit02_modul4_2a_comment text,
    audit02_modul4_2b integer,
    audit02_modul4_2b_comment text,
    audit02_modul4_2c integer,
    audit02_modul4_2c_comment text,
    audit02_modul5_1a integer,
    audit02_modul5_1a_comment text,
    audit02_modul5_1b integer,
    audit02_modul5_1b_comment text,
    audit02_modul5_2a integer,
    audit02_modul5_2a_comment text,
    audit02_modul5_2b integer,
    audit02_modul5_2b_comment text,
    audit02_modul5_3a integer,
    audit02_modul5_3a_comment text,
    audit02_modul5_4a integer,
    audit02_modul5_4a_comment text,
    audit02_modul6_a integer,
    audit02_modul6_a_comment text,
    audit02_modul6_1a integer,
    audit02_modul6_1a_comment text,
    audit02_modul6_1b integer,
    audit02_modul6_1b_comment text,
    audit02_modul6_2a integer,
    audit02_modul6_2a_comment text,
    audit02_modul6_2b integer,
    audit02_modul6_2b_comment text,
    audit02_modul6_2c integer,
    audit02_modul6_2c_comment text,
    audit02_modul6_2d integer,
    audit02_modul6_2d_comment text,
    audit02_modul7_a integer,
    audit02_modul7_a_comment text,
    audit02_modul7_1a integer,
    audit02_modul7_1a_comment text,
    audit02_modul7_2a integer,
    audit02_modul7_2a_comment text,
    audit02_modul7_2b integer,
    audit02_modul7_2b_comment text,
    audit02_modul7_2c integer,
    audit02_modul7_2c_comment text,
    audit02_modul7_2d integer,
    audit02_modul7_2d_comment text,
    audit02_modul7_2e integer,
    audit02_modul7_2e_comment text,
    audit02_modul7_2f integer,
    audit02_modul7_2f_comment text,
    audit02_modul7_3a integer,
    audit02_modul7_3a_comment text,
    audit02_modul7_3b integer,
    audit02_modul7_3b_comment text,
    audit02_modul7_4a integer,
    audit02_modul7_4a_comment text,
    audit02_modul7_4b integer,
    audit02_modul7_4b_comment text,
    audit02_modul7_5a integer,
    audit02_modul7_5a_comment text,
    audit02_modul7_5b integer,
    audit02_modul7_5b_comment text,
    audit02_modul7_6a integer,
    audit02_modul7_6a_comment text,
    audit02_modul7_7a integer,
    audit02_modul7_7a_comment text,
    audit02_modul7_7b integer,
    audit02_modul7_7b_comment text,
    audit02_modul7_7c integer,
    audit02_modul7_7c_comment text,
    audit02_modul8_a integer,
    audit02_modul8_a_comment text,
    audit02_modul8_1a integer,
    audit02_modul8_1a_comment text,
    audit02_modul8_1b integer,
    audit02_modul8_1b_comment text,
    audit02_modul8_1c integer,
    audit02_modul8_1c_comment text,
    audit02_modul8_2a integer,
    audit02_modul8_2a_comment text,
    audit02_modul8_2b integer,
    audit02_modul8_2b_comment text,
    audit02_modul8_4a integer,
    audit02_modul8_4a_comment text,
    audit02_modul8_5a integer,
    audit02_modul8_5a_comment text,
    audit02_modul9_1a integer,
    audit02_modul9_1a_comment text,
    audit02_modul9_2a integer,
    audit02_modul9_2a_comment text,
    audit02_modul9_2b integer,
    audit02_modul9_2b_comment text,
    audit02_modul9_3a integer,
    audit02_modul9_3a_comment text,
    audit02_modul9_4a integer,
    audit02_modul9_4a_comment text,
    audit02_modul9_4b integer,
    audit02_modul9_4b_comment text,
    audit02_modul9_5a integer,
    audit02_modul9_5a_comment text,
    audit02_modul9_6a integer,
    audit02_modul9_6a_comment text,
    audit02_modul9_7a integer,
    audit02_modul9_7a_comment text,
    audit02_modul9_7b integer,
    audit02_modul9_7b_comment text,
    audit02_modul9_8a integer,
    audit02_modul9_8a_comment text,
    audit02_modul10_1a integer,
    audit02_modul10_1a_comment text,
    audit02_modul10_2a integer,
    audit02_modul10_2a_comment text,
    audit02_modul10_3a integer,
    audit02_modul10_3a_comment text,
    audit02_modul10_3b integer,
    audit02_modul10_3b_comment text,
    audit02_modul10_4a integer,
    audit02_modul10_4a_comment text,
    audit02_modul10_4b integer,
    audit02_modul10_4b_comment text,
    audit02_modul11_1a integer,
    audit02_modul11_1a_comment text,
    audit02_modul11_2a integer,
    audit02_modul11_2a_comment text,
    audit02_modul11_2b integer,
    audit02_modul11_2b_comment text,
    audit02_modul11_2c integer,
    audit02_modul11_2c_comment text,
    audit02_modul11_2d integer,
    audit02_modul11_2d_comment text,
    audit02_modul11_2e integer,
    audit02_modul11_2e_comment text,
    audit02_modul11_2f integer,
    audit02_modul11_2f_comment text,
    audit02_modul11_2g integer,
    audit02_modul11_2g_comment text,
    audit02_modul11_2h integer,
    audit02_modul11_2h_comment text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.audit02 OWNER TO wsp;

--
-- Name: audit02_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.audit02_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.audit02_id_seq OWNER TO wsp;

--
-- Name: audit02_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.audit02_id_seq OWNED BY public.audit02.id;


--
-- Name: audit03; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.audit03 (
    id bigint NOT NULL,
    audit_id bigint NOT NULL,
    audit03_umum_spamjp_ap_i character varying(255),
    audit03_umum_spamjp_ma_i character varying(255),
    audit03_umum_spamjp_sb_i character varying(255),
    audit03_umum_spamjp_ah_i character varying(255),
    audit03_umum_temuan_i integer,
    audit03_umum_comment_i text,
    audit03_umum_spamjp_ap_ii character varying(255),
    audit03_umum_spamjp_ma_ii character varying(255),
    audit03_umum_spamjp_sb_ii character varying(255),
    audit03_umum_spamjp_ah_ii character varying(255),
    audit03_umum_temuan_ii integer,
    audit03_umum_comment_ii text,
    audit03_umum_spamjp_ap_iii character varying(255),
    audit03_umum_spamjp_ma_iii character varying(255),
    audit03_umum_spamjp_sb_iii character varying(255),
    audit03_umum_spamjp_ah_iii character varying(255),
    audit03_umum_temuan_iii integer,
    audit03_umum_comment_iii text,
    audit03_umum_spamjp_ap_iv character varying(255),
    audit03_umum_spamjp_ma_iv character varying(255),
    audit03_umum_spamjp_sb_iv character varying(255),
    audit03_umum_spamjp_ah_iv character varying(255),
    audit03_umum_temuan_iv integer,
    audit03_umum_comment_iv text,
    audit03_umum_spamjp_ap_v character varying(255),
    audit03_umum_spamjp_ma_v character varying(255),
    audit03_umum_spamjp_sb_v character varying(255),
    audit03_umum_spamjp_ah_v character varying(255),
    audit03_umum_temuan_v integer,
    audit03_umum_comment_v text,
    audit03_umum_spamjp_ap_vi character varying(255),
    audit03_umum_spamjp_ma_vi character varying(255),
    audit03_umum_spamjp_sb_vi character varying(255),
    audit03_umum_spamjp_ah_vi character varying(255),
    audit03_umum_temuan_vi integer,
    audit03_umum_comment_vi text,
    audit03_umum_spamjp_ap_vii character varying(255),
    audit03_umum_spamjp_ma_vii character varying(255),
    audit03_umum_spamjp_sb_vii character varying(255),
    audit03_umum_spamjp_ah_vii character varying(255),
    audit03_umum_temuan_vii integer,
    audit03_umum_comment_vii text,
    audit03_umum_spamjp_ap_viii character varying(255),
    audit03_umum_spamjp_ma_viii character varying(255),
    audit03_umum_spamjp_sb_viii character varying(255),
    audit03_umum_spamjp_ah_viii character varying(255),
    audit03_umum_temuan_viii integer,
    audit03_umum_comment_viii text,
    audit03_umum_spamjp_ap_ix character varying(255),
    audit03_umum_spamjp_ma_ix character varying(255),
    audit03_umum_spamjp_sb_ix character varying(255),
    audit03_umum_spamjp_ah_ix character varying(255),
    audit03_umum_temuan_ix integer,
    audit03_umum_comment_ix text,
    audit03_umum_spamjp_ap_x character varying(255),
    audit03_umum_spamjp_ma_x character varying(255),
    audit03_umum_spamjp_sb_x character varying(255),
    audit03_umum_spamjp_ah_x character varying(255),
    audit03_umum_temuan_x integer,
    audit03_umum_comment_x text,
    audit03_umum_spamjp_ap_xi character varying(255),
    audit03_umum_spamjp_ma_xi character varying(255),
    audit03_umum_spamjp_sb_xi character varying(255),
    audit03_umum_spamjp_ah_xi character varying(255),
    audit03_umum_temuan_xi integer,
    audit03_umum_comment_xi text,
    audit03_umum_spamjp_ap_xii character varying(255),
    audit03_umum_spamjp_ma_xii character varying(255),
    audit03_umum_spamjp_sb_xii character varying(255),
    audit03_umum_spamjp_ah_xii character varying(255),
    audit03_umum_temuan_xii integer,
    audit03_umum_comment_xii text,
    audit03_umum_spamjp_ap_xiii character varying(255),
    audit03_umum_spamjp_ma_xiii character varying(255),
    audit03_umum_spamjp_sb_xiii character varying(255),
    audit03_umum_spamjp_ah_xiii character varying(255),
    audit03_umum_temuan_xiii integer,
    audit03_umum_comment_xiii text,
    audit03_umum_spamjp_ap_xiv character varying(255),
    audit03_umum_spamjp_ma_xiv character varying(255),
    audit03_umum_spamjp_sb_xiv character varying(255),
    audit03_umum_spamjp_ah_xiv character varying(255),
    audit03_umum_temuan_xiv integer,
    audit03_umum_comment_xiv text,
    audit03_umum_spamjp_ap_xv character varying(255),
    audit03_umum_spamjp_ma_xv character varying(255),
    audit03_umum_spamjp_sb_xv character varying(255),
    audit03_umum_spamjp_ah_xv character varying(255),
    audit03_umum_temuan_xv integer,
    audit03_umum_comment_xv text,
    audit03_umum_spamjp_ap_xvi character varying(255),
    audit03_umum_spamjp_ma_xvi character varying(255),
    audit03_umum_spamjp_sb_xvi character varying(255),
    audit03_umum_spamjp_ah_xvi character varying(255),
    audit03_umum_temuan_xvi integer,
    audit03_umum_comment_xvi text,
    audit03_umum_spamjp_ap_xvii character varying(255),
    audit03_umum_spamjp_ma_xvii character varying(255),
    audit03_umum_spamjp_sb_xvii character varying(255),
    audit03_umum_spamjp_ah_xvii character varying(255),
    audit03_umum_temuan_xvii integer,
    audit03_umum_comment_xvii text,
    audit03_umum_spamjp_ap_xviii character varying(255),
    audit03_umum_spamjp_ma_xviii character varying(255),
    audit03_umum_spamjp_sb_xviii character varying(255),
    audit03_umum_spamjp_ah_xviii character varying(255),
    audit03_umum_temuan_xviii integer,
    audit03_umum_comment_xviii text,
    audit03_umum_spamjp_ap_xix character varying(255),
    audit03_umum_spamjp_ma_xix character varying(255),
    audit03_umum_spamjp_sb_xix character varying(255),
    audit03_umum_spamjp_ah_xix character varying(255),
    audit03_umum_temuan_xix integer,
    audit03_umum_comment_xix text,
    audit03_aspek1_spamjp_ap_1 character varying(255),
    audit03_aspek1_spamjp_ma_1 character varying(255),
    audit03_aspek1_spamjp_sb_1 character varying(255),
    audit03_aspek1_spamjp_ah_1 character varying(255),
    audit03_aspek1_temuan_1 integer,
    audit03_aspek1_comment_1 text,
    audit03_aspek_spamjp_ap_2 character varying(255),
    audit03_aspek_spamjp_ma_2 character varying(255),
    audit03_aspek_spamjp_sb_2 character varying(255),
    audit03_aspek_spamjp_ah_2 character varying(255),
    audit03_aspek_temuan_2 integer,
    audit03_aspek_comment_2 text,
    audit03_aspek_spamjp_ap_2a character varying(255),
    audit03_aspek_spamjp_ma_2a character varying(255),
    audit03_aspek_spamjp_sb_2a character varying(255),
    audit03_aspek_spamjp_ah_2a character varying(255),
    audit03_aspek_comment_2a text,
    audit03_aspek_spamjp_ap_3 character varying(255),
    audit03_aspek_spamjp_ma_3 character varying(255),
    audit03_aspek_spamjp_sb_3 character varying(255),
    audit03_aspek_spamjp_ah_3 character varying(255),
    audit03_aspek_temuan_3 integer,
    audit03_aspek_comment_3 text,
    audit03_aspek_spamjp_ap_2b character varying(255),
    audit03_aspek_spamjp_ma_2b character varying(255),
    audit03_aspek_spamjp_sb_2b character varying(255),
    audit03_aspek_spamjp_ah_2b character varying(255),
    audit03_aspek_comment_2b text,
    audit03_aspek_spamjp_ap_2c character varying(255),
    audit03_aspek_spamjp_ma_2c character varying(255),
    audit03_aspek_spamjp_sb_2c character varying(255),
    audit03_aspek_spamjp_ah_2c character varying(255),
    audit03_aspek_comment_2c text,
    audit03_aspek_spamjp_ap_4 character varying(255),
    audit03_aspek_spamjp_ma_4 character varying(255),
    audit03_aspek_spamjp_sb_4 character varying(255),
    audit03_aspek_spamjp_ah_4 character varying(255),
    audit03_aspek_temuan_4 integer,
    audit03_aspek_comment_4 text,
    audit03_aspek_spamjp_ap_2d character varying(255),
    audit03_aspek_spamjp_ma_2d character varying(255),
    audit03_aspek_spamjp_sb_2d character varying(255),
    audit03_aspek_spamjp_ah_2d character varying(255),
    audit03_aspek_comment_2d text,
    audit03_aspek_spamjp_ap_2e character varying(255),
    audit03_aspek_spamjp_ma_2e character varying(255),
    audit03_aspek_spamjp_sb_2e character varying(255),
    audit03_aspek_spamjp_ah_2e character varying(255),
    audit03_aspek_comment_2e text,
    audit03_aspek_spamjp_ap_5 character varying(255),
    audit03_aspek_spamjp_ma_5 character varying(255),
    audit03_aspek_spamjp_sb_5 character varying(255),
    audit03_aspek_spamjp_ah_5 character varying(255),
    audit03_aspek_temuan_5 integer,
    audit03_aspek_comment_5 text,
    audit03_aspek_spamjp_ap_6 character varying(255),
    audit03_aspek_spamjp_ma_6 character varying(255),
    audit03_aspek_spamjp_sb_6 character varying(255),
    audit03_aspek_spamjp_ah_6 character varying(255),
    audit03_aspek_temuan_6 integer,
    audit03_aspek_comment_6 text,
    audit03_aspek_spamjp_ap_3a character varying(255),
    audit03_aspek_spamjp_ma_3a character varying(255),
    audit03_aspek_spamjp_sb_3a character varying(255),
    audit03_aspek_spamjp_ah_3a character varying(255),
    audit03_aspek_comment_3a text,
    audit03_aspek_spamjp_ap_7 character varying(255),
    audit03_aspek_spamjp_ma_7 character varying(255),
    audit03_aspek_spamjp_sb_7 character varying(255),
    audit03_aspek_spamjp_ah_7 character varying(255),
    audit03_aspek_temuan_7 integer,
    audit03_aspek_comment_7 text,
    audit03_aspek_spamjp_ap_3b character varying(255),
    audit03_aspek_spamjp_ma_3b character varying(255),
    audit03_aspek_spamjp_sb_3b character varying(255),
    audit03_aspek_spamjp_ah_3b character varying(255),
    audit03_aspek_comment_3b text,
    audit03_aspek_spamjp_ap_4a character varying(255),
    audit03_aspek_spamjp_ma_4a character varying(255),
    audit03_aspek_spamjp_sb_4a character varying(255),
    audit03_aspek_spamjp_ah_4a character varying(255),
    audit03_aspek_comment_4a text,
    audit03_aspek_spamjp_ap_8 character varying(255),
    audit03_aspek_spamjp_ma_8 character varying(255),
    audit03_aspek_spamjp_sb_8 character varying(255),
    audit03_aspek_spamjp_ah_8 character varying(255),
    audit03_aspek_temuan_8 integer,
    audit03_aspek_comment_8 text,
    audit03_aspek_spamjp_ap_4b character varying(255),
    audit03_aspek_spamjp_ma_4b character varying(255),
    audit03_aspek_spamjp_sb_4b character varying(255),
    audit03_aspek_spamjp_ah_4b character varying(255),
    audit03_aspek_comment_4b text,
    audit03_aspek_spamjp_ap_9 character varying(255),
    audit03_aspek_spamjp_ma_9 character varying(255),
    audit03_aspek_spamjp_sb_9 character varying(255),
    audit03_aspek_spamjp_ah_9 character varying(255),
    audit03_aspek_temuan_9 integer,
    audit03_aspek_comment_9 text,
    audit03_aspek_spamjp_ap_4c character varying(255),
    audit03_aspek_spamjp_ma_4c character varying(255),
    audit03_aspek_spamjp_sb_4c character varying(255),
    audit03_aspek_spamjp_ah_4c character varying(255),
    audit03_aspek_comment_4c text,
    audit03_aspek_spamjp_ap_10 character varying(255),
    audit03_aspek_spamjp_ma_10 character varying(255),
    audit03_aspek_spamjp_sb_10 character varying(255),
    audit03_aspek_spamjp_ah_10 character varying(255),
    audit03_aspek_temuan_10 integer,
    audit03_aspek_comment_10 text,
    audit03_aspek_spamjp_ap_11 character varying(255),
    audit03_aspek_spamjp_ma_11 character varying(255),
    audit03_aspek_spamjp_sb_11 character varying(255),
    audit03_aspek_spamjp_ah_11 character varying(255),
    audit03_aspek_temuan_11 integer,
    audit03_aspek_comment_11 text,
    audit03_aspek_spamjp_ap_12 character varying(255),
    audit03_aspek_spamjp_ma_12 character varying(255),
    audit03_aspek_spamjp_sb_12 character varying(255),
    audit03_aspek_spamjp_ah_12 character varying(255),
    audit03_aspek_temuan_12 integer,
    audit03_aspek_comment_12 text,
    audit03_aspek_spamjp_ap_13 character varying(255),
    audit03_aspek_spamjp_ma_13 character varying(255),
    audit03_aspek_spamjp_sb_13 character varying(255),
    audit03_aspek_spamjp_ah_13 character varying(255),
    audit03_aspek_temuan_13 integer,
    audit03_aspek_comment_13 text,
    audit03_aspek_spamjp_ap_4d character varying(255),
    audit03_aspek_spamjp_ma_4d character varying(255),
    audit03_aspek_spamjp_sb_4d character varying(255),
    audit03_aspek_spamjp_ah_4d character varying(255),
    audit03_aspek_comment_4d text,
    audit03_aspek_spamjp_ap_14 character varying(255),
    audit03_aspek_spamjp_ma_14 character varying(255),
    audit03_aspek_spamjp_sb_14 character varying(255),
    audit03_aspek_spamjp_ah_14 character varying(255),
    audit03_aspek_temuan_14 integer,
    audit03_aspek_comment_14 text,
    audit03_aspek_spamjp_ap_4f character varying(255),
    audit03_aspek_spamjp_ma_4f character varying(255),
    audit03_aspek_spamjp_sb_4f character varying(255),
    audit03_aspek_spamjp_ah_4f character varying(255),
    audit03_aspek_comment_4f text,
    audit03_aspek_spamjp_ap_15 character varying(255),
    audit03_aspek_spamjp_ma_15 character varying(255),
    audit03_aspek_spamjp_sb_15 character varying(255),
    audit03_aspek_spamjp_ah_15 character varying(255),
    audit03_aspek_temuan_15 integer,
    audit03_aspek_comment_15 text,
    audit03_aspek_spamjp_ap_4e character varying(255),
    audit03_aspek_spamjp_ma_4e character varying(255),
    audit03_aspek_spamjp_sb_4e character varying(255),
    audit03_aspek_spamjp_ah_4e character varying(255),
    audit03_aspek_comment_4e text,
    audit03_aspek_spamjp_ap_16 character varying(255),
    audit03_aspek_spamjp_ma_16 character varying(255),
    audit03_aspek_spamjp_sb_16 character varying(255),
    audit03_aspek_spamjp_ah_16 character varying(255),
    audit03_aspek_temuan_16 integer,
    audit03_aspek_comment_16 text,
    audit03_aspek_spamjp_ap_17 character varying(255),
    audit03_aspek_spamjp_ma_17 character varying(255),
    audit03_aspek_spamjp_sb_17 character varying(255),
    audit03_aspek_spamjp_ah_17 character varying(255),
    audit03_aspek_temuan_17 integer,
    audit03_aspek_comment_17 text,
    audit03_aspek_spamjp_ap_18 character varying(255),
    audit03_aspek_spamjp_ma_18 character varying(255),
    audit03_aspek_spamjp_sb_18 character varying(255),
    audit03_aspek_spamjp_ah_18 character varying(255),
    audit03_aspek_temuan_18 integer,
    audit03_aspek_comment_18 text,
    audit03_aspek_spamjp_ap_19 character varying(255),
    audit03_aspek_spamjp_ma_19 character varying(255),
    audit03_aspek_spamjp_sb_19 character varying(255),
    audit03_aspek_spamjp_ah_19 character varying(255),
    audit03_aspek_temuan_19 integer,
    audit03_aspek_comment_19 text,
    audit03_aspek_spamjp_ap_20 character varying(255),
    audit03_aspek_spamjp_ma_20 character varying(255),
    audit03_aspek_spamjp_sb_20 character varying(255),
    audit03_aspek_spamjp_ah_20 character varying(255),
    audit03_aspek_temuan_20 integer,
    audit03_aspek_comment_20 text,
    audit03_aspek_spamjp_ap_4g character varying(255),
    audit03_aspek_spamjp_ma_4g character varying(255),
    audit03_aspek_spamjp_sb_4g character varying(255),
    audit03_aspek_spamjp_ah_4g character varying(255),
    audit03_aspek_comment_4g text,
    audit03_aspek_spamjp_ap_21 character varying(255),
    audit03_aspek_spamjp_ma_21 character varying(255),
    audit03_aspek_spamjp_sb_21 character varying(255),
    audit03_aspek_spamjp_ah_21 character varying(255),
    audit03_aspek_temuan_21 integer,
    audit03_aspek_comment_21 text,
    audit03_aspek_spamjp_ap_22 character varying(255),
    audit03_aspek_spamjp_ma_22 character varying(255),
    audit03_aspek_spamjp_sb_22 character varying(255),
    audit03_aspek_spamjp_ah_22 character varying(255),
    audit03_aspek_temuan_22 integer,
    audit03_aspek_comment_22 text,
    audit03_aspek_spamjp_ap_23 character varying(255),
    audit03_aspek_spamjp_ma_23 character varying(255),
    audit03_aspek_spamjp_sb_23 character varying(255),
    audit03_aspek_spamjp_ah_23 character varying(255),
    audit03_aspek_temuan_23 integer,
    audit03_aspek_comment_23 text,
    audit03_aspek_spamjp_ap_24 character varying(255),
    audit03_aspek_spamjp_ma_24 character varying(255),
    audit03_aspek_spamjp_sb_24 character varying(255),
    audit03_aspek_spamjp_ah_24 character varying(255),
    audit03_aspek_temuan_24 integer,
    audit03_aspek_comment_24 text,
    audit03_aspek_spamjp_ap_25 character varying(255),
    audit03_aspek_spamjp_ma_25 character varying(255),
    audit03_aspek_spamjp_sb_25 character varying(255),
    audit03_aspek_spamjp_ah_25 character varying(255),
    audit03_aspek_temuan_25 integer,
    audit03_aspek_comment_25 text,
    audit03_aspek_spamjp_ap_26 character varying(255),
    audit03_aspek_spamjp_ma_26 character varying(255),
    audit03_aspek_spamjp_sb_26 character varying(255),
    audit03_aspek_spamjp_ah_26 character varying(255),
    audit03_aspek_temuan_26 integer,
    audit03_aspek_comment_26 text,
    audit03_aspek_spamjp_ap_27 character varying(255),
    audit03_aspek_spamjp_ma_27 character varying(255),
    audit03_aspek_spamjp_sb_27 character varying(255),
    audit03_aspek_spamjp_ah_27 character varying(255),
    audit03_aspek_temuan_27 integer,
    audit03_aspek_comment_27 text,
    audit03_aspek_spamjp_ap_28 character varying(255),
    audit03_aspek_spamjp_ma_28 character varying(255),
    audit03_aspek_spamjp_sb_28 character varying(255),
    audit03_aspek_spamjp_ah_28 character varying(255),
    audit03_aspek_temuan_28 integer,
    audit03_aspek_comment_28 text,
    audit03_aspek_spamjp_ap_29 character varying(255),
    audit03_aspek_spamjp_ma_29 character varying(255),
    audit03_aspek_spamjp_sb_29 character varying(255),
    audit03_aspek_spamjp_ah_29 character varying(255),
    audit03_aspek_temuan_29 integer,
    audit03_aspek_comment_29 text,
    audit03_aspek_spamjp_ap_30 character varying(255),
    audit03_aspek_spamjp_ma_30 character varying(255),
    audit03_aspek_spamjp_sb_30 character varying(255),
    audit03_aspek_spamjp_ah_30 character varying(255),
    audit03_aspek_temuan_30 integer,
    audit03_aspek_comment_30 text,
    audit03_aspek_spamjp_ap_31 character varying(255),
    audit03_aspek_spamjp_ma_31 character varying(255),
    audit03_aspek_spamjp_sb_31 character varying(255),
    audit03_aspek_spamjp_ah_31 character varying(255),
    audit03_aspek_temuan_31 integer,
    audit03_aspek_comment_31 text,
    audit03_aspek_spamjp_ap_32 character varying(255),
    audit03_aspek_spamjp_ma_32 character varying(255),
    audit03_aspek_spamjp_sb_32 character varying(255),
    audit03_aspek_spamjp_ah_32 character varying(255),
    audit03_aspek_temuan_32 integer,
    audit03_aspek_comment_32 text,
    audit03_aspek_spamjp_ap_33 character varying(255),
    audit03_aspek_spamjp_ma_33 character varying(255),
    audit03_aspek_spamjp_sb_33 character varying(255),
    audit03_aspek_spamjp_ah_33 character varying(255),
    audit03_aspek_temuan_33 integer,
    audit03_aspek_comment_33 text,
    audit03_aspek_spamjp_ap_34 character varying(255),
    audit03_aspek_spamjp_ma_34 character varying(255),
    audit03_aspek_spamjp_sb_34 character varying(255),
    audit03_aspek_spamjp_ah_34 character varying(255),
    audit03_aspek_temuan_34 integer,
    audit03_aspek_comment_34 text,
    audit03_aspek_spamjp_ap_35 character varying(255),
    audit03_aspek_spamjp_ma_35 character varying(255),
    audit03_aspek_spamjp_sb_35 character varying(255),
    audit03_aspek_spamjp_ah_35 character varying(255),
    audit03_aspek_temuan_35 integer,
    audit03_aspek_comment_35 text,
    audit03_aspek_spamjp_ap_36 character varying(255),
    audit03_aspek_spamjp_ma_36 character varying(255),
    audit03_aspek_spamjp_sb_36 character varying(255),
    audit03_aspek_spamjp_ah_36 character varying(255),
    audit03_aspek_temuan_36 integer,
    audit03_aspek_comment_36 text,
    audit03_aspek_spamjp_ap_6a character varying(255),
    audit03_aspek_spamjp_ma_6a character varying(255),
    audit03_aspek_spamjp_sb_6a character varying(255),
    audit03_aspek_spamjp_ah_6a character varying(255),
    audit03_aspek_comment_6a text,
    audit03_aspek_spamjp_ap_37 character varying(255),
    audit03_aspek_spamjp_ma_37 character varying(255),
    audit03_aspek_spamjp_sb_37 character varying(255),
    audit03_aspek_spamjp_ah_37 character varying(255),
    audit03_aspek_temuan_37 integer,
    audit03_aspek_comment_37 text,
    audit03_aspek_spamjp_ap_38 character varying(255),
    audit03_aspek_spamjp_ma_38 character varying(255),
    audit03_aspek_spamjp_sb_38 character varying(255),
    audit03_aspek_spamjp_ah_38 character varying(255),
    audit03_aspek_temuan_38 integer,
    audit03_aspek_comment_38 text,
    audit03_aspek_spamjp_ap_39 character varying(255),
    audit03_aspek_spamjp_ma_39 character varying(255),
    audit03_aspek_spamjp_sb_39 character varying(255),
    audit03_aspek_spamjp_ah_39 character varying(255),
    audit03_aspek_temuan_39 integer,
    audit03_aspek_comment_39 text,
    audit03_aspek_spamjp_ap_40 character varying(255),
    audit03_aspek_spamjp_ma_40 character varying(255),
    audit03_aspek_spamjp_sb_40 character varying(255),
    audit03_aspek_spamjp_ah_40 character varying(255),
    audit03_aspek_temuan_40 integer,
    audit03_aspek_comment_40 text,
    audit03_aspek_spamjp_ap_41 character varying(255),
    audit03_aspek_spamjp_ma_41 character varying(255),
    audit03_aspek_spamjp_sb_41 character varying(255),
    audit03_aspek_spamjp_ah_41 character varying(255),
    audit03_aspek_temuan_41 integer,
    audit03_aspek_comment_41 text,
    audit03_cadangan_spamjp_ap_42 character varying(255),
    audit03_cadangan_spamjp_ma_42 character varying(255),
    audit03_cadangan_spamjp_sb_42 character varying(255),
    audit03_cadangan_spamjp_ah_42 character varying(255),
    audit03_cadangan_temuan_42 integer,
    audit03_cadangan_comment_42 text,
    audit03_cadangan_spamjp_ap_43 character varying(255),
    audit03_cadangan_spamjp_ma_43 character varying(255),
    audit03_cadangan_spamjp_sb_43 character varying(255),
    audit03_cadangan_spamjp_ah_43 character varying(255),
    audit03_cadangan_temuan_43 integer,
    audit03_cadangan_comment_43 text,
    audit03_lab_spamjp_ap_44 character varying(255),
    audit03_lab_spamjp_ma_44 character varying(255),
    audit03_lab_spamjp_sb_44 character varying(255),
    audit03_lab_spamjp_ah_44 character varying(255),
    audit03_lab_temuan_44 integer,
    audit03_lab_comment_44 text,
    audit03_lab_spamjp_ap_45 character varying(255),
    audit03_lab_spamjp_ma_45 character varying(255),
    audit03_lab_spamjp_sb_45 character varying(255),
    audit03_lab_spamjp_ah_45 character varying(255),
    audit03_lab_temuan_45 integer,
    audit03_lab_comment_45 text,
    audit03_lab_spamjp_ap_46 character varying(255),
    audit03_lab_spamjp_ma_46 character varying(255),
    audit03_lab_spamjp_sb_46 character varying(255),
    audit03_lab_spamjp_ah_46 character varying(255),
    audit03_lab_temuan_46 integer,
    audit03_lab_comment_46 text,
    audit03_lab_spamjp_ap_47 character varying(255),
    audit03_lab_spamjp_ma_47 character varying(255),
    audit03_lab_spamjp_sb_47 character varying(255),
    audit03_lab_spamjp_ah_47 character varying(255),
    audit03_lab_temuan_47 integer,
    audit03_lab_comment_47 text,
    audit03_lab_spamjp_ap_48 character varying(255),
    audit03_lab_spamjp_ma_48 character varying(255),
    audit03_lab_spamjp_sb_48 character varying(255),
    audit03_lab_spamjp_ah_48 character varying(255),
    audit03_lab_temuan_48 integer,
    audit03_lab_comment_48 text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    audit03_aspek_spamjp_ap_1_ character varying(255),
    audit03_aspek_spamjp_ma_1_ character varying(255),
    audit03_aspek_spamjp_sb_1_ character varying(255),
    audit03_aspek_spamjp_ah_1_ character varying(255),
    audit03_aspek_comment_1_ text,
    audit03_aspek_spamjp_ap_2_ character varying(255),
    audit03_aspek_spamjp_ma_2_ character varying(255),
    audit03_aspek_spamjp_sb_2_ character varying(255),
    audit03_aspek_spamjp_ah_2_ character varying(255),
    audit03_aspek_comment_2_ text,
    audit03_aspek_spamjp_ap_3_ character varying(255),
    audit03_aspek_spamjp_ma_3_ character varying(255),
    audit03_aspek_spamjp_sb_3_ character varying(255),
    audit03_aspek_spamjp_ah_3_ character varying(255),
    audit03_aspek_comment_3_ text,
    audit03_aspek_spamjp_ap_4_ character varying(255),
    audit03_aspek_spamjp_ma_4_ character varying(255),
    audit03_aspek_spamjp_sb_4_ character varying(255),
    audit03_aspek_spamjp_ah_4_ character varying(255),
    audit03_aspek_comment_4_ text,
    audit03_aspek_spamjp_ap_5_ character varying(255),
    audit03_aspek_spamjp_ma_5_ character varying(255),
    audit03_aspek_spamjp_sb_5_ character varying(255),
    audit03_aspek_spamjp_ah_5_ character varying(255),
    audit03_aspek_comment_5_ text,
    audit03_aspek_spamjp_ap_6_ character varying(255),
    audit03_aspek_spamjp_ma_6_ character varying(255),
    audit03_aspek_spamjp_sb_6_ character varying(255),
    audit03_aspek_spamjp_ah_6_ character varying(255),
    audit03_aspek_comment_6_ text
);


ALTER TABLE public.audit03 OWNER TO wsp;

--
-- Name: audit03_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.audit03_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.audit03_id_seq OWNER TO wsp;

--
-- Name: audit03_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.audit03_id_seq OWNED BY public.audit03.id;


--
-- Name: audits; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.audits (
    id bigint NOT NULL,
    audit_date date,
    institution_name character varying(255),
    institution_address character varying(255),
    auditor_name character varying(255),
    auditor_organization character varying(255),
    certificate_organization character varying(255),
    spamjp character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    organization_id integer
);


ALTER TABLE public.audits OWNER TO wsp;

--
-- Name: audits_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.audits_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.audits_id_seq OWNER TO wsp;

--
-- Name: audits_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.audits_id_seq OWNED BY public.audits.id;


--
-- Name: course_user; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.course_user (
    course_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE public.course_user OWNER TO wsp;

--
-- Name: courses; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.courses (
    id bigint NOT NULL,
    title character varying(255) NOT NULL,
    description text,
    picture character varying(255),
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    start_date_time timestamp(0) without time zone,
    is_master boolean DEFAULT false NOT NULL,
    instructor_id integer
);


ALTER TABLE public.courses OWNER TO wsp;

--
-- Name: courses_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.courses_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.courses_id_seq OWNER TO wsp;

--
-- Name: courses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.courses_id_seq OWNED BY public.courses.id;

--
-- Name: discussions_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.discussions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.discussions_id_seq OWNER TO wsp;

--
-- Name: discussions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.discussions_id_seq OWNED BY public.discussions.id;


--
-- Name: failed_jobs; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.failed_jobs (
    id bigint NOT NULL,
    uuid character varying(255) NOT NULL,
    connection text NOT NULL,
    queue text NOT NULL,
    payload text NOT NULL,
    exception text NOT NULL,
    failed_at timestamp(0) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.failed_jobs OWNER TO wsp;

--
-- Name: failed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.failed_jobs_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.failed_jobs_id_seq OWNER TO wsp;

--
-- Name: failed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.failed_jobs_id_seq OWNED BY public.failed_jobs.id;


--
-- Name: menus; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.menus (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    menu_name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.menus OWNER TO wsp;

--
-- Name: menus_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.menus_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.menus_id_seq OWNER TO wsp;

--
-- Name: menus_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.menus_id_seq OWNED BY public.menus.id;


--
-- Name: migrations; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.migrations (
    id integer NOT NULL,
    migration character varying(255) NOT NULL,
    batch integer NOT NULL
);


ALTER TABLE public.migrations OWNER TO wsp;

--
-- Name: migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

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


ALTER TABLE public.migrations_id_seq OWNER TO wsp;

--
-- Name: migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.migrations_id_seq OWNED BY public.migrations.id;


--
-- Name: organizations; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.organizations (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    is_pdam boolean DEFAULT true NOT NULL,
    city character varying(255),
    address character varying(255)
);


ALTER TABLE public.organizations OWNER TO wsp;

--
-- Name: organizations_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.organizations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.organizations_id_seq OWNER TO wsp;

--
-- Name: organizations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.organizations_id_seq OWNED BY public.organizations.id;

--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.personal_access_tokens_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.personal_access_tokens_id_seq OWNER TO wsp;

--
-- Name: personal_access_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.personal_access_tokens_id_seq OWNED BY public.personal_access_tokens.id;


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

CREATE TABLE public.questions (
    id bigint NOT NULL,
    quiz_id integer NOT NULL,
    question character varying(255) NOT NULL,
    answer_a character varying(255),
    answer_b character varying(255),
    answer_c character varying(255),
    answer_d character varying(255),
    answer_e character varying(255),
    correct_answer character varying(255),
    nilai double precision
);


ALTER TABLE public.questions OWNER TO wsp;

--
-- Name: questions_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.questions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.questions_id_seq OWNER TO wsp;

--
-- Name: questions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.questions_id_seq OWNED BY public.questions.id;


--
-- Name: quizzes; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.quizzes (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone
);


ALTER TABLE public.quizzes OWNER TO wsp;

--
-- Name: quizzes_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.quizzes_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.quizzes_id_seq OWNER TO wsp;

--
-- Name: quizzes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.quizzes_id_seq OWNED BY public.quizzes.id;


--
-- Name: reports; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.reports (
    id bigint NOT NULL,
    audit_id integer NOT NULL,
    pelaksana character varying(255),
    kontak text,
    tgl_penerbitan date,
    jenis_sertifikasi character varying(255),
    status_sertifikasi character varying(255),
    spam character varying(255),
    koreksi text,
    analisis text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    tindakan_perbaikan text,
    kontak_utama_paraf character varying(255),
    kontak_utama_paraf_tgl date,
    auditee_paraf character varying(255),
    auditee_paraf_tgl date,
    lampiran_koreksi character varying(255),
    lampiran_perbaikan character varying(255),
    user_id integer,
    koreksi02 text,
    koreksi03 text,
    analisis02 text,
    analisis03 text,
    tindakan_perbaikan02 text,
    tindakan_perbaikan03 text,
    lampiran_koreksi02 character varying(255),
    lampiran_koreksi03 character varying(255),
    lampiran_perbaikan02 character varying(255),
    lampiran_perbaikan03 character varying(255)
);


ALTER TABLE public.reports OWNER TO wsp;

--
-- Name: reports_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.reports_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.reports_id_seq OWNER TO wsp;

--
-- Name: reports_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.reports_id_seq OWNED BY public.reports.id;


--
-- Name: rpam; Type: TABLE; Schema: public; Owner: wsp
--

CREATE TABLE public.rpam (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    organization_id integer
);


ALTER TABLE public.rpam OWNER TO wsp;

--
-- Name: rpam_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.rpam_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rpam_id_seq OWNER TO wsp;

--
-- Name: rpam_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.rpam_id_seq OWNED BY public.rpam.id;

--
-- Name: session_files_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.session_files_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.session_files_id_seq OWNER TO wsp;

--
-- Name: session_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.session_files_id_seq OWNED BY public.session_files.id;


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

CREATE TABLE public.sessions (
    id bigint NOT NULL,
    course_id integer NOT NULL,
    title character varying(255) NOT NULL,
    description text,
    created_at timestamp(0) without time zone,
    updated_at timestamp(0) without time zone,
    sort integer,
    live text
);


ALTER TABLE public.sessions OWNER TO wsp;

--
-- Name: sessions_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.sessions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sessions_id_seq OWNER TO wsp;

--
-- Name: sessions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.sessions_id_seq OWNED BY public.sessions.id;

--
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: wsp
--

CREATE SEQUENCE public.users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.users_id_seq OWNER TO wsp;

--
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: wsp
--

ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;


--
-- Name: assets id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: audit01 id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: audit02 id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: audit03 id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: audits id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: courses id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: failed_jobs id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: menus id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: migrations id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: organizations id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: questions id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: quizzes id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: reports id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: rpam id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Name: sessions id; Type: DEFAULT; Schema: public; Owner: wsp
--

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


--
-- Data for Name: assets; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.assets (id, user_id, original_filename, filename, created_at, updated_at) FROM stdin;
1	1	Modul 0_RSD_MD_30072023_rev1.pdf	public/PsEfsd5WeLpcNWBWOFA7OmbIuQ7EoWS6KIG3SBp5.pdf	2024-02-21 06:43:37	2024-02-21 06:43:37
2	1	Modul 0_RSD_MD_30072023_rev1.pdf	public/f3ggNuI827cqTS9wT9yIugtL0KfuCbDBeM4rX084.pdf	2024-02-21 06:43:55	2024-02-21 06:43:55
3	1	Modul 1_RSD_MD_31072023_rev1.pdf	public/cNp8uwmwjiXf033Gt3YFyVue7jbMXuyZ8hwWGICi.pdf	2024-02-21 06:44:24	2024-02-21 06:44:24
4	1	Modul 2_RSD_MD 02_31072023.pdf	public/3VcVdIyor9fcfAUUI9QKXm3gQZsDKAODNic2nc1E.pdf	2024-02-21 06:47:39	2024-02-21 06:47:39
5	1	Modul 3_RSD_MD 02_31072023.pdf	public/JBGhKTD0uLcQK0UXgOTgTHXn397JdZe50OMUu2wa.pdf	2024-02-21 06:48:10	2024-02-21 06:48:10
6	1	Modul 4_RSD_MD 02_01082023.pdf	public/QIlP7OSxK6bpBtA2GlLOPea26Dg5EsZVfkBmZ3fb.pdf	2024-02-21 06:49:02	2024-02-21 06:49:02
7	1	Modul 5_RSD_MD 02_01082023.pdf	public/V39nWEI9O5s1zKmA59vL0XHOQCBjrJnOqDV5JD5d.pdf	2024-02-21 06:49:23	2024-02-21 06:49:23
8	1	Modul 6_RSD_MD 02_02082023.pdf	public/EqMGSV3EXqry86VLJSCnD355doXaOIBjbzQMyZCJ.pdf	2024-02-21 06:49:51	2024-02-21 06:49:51
9	1	Modul 7_RSD_MD 02_02082023 (1).pdf	public/e9VgNJiV7bWbWlRaf95I68NNDlUnsmEdlEYNQ0Eo.pdf	2024-02-21 06:50:23	2024-02-21 06:50:23
10	1	Modul 8_RSD_MD 02_02082023.pdf	public/4mclSbK6SwLlyLp1Y52r98eZYZXtKdhRCRbJWe9T.pdf	2024-02-21 06:50:46	2024-02-21 06:50:46
11	1	Modul 9_RSD_MD 02_02082023.pdf	public/QmLkMaIspKuTVzyBAXbT1I1fpb0TB8Yn1A2hhbib.pdf	2024-02-21 06:58:13	2024-02-21 06:58:13
12	1	Modul 10_RSD_MD 02_03082023.pdf	public/ItEq1LB8rkKBjVY4FjJVlBqvKRymsdDAszi7dSN9.pdf	2024-02-21 06:58:51	2024-02-21 06:58:51
13	1	Modul 11_RSD_MD 02_03082023.pdf	public/66ZcCDUQBr0KnSMncejg0ysKrGPSagMuezlv0JyW.pdf	2024-02-21 06:58:51	2024-02-21 06:58:51
14	1	04 Penjelasan_RSD_1412023.pdf	public/8tTHcgrATkD7jCiMCbHW5i51iOamhhh75NMzJgDI.pdf	2024-02-21 06:59:41	2024-02-21 06:59:41
15	1	07 BLC_RSD_24012024.pdf	public/zJjW1bNW5yBcbhxjEOo7nWJIv6SinRXrzzEo2SUl.pdf	2024-02-21 07:00:00	2024-02-21 07:00:00
16	1	08 MPD 1 Kebijakan tentang RPAM_RSD_24012024.pdf	public/tAUghOLh85Cz6edkHsiVjn9Yny6nsO8WHRATgpTc.pdf	2024-02-21 07:00:27	2024-02-21 07:00:27
17	1	08 MPI 1 RPAM_RSD_24012024.pdf	public/RD0p9aXy20IgOz4x0TarX2cjbZ9APtxL4DXslgUw.pdf	2024-02-21 07:05:56	2024-02-21 07:05:56
18	1	09 MPI 2 Audit Internal & Eksternal_RSD_24012024.pdf	public/QOPu43o6QxYTvb2MSb8lwkg6c6fXFPNqZk8E9RnV.pdf	2024-02-21 07:06:38	2024-02-21 07:06:38
19	1	11 MPI 3 Alur Teknis Audit Eksternal_RSD_24012024.pdf	public/PLJtcfeF768o1yCHK0vc2HRT60iDG8BydVuxbOJ7.pdf	2024-02-21 07:07:07	2024-02-21 07:07:07
20	1	08 MPI 4 Pemeriksaan Kelengkapan Dokumen RPAM_RSD_24012024.pdf	public/BEIdmY8yOKTxJOAep2NTyQsG0Ljc6sPsBWjsaiO2.pdf	2024-02-21 07:07:41	2024-02-21 07:07:41
21	1	07 MPI 5 Pemeriksaan Kesesuaian Dokumen RPAM_RSD_24012024.pdf	public/ue08KZvKlJ5yZWgdMnSV8Tk8oeHLgDA625AkCNK6.pdf	2024-02-21 07:08:09	2024-02-21 07:08:09
22	1	07 MPI 6 Pemeriksaan Implementasi RPAM_RSD_24012024.pdf	public/AokppUSHvKZKE4jn9npK0gcmsQ2NMQHcPcnApvNP.pdf	2024-02-21 07:10:33	2024-02-21 07:10:33
23	1	02 Kunjungan Lap_RSD_14122023.pdf	public/2Ab4RZZPFHvcopq52TBWovHhsXNyGqKCskDXETeH.pdf	2024-02-21 07:11:21	2024-02-21 07:11:21
24	1	06 MPD 1 Kebijakan tentang RPAM.docx	public/07viCy2IQv5B52HFa6QkUhnoAwDX2r8ucIwwmUYY.docx	2024-02-21 07:22:46	2024-02-21 07:22:46
25	1	MPD 1 Kebijakan tentang RPAM.pdf	public/VSZUYrVlyo0ZAgUFF9nV50Mg8HK6re6Ez72yoyv8.pdf	2024-02-21 07:25:49	2024-02-21 07:25:49
\.


--
-- Data for Name: audit01; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.audit01 (id, audit_id, audit01_umum_i, audit01_umum_i_comment, audit01_umum_ii, audit01_umum_ii_comment, audit01_umum_iii, audit01_umum_iii_comment, audit01_umum_iv, audit01_umum_iv_comment, audit01_modul1_1, audit01_modul1_1_comment, audit01_modul1_2, audit01_modul1_2_comment, audit01_modul1_3, audit01_modul1_3_comment, audit01_modul1_4, audit01_modul1_4_comment, audit01_modul1_5, audit01_modul1_5_comment, audit01_modul1_6, audit01_modul1_6_comment, audit01_modul1_7, audit01_modul1_7_comment, audit01_modul1_8, audit01_modul1_8_comment, audit01_modul1_9, audit01_modul1_9_comment, audit01_modul1_10, audit01_modul1_10_comment, audit01_modul1_11, audit01_modul1_11_comment, audit01_modul1_12, audit01_modul1_12_comment, audit01_modul1_13, audit01_modul1_13_comment, audit01_modul1_14, audit01_modul1_14_comment, audit01_modul1_15, audit01_modul1_15_comment, audit01_modul2_1, audit01_modul2_1_comment, audit01_modul2_2, audit01_modul2_2_comment, audit01_modul2_3, audit01_modul2_3_comment, audit01_modul2_4, audit01_modul2_4_comment, audit01_modul2_5, audit01_modul2_5_comment, audit01_modul2_6, audit01_modul2_6_comment, audit01_modul2_7, audit01_modul2_7_comment, audit01_modul2_8, audit01_modul2_8_comment, audit01_modul2_9, audit01_modul2_9_comment, audit01_modul3_1, audit01_modul3_1_comment, audit01_modul3_2, audit01_modul3_2_comment, audit01_modul3_3, audit01_modul3_3_comment, audit01_modul3_4, audit01_modul3_4_comment, audit01_modul3_5, audit01_modul3_5_comment, audit01_modul3_6, audit01_modul3_6_comment, audit01_modul3_7, audit01_modul3_7_comment, audit01_modul4_1, audit01_modul4_1_comment, audit01_modul4_2, audit01_modul4_2_comment, audit01_modul5_1, audit01_modul5_1_comment, audit01_modul5_2, audit01_modul5_2_comment, audit01_modul5_3, audit01_modul5_3_comment, audit01_modul5_4, audit01_modul5_4_comment, audit01_modul6_1, audit01_modul6_1_comment, audit01_modul6_2, audit01_modul6_2_comment, audit01_modul7_1, audit01_modul7_1_comment, audit01_modul7_2, audit01_modul7_2_comment, audit01_modul7_3, audit01_modul7_3_comment, audit01_modul7_4, audit01_modul7_4_comment, audit01_modul7_5, audit01_modul7_5_comment, audit01_modul7_6, audit01_modul7_6_comment, audit01_modul7_7, audit01_modul7_7_comment, audit01_modul8_1, audit01_modul8_1_comment, audit01_modul8_2, audit01_modul8_2_comment, audit01_modul8_3, audit01_modul8_3_comment, audit01_modul8_4, audit01_modul8_4_comment, audit01_modul8_5, audit01_modul8_5_comment, audit01_modul9_1, audit01_modul9_1_comment, audit01_modul9_2, audit01_modul9_2_comment, audit01_modul9_3, audit01_modul9_3_comment, audit01_modul9_4, audit01_modul9_4_comment, audit01_modul9_5, audit01_modul9_5_comment, audit01_modul9_6, audit01_modul9_6_comment, audit01_modul9_7, audit01_modul9_7_comment, audit01_modul9_8, audit01_modul9_8_comment, audit01_modul10_1, audit01_modul10_1_comment, audit01_modul10_2, audit01_modul10_2_comment, audit01_modul10_3, audit01_modul10_3_comment, audit01_modul10_4, audit01_modul10_4_comment, audit01_modul11_1, audit01_modul11_1_comment, audit01_modul11_2, audit01_modul11_2_comment, created_at, updated_at) FROM stdin;
1	1	0	\N	1	\N	2	\N	2	test update komentar	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-03-20 22:33:26	2024-03-20 22:34:07
2	2	0	\N	0	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	2	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	\N	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	\N	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	2024-03-21 04:00:49	2024-03-21 04:00:49
3	3	1	\N	1	\N	0	\N	0	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	2	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	2	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	2	\N	0	\N	0	\N	1	\N	1	\N	1	\N	0	\N	\N	\N	0	\N	0	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	0	\N	0	\N	1	\N	1	\N	1	\N	2	\N	2024-05-27 03:14:17	2024-05-27 03:16:09
4	4	1	\N	0	\N	1	\N	1	\N	2	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	0	ketua tim sudah pindah bagian	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	2	\N	0	\N	0	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	0	\N	1	\N	\N	\N	1	\N	0	\N	1	\N	1	\N	1	\N	0	\N	0	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	0	\N	2024-06-03 06:57:41	2024-06-03 07:01:05
5	5	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	0	masih didominasi oleh pria sebanyak 90%	1	\N	0	Ahli eksternal masih berupa kontrak kerjasama	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	1	\N	0	target kualitas air minum belum menyesuaikan per unit pengolahan	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	dampak keparahan tidak sesuai	1	\N	1	\N	1	\N	0	\N	1	\N	\N	\N	1	\N	0	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	1	\N	1	\N	0	\N	1	\N	1	\N	2024-06-04 02:35:33	2024-06-04 03:01:40
6	6	\N	\N	\N	\N	1	Juknis sudah mengacu dengan keadaan di lapangan	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-06-04 03:46:27	2024-06-04 03:47:43
\.


--
-- Data for Name: audit02; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.audit02 (id, audit_id, audit02_umum_i, audit02_umum_i_comment, audit02_umum_ii, audit02_umum_ii_comment, audit02_umum_iii, audit02_umum_iii_comment, audit02_modul1_1a, audit02_modul1_1a_comment, audit02_modul1_1b, audit02_modul1_1b_comment, audit02_modul1_2a, audit02_modul1_2a_comment, audit02_modul1_3a, audit02_modul1_3a_comment, audit02_modul1_4a, audit02_modul1_4a_comment, audit02_modul1_5a, audit02_modul1_5a_comment, audit02_modul1_6a, audit02_modul1_6a_comment, audit02_modul1_8a, audit02_modul1_8a_comment, audit02_modul1_9a, audit02_modul1_9a_comment, audit02_modul1_9b, audit02_modul1_9b_comment, audit02_modul1_7c, audit02_modul1_7c_comment, audit02_modul1_10a, audit02_modul1_10a_comment, audit02_modul1_11, audit02_modul1_11_comment, audit02_modul1_12a, audit02_modul1_12a_comment, audit02_modul1_13a, audit02_modul1_13a_comment, audit02_modul1_14a, audit02_modul1_14a_comment, audit02_modul2_1a, audit02_modul2_1a_comment, audit02_modul2_2a, audit02_modul2_2a_comment, audit02_modul2_3a, audit02_modul2_3a_comment, audit02_modul2_4a, audit02_modul2_4a_comment, audit02_modul2_5a, audit02_modul2_5a_comment, audit02_modul2_5b, audit02_modul2_5b_comment, audit02_modul2_6a, audit02_modul2_6a_comment, audit02_modul2_7a, audit02_modul2_7a_comment, audit02_modul2_8a, audit02_modul2_8a_comment, audit02_modul2_9a, audit02_modul2_9a_comment, audit02_modul3_1a, audit02_modul3_1a_comment, audit02_modul3_1b, audit02_modul3_1b_comment, audit02_modul3_1c, audit02_modul3_1c_comment, audit02_modul3_2a, audit02_modul3_2a_comment, audit02_modul3_3a6a, audit02_modul3_3a6a_comment, audit02_modul3_7a, audit02_modul3_7a_comment, audit02_modul4_1a, audit02_modul4_1a_comment, audit02_modul4_1b, audit02_modul4_1b_comment, audit02_modul4_2a, audit02_modul4_2a_comment, audit02_modul4_2b, audit02_modul4_2b_comment, audit02_modul4_2c, audit02_modul4_2c_comment, audit02_modul5_1a, audit02_modul5_1a_comment, audit02_modul5_1b, audit02_modul5_1b_comment, audit02_modul5_2a, audit02_modul5_2a_comment, audit02_modul5_2b, audit02_modul5_2b_comment, audit02_modul5_3a, audit02_modul5_3a_comment, audit02_modul5_4a, audit02_modul5_4a_comment, audit02_modul6_a, audit02_modul6_a_comment, audit02_modul6_1a, audit02_modul6_1a_comment, audit02_modul6_1b, audit02_modul6_1b_comment, audit02_modul6_2a, audit02_modul6_2a_comment, audit02_modul6_2b, audit02_modul6_2b_comment, audit02_modul6_2c, audit02_modul6_2c_comment, audit02_modul6_2d, audit02_modul6_2d_comment, audit02_modul7_a, audit02_modul7_a_comment, audit02_modul7_1a, audit02_modul7_1a_comment, audit02_modul7_2a, audit02_modul7_2a_comment, audit02_modul7_2b, audit02_modul7_2b_comment, audit02_modul7_2c, audit02_modul7_2c_comment, audit02_modul7_2d, audit02_modul7_2d_comment, audit02_modul7_2e, audit02_modul7_2e_comment, audit02_modul7_2f, audit02_modul7_2f_comment, audit02_modul7_3a, audit02_modul7_3a_comment, audit02_modul7_3b, audit02_modul7_3b_comment, audit02_modul7_4a, audit02_modul7_4a_comment, audit02_modul7_4b, audit02_modul7_4b_comment, audit02_modul7_5a, audit02_modul7_5a_comment, audit02_modul7_5b, audit02_modul7_5b_comment, audit02_modul7_6a, audit02_modul7_6a_comment, audit02_modul7_7a, audit02_modul7_7a_comment, audit02_modul7_7b, audit02_modul7_7b_comment, audit02_modul7_7c, audit02_modul7_7c_comment, audit02_modul8_a, audit02_modul8_a_comment, audit02_modul8_1a, audit02_modul8_1a_comment, audit02_modul8_1b, audit02_modul8_1b_comment, audit02_modul8_1c, audit02_modul8_1c_comment, audit02_modul8_2a, audit02_modul8_2a_comment, audit02_modul8_2b, audit02_modul8_2b_comment, audit02_modul8_4a, audit02_modul8_4a_comment, audit02_modul8_5a, audit02_modul8_5a_comment, audit02_modul9_1a, audit02_modul9_1a_comment, audit02_modul9_2a, audit02_modul9_2a_comment, audit02_modul9_2b, audit02_modul9_2b_comment, audit02_modul9_3a, audit02_modul9_3a_comment, audit02_modul9_4a, audit02_modul9_4a_comment, audit02_modul9_4b, audit02_modul9_4b_comment, audit02_modul9_5a, audit02_modul9_5a_comment, audit02_modul9_6a, audit02_modul9_6a_comment, audit02_modul9_7a, audit02_modul9_7a_comment, audit02_modul9_7b, audit02_modul9_7b_comment, audit02_modul9_8a, audit02_modul9_8a_comment, audit02_modul10_1a, audit02_modul10_1a_comment, audit02_modul10_2a, audit02_modul10_2a_comment, audit02_modul10_3a, audit02_modul10_3a_comment, audit02_modul10_3b, audit02_modul10_3b_comment, audit02_modul10_4a, audit02_modul10_4a_comment, audit02_modul10_4b, audit02_modul10_4b_comment, audit02_modul11_1a, audit02_modul11_1a_comment, audit02_modul11_2a, audit02_modul11_2a_comment, audit02_modul11_2b, audit02_modul11_2b_comment, audit02_modul11_2c, audit02_modul11_2c_comment, audit02_modul11_2d, audit02_modul11_2d_comment, audit02_modul11_2e, audit02_modul11_2e_comment, audit02_modul11_2f, audit02_modul11_2f_comment, audit02_modul11_2g, audit02_modul11_2g_comment, audit02_modul11_2h, audit02_modul11_2h_comment, created_at, updated_at) FROM stdin;
1	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-03-20 22:33:26	2024-03-20 22:33:26
3	3	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-05-27 03:14:17	2024-05-27 03:14:17
4	4	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-06-03 06:57:41	2024-06-03 06:57:41
5	5	0	\N	1	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	1	ketua tim RPAM sudah pensiun	0	\N	1	tidak terdapat rekaman sosialisasi	0	\N	0	\N	\N	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	1	\N	1	Bak pelepas tekan tidak ada di narasi	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	1	\N	0	\N	0	\N	0	\N	0	\N	0	\N	1	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	1	\N	0	\N	0	\N	0	\N	1	\N	0	\N	0	\N	1	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	1	\N	0	\N	1	\N	0	\N	0	\N	0	\N	0	\N	0	\N	1	\N	1	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	1	\N	0	\N	0	\N	1	\N	1	\N	0	\N	0	\N	0	\N	2	\N	2	RPAM baru dijalankan satu siklus, sehingga belum ada revisi	2024-06-04 02:35:33	2024-06-04 03:01:40
6	6	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-06-04 03:46:27	2024-06-04 03:46:27
2	2	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	\N	\N	0	\N	0	Menyusul	0	\N	0	\N	0	\N	2	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	2	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	\N	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	0	\N	2024-03-21 04:00:49	2024-06-04 06:47:25
\.


--
-- Data for Name: audit03; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.audit03 (id, audit_id, audit03_umum_spamjp_ap_i, audit03_umum_spamjp_ma_i, audit03_umum_spamjp_sb_i, audit03_umum_spamjp_ah_i, audit03_umum_temuan_i, audit03_umum_comment_i, audit03_umum_spamjp_ap_ii, audit03_umum_spamjp_ma_ii, audit03_umum_spamjp_sb_ii, audit03_umum_spamjp_ah_ii, audit03_umum_temuan_ii, audit03_umum_comment_ii, audit03_umum_spamjp_ap_iii, audit03_umum_spamjp_ma_iii, audit03_umum_spamjp_sb_iii, audit03_umum_spamjp_ah_iii, audit03_umum_temuan_iii, audit03_umum_comment_iii, audit03_umum_spamjp_ap_iv, audit03_umum_spamjp_ma_iv, audit03_umum_spamjp_sb_iv, audit03_umum_spamjp_ah_iv, audit03_umum_temuan_iv, audit03_umum_comment_iv, audit03_umum_spamjp_ap_v, audit03_umum_spamjp_ma_v, audit03_umum_spamjp_sb_v, audit03_umum_spamjp_ah_v, audit03_umum_temuan_v, audit03_umum_comment_v, audit03_umum_spamjp_ap_vi, audit03_umum_spamjp_ma_vi, audit03_umum_spamjp_sb_vi, audit03_umum_spamjp_ah_vi, audit03_umum_temuan_vi, audit03_umum_comment_vi, audit03_umum_spamjp_ap_vii, audit03_umum_spamjp_ma_vii, audit03_umum_spamjp_sb_vii, audit03_umum_spamjp_ah_vii, audit03_umum_temuan_vii, audit03_umum_comment_vii, audit03_umum_spamjp_ap_viii, audit03_umum_spamjp_ma_viii, audit03_umum_spamjp_sb_viii, audit03_umum_spamjp_ah_viii, audit03_umum_temuan_viii, audit03_umum_comment_viii, audit03_umum_spamjp_ap_ix, audit03_umum_spamjp_ma_ix, audit03_umum_spamjp_sb_ix, audit03_umum_spamjp_ah_ix, audit03_umum_temuan_ix, audit03_umum_comment_ix, audit03_umum_spamjp_ap_x, audit03_umum_spamjp_ma_x, audit03_umum_spamjp_sb_x, audit03_umum_spamjp_ah_x, audit03_umum_temuan_x, audit03_umum_comment_x, audit03_umum_spamjp_ap_xi, audit03_umum_spamjp_ma_xi, audit03_umum_spamjp_sb_xi, audit03_umum_spamjp_ah_xi, audit03_umum_temuan_xi, audit03_umum_comment_xi, audit03_umum_spamjp_ap_xii, audit03_umum_spamjp_ma_xii, audit03_umum_spamjp_sb_xii, audit03_umum_spamjp_ah_xii, audit03_umum_temuan_xii, audit03_umum_comment_xii, audit03_umum_spamjp_ap_xiii, audit03_umum_spamjp_ma_xiii, audit03_umum_spamjp_sb_xiii, audit03_umum_spamjp_ah_xiii, audit03_umum_temuan_xiii, audit03_umum_comment_xiii, audit03_umum_spamjp_ap_xiv, audit03_umum_spamjp_ma_xiv, audit03_umum_spamjp_sb_xiv, audit03_umum_spamjp_ah_xiv, audit03_umum_temuan_xiv, audit03_umum_comment_xiv, audit03_umum_spamjp_ap_xv, audit03_umum_spamjp_ma_xv, audit03_umum_spamjp_sb_xv, audit03_umum_spamjp_ah_xv, audit03_umum_temuan_xv, audit03_umum_comment_xv, audit03_umum_spamjp_ap_xvi, audit03_umum_spamjp_ma_xvi, audit03_umum_spamjp_sb_xvi, audit03_umum_spamjp_ah_xvi, audit03_umum_temuan_xvi, audit03_umum_comment_xvi, audit03_umum_spamjp_ap_xvii, audit03_umum_spamjp_ma_xvii, audit03_umum_spamjp_sb_xvii, audit03_umum_spamjp_ah_xvii, audit03_umum_temuan_xvii, audit03_umum_comment_xvii, audit03_umum_spamjp_ap_xviii, audit03_umum_spamjp_ma_xviii, audit03_umum_spamjp_sb_xviii, audit03_umum_spamjp_ah_xviii, audit03_umum_temuan_xviii, audit03_umum_comment_xviii, audit03_umum_spamjp_ap_xix, audit03_umum_spamjp_ma_xix, audit03_umum_spamjp_sb_xix, audit03_umum_spamjp_ah_xix, audit03_umum_temuan_xix, audit03_umum_comment_xix, audit03_aspek1_spamjp_ap_1, audit03_aspek1_spamjp_ma_1, audit03_aspek1_spamjp_sb_1, audit03_aspek1_spamjp_ah_1, audit03_aspek1_temuan_1, audit03_aspek1_comment_1, audit03_aspek_spamjp_ap_2, audit03_aspek_spamjp_ma_2, audit03_aspek_spamjp_sb_2, audit03_aspek_spamjp_ah_2, audit03_aspek_temuan_2, audit03_aspek_comment_2, audit03_aspek_spamjp_ap_2a, audit03_aspek_spamjp_ma_2a, audit03_aspek_spamjp_sb_2a, audit03_aspek_spamjp_ah_2a, audit03_aspek_comment_2a, audit03_aspek_spamjp_ap_3, audit03_aspek_spamjp_ma_3, audit03_aspek_spamjp_sb_3, audit03_aspek_spamjp_ah_3, audit03_aspek_temuan_3, audit03_aspek_comment_3, audit03_aspek_spamjp_ap_2b, audit03_aspek_spamjp_ma_2b, audit03_aspek_spamjp_sb_2b, audit03_aspek_spamjp_ah_2b, audit03_aspek_comment_2b, audit03_aspek_spamjp_ap_2c, audit03_aspek_spamjp_ma_2c, audit03_aspek_spamjp_sb_2c, audit03_aspek_spamjp_ah_2c, audit03_aspek_comment_2c, audit03_aspek_spamjp_ap_4, audit03_aspek_spamjp_ma_4, audit03_aspek_spamjp_sb_4, audit03_aspek_spamjp_ah_4, audit03_aspek_temuan_4, audit03_aspek_comment_4, audit03_aspek_spamjp_ap_2d, audit03_aspek_spamjp_ma_2d, audit03_aspek_spamjp_sb_2d, audit03_aspek_spamjp_ah_2d, audit03_aspek_comment_2d, audit03_aspek_spamjp_ap_2e, audit03_aspek_spamjp_ma_2e, audit03_aspek_spamjp_sb_2e, audit03_aspek_spamjp_ah_2e, audit03_aspek_comment_2e, audit03_aspek_spamjp_ap_5, audit03_aspek_spamjp_ma_5, audit03_aspek_spamjp_sb_5, audit03_aspek_spamjp_ah_5, audit03_aspek_temuan_5, audit03_aspek_comment_5, audit03_aspek_spamjp_ap_6, audit03_aspek_spamjp_ma_6, audit03_aspek_spamjp_sb_6, audit03_aspek_spamjp_ah_6, audit03_aspek_temuan_6, audit03_aspek_comment_6, audit03_aspek_spamjp_ap_3a, audit03_aspek_spamjp_ma_3a, audit03_aspek_spamjp_sb_3a, audit03_aspek_spamjp_ah_3a, audit03_aspek_comment_3a, audit03_aspek_spamjp_ap_7, audit03_aspek_spamjp_ma_7, audit03_aspek_spamjp_sb_7, audit03_aspek_spamjp_ah_7, audit03_aspek_temuan_7, audit03_aspek_comment_7, audit03_aspek_spamjp_ap_3b, audit03_aspek_spamjp_ma_3b, audit03_aspek_spamjp_sb_3b, audit03_aspek_spamjp_ah_3b, audit03_aspek_comment_3b, audit03_aspek_spamjp_ap_4a, audit03_aspek_spamjp_ma_4a, audit03_aspek_spamjp_sb_4a, audit03_aspek_spamjp_ah_4a, audit03_aspek_comment_4a, audit03_aspek_spamjp_ap_8, audit03_aspek_spamjp_ma_8, audit03_aspek_spamjp_sb_8, audit03_aspek_spamjp_ah_8, audit03_aspek_temuan_8, audit03_aspek_comment_8, audit03_aspek_spamjp_ap_4b, audit03_aspek_spamjp_ma_4b, audit03_aspek_spamjp_sb_4b, audit03_aspek_spamjp_ah_4b, audit03_aspek_comment_4b, audit03_aspek_spamjp_ap_9, audit03_aspek_spamjp_ma_9, audit03_aspek_spamjp_sb_9, audit03_aspek_spamjp_ah_9, audit03_aspek_temuan_9, audit03_aspek_comment_9, audit03_aspek_spamjp_ap_4c, audit03_aspek_spamjp_ma_4c, audit03_aspek_spamjp_sb_4c, audit03_aspek_spamjp_ah_4c, audit03_aspek_comment_4c, audit03_aspek_spamjp_ap_10, audit03_aspek_spamjp_ma_10, audit03_aspek_spamjp_sb_10, audit03_aspek_spamjp_ah_10, audit03_aspek_temuan_10, audit03_aspek_comment_10, audit03_aspek_spamjp_ap_11, audit03_aspek_spamjp_ma_11, audit03_aspek_spamjp_sb_11, audit03_aspek_spamjp_ah_11, audit03_aspek_temuan_11, audit03_aspek_comment_11, audit03_aspek_spamjp_ap_12, audit03_aspek_spamjp_ma_12, audit03_aspek_spamjp_sb_12, audit03_aspek_spamjp_ah_12, audit03_aspek_temuan_12, audit03_aspek_comment_12, audit03_aspek_spamjp_ap_13, audit03_aspek_spamjp_ma_13, audit03_aspek_spamjp_sb_13, audit03_aspek_spamjp_ah_13, audit03_aspek_temuan_13, audit03_aspek_comment_13, audit03_aspek_spamjp_ap_4d, audit03_aspek_spamjp_ma_4d, audit03_aspek_spamjp_sb_4d, audit03_aspek_spamjp_ah_4d, audit03_aspek_comment_4d, audit03_aspek_spamjp_ap_14, audit03_aspek_spamjp_ma_14, audit03_aspek_spamjp_sb_14, audit03_aspek_spamjp_ah_14, audit03_aspek_temuan_14, audit03_aspek_comment_14, audit03_aspek_spamjp_ap_4f, audit03_aspek_spamjp_ma_4f, audit03_aspek_spamjp_sb_4f, audit03_aspek_spamjp_ah_4f, audit03_aspek_comment_4f, audit03_aspek_spamjp_ap_15, audit03_aspek_spamjp_ma_15, audit03_aspek_spamjp_sb_15, audit03_aspek_spamjp_ah_15, audit03_aspek_temuan_15, audit03_aspek_comment_15, audit03_aspek_spamjp_ap_4e, audit03_aspek_spamjp_ma_4e, audit03_aspek_spamjp_sb_4e, audit03_aspek_spamjp_ah_4e, audit03_aspek_comment_4e, audit03_aspek_spamjp_ap_16, audit03_aspek_spamjp_ma_16, audit03_aspek_spamjp_sb_16, audit03_aspek_spamjp_ah_16, audit03_aspek_temuan_16, audit03_aspek_comment_16, audit03_aspek_spamjp_ap_17, audit03_aspek_spamjp_ma_17, audit03_aspek_spamjp_sb_17, audit03_aspek_spamjp_ah_17, audit03_aspek_temuan_17, audit03_aspek_comment_17, audit03_aspek_spamjp_ap_18, audit03_aspek_spamjp_ma_18, audit03_aspek_spamjp_sb_18, audit03_aspek_spamjp_ah_18, audit03_aspek_temuan_18, audit03_aspek_comment_18, audit03_aspek_spamjp_ap_19, audit03_aspek_spamjp_ma_19, audit03_aspek_spamjp_sb_19, audit03_aspek_spamjp_ah_19, audit03_aspek_temuan_19, audit03_aspek_comment_19, audit03_aspek_spamjp_ap_20, audit03_aspek_spamjp_ma_20, audit03_aspek_spamjp_sb_20, audit03_aspek_spamjp_ah_20, audit03_aspek_temuan_20, audit03_aspek_comment_20, audit03_aspek_spamjp_ap_4g, audit03_aspek_spamjp_ma_4g, audit03_aspek_spamjp_sb_4g, audit03_aspek_spamjp_ah_4g, audit03_aspek_comment_4g, audit03_aspek_spamjp_ap_21, audit03_aspek_spamjp_ma_21, audit03_aspek_spamjp_sb_21, audit03_aspek_spamjp_ah_21, audit03_aspek_temuan_21, audit03_aspek_comment_21, audit03_aspek_spamjp_ap_22, audit03_aspek_spamjp_ma_22, audit03_aspek_spamjp_sb_22, audit03_aspek_spamjp_ah_22, audit03_aspek_temuan_22, audit03_aspek_comment_22, audit03_aspek_spamjp_ap_23, audit03_aspek_spamjp_ma_23, audit03_aspek_spamjp_sb_23, audit03_aspek_spamjp_ah_23, audit03_aspek_temuan_23, audit03_aspek_comment_23, audit03_aspek_spamjp_ap_24, audit03_aspek_spamjp_ma_24, audit03_aspek_spamjp_sb_24, audit03_aspek_spamjp_ah_24, audit03_aspek_temuan_24, audit03_aspek_comment_24, audit03_aspek_spamjp_ap_25, audit03_aspek_spamjp_ma_25, audit03_aspek_spamjp_sb_25, audit03_aspek_spamjp_ah_25, audit03_aspek_temuan_25, audit03_aspek_comment_25, audit03_aspek_spamjp_ap_26, audit03_aspek_spamjp_ma_26, audit03_aspek_spamjp_sb_26, audit03_aspek_spamjp_ah_26, audit03_aspek_temuan_26, audit03_aspek_comment_26, audit03_aspek_spamjp_ap_27, audit03_aspek_spamjp_ma_27, audit03_aspek_spamjp_sb_27, audit03_aspek_spamjp_ah_27, audit03_aspek_temuan_27, audit03_aspek_comment_27, audit03_aspek_spamjp_ap_28, audit03_aspek_spamjp_ma_28, audit03_aspek_spamjp_sb_28, audit03_aspek_spamjp_ah_28, audit03_aspek_temuan_28, audit03_aspek_comment_28, audit03_aspek_spamjp_ap_29, audit03_aspek_spamjp_ma_29, audit03_aspek_spamjp_sb_29, audit03_aspek_spamjp_ah_29, audit03_aspek_temuan_29, audit03_aspek_comment_29, audit03_aspek_spamjp_ap_30, audit03_aspek_spamjp_ma_30, audit03_aspek_spamjp_sb_30, audit03_aspek_spamjp_ah_30, audit03_aspek_temuan_30, audit03_aspek_comment_30, audit03_aspek_spamjp_ap_31, audit03_aspek_spamjp_ma_31, audit03_aspek_spamjp_sb_31, audit03_aspek_spamjp_ah_31, audit03_aspek_temuan_31, audit03_aspek_comment_31, audit03_aspek_spamjp_ap_32, audit03_aspek_spamjp_ma_32, audit03_aspek_spamjp_sb_32, audit03_aspek_spamjp_ah_32, audit03_aspek_temuan_32, audit03_aspek_comment_32, audit03_aspek_spamjp_ap_33, audit03_aspek_spamjp_ma_33, audit03_aspek_spamjp_sb_33, audit03_aspek_spamjp_ah_33, audit03_aspek_temuan_33, audit03_aspek_comment_33, audit03_aspek_spamjp_ap_34, audit03_aspek_spamjp_ma_34, audit03_aspek_spamjp_sb_34, audit03_aspek_spamjp_ah_34, audit03_aspek_temuan_34, audit03_aspek_comment_34, audit03_aspek_spamjp_ap_35, audit03_aspek_spamjp_ma_35, audit03_aspek_spamjp_sb_35, audit03_aspek_spamjp_ah_35, audit03_aspek_temuan_35, audit03_aspek_comment_35, audit03_aspek_spamjp_ap_36, audit03_aspek_spamjp_ma_36, audit03_aspek_spamjp_sb_36, audit03_aspek_spamjp_ah_36, audit03_aspek_temuan_36, audit03_aspek_comment_36, audit03_aspek_spamjp_ap_6a, audit03_aspek_spamjp_ma_6a, audit03_aspek_spamjp_sb_6a, audit03_aspek_spamjp_ah_6a, audit03_aspek_comment_6a, audit03_aspek_spamjp_ap_37, audit03_aspek_spamjp_ma_37, audit03_aspek_spamjp_sb_37, audit03_aspek_spamjp_ah_37, audit03_aspek_temuan_37, audit03_aspek_comment_37, audit03_aspek_spamjp_ap_38, audit03_aspek_spamjp_ma_38, audit03_aspek_spamjp_sb_38, audit03_aspek_spamjp_ah_38, audit03_aspek_temuan_38, audit03_aspek_comment_38, audit03_aspek_spamjp_ap_39, audit03_aspek_spamjp_ma_39, audit03_aspek_spamjp_sb_39, audit03_aspek_spamjp_ah_39, audit03_aspek_temuan_39, audit03_aspek_comment_39, audit03_aspek_spamjp_ap_40, audit03_aspek_spamjp_ma_40, audit03_aspek_spamjp_sb_40, audit03_aspek_spamjp_ah_40, audit03_aspek_temuan_40, audit03_aspek_comment_40, audit03_aspek_spamjp_ap_41, audit03_aspek_spamjp_ma_41, audit03_aspek_spamjp_sb_41, audit03_aspek_spamjp_ah_41, audit03_aspek_temuan_41, audit03_aspek_comment_41, audit03_cadangan_spamjp_ap_42, audit03_cadangan_spamjp_ma_42, audit03_cadangan_spamjp_sb_42, audit03_cadangan_spamjp_ah_42, audit03_cadangan_temuan_42, audit03_cadangan_comment_42, audit03_cadangan_spamjp_ap_43, audit03_cadangan_spamjp_ma_43, audit03_cadangan_spamjp_sb_43, audit03_cadangan_spamjp_ah_43, audit03_cadangan_temuan_43, audit03_cadangan_comment_43, audit03_lab_spamjp_ap_44, audit03_lab_spamjp_ma_44, audit03_lab_spamjp_sb_44, audit03_lab_spamjp_ah_44, audit03_lab_temuan_44, audit03_lab_comment_44, audit03_lab_spamjp_ap_45, audit03_lab_spamjp_ma_45, audit03_lab_spamjp_sb_45, audit03_lab_spamjp_ah_45, audit03_lab_temuan_45, audit03_lab_comment_45, audit03_lab_spamjp_ap_46, audit03_lab_spamjp_ma_46, audit03_lab_spamjp_sb_46, audit03_lab_spamjp_ah_46, audit03_lab_temuan_46, audit03_lab_comment_46, audit03_lab_spamjp_ap_47, audit03_lab_spamjp_ma_47, audit03_lab_spamjp_sb_47, audit03_lab_spamjp_ah_47, audit03_lab_temuan_47, audit03_lab_comment_47, audit03_lab_spamjp_ap_48, audit03_lab_spamjp_ma_48, audit03_lab_spamjp_sb_48, audit03_lab_spamjp_ah_48, audit03_lab_temuan_48, audit03_lab_comment_48, created_at, updated_at, audit03_aspek_spamjp_ap_1_, audit03_aspek_spamjp_ma_1_, audit03_aspek_spamjp_sb_1_, audit03_aspek_spamjp_ah_1_, audit03_aspek_comment_1_, audit03_aspek_spamjp_ap_2_, audit03_aspek_spamjp_ma_2_, audit03_aspek_spamjp_sb_2_, audit03_aspek_spamjp_ah_2_, audit03_aspek_comment_2_, audit03_aspek_spamjp_ap_3_, audit03_aspek_spamjp_ma_3_, audit03_aspek_spamjp_sb_3_, audit03_aspek_spamjp_ah_3_, audit03_aspek_comment_3_, audit03_aspek_spamjp_ap_4_, audit03_aspek_spamjp_ma_4_, audit03_aspek_spamjp_sb_4_, audit03_aspek_spamjp_ah_4_, audit03_aspek_comment_4_, audit03_aspek_spamjp_ap_5_, audit03_aspek_spamjp_ma_5_, audit03_aspek_spamjp_sb_5_, audit03_aspek_spamjp_ah_5_, audit03_aspek_comment_5_, audit03_aspek_spamjp_ap_6_, audit03_aspek_spamjp_ma_6_, audit03_aspek_spamjp_sb_6_, audit03_aspek_spamjp_ah_6_, audit03_aspek_comment_6_) FROM stdin;
1	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-03-20 22:33:26	2024-03-20 22:33:26	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
2	2	a	\N	\N	a	1	\N	a	na	na	na	2	\N	\N	\N	a	\N	0	\N	\N	\N	na	\N	1	\N	\N	\N	\N	\N	2	\N	\N	\N	\N	\N	\N	\N	\N	na	\N	\N	2	\N	\N	a	\N	\N	2	\N	a	a	\N	\N	0	\N	\N	a	\N	\N	2	\N	\N	\N	\N	\N	\N	\N	\N	na	na	\N	0	\N	\N	a	na	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	0	\N	a	\N	\N	\N	\N	\N	\N	na	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1	\N	\N	\N	\N	\N	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	1	\N	a	a	a	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2	\N	\N	\N	\N	\N	2	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2	\N	\N	\N	\N	\N	2	\N	a	\N	\N	\N	1	\N	\N	\N	\N	\N	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	a	\N	\N	\N	\N	\N	a	na	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	a	\N	\N	\N	\N	\N	a	\N	\N	\N	\N	\N	2024-03-21 04:00:49	2024-03-21 04:24:47	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	a	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
3	3	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-05-27 03:14:17	2024-05-27 03:14:17	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4	4	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-06-03 06:57:41	2024-06-03 06:57:41	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
5	5	a	\N	\N	\N	0	\N	a	\N	\N	\N	1	ada beberapa lokasi yang sulit diakses	a	\N	\N	\N	1	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	1	belum memperhatikan faktor kejadian bencana	a	\N	\N	\N	\N	a	\N	\N	\N	1	terdapat sampah	a	\N	\N	\N	bar screen h: 2m, fine screen	na	\N	\N	\N	tidak menggunakan pompa	na	\N	\N	\N	\N	\N	a	\N	\N	\N	\N	a	\N	\N	\N	\N	a	\N	\N	\N	0	\N	na	\N	\N	\N	\N	saluran transmisi tertutup	na	\N	\N	\N	tidak ada BPT	na	\N	\N	\N	\N	\N	a	\N	\N	\N	\N	na	\N	\N	\N	Tidak terdapat unit Grit Chamber	na	\N	\N	\N	\N	\N	na	\N	\N	\N	\N	na	\N	\N	\N	\N	\N	a	\N	\N	\N	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	1	pembubuhan klor masih dilakukan intermiten	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	1	\N	na	\N	\N	\N	\N	\N	a	\N	\N	\N	1	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	a	\N	\N	\N	0	\N	2024-06-04 02:35:33	2024-06-04 03:01:40	a	\N	\N	\N	\N	a	\N	\N	\N	\N	a	\N	\N	\N	sistem tertutup	a	\N	\N	\N	\N	a	\N	\N	\N	\N	a	\N	\N	\N	\N
6	6	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	2024-06-04 03:46:27	2024-06-04 03:46:27	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
\.


--
-- Data for Name: audits; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.audits (id, audit_date, institution_name, institution_address, auditor_name, auditor_organization, certificate_organization, spamjp, created_at, updated_at, organization_id) FROM stdin;
1	2024-03-20	test coba	pdam	xyz	abc	wakwaw	air permukaan	2024-03-20 22:33:26	2024-03-20 22:33:26	\N
2	2024-03-21	Air minum Okeh	jalan aja terus	ujang godeg	Audit udin	LSP Audit	air permukaan	2024-03-21 04:00:49	2024-03-21 04:26:47	\N
3	2024-05-28	PDAM YYY	Jalan Sejahtera	Yuza	Mutu Sertifikasi	Kemenkes	air permukaan	2024-05-27 03:14:17	2024-05-27 03:14:17	\N
4	2024-06-12	PDAM Kota Brmnhm	Jl. Hayam Wuruk 11, Brmnhm	Yuza	Merpati Mutu Sertifikasi	BNSP	air permukaan	2024-06-03 06:57:41	2024-06-03 06:57:41	\N
5	2024-06-06	PDAM Kabupaten Selangor	Jl. Kucing Hitam 99, Selangor	Yuza	Air Terjaga	BNSP	air permukaan	2024-06-04 02:35:33	2024-06-04 02:35:45	18
6	2024-06-04	PDAM Tirta Makmur	Jalan Polaroid	Hendra Handy	Professional	BNSP	mata air	2024-06-04 03:46:27	2024-06-04 03:46:38	20
\.


--
-- Data for Name: course_user; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.course_user (course_id, user_id) FROM stdin;
5	12
5	13
5	15
5	14
5	16
5	17
5	18
5	19
5	20
5	21
5	22
5	38
\.


--
-- Data for Name: courses; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.courses (id, title, description, picture, created_at, updated_at, start_date_time, is_master, instructor_id) FROM stdin;
1	Test	<p>lorem ipsum dolor sit amet</p>	public/54BzExBDHvFuMnf5hXm4ClZlRnUA0rFSMauIEIAm.pdf	2024-02-21 03:46:23	2024-02-21 03:46:23	2024-02-21 10:45:00	t	\N
2	Test 2	<p>asdas asf a asf aafffag kajsf ppoawrljasm poiq</p>	public/PajHqsUToTIKm9N7Dqja4C16mT0jsJy0bgbBOhjH.jpg	2024-02-21 03:47:25	2024-02-21 03:47:25	2024-02-21 10:46:00	t	\N
3	Test 3	<p>hello world</p>	public/0wN0j7h9feFYDaA6ng4u2rYmDOeMGhUht5lF9REl.jpg	2024-02-21 03:48:18	2024-02-21 03:48:18	2024-02-21 10:47:00	t	\N
4	Pelatihan Audit RPAM	<p>Pelatihan Audit RPAM ini berlangsung secara hybrid selama 7 hari, yakni : hari kamis - jumat (15-16 Februari 2024) &amp; hari Senin - jumat (19-23 Februari 2024).</p><p><br></p><p>Tujuan dari kegiatan ini adalah sebagai berikut :</p><ol><li>Memberikan peningkatan kapasitas bagi penyelenggara SPAM dan pemangku kepentingan terkait dalam audit RPAM</li><li>Menghasilkan auditor RPAM.</li></ol>	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	2024-02-21 12:12:00	t	\N
5	Pelatihan Audit RPAM	<p><br></p>	public/XQgvc8Ut99wk8xTBpuJkchOxlqWoVEp5doewWCvN.jpg	2024-02-21 06:18:26	2024-07-24 02:30:30	2024-02-21 13:18:00	f	\N
\.


--
-- Data for Name: failed_jobs; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.failed_jobs (id, uuid, connection, queue, payload, exception, failed_at) FROM stdin;
\.


--
-- Data for Name: menus; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.menus (id, user_id, menu_name, created_at, updated_at) FROM stdin;
1	1	pelatihan	2024-02-21 03:45:27	2024-02-21 03:45:27
2	1	master_pelatihan	2024-02-21 03:45:27	2024-02-21 03:45:27
3	1	modul_pelatihan	2024-02-21 03:45:27	2024-02-21 03:45:27
4	1	pengguna	2024-02-21 03:45:27	2024-02-21 03:45:27
5	1	organisasi	2024-02-21 03:45:27	2024-02-21 03:45:27
6	1	quiz	2024-02-21 03:45:27	2024-02-21 03:45:27
7	2	pelatihan	2024-02-21 04:33:39	2024-02-21 04:33:39
8	2	quiz	2024-02-21 04:33:39	2024-02-21 04:33:39
9	3	pelatihan	2024-02-21 04:34:50	2024-02-21 04:34:50
10	3	quiz	2024-02-21 04:34:50	2024-02-21 04:34:50
11	4	pelatihan	2024-02-21 04:35:56	2024-02-21 04:35:56
12	4	quiz	2024-02-21 04:35:56	2024-02-21 04:35:56
13	5	pelatihan	2024-02-21 04:38:08	2024-02-21 04:38:08
14	5	quiz	2024-02-21 04:38:08	2024-02-21 04:38:08
15	6	pelatihan	2024-02-21 04:39:31	2024-02-21 04:39:31
16	6	quiz	2024-02-21 04:39:31	2024-02-21 04:39:31
21	9	pelatihan	2024-02-21 04:44:14	2024-02-21 04:44:14
22	9	quiz	2024-02-21 04:44:14	2024-02-21 04:44:14
23	8	pelatihan	2024-02-21 04:44:31	2024-02-21 04:44:31
24	8	quiz	2024-02-21 04:44:31	2024-02-21 04:44:31
25	10	pelatihan	2024-02-21 04:45:45	2024-02-21 04:45:45
26	10	quiz	2024-02-21 04:45:45	2024-02-21 04:45:45
27	11	pelatihan	2024-02-21 04:46:40	2024-02-21 04:46:40
28	11	quiz	2024-02-21 04:46:40	2024-02-21 04:46:40
29	12	pelatihan	2024-02-21 04:47:36	2024-02-21 04:47:36
30	12	quiz	2024-02-21 04:47:36	2024-02-21 04:47:36
31	13	pelatihan	2024-02-21 04:48:24	2024-02-21 04:48:24
32	13	quiz	2024-02-21 04:48:24	2024-02-21 04:48:24
37	14	pelatihan	2024-02-21 04:51:18	2024-02-21 04:51:18
38	14	quiz	2024-02-21 04:51:18	2024-02-21 04:51:18
39	15	pelatihan	2024-02-21 04:51:38	2024-02-21 04:51:38
40	15	quiz	2024-02-21 04:51:38	2024-02-21 04:51:38
41	16	pelatihan	2024-02-21 04:52:36	2024-02-21 04:52:36
42	16	quiz	2024-02-21 04:52:36	2024-02-21 04:52:36
43	17	pelatihan	2024-02-21 04:53:29	2024-02-21 04:53:29
44	17	quiz	2024-02-21 04:53:29	2024-02-21 04:53:29
45	18	pelatihan	2024-02-21 04:54:15	2024-02-21 04:54:15
46	18	quiz	2024-02-21 04:54:15	2024-02-21 04:54:15
47	19	pelatihan	2024-02-21 04:55:06	2024-02-21 04:55:06
48	19	quiz	2024-02-21 04:55:06	2024-02-21 04:55:06
49	20	pelatihan	2024-02-21 04:55:44	2024-02-21 04:55:44
50	20	quiz	2024-02-21 04:55:44	2024-02-21 04:55:44
51	21	pelatihan	2024-02-21 04:56:29	2024-02-21 04:56:29
52	21	quiz	2024-02-21 04:56:29	2024-02-21 04:56:29
53	22	pelatihan	2024-02-21 04:57:26	2024-02-21 04:57:26
54	22	quiz	2024-02-21 04:57:26	2024-02-21 04:57:26
55	23	pelatihan	2024-02-21 04:58:12	2024-02-21 04:58:12
56	23	quiz	2024-02-21 04:58:12	2024-02-21 04:58:12
57	24	pelatihan	2024-02-21 04:59:25	2024-02-21 04:59:25
58	24	quiz	2024-02-21 04:59:25	2024-02-21 04:59:25
59	25	pelatihan	2024-02-21 05:00:13	2024-02-21 05:00:13
60	25	quiz	2024-02-21 05:00:13	2024-02-21 05:00:13
61	26	pelatihan	2024-02-21 05:00:56	2024-02-21 05:00:56
62	26	quiz	2024-02-21 05:00:56	2024-02-21 05:00:56
63	27	pelatihan	2024-02-21 05:01:42	2024-02-21 05:01:42
64	27	quiz	2024-02-21 05:01:42	2024-02-21 05:01:42
65	28	pelatihan	2024-02-21 05:02:33	2024-02-21 05:02:33
66	28	quiz	2024-02-21 05:02:33	2024-02-21 05:02:33
67	29	pelatihan	2024-02-21 05:03:37	2024-02-21 05:03:37
68	29	quiz	2024-02-21 05:03:37	2024-02-21 05:03:37
69	30	pelatihan	2024-02-21 05:04:25	2024-02-21 05:04:25
70	30	quiz	2024-02-21 05:04:25	2024-02-21 05:04:25
71	31	pelatihan	2024-02-21 05:05:07	2024-02-21 05:05:07
72	31	quiz	2024-02-21 05:05:07	2024-02-21 05:05:07
73	32	pelatihan	2024-02-21 05:05:47	2024-02-21 05:05:47
74	32	quiz	2024-02-21 05:05:47	2024-02-21 05:05:47
173	33	pelatihan	2024-07-24 02:24:31	2024-07-24 02:24:31
174	33	master_pelatihan	2024-07-24 02:24:31	2024-07-24 02:24:31
175	33	modul_pelatihan	2024-07-24 02:24:31	2024-07-24 02:24:31
176	33	pengguna	2024-07-24 02:24:31	2024-07-24 02:24:31
177	33	organisasi	2024-07-24 02:24:31	2024-07-24 02:24:31
178	33	quiz	2024-07-24 02:24:31	2024-07-24 02:24:31
179	38	pelatihan	2024-07-24 02:25:40	2024-07-24 02:25:40
109	34	pelatihan	2024-04-17 06:57:29	2024-04-17 06:57:29
110	34	master_pelatihan	2024-04-17 06:57:29	2024-04-17 06:57:29
111	34	modul_pelatihan	2024-04-17 06:57:29	2024-04-17 06:57:29
112	34	pengguna	2024-04-17 06:57:29	2024-04-17 06:57:29
113	34	organisasi	2024-04-17 06:57:29	2024-04-17 06:57:29
114	34	quiz	2024-04-17 06:57:29	2024-04-17 06:57:29
120	35	pelatihan	2024-04-17 06:59:47	2024-04-17 06:59:47
121	35	master_pelatihan	2024-04-17 06:59:47	2024-04-17 06:59:47
122	35	modul_pelatihan	2024-04-17 06:59:47	2024-04-17 06:59:47
123	35	pengguna	2024-04-17 06:59:47	2024-04-17 06:59:47
124	35	organisasi	2024-04-17 06:59:47	2024-04-17 06:59:47
125	35	quiz	2024-04-17 06:59:47	2024-04-17 06:59:47
126	7	pelatihan	2024-04-17 07:00:55	2024-04-17 07:00:55
127	7	quiz	2024-04-17 07:00:55	2024-04-17 07:00:55
139	36	pengguna	2024-05-27 03:12:48	2024-05-27 03:12:48
140	37	pelatihan	2024-06-04 03:39:20	2024-06-04 03:39:20
141	37	modul_pelatihan	2024-06-04 03:39:20	2024-06-04 03:39:20
142	37	pengguna	2024-06-04 03:39:20	2024-06-04 03:39:20
\.


--
-- Data for Name: migrations; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.migrations (id, migration, batch) FROM stdin;
1	2014_10_12_000000_create_users_table	1
2	2014_10_12_100000_create_password_resets_table	1
3	2019_08_19_000000_create_failed_jobs_table	1
4	2019_12_14_000001_create_personal_access_tokens_table	1
5	2023_01_12_032216_create_organizations_table	1
6	2023_01_12_043212_add_organization_id_to_users	1
7	2023_01_30_074231_create_courses_table	1
8	2023_01_30_074956_create_course_user_table	1
9	2023_02_01_064126_create_sessions_table	1
10	2023_04_01_013513_create_assets_table	1
11	2023_04_01_053949_create_discussions_table	1
12	2023_04_01_095738_create_session_files_table	1
13	2023_04_03_122356_add_is_master_to_courses	1
14	2023_04_08_132824_add_instructor_to_courses	1
15	2023_07_28_075837_add_sort_to_sessions	1
16	2023_07_28_115620_add_role_to_users	1
17	2023_07_28_232925_add_live_to_sessions	1
18	2023_07_29_115753_create_quizzes_table	1
19	2023_07_29_115935_create_questions_table	1
20	2023_08_18_122639_create_menus_table	1
21	2023_09_10_043736_add_is_pdam_to_organizations	1
22	2023_09_10_090054_add_city_to_organizations	1
23	2023_09_17_142416_create_rpams_table	1
24	2023_10_08_211835_create_module1_0s_table	1
25	2023_10_09_091351_create_module1_1s_table	1
26	2023_10_09_092252_add_organization_id_to_rpams	1
27	2023_10_10_114130_create_module1_2s_table	1
28	2023_10_10_152022_create_module1_3s_table	1
29	2023_10_11_115842_create_module2_1s_table	1
30	2023_10_11_121323_create_module2_1_sabs_table	1
31	2023_10_11_122301_create_module2_1_ipams_table	1
32	2023_10_14_011855_create_module2_2s_table	1
33	2023_10_16_142910_create_module2_3s_table	1
34	2023_10_16_152907_create_module2_5s_table	1
35	2023_10_16_154212_create_module2_6s_table	1
36	2023_10_16_155420_create_module3_4s_table	1
37	2023_10_16_161739_create_module4_1s_table	1
38	2023_10_16_164643_create_module5_1s_table	1
39	2023_10_16_170328_create_module6_1s_table	1
40	2023_10_17_112033_create_module7_1s_table	1
41	2023_10_17_113325_create_module7_2s_table	1
42	2023_10_17_120314_create_module7_3s_table	1
43	2023_10_17_121451_create_module8_1s_table	1
44	2023_10_19_125431_create_module9_1s_table	1
45	2023_10_19_130225_create_module9_2s_table	1
46	2023_10_19_130636_create_module9_3s_table	1
47	2023_10_19_135903_create_module10_1s_table	1
48	2023_10_19_135908_create_module10_2s_table	1
49	2023_10_19_135914_create_module10_3s_table	1
50	2023_10_31_112500_add_ttd_image_to_m1_0	1
51	2023_10_31_121412_add_ttd_image_to_m1_1	1
52	2023_10_31_132119_add_attachment_to_m4_1	1
53	2023_10_31_134746_add_attachment_to_m8_1	1
54	2024_03_02_105720_drop_wsp_tables	2
55	2024_03_02_105733_create_audits_table	2
56	2024_03_02_110626_create_audit01s_table	2
57	2024_03_14_145754_create_audit02s_table	2
58	2024_03_19_132001_create_audit03s_table	2
59	2024_03_19_152936_add_columns_to_audit03	2
60	2024_05_26_220905_create_reports_table	3
61	2024_06_03_013031_add_fields_to_report	3
62	2024_06_03_103643_add_organization_id_to_audits	4
63	2024_06_04_062526_add_fields_second_time_fuck_off_tai_to_report	5
\.


--
-- Data for Name: organizations; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.organizations (id, name, created_at, updated_at, is_pdam, city, address) FROM stdin;
1	PERUMDA Air Minum Kota Palangkaraya	2024-02-21 04:03:44	2024-02-21 04:11:32	t	Provinsi Kalimantan Tengah|Kota Palangka Raya	Jl. Ahmad Yani No. 7, Langkai, Kec. Pahandut,  Kota Palangka Raya, Kalimantan Tengah 74874
2	PERUMDA Air Minum Tirta Sembada Kabupaten Sleman	2024-02-21 04:04:38	2024-02-21 04:12:03	t	Provinsi D.I Yogyakarta|Kabupaten Sleman	Jl. Parasamya No.18, Beran Lor, Tridadi, Kec. Sleman, Kabupaten Sleman, Daerah Istimewa Yogyakarta 55511
3	PERUMDA Air Minum Lawu Tirta  Kabupaten Magetan	2024-02-21 04:13:29	2024-02-21 04:13:51	t	Provinsi Jawa Timur|Kabupaten Magetan	Jl. Tripandita No. 5 Magetan, Kab. Magetan, Jawa Timur
4	PERUMDA Air Minum Tirta Aji Kabupaten Wonosobo	2024-02-21 04:14:08	2024-02-21 04:14:36	t	Provinsi Jawa Tengah|Kabupaten Wonosobo	JL. Tirta Aji, No. 02, 56311, Wonosobo Timur, Wonosobo Tim., Kec. Wonosobo, Kabupaten Wonosobo, Jawa Tengah
5	PERUMDA Air Minum Tirta Sanjiwani Kabupaten Gianyar	2024-02-21 04:15:08	2024-02-21 04:15:24	t	Provinsi Bali|Kabupaten Gianyar	Jl. Astina Timur, Samplangan, Kec. Gianyar, Kabupaten Gianyar, Bali 80512.
6	PERUMDA Air Minum Tirta Bumi Sentosa Kabupaten Kebumen	2024-02-21 04:15:43	2024-02-21 04:16:02	t	Provinsi Jawa Tengah|Kabupaten Kebumen	Jl. Aroengbinang No.12, Kawedusan, Kecamatan Kebumen, Kabupaten Kebumen, Jawa Tengah 54317
7	PERUMDA Air Minum Tirta Medal Kabupaten Sumedang	2024-02-21 04:16:15	2024-02-21 04:16:35	t	Provinsi Jawa Barat|Kabupaten Sumedang	Jl. Raya Sumedang-Cirebon KM 4,5 Desa Serang-Cimalaka, Kabupaten Sumedang, Jawa Barat
8	PERUMDA Air Minum Tirta Musi Kota Palembang	2024-02-21 04:16:49	2024-02-21 04:17:27	t	Provinsi Sumatera Selatan|Kota Palembang	Jl. Rambutan Ujung No.1, 30 Ilir, Kec. Ilir Barat II, Kota Palembang, Sumatera Selatan 30129
9	PERUMDA Air Minum Tirta Raharja - Kab.Bandung	2024-02-21 04:17:45	2024-02-21 04:18:12	t	Provinsi Jawa Barat|Kota Cimahi	Jl. Kolonel Masturi No.272, Cipageran, Kec. Cimahi Utara, Kota Cimahi, Jawa Barat 40511
10	PERUMDA Air Minum Tirta Langkisau Kab.Pesisir Selatan	2024-02-21 04:17:54	2024-02-21 04:20:40	t	Provinsi Sumatera Barat|Kabupaten Pesisir Selatan	Jl. Perintis Kemerdekaan-Painan Timur
11	Direktorat Penyehatan Lingkungan, Kementerian Kesehatan	2024-02-21 04:29:13	2024-02-21 04:29:13	t	\N	\N
12	LSP KLI	2024-02-21 04:29:31	2024-02-21 04:29:31	t	\N	\N
13	Profesional	2024-02-21 04:29:47	2024-02-21 04:29:47	t	\N	\N
14	Direktorat Perumahan dan Kawasan  Pemukiman Bappenas	2024-02-21 04:29:59	2024-02-21 04:29:59	t	\N	\N
15	Direktorat Air Minum Kementerian PUPR	2024-02-21 04:30:10	2024-02-21 04:30:10	t	\N	\N
16	Balai Prasarana Permukiman Wilayah D.I. Yogyakarta	2024-02-21 04:30:21	2024-02-21 04:30:21	t	\N	\N
17	Perumda Air Minum Tirta Satria Kabupaten Banyumas	2024-02-21 04:30:36	2024-02-21 04:30:36	t	\N	\N
18	KIAT/LPPM Itenas	2024-02-21 04:31:00	2024-02-21 04:31:00	t	\N	\N
19	WHO Indonesia	2024-02-21 04:31:09	2024-02-21 05:06:11	f	Provinsi |undefined	\N
20	Peserta	2024-06-04 03:38:35	2024-06-04 03:38:35	t	\N	\N
21	Development	2024-07-24 02:23:23	2024-07-24 02:23:23	f	\N	\N
\.


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

COPY public.questions (id, quiz_id, question, answer_a, answer_b, answer_c, answer_d, answer_e, correct_answer, nilai) FROM stdin;
\.


--
-- Data for Name: quizzes; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.quizzes (id, name, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: reports; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.reports (id, audit_id, pelaksana, kontak, tgl_penerbitan, jenis_sertifikasi, status_sertifikasi, spam, koreksi, analisis, created_at, updated_at, tindakan_perbaikan, kontak_utama_paraf, kontak_utama_paraf_tgl, auditee_paraf, auditee_paraf_tgl, lampiran_koreksi, lampiran_perbaikan, user_id, koreksi02, koreksi03, analisis02, analisis03, tindakan_perbaikan02, tindakan_perbaikan03, lampiran_koreksi02, lampiran_koreksi03, lampiran_perbaikan02, lampiran_perbaikan03) FROM stdin;
1	1	\N	Fatur Kodi	2024-06-03	SPAM Air Minum	awal	SPAM 1	Tidak ada koreksi	Sesuai semua, ok good job	2024-06-03 05:03:25	2024-06-03 05:03:25	tidak ada perbaikan	public/FHeU4CiN0gLIwVDrBXEDsM5k8j4vA9kmdV49WXjD.png	2024-06-03	public/71KET7BDA1zkX86N6mOjoqTSMnj7jecvA1MKwPoY.png	2024-06-01	public/zVCGP4Rkjs8Y9ix7jZJamTkaQKd0cRV3DiSjFZOK.jpg	public/sNm78QBbpUl64QiP2MS9m5NdCKa9dqjjJzJIQv5p.jpg	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
3	4	\N	Andri, Direktur Utama, 02687237356, andri@gmail.com	2024-06-06	Air Minum Aman	awal	Cimekar	- Kelengkapan tabel rencana perbaikan	tidak sesuai antara juknis dan pedoman	2024-06-03 07:30:34	2024-06-03 07:30:34	- ditambahkan di halaman 45	public/CA130zDDUEqBu0jwzQKCzHq1g4BkKt4cnNsRvt2e.jpg	2024-06-14	public/1ptxx83k02mf8UGfJ31rejXUmy7HOZ6tGttN4TU0.jpg	2024-06-22	public/fURS2CGnAPXw800HtuDquM4sjc3yOHs1JesTQXl3.jpg	public/A2vCAFKLsRZ0EaYde1KvqU5nJPnp3dIbupXo9TeQ.pdf	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
6	6	\N	aan	2024-06-15	adda	awal	daadda	addaad	zzz	2024-06-04 06:30:29	2024-06-04 06:30:29	xxxx	\N	2024-06-12	\N	2024-06-12	\N	\N	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
7	6	\N	dadaad	2024-06-12	zxzx	awal	daadda	wewe	ewwe	2024-06-04 06:30:47	2024-06-04 06:30:47	xxxx	\N	2024-06-12	\N	2024-06-12	\N	\N	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
5	2	\N	Pak UTE	2024-06-04	Sertifikasi	resertifikasi	SPAM bandung	perbaikan saluran	Data kurang lengkap	2024-06-04 03:25:09	2024-06-04 08:18:00	dilengkapi data yang kurang	public/xE4Q3kp1nvgWnqkzGHN6NG3Ia2zTVynmP0lHdWJP.png	2024-06-04	public/wXX6BglYVzfzyYqfolLOtMMLBgRJW8Yw7eeNBI9U.png	2024-06-04	\N	public/MHk1PqAJ7zz0DIoCrGc5VliBhNMDwl0wrL1LjdxA.gif	1	ABC	JKL	DEF	MNO	GHI	PQRSTU	\N	\N	public/rkVBTxEEWzJXcTkLE0ko0x1RUv8J58MgY2seVeEs.jpg	public/KkO7dAEuEDYNNLylMgt7x6cj9VQTYq4C2Iyj4zvD.png
2	4	\N	Andri, Direktur Utama, 08217812621, andri@gmail.com	2024-06-06	Sertifikat Air Minum Aman	awal	SPAM Cimekar	- penyesuaian penulisan M1-M6\n- menambahkan identifikasi kendala pembiayaan	Juknis RPAM dan pedoman Audit tidak sesuai	2024-06-03 07:26:43	2024-06-04 08:20:22	\N	public/5S6j3bmnKA1My6D77BDE8kSH9q2623nRabdbrBvD.jpg	2024-06-14	public/UbYN3CMsGGgB00yjC6m9q8Vlmtvq1N9qq02hsjxT.jpg	2024-06-22	public/ZnwM6Y8kDMhas4bfWzZpsnBZNVtZg9Xh7lLqQfuP.pdf	public/tpvla7cmfFXCF1PzQ0hJRCfQqBpLaflHejucDdNb.pdf	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4	5	\N	Jaja	2024-06-08	Sertifikat Air Minum Aman	awal	SPAM Cisela	Klorinasi masih digunakan intermiten	Terdapat perbedaan antara Juknis RPAM dan Pedoman Audit	2024-06-04 03:05:10	2024-06-05 04:30:42	\N	public/RoW920OeBS2ghseofWOBhAqM11ZCngq6QlUfs6hl.jpg	2024-06-13	public/7zkIDeImaAz8KRhoNE3wwb2z8hH3maZHM2pdZH6O.jpg	2024-06-21	public/PxKjOzqOE1vzbHlF7oECC26Oblv47uNYwhku25fd.pdf	public/l7XKT6pBqwX3Bwsqpj4NRx1k7RAcjxDWL6XoHqhA.pdf	36	tabel-tabel modul 3 sudah dilengkapi	tidak ada cadangan air baku	PDAM masih kebingungan dalam menentukan skala dampak	tidak tersedia air baku	Diskusi selanjutnya	perlu dilakukan pengkajian mengenai analisis faktor iklim/ketersediaan air baku jangka panjang	\N	\N	\N	\N
8	2	\N	Yuri	2024-06-05	Sertifikasi Perbaikan	resertifikasi	SPAM Tanpa nama	abc	def	2024-06-05 05:46:53	2024-06-05 05:46:53	ghi	public/DcZxFhb0ACJ1uBedVq1MBSukvOYZcCjcY8RDJK4Q.png	2024-06-05	public/6n9ZMnRV7R6NRL4mJnn4NOzlajLZPE86RkQbrRgE.png	2024-06-05	public/FVXfxszgCtwmAcENehqcUEBkdRHSo5q6IBYo8dvi.png	public/SfXkuI0Ylpuwqj7D2yBmyrFN3bQZ5Krb6OPCXMk0.png	1	jkl	KOR	JKT	PNJ	JPN	IND	public/Q3hJGvfXA63vIu6BbB9Mmt7sDIHhYflCoBgnpnWT.png	\N	public/sByPtbUmLejWQcvpRXx5IrCs3txp6CCjEPn6xqy8.png	\N
\.


--
-- Data for Name: rpam; Type: TABLE DATA; Schema: public; Owner: wsp
--

COPY public.rpam (id, name, created_at, updated_at, organization_id) FROM stdin;
\.


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

COPY public.sessions (id, course_id, title, description, created_at, updated_at, sort, live) FROM stdin;
1	1	Sesi 1	<p>eta we lah</p>	2024-02-21 03:46:23	2024-02-21 03:46:23	0	[]
2	4	Modul 0: Pendahuluan	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	0	[]
3	4	Modul 1: Pembentukan Tim RPAM	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	1	[]
4	4	Modul 2: Gambaran SPAM	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	2	[]
5	4	Modul 3: Identifikasi Bahaya & Kejadian Bahaya, dan Analisis Risiko	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	3	[]
6	4	Modul 4: Tindakan Pengendalian & Kaji Ulang Risiko	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	4	[]
7	4	Modul 5: Rencana Perbaikan	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	5	[]
8	4	Modul 6: Monitoring Operasional	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	6	[]
9	4	Modul 7: Verifikasi	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	7	[]
10	4	Modul 8: Prosedur Manajemen	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	8	[]
11	4	Modul 9: Program Pendukung	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	9	[]
12	4	Modul 10&11: Pengkajian & Revisi	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	10	[]
13	4	MPD 1: Kebijakan tentang RPAM	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	11	[]
14	4	MPI 1: RPAM	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	12	[]
15	4	MPI 2: Latihan Audit Internal dan Eksternal	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	13	[]
16	4	MPI 3: Alur Teknis Audit Eksternal	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	14	[]
17	4	MPI 4: Pemeriksaan Kelengkapan Dokumen RPAM	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	15	[]
18	4	MPI 5: Pemeriksaan Kesesuaian Dokumen RPAM	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	16	[]
19	4	MPI 6: Pemeriksaan Implementasi RPAM	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	17	[]
20	4	Penjelasan Program Pelatihan	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	18	[]
21	4	Building Learning Commitment	\N	2024-02-21 06:17:43	2024-02-21 06:17:43	19	[]
300	5	Modul 0: Pendahuluan	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	0	["AluxCy9nSKA"]
301	5	Modul 1: Pembentukan Tim RPAM	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	1	["AluxCy9nSKA"]
302	5	Modul 2: Gambaran SPAM	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	2	["AluxCy9nSKA"]
303	5	Modul 3: Identifikasi Bahaya & Kejadian Bahaya, dan Analisis Risiko	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	3	["AluxCy9nSKA"]
304	5	Modul 4: Tindakan Pengendalian & Kaji Ulang Risiko	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	4	["AluxCy9nSKA"]
305	5	Modul 5: Rencana Perbaikan	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	5	["L1iw6QBttIk"]
306	5	Modul 6: Monitoring Operasional	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	6	["L1iw6QBttIk"]
307	5	Modul 7: Verifikasi	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	7	["L1iw6QBttIk"]
308	5	Modul 8: Prosedur Manajemen	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	8	["L1iw6QBttIk"]
309	5	Modul 9: Program Pendukung	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	9	["L1iw6QBttIk"]
310	5	Modul 10 & 11: Pengkajian & Revisi	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	10	["L1iw6QBttIk"]
311	5	Penjelasan Program Pelatihan	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	11	["_YWzqB8u238"]
312	5	Building Learning Commitment	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	12	["_YWzqB8u238"]
313	5	MPD 1: Kebijakan tentang RPAM	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	13	["_YWzqB8u238"]
314	5	MPI 1: RPAM	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	14	["_YWzqB8u238"]
315	5	MPI 2: Audit Internal dan Eksternal	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	15	["_YWzqB8u238"]
316	5	MPI 3: Alur Teknis Audit Eksternal	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	16	["l8eHbvKeANQ"]
317	5	MPI 4: Pemeriksaan Kelengkapan Dokumen RPAM	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	17	["l8eHbvKeANQ"]
318	5	MPI 5: Pemeriksaan Kesesuaian Dokumen RPAM	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	18	["l8eHbvKeANQ"]
319	5	MPI 6: Pemeriksaan Implementasi RPAM	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	19	["l8eHbvKeANQ"]
320	5	Kunjungan Lapangan	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	20	["WpebKb934mk","mgEoiYZJVWM"]
321	5	Hari Terakhir Pelatihan (Review & Evaluation)	\N	2024-07-24 02:30:30	2024-07-24 02:30:30	21	["wUA55BC-ZSE"]
\.



--
-- Name: assets assets_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.assets
    ADD CONSTRAINT assets_pkey PRIMARY KEY (id);


--
-- Name: audit01 audit01_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.audit01
    ADD CONSTRAINT audit01_pkey PRIMARY KEY (id);


--
-- Name: audit02 audit02_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.audit02
    ADD CONSTRAINT audit02_pkey PRIMARY KEY (id);


--
-- Name: audit03 audit03_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.audit03
    ADD CONSTRAINT audit03_pkey PRIMARY KEY (id);


--
-- Name: audits audits_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.audits
    ADD CONSTRAINT audits_pkey PRIMARY KEY (id);


--
-- Name: courses courses_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.courses
    ADD CONSTRAINT courses_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- Name: menus menus_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.menus
    ADD CONSTRAINT menus_pkey PRIMARY KEY (id);


--
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT migrations_pkey PRIMARY KEY (id);


--
-- Name: organizations organizations_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.organizations
    ADD CONSTRAINT organizations_pkey PRIMARY KEY (id);


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

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


--
-- Name: quizzes quizzes_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.quizzes
    ADD CONSTRAINT quizzes_pkey PRIMARY KEY (id);


--
-- Name: reports reports_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.reports
    ADD CONSTRAINT reports_pkey PRIMARY KEY (id);


--
-- Name: rpam rpam_pkey; Type: CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.rpam
    ADD CONSTRAINT rpam_pkey PRIMARY KEY (id);


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

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


--
-- Name: audits_organization_id_index; Type: INDEX; Schema: public; Owner: wsp
--

CREATE INDEX audits_organization_id_index ON public.audits USING btree (organization_id);


--
-- Name: assets assets_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.assets
    ADD CONSTRAINT assets_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: audit01 audit01_audit_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.audit01
    ADD CONSTRAINT audit01_audit_id_foreign FOREIGN KEY (audit_id) REFERENCES public.audits(id) ON DELETE CASCADE;


--
-- Name: audit02 audit02_audit_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.audit02
    ADD CONSTRAINT audit02_audit_id_foreign FOREIGN KEY (audit_id) REFERENCES public.audits(id) ON DELETE CASCADE;


--
-- Name: audit03 audit03_audit_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.audit03
    ADD CONSTRAINT audit03_audit_id_foreign FOREIGN KEY (audit_id) REFERENCES public.audits(id) ON DELETE CASCADE;


--
-- Name: course_user course_user_course_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.course_user
    ADD CONSTRAINT course_user_course_id_foreign FOREIGN KEY (course_id) REFERENCES public.courses(id) ON DELETE CASCADE;


--
-- Name: course_user course_user_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.course_user
    ADD CONSTRAINT course_user_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: courses courses_instructor_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.courses
    ADD CONSTRAINT courses_instructor_id_foreign FOREIGN KEY (instructor_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: menus menus_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.menus
    ADD CONSTRAINT menus_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: questions questions_quiz_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.questions
    ADD CONSTRAINT questions_quiz_id_foreign FOREIGN KEY (quiz_id) REFERENCES public.quizzes(id) ON DELETE CASCADE;


--
-- Name: reports reports_audit_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.reports
    ADD CONSTRAINT reports_audit_id_foreign FOREIGN KEY (audit_id) REFERENCES public.audits(id) ON DELETE CASCADE;


--
-- Name: reports reports_user_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.reports
    ADD CONSTRAINT reports_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: rpam rpam_organization_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.rpam
    ADD CONSTRAINT rpam_organization_id_foreign FOREIGN KEY (organization_id) REFERENCES public.organizations(id) ON DELETE CASCADE;


--
-- Name: sessions sessions_course_id_foreign; Type: FK CONSTRAINT; Schema: public; Owner: wsp
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_course_id_foreign FOREIGN KEY (course_id) REFERENCES public.courses(id) ON DELETE CASCADE;


--
--

