/*
 Navicat Premium Data Transfer

 Source Server         : eRaporSMA
 Source Server Type    : PostgreSQL
 Source Server Version : 90204
 Source Host           : localhost:56723
 Source Catalog        : eraporsma
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 90204
 File Encoding         : 65001

 Date: 28/08/2022 09:37:28
*/


-- ----------------------------
-- Table structure for tabel_wbkoneksi
-- ----------------------------
DROP TABLE IF EXISTS "public"."tabel_wbkoneksi";
CREATE TABLE "public"."tabel_wbkoneksi" (
  "id_data" uuid NOT NULL,
  "nama_app" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "alamat_ip" varchar(150) COLLATE "pg_catalog"."default" NOT NULL,
  "key" varchar(150) COLLATE "pg_catalog"."default" NOT NULL,
  "port" varchar(5) COLLATE "pg_catalog"."default" NOT NULL,
  "npsn" varchar(15) COLLATE "pg_catalog"."default" NOT NULL,
  "ip_rapor" varchar(150) COLLATE "pg_catalog"."default" NOT NULL
)
;

-- ----------------------------
-- Records of tabel_wbkoneksi
-- ----------------------------
INSERT INTO "public"."tabel_wbkoneksi" VALUES ('8781450e-deba-4bcb-9ac3-849d6eaa01be', 'Aplikasi MPD ', 'localhost', 'd87KGVrHTpIzdrg', '5774', '51234567', 'localhost');

-- ----------------------------
-- Primary Key structure for table tabel_wbkoneksi
-- ----------------------------
ALTER TABLE "public"."tabel_wbkoneksi" ADD CONSTRAINT "tabel_wbkoneksi_pkey" PRIMARY KEY ("id_data");
 