--
-- PostgreSQL database dump
--

-- Dumped from database version 11.5
-- Dumped by pg_dump version 11.5

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

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: dokumen; Type: TABLE; Schema: public; Owner: earsip
--

CREATE TABLE public.dokumen (
    dok_id integer DEFAULT nextval('public.dok_id_seq'::regclass) NOT NULL,
    kode_dok character varying(11),
    judul text,
    tahun integer,
    tentang text,
    summary text,
    status character(1),
    jenis character varying,
    nama_file text,
    create_at date,
    update_at date
);


ALTER TABLE public.dokumen OWNER TO earsip;

--
-- Name: COLUMN dokumen.status; Type: COMMENT; Schema: public; Owner: earsip
--

COMMENT ON COLUMN public.dokumen.status IS 'aktif atau tidak';


--
-- Name: COLUMN dokumen.jenis; Type: COMMENT; Schema: public; Owner: earsip
--

COMMENT ON COLUMN public.dokumen.jenis IS 'umum atau privat';


--
-- Name: kategori_dokumen; Type: TABLE; Schema: public; Owner: earsip
--

CREATE TABLE public.kategori_dokumen (
    kat_dok_id integer DEFAULT nextval('public.kat_dok_id_seq'::regclass) NOT NULL,
    kode_dok character varying(11),
    kategori_dokumen character varying(100),
    status integer
);


ALTER TABLE public.kategori_dokumen OWNER TO earsip;

--
-- Data for Name: dokumen; Type: TABLE DATA; Schema: public; Owner: earsip
--

COPY public.dokumen (dok_id, kode_dok, judul, tahun, tentang, summary, status, jenis, nama_file, create_at, update_at) FROM stdin;
3	SOP	Pengantar Workshop	2019	SOP operasional internal Penggunaan IT	SOP internal	1	Umum	1575535685-Pengantar_Workshop.pdf	\N	2019-12-05
56	SOP	SOP kebijakan IT	2019	Support IT		1	Umum	1575535725-SOP_kebijakan_IT.pdf	2019-12-05	2019-12-05
55	SOP	SOP kebijakan penggunaan sistem IT	2027	penggunaan komputer		1	Umum	1575535749-SOP_kebijakan_penggunaan_sistem_IT.pdf	2019-12-05	2019-12-05
54	PPM	Peraturan Pemerintah No 53 Tahun 2018	2018	Perubahan aturan		1	Umum	1575535771-Peraturan_Pemerintah_No_53_Tahun_2018.pdf	2019-12-05	2019-12-05
46	UU	Undang-undang Umum	2017	Perundangundangan		1	Umum	1575535814-Undang-undang_Umum.pdf	\N	2019-12-05
44	PP	PMI	2018	PMI		1	Internal	1575535835-PMI.pdf	\N	2019-12-05
48	PP	Peraturan Internal	2017	Penggunaan sistem informasi internal		1	Umum	1575535862-Peraturan_Internal.pdf	\N	2019-12-05
43	PP	Peraturan baru [Kebijakan]	2000	Perubahan Peraturan Divisin		1	Internal	1575535897-Peraturan_baru_Kebijakan.pdf	\N	2019-12-05
59	SOP	SOP SPBE baru	2018	spbe		1	Umum	1575536118-SOP_SPBE_baru.pdf	2019-12-05	2019-12-05
\.


--
-- Data for Name: kategori_dokumen; Type: TABLE DATA; Schema: public; Owner: earsip
--

COPY public.kategori_dokumen (kat_dok_id, kode_dok, kategori_dokumen, status) FROM stdin;
5	SOP	SOP internal Kebijakan	1
17	UU	UUD 1945	1
6	PP	Peraturan Menteri Internal New	1
18	PPM	Peraturan Pemerintah Sosial Menteri	1
\.


--
-- Name: dokumen dokumen_pkey; Type: CONSTRAINT; Schema: public; Owner: earsip
--

ALTER TABLE ONLY public.dokumen
    ADD CONSTRAINT dokumen_pkey PRIMARY KEY (dok_id);


--
-- Name: kategori_dokumen kategori_dokumen_kode_key; Type: CONSTRAINT; Schema: public; Owner: earsip
--

ALTER TABLE ONLY public.kategori_dokumen
    ADD CONSTRAINT kategori_dokumen_kode_key UNIQUE (kode_dok);


--
-- Name: kategori_dokumen kategori_dokumen_pkey; Type: CONSTRAINT; Schema: public; Owner: earsip
--

ALTER TABLE ONLY public.kategori_dokumen
    ADD CONSTRAINT kategori_dokumen_pkey PRIMARY KEY (kat_dok_id);


--
-- PostgreSQL database dump complete
--

