423 lines
11 KiB
SQL
423 lines
11 KiB
SQL
--
|
|
-- PostgreSQL database dump
|
|
--
|
|
|
|
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;
|
|
|
|
--
|
|
-- TOC entry 5 (class 2615 OID 18291)
|
|
-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
|
|
--
|
|
|
|
-- *not* creating schema, since initdb creates it
|
|
|
|
|
|
--ALTER SCHEMA public OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 5092 (class 0 OID 0)
|
|
-- Dependencies: 5
|
|
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
|
|
--
|
|
|
|
COMMENT ON SCHEMA public IS '';
|
|
|
|
|
|
SET default_tablespace = '';
|
|
|
|
SET default_table_access_method = heap;
|
|
|
|
--
|
|
-- TOC entry 220 (class 1259 OID 18294)
|
|
-- Name: daftar_kategori_operasi; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.daftar_kategori_operasi (
|
|
id integer NOT NULL,
|
|
status character varying(255) DEFAULT 'draft'::character varying NOT NULL,
|
|
date_created timestamp without time zone,
|
|
date_updated timestamp without time zone,
|
|
"Kategori" character varying(255)
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.daftar_kategori_operasi OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 219 (class 1259 OID 18293)
|
|
-- Name: daftar_kategori_operasi_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE SEQUENCE public.daftar_kategori_operasi_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
--ALTER SEQUENCE public.daftar_kategori_operasi_id_seq OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 5094 (class 0 OID 0)
|
|
-- Dependencies: 219
|
|
-- Name: daftar_kategori_operasi_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER SEQUENCE public.daftar_kategori_operasi_id_seq OWNED BY public.daftar_kategori_operasi.id;
|
|
|
|
|
|
--
|
|
-- TOC entry 233 (class 1259 OID 18376)
|
|
-- Name: daftar_ksm; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.daftar_ksm (
|
|
id integer NOT NULL,
|
|
"Nama_ksm" character varying(255)
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.daftar_ksm OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 232 (class 1259 OID 18375)
|
|
-- Name: daftar_ksm_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE SEQUENCE public.daftar_ksm_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
--ALTER SEQUENCE public.daftar_ksm_id_seq OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 5095 (class 0 OID 0)
|
|
-- Dependencies: 232
|
|
-- Name: daftar_ksm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER SEQUENCE public.daftar_ksm_id_seq OWNED BY public.daftar_ksm.id;
|
|
|
|
|
|
--
|
|
-- TOC entry 223 (class 1259 OID 18317)
|
|
-- Name: daftar_spesialis; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.daftar_spesialis (
|
|
id integer NOT NULL,
|
|
"Kode" character varying(255),
|
|
"Spesialis" character varying(255),
|
|
"Id_group_location_simgos" character varying(255)
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.daftar_spesialis OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 222 (class 1259 OID 18316)
|
|
-- Name: daftar_spesialis_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE SEQUENCE public.daftar_spesialis_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
--ALTER SEQUENCE public.daftar_spesialis_id_seq OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 5096 (class 0 OID 0)
|
|
-- Dependencies: 222
|
|
-- Name: daftar_spesialis_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER SEQUENCE public.daftar_spesialis_id_seq OWNED BY public.daftar_spesialis.id;
|
|
|
|
|
|
--
|
|
-- TOC entry 225 (class 1259 OID 18327)
|
|
-- Name: daftar_subspesialis; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.daftar_subspesialis (
|
|
id integer NOT NULL,
|
|
"Kode" character varying(255),
|
|
"Subspesialis" character varying(255),
|
|
"FK_daftar_spesialis_ID" integer
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.daftar_subspesialis OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 224 (class 1259 OID 18326)
|
|
-- Name: daftar_subspesialis_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE SEQUENCE public.daftar_subspesialis_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
--ALTER SEQUENCE public.daftar_subspesialis_id_seq OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 5097 (class 0 OID 0)
|
|
-- Dependencies: 224
|
|
-- Name: daftar_subspesialis_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER SEQUENCE public.daftar_subspesialis_id_seq OWNED BY public.daftar_subspesialis.id;
|
|
|
|
|
|
--
|
|
-- TOC entry 230 (class 1259 OID 18358)
|
|
-- Name: data_diagnosa_pasien_operasi; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.data_diagnosa_pasien_operasi (
|
|
id uuid NOT NULL,
|
|
user_created uuid,
|
|
date_created timestamp with time zone,
|
|
user_updated uuid,
|
|
date_updated timestamp with time zone,
|
|
"Kode_diagnosa" character varying(255),
|
|
"Diagnosa" character varying(255),
|
|
"Keterangan" character varying(255),
|
|
"FK_pasien_operasi_diagnosa_pasien_operasi_ID" uuid,
|
|
"Jenis_diagnosa" character varying(255)
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.data_diagnosa_pasien_operasi OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 221 (class 1259 OID 18305)
|
|
-- Name: data_pasien_operasi; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.data_pasien_operasi (
|
|
id uuid NOT NULL,
|
|
status character varying(20) DEFAULT 'draft'::character varying NOT NULL,
|
|
sort integer,
|
|
user_created uuid,
|
|
date_created timestamp with time zone,
|
|
user_updated uuid,
|
|
date_updated timestamp with time zone,
|
|
"No_rekam_medis" character varying(255),
|
|
"No_KTP" character varying(255),
|
|
"Nama_pasien" character varying(255),
|
|
"Jenis_kelamin" character varying(255),
|
|
"Tanggal_lahir" date,
|
|
"Umur" character varying(255),
|
|
"Alamat" text,
|
|
"Tanggal_daftar" timestamp without time zone,
|
|
"Kategori_operasi" integer,
|
|
"Rencana_operasi" text,
|
|
"Keterangan" text,
|
|
"Tanggal_selesai_operasi" timestamp without time zone,
|
|
"Status_operasi" character varying(255),
|
|
"Nomor" integer,
|
|
"Old_kategori" integer,
|
|
"Spesialis" integer,
|
|
"Sub_spesialis" integer NOT NULL,
|
|
"Keterangan_status_pasien" text,
|
|
"Nomor_spesialis" integer,
|
|
"Nomor_sub_spesialis" integer,
|
|
"Old_spesialis" integer,
|
|
"Old_sub_spesialis" integer
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.data_pasien_operasi OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 229 (class 1259 OID 18351)
|
|
-- Name: data_pasien_operasi_data_pegawai; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.data_pasien_operasi_data_pegawai (
|
|
id integer NOT NULL,
|
|
data_pasien_operasi_id uuid,
|
|
data_pegawai_id uuid
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.data_pasien_operasi_data_pegawai OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 228 (class 1259 OID 18350)
|
|
-- Name: data_pasien_operasi_data_pegawai_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE SEQUENCE public.data_pasien_operasi_data_pegawai_id_seq
|
|
AS integer
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
NO MINVALUE
|
|
NO MAXVALUE
|
|
CACHE 1;
|
|
|
|
|
|
--ALTER SEQUENCE public.data_pasien_operasi_data_pegawai_id_seq OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 5098 (class 0 OID 0)
|
|
-- Dependencies: 228
|
|
-- Name: data_pasien_operasi_data_pegawai_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER SEQUENCE public.data_pasien_operasi_data_pegawai_id_seq OWNED BY public.data_pasien_operasi_data_pegawai.id;
|
|
|
|
|
|
--
|
|
-- TOC entry 231 (class 1259 OID 18366)
|
|
-- Name: data_pegawai; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.data_pegawai (
|
|
id uuid NOT NULL,
|
|
status character varying(255) DEFAULT 'draft'::character varying,
|
|
sort integer,
|
|
user_created uuid,
|
|
date_created timestamp with time zone,
|
|
user_updated uuid,
|
|
date_updated timestamp with time zone,
|
|
"Foto_pegawai" uuid,
|
|
"Kartu_pegawai" uuid,
|
|
"KTP" uuid,
|
|
"Nomor_kartu_pegawai" character varying(255),
|
|
"NIP" character varying(255),
|
|
"NIP_lama" character varying(255),
|
|
"Jabatan" integer,
|
|
"Golongan" integer,
|
|
"Rumpun" integer,
|
|
"KSM" integer,
|
|
"Tanggal_masuk" date,
|
|
"Tanggal_pensiun" date,
|
|
"TMT_CPNS" date,
|
|
"TMT_PNS" date,
|
|
"Satuan_kerja" integer,
|
|
"FK_spt_pegawai_id" uuid,
|
|
"Nama_depan" character varying(255),
|
|
"Nama_belakang" character varying(255),
|
|
"Username" character varying(255),
|
|
"User_email" character varying(255),
|
|
"Id_user" character varying(255),
|
|
"Practicioner" uuid,
|
|
"HFIS_code" character varying(255),
|
|
"HFIS_display" character varying(255),
|
|
"Code_dpjp" character varying(255),
|
|
"KDDOKTER" bigint,
|
|
"Practicioner_detail" bigint,
|
|
"Kode_satusehat" character varying(255),
|
|
"No_whatsapp" character varying(255),
|
|
"Posisi_ruang" integer,
|
|
"Substansi" integer,
|
|
"NDE" uuid,
|
|
"Subspesialis" integer,
|
|
"Status_pegawai" integer,
|
|
"File_status" uuid,
|
|
"Ketarangan" integer,
|
|
"Kode_DPJP" character varying(255)
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.data_pegawai OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 226 (class 1259 OID 18336)
|
|
-- Name: data_telepon_pasien_operasi; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.data_telepon_pasien_operasi (
|
|
id uuid NOT NULL,
|
|
"Nomor_telepon" character varying(255),
|
|
"FK_pasien_operasi_telepon_pasien_operasi_ID" uuid
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.data_telepon_pasien_operasi OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 227 (class 1259 OID 18342)
|
|
-- Name: data_tindakan_pasien_operasi; Type: TABLE; Schema: public; Owner: postgres
|
|
--
|
|
|
|
CREATE TABLE public.data_tindakan_pasien_operasi (
|
|
id uuid NOT NULL,
|
|
user_created uuid,
|
|
date_created timestamp with time zone,
|
|
user_updated uuid,
|
|
date_updated timestamp with time zone,
|
|
"Kode_tindakan" character varying(255),
|
|
"Tindakan" character varying(255),
|
|
"Tindakan_tambahan" text,
|
|
"FK_pasien_operasi_tindakan_pasien_operasi_ID" uuid
|
|
);
|
|
|
|
|
|
--ALTER TABLE public.data_tindakan_pasien_operasi OWNER TO postgres;
|
|
|
|
--
|
|
-- TOC entry 4896 (class 2604 OID 18297)
|
|
-- Name: daftar_kategori_operasi id; Type: DEFAULT; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER TABLE ONLY public.daftar_kategori_operasi ALTER COLUMN id SET DEFAULT nextval('public.daftar_kategori_operasi_id_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- TOC entry 4903 (class 2604 OID 18379)
|
|
-- Name: daftar_ksm id; Type: DEFAULT; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER TABLE ONLY public.daftar_ksm ALTER COLUMN id SET DEFAULT nextval('public.daftar_ksm_id_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- TOC entry 4899 (class 2604 OID 18320)
|
|
-- Name: daftar_spesialis id; Type: DEFAULT; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER TABLE ONLY public.daftar_spesialis ALTER COLUMN id SET DEFAULT nextval('public.daftar_spesialis_id_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- TOC entry 4900 (class 2604 OID 18330)
|
|
-- Name: daftar_subspesialis id; Type: DEFAULT; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER TABLE ONLY public.daftar_subspesialis ALTER COLUMN id SET DEFAULT nextval('public.daftar_subspesialis_id_seq'::regclass);
|
|
|
|
|
|
--
|
|
-- TOC entry 4901 (class 2604 OID 18354)
|
|
-- Name: data_pasien_operasi_data_pegawai id; Type: DEFAULT; Schema: public; Owner: postgres
|
|
--
|
|
|
|
ALTER TABLE ONLY public.data_pasien_operasi_data_pegawai ALTER COLUMN id SET DEFAULT nextval('public.data_pasien_operasi_data_pegawai_id_seq'::regclass); |