L3Y1A1FA

1/*
2Navicat PGSQL Data Transfer
3
4Source Server         : Localhost - PostgreSQL
5Source Server Version : 90603
6Source Host           : localhost:5432
7Source Database       : dms
8Source Schema         : public
9
10Target Server Type    : PGSQL
11Target Server Version : 90603
12File Encoding         : 65001
13
14Date: 2017-10-03 12:57:54
15*/
16
17
18-- ----------------------------
19-- Sequence structure for app_workflow_case_detail_id_seq
20-- ----------------------------
21DROP SEQUENCE IF EXISTS "public"."app_workflow_case_detail_id_seq";
22CREATE SEQUENCE "public"."app_workflow_case_detail_id_seq"
23 INCREMENT 1
24 MINVALUE 1
25 MAXVALUE 9223372036854775807
26 START 101
27 CACHE 1;
28SELECT setval('"public"."app_workflow_case_detail_id_seq"', 101, true);
29
30-- ----------------------------
31-- Table structure for app_access_file
32-- ----------------------------
33DROP TABLE IF EXISTS "public"."app_access_file";
34CREATE TABLE "public"."app_access_file" (
35"dfi_id" varchar(10) COLLATE "default",
36"jenis" char(1) COLLATE "default",
37"mydata" varchar(255) COLLATE "default"
38)
39WITH (OIDS=FALSE)
40
41;
42COMMENT ON COLUMN "public"."app_access_file"."jenis" IS '1 = User , 2 = Function Access ';
43
44-- ----------------------------
45-- Records of app_access_file
46-- ----------------------------
47
48-- ----------------------------
49-- Table structure for app_function_access
50-- ----------------------------
51DROP TABLE IF EXISTS "public"."app_function_access";
52CREATE TABLE "public"."app_function_access" (
53"fua_name" varchar(255) COLLATE "default",
54"fua_read" int4,
55"fua_delete" int4,
56"fua_edit" int4,
57"fua_add" int4,
58"men_nomorurut" int4
59)
60WITH (OIDS=FALSE)
61
62;
63
64-- ----------------------------
65-- Records of app_function_access
66-- ----------------------------
67INSERT INTO "public"."app_function_access" VALUES ('AdminDokumen', '1', '1', '1', '1', '2');
68INSERT INTO "public"."app_function_access" VALUES ('AdminDokumen', '1', '1', '1', '1', '3');
69INSERT INTO "public"."app_function_access" VALUES ('AdminDokumen', '1', '1', '1', '1', '4');
70INSERT INTO "public"."app_function_access" VALUES ('AdminDokumen', '1', '1', '1', '1', '13');
71INSERT INTO "public"."app_function_access" VALUES ('AdminDokumen', '1', '1', '1', '1', '14');
72INSERT INTO "public"."app_function_access" VALUES ('AdminDokumen', '1', '1', '1', '1', '15');
73INSERT INTO "public"."app_function_access" VALUES ('AdminDokumen', '1', '1', '1', '1', '16');
74INSERT INTO "public"."app_function_access" VALUES ('AdminDokumen', '1', '1', '1', '1', '17');
75INSERT INTO "public"."app_function_access" VALUES ('Default', '1', '1', '1', '1', '2');
76INSERT INTO "public"."app_function_access" VALUES ('Default', '1', '1', '1', '1', '3');
77INSERT INTO "public"."app_function_access" VALUES ('Default', '1', '1', '1', '1', '4');
78INSERT INTO "public"."app_function_access" VALUES ('Default', '1', '1', '1', '1', '13');
79INSERT INTO "public"."app_function_access" VALUES ('Default', '1', '1', '1', '1', '14');
80INSERT INTO "public"."app_function_access" VALUES ('Default', '1', '1', '1', '1', '15');
81INSERT INTO "public"."app_function_access" VALUES ('Default', '1', '1', '1', '1', '16');
82INSERT INTO "public"."app_function_access" VALUES ('Default', '1', '1', '1', '1', '17');
83INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '2');
84INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '3');
85INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '4');
86INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '5');
87INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '6');
88INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '7');
89INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '8');
90INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '10');
91INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '11');
92INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '13');
93INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '14');
94INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '15');
95INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '16');
96INSERT INTO "public"."app_function_access" VALUES ('SuperUser', '1', '1', '1', '1', '17');
97
98-- ----------------------------
99-- Table structure for app_inquiry_access
100-- ----------------------------
101DROP TABLE IF EXISTS "public"."app_inquiry_access";
102CREATE TABLE "public"."app_inquiry_access" (
103"id" int4 NOT NULL,
104"access_name" varchar(200) COLLATE "default" NOT NULL,
105"inquiry_name" varchar(200) COLLATE "default" NOT NULL,
106"inquiry_access" varchar(500) COLLATE "default",
107"is_delete" int4,
108"c_time" timestamp(6),
109"c_user" varchar(50) COLLATE "default",
110"m_time" timestamp(6),
111"m_user" varchar(50) COLLATE "default",
112"d_time" timestamp(6),
113"d_user" varchar(50) COLLATE "default"
114)
115WITH (OIDS=FALSE)
116
117;
118
119-- ----------------------------
120-- Records of app_inquiry_access
121-- ----------------------------
122INSERT INTO "public"."app_inquiry_access" VALUES ('1', 'Administrator', 'ManageUser', 'Yes', null, null, null, null, null, null, null);
123INSERT INTO "public"."app_inquiry_access" VALUES ('2', 'Administrator', 'ManageAccess', 'Yes', null, null, null, null, null, null, null);
124INSERT INTO "public"."app_inquiry_access" VALUES ('3', 'Default', 'ManageUser', 'No', null, null, null, null, null, null, null);
125INSERT INTO "public"."app_inquiry_access" VALUES ('4', 'Default', 'ManageAccess', 'No', null, null, null, null, null, null, null);
126
127-- ----------------------------
128-- Table structure for app_list_case_activity
129-- ----------------------------
130DROP TABLE IF EXISTS "public"."app_list_case_activity";
131CREATE TABLE "public"."app_list_case_activity" (
132"id_model" varchar(10) COLLATE "default" NOT NULL,
133"model_name" varchar(50) COLLATE "default"
134)
135WITH (OIDS=FALSE)
136
137;
138
139-- ----------------------------
140-- Records of app_list_case_activity
141-- ----------------------------
142INSERT INTO "public"."app_list_case_activity" VALUES ('MDL-000001', 'Group / Function Access');
143INSERT INTO "public"."app_list_case_activity" VALUES ('MDL-000002', 'Owner');
144
145-- ----------------------------
146-- Table structure for app_list_distribution_activity
147-- ----------------------------
148DROP TABLE IF EXISTS "public"."app_list_distribution_activity";
149CREATE TABLE "public"."app_list_distribution_activity" (
150"id_list_distribution" varchar(10) COLLATE "default",
151"distribution" varchar(50) COLLATE "default"
152)
153WITH (OIDS=FALSE)
154
155;
156
157-- ----------------------------
158-- Records of app_list_distribution_activity
159-- ----------------------------
160INSERT INTO "public"."app_list_distribution_activity" VALUES ('DST-000001', 'Create');
161INSERT INTO "public"."app_list_distribution_activity" VALUES ('DST-000002', 'Approve');
162INSERT INTO "public"."app_list_distribution_activity" VALUES ('DST-000003', 'Finish');
163
164-- ----------------------------
165-- Table structure for app_list_type_activity
166-- ----------------------------
167DROP TABLE IF EXISTS "public"."app_list_type_activity";
168CREATE TABLE "public"."app_list_type_activity" (
169"id_list_type" varchar(10) COLLATE "default" NOT NULL,
170"tipe" varchar(30) COLLATE "default"
171)
172WITH (OIDS=FALSE)
173
174;
175
176-- ----------------------------
177-- Records of app_list_type_activity
178-- ----------------------------
179INSERT INTO "public"."app_list_type_activity" VALUES ('TY-000001', 'User');
180INSERT INTO "public"."app_list_type_activity" VALUES ('TY-000002', 'Function Access');
181
182-- ----------------------------
183-- Table structure for app_list_type_sequence
184-- ----------------------------
185DROP TABLE IF EXISTS "public"."app_list_type_sequence";
186CREATE TABLE "public"."app_list_type_sequence" (
187"id_list_type_sequence" varchar(10) COLLATE "default",
188"tipe" varchar(30) COLLATE "default"
189)
190WITH (OIDS=FALSE)
191
192;
193
194-- ----------------------------
195-- Records of app_list_type_sequence
196-- ----------------------------
197INSERT INTO "public"."app_list_type_sequence" VALUES ('TYS-000001', 'Sequence');
198INSERT INTO "public"."app_list_type_sequence" VALUES ('TYS-000002', 'Formula');
199
200-- ----------------------------
201-- Table structure for app_log
202-- ----------------------------
203DROP TABLE IF EXISTS "public"."app_log";
204CREATE TABLE "public"."app_log" (
205"user_id" varchar(10) COLLATE "default" NOT NULL,
206"activity" varchar(1000) COLLATE "default",
207"ip" varchar(100) COLLATE "default" NOT NULL,
208"detail" varchar(1000) COLLATE "default",
209"ctime" timestamp(6)
210)
211WITH (OIDS=FALSE)
212
213;
214
215-- ----------------------------
216-- Records of app_log
217-- ----------------------------
218INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Add Sequence', '::1', 'Add Sequence : WF-000001 & Sequence ID : SEQ-000005', '2017-09-30 22:08:42');
219INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Add Workflow Activity', '::1', 'Add Workflow Activity : WF-000001 & Activity ID : ACT-000014', '2017-09-30 22:06:39');
220INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Sequence', '::1', 'Update Sequence : WF-000001 & Sequence ID : SEQ-000002', '2017-09-30 22:08:13');
221INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Sequence', '::1', 'Update Sequence ID : U0VRLTAwMDAwNQ==', '2017-09-30 22:03:23');
222INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update User', '::1', 'Update User username : luviann & user_id USR-000004 & function access Default ', '2017-10-01 09:43:37');
223INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000010', '2017-09-30 22:04:21');
224INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000010', '2017-09-30 22:04:26');
225INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000010', '2017-10-02 21:34:14');
226INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000010', '2017-10-02 21:34:22');
227INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000011', '2017-10-01 08:59:23');
228INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000014', '2017-09-30 22:07:21');
229INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000014', '2017-09-30 22:13:34');
230INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000014', '2017-09-30 22:16:32');
231INSERT INTO "public"."app_log" VALUES ('USR-000001', 'Update Workflow Activity', '::1', 'Update Workflow Activity : WF-000001 & Activity ID : ACT-000014', '2017-09-30 22:23:43');
232INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Access File', '::1', 'Add Access File dfi_id : DFI-000002 & 1 & access USR-000003', '2017-10-02 21:13:57');
233INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Access File', '::1', 'Add Access File dfi_id : DFI-000004 & 1 & access USR-000003', '2017-10-01 11:25:43');
234INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Access File', '::1', 'Add Access File dfi_id : DFI-000004 & 1 & access USR-000003', '2017-10-01 11:32:03');
235INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Access File', '::1', 'Add Access File dfi_id : DFI-000004 & 1 & access USR-000003', '2017-10-01 11:40:28');
236INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Access File', '::1', 'Add Access File dfi_id : DFI-000005 & 1 & access USR-000003', '2017-10-01 09:03:16');
237INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Access File', '::1', 'Add Access File dfi_id : DFI-000005 & 1 & access USR-000003', '2017-10-01 12:14:52');
238INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Access File', '::1', 'Add Access File dfi_id : DFI-000006 & 1 & access USR-000003', '2017-10-01 09:28:32');
239INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000001', '2017-10-01 09:03:17');
240INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000001', '2017-10-01 11:32:03');
241INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000001', '2017-10-01 11:40:28');
242INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000001', '2017-10-02 10:52:50');
243INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000001', '2017-10-02 11:58:10');
244INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000001', '2017-10-02 19:13:15');
245INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000001', '2017-10-02 19:14:32');
246INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000002', '2017-10-01 09:28:32');
247INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000002', '2017-10-01 12:14:52');
248INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000002', '2017-10-02 19:09:03');
249INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000002', '2017-10-02 21:13:57');
250INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000003', '2017-10-01 11:25:43');
251INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '::1', 'Add Layanan Mandiri Case Number : KSO-000004', '2017-10-02 10:45:00');
252INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '127.0.0.1', 'Add Layanan Mandiri Case Number : KSO-000003', '2017-10-02 08:37:50');
253INSERT INTO "public"."app_log" VALUES ('USR-000003', 'Add Layanan Mandiri', '127.0.0.1', 'Add Layanan Mandiri Case Number : KSO-000003', '2017-10-02 08:42:23');
254
255-- ----------------------------
256-- Table structure for app_menu
257-- ----------------------------
258DROP TABLE IF EXISTS "public"."app_menu";
259CREATE TABLE "public"."app_menu" (
260"menu_level" int4,
261"title" varchar(200) COLLATE "default",
262"url" varchar(1000) COLLATE "default",
263"remark" varchar(200) COLLATE "default",
264"target" varchar(50) COLLATE "default",
265"image" varchar(50) COLLATE "default",
266"weight" int4,
267"show" int4,
268"hierarchy" int4,
269"basichierarchy" varchar(100) COLLATE "default",
270"is_delete" char(1) COLLATE "default",
271"c_time" timestamp(6),
272"c_user" varchar(50) COLLATE "default",
273"m_time" timestamp(6),
274"m_user" varchar(50) COLLATE "default",
275"d_time" timestamp(6),
276"d_user" varchar(50) COLLATE "POSIX",
277"is_category" char(1) COLLATE "default",
278"category_code" varchar(10) COLLATE "default",
279"men_id" int4,
280"reference" int4
281)
282WITH (OIDS=FALSE)
283
284;
285
286-- ----------------------------
287-- Records of app_menu
288-- ----------------------------
289INSERT INTO "public"."app_menu" VALUES ('1', 'Category', '#', 'Category', 'main', 'fa fa-book', '4', '1', null, null, 'N', '2016-05-09 09:31:33', 'USR-000001', '2017-09-22 05:43:34', 'USR-000001', null, null, 'N', '0', '4', '0');
290INSERT INTO "public"."app_menu" VALUES ('1', 'Document Upload', 'document_upload', 'Only Document Upload Non Scan', 'main', null, '3', '1', null, null, 'N', '2017-09-20 13:09:44', 'USR-000001', '2017-09-27 07:10:02', 'USR-000001', null, null, 'Y', 'RCA-000004', '14', '4');
291INSERT INTO "public"."app_menu" VALUES ('1', 'Home', 'home', 'Home', 'main', 'fa fa-home', '1', '1', null, null, 'N', '2016-05-04 14:45:05', 'USR-000001', '2017-09-18 09:31:01', 'USR-000001', null, null, 'N', null, '1', '0');
292INSERT INTO "public"."app_menu" VALUES ('1', 'Scan', 'scan', 'Scan', 'main', 'fa fa-file-text', '2', '1', null, null, 'N', '2016-05-04 14:46:47', 'USR-000001', '2016-05-04 14:46:47', 'USR-000001', null, null, 'N', null, '2', '0');
293INSERT INTO "public"."app_menu" VALUES ('1', 'Scan Non OCR', 'scan_non_ocr', 'Scan Folder Non OCR', 'main', null, '2', '1', null, null, 'N', '2017-09-20 13:09:44', 'USR-000001', '2017-09-22 05:43:26', 'USR-000001', null, null, 'Y', 'RCA-000002', '15', '4');
294INSERT INTO "public"."app_menu" VALUES ('1', 'Scan OCR', 'scan_ocr', 'Scan Document OCR', 'main', null, '1', '1', null, null, 'N', '2017-09-20 13:09:44', 'USR-000001', '2017-09-28 06:35:24', 'USR-000001', null, null, 'Y', 'RCA-000003', '13', '4');
295INSERT INTO "public"."app_menu" VALUES ('1', 'Upload', 'upload', 'Upload', 'main', 'fa fa-upload', '3', '1', null, null, 'N', '2016-05-09 09:31:33', 'USR-000001', '2016-05-09 09:31:33', 'USR-000001', null, null, 'N', null, '3', '0');
296INSERT INTO "public"."app_menu" VALUES ('1', 'User & Function Access', '#', 'Admin', 'main', '', '5', '1', null, null, 'N', '2016-05-09 09:31:33', 'USR-000001', '2017-09-19 03:46:25', 'USR-000001', null, null, 'N', null, '5', '0');
297INSERT INTO "public"."app_menu" VALUES ('1', 'Workflow & Activity', '#', 'Menu - menu Workflow & Activity', 'main', null, '6', '1', null, null, 'N', '2017-09-19 03:55:48', 'USR-000001', '2017-09-19 03:55:48', 'USR-000001', null, null, 'N', null, '10', '0');
298INSERT INTO "public"."app_menu" VALUES ('2', 'Function Access', 'function_access', 'Function Access', 'main', 'fa fa-key', '8', '1', null, null, 'N', '2016-05-09 09:31:33', 'USR-000001', '2016-05-09 09:31:33', 'USR-000001', null, null, 'N', null, '8', '5');
299INSERT INTO "public"."app_menu" VALUES ('2', 'Menu', 'menu', 'Menu', 'main', 'fa fa-list', '7', '1', null, null, 'N', '2016-05-09 09:31:33', 'USR-000001', '2016-05-09 09:31:33', 'USR-000001', null, null, 'N', null, '7', '5');
300INSERT INTO "public"."app_menu" VALUES ('2', 'Scan Non OCR', 'scan', 'Scan Non OCR', 'main', 'fa fa-image', '2', '1', null, null, 'N', '2017-09-19 04:01:31', 'USR-000001', '2017-09-19 04:01:31', 'USR-000001', null, null, 'N', null, '17', '2');
301INSERT INTO "public"."app_menu" VALUES ('2', 'Scan OCR', 'scan_ocr', 'Scan OCR', 'main', 'fa fa-file-text', '1', '1', null, null, 'N', '2017-09-19 04:01:31', 'USR-000001', '2017-09-19 04:01:31', 'USR-000001', null, null, 'N', null, '16', '2');
302INSERT INTO "public"."app_menu" VALUES ('2', 'User', 'user', 'User', 'main', 'fa fa-users', '6', '1', null, null, 'N', '2016-05-09 09:31:33', 'USR-000001', '2016-05-09 09:31:33', 'USR-000001', null, null, 'N', null, '6', '5');
303INSERT INTO "public"."app_menu" VALUES ('2', 'Workflow', 'workflow', 'Menu Workflow', 'main', 'fa fa-book', '1', '1', null, null, 'N', '2017-09-19 04:01:31', 'USR-000001', '2017-09-19 04:01:31', 'USR-000001', null, null, 'N', null, '11', '10');
304
305-- ----------------------------
306-- Table structure for app_session
307-- ----------------------------
308DROP TABLE IF EXISTS "public"."app_session";
309CREATE TABLE "public"."app_session" (
310"session_id" varchar(32) COLLATE "default",
311"username" varchar(16) COLLATE "default",
312"last_access" timestamp(6),
313"ip" varchar(32) COLLATE "default",
314"user_agent" varchar(255) COLLATE "default",
315"status" numeric(38),
316"ctime" timestamp(6),
317"challenge" text COLLATE "default",
318"session_content" text COLLATE "default"
319)
320WITH (OIDS=FALSE)
321
322;
323
324-- ----------------------------
325-- Records of app_session
326-- ----------------------------
327INSERT INTO "public"."app_session" VALUES ('13df202742062d80ae0aa7f277fd20f5', 'admin', '2016-04-01 20:06:35', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-01 20:06:35', 'f1c3dbbe461093c37efea1737bd5deff', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
328INSERT INTO "public"."app_session" VALUES ('1821abb6a6377f2530057fa53e9fa538', 'admin', '2016-04-28 23:46:44', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-28 23:46:36', 'efba3a7b218b4e9c24d574e55bcf55fc', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
329INSERT INTO "public"."app_session" VALUES ('2262a3cfaa20b1fb366d91e5eee06ecf', 'admin', '2016-04-01 20:19:20', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-01 20:19:20', '4adcd8922014bd0da21ee3a30a6282e7', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
330INSERT INTO "public"."app_session" VALUES ('22c63224e9ac2cf4359f2b163fa175ee', 'admin', '2016-04-30 20:32:24', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-30 20:11:29', 'cf11aabaf1c1e3c95f3ac2e2776a151f', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
331INSERT INTO "public"."app_session" VALUES ('2cbb10e171c433d2669a4517d916a4a6', 'admin', '2016-05-18 21:11:23', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:46.0) Gecko/20100101 Firefox/46.0', '1', '2016-05-18 20:36:14', 'd2270120e66e7d3c7eeb3ba55e8d2758', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1","function_access":"Administrator","inquiry_access":"Administrator"}');
332INSERT INTO "public"."app_session" VALUES ('4c36ce2832bbce7767ce529ec8a7de62', 'admin', '2016-04-30 20:36:43', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 Safari/537.36 Edge/13.10586', '1', '2016-04-30 20:36:29', '770374e38a9727cbf15995505d154613', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
333INSERT INTO "public"."app_session" VALUES ('505b582738797d6d93ede30356a71940', 'admin', '2016-05-11 13:04:24', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:46.0) Gecko/20100101 Firefox/46.0', '1', '2016-05-11 12:57:00', 'cf16953f007892a3b701c067889990e2', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1","function_access":"Administrator","inquiry_access":"Administrator"}');
334INSERT INTO "public"."app_session" VALUES ('5a1bd7f5d2755072b07b7bebf6fd2a77', 'admin', '2016-04-17 17:22:29', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-17 17:22:29', 'd7216eb6cf2abc694af144c7d8148f2f', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
335INSERT INTO "public"."app_session" VALUES ('5cb60278006dabaeeffbbdea1f0659fe', 'admin', '2016-05-13 09:07:31', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:46.0) Gecko/20100101 Firefox/46.0', '1', '2016-05-13 08:02:48', 'a948a46cddb24069153331cafdc7f6db', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1","function_access":"Administrator","inquiry_access":"Administrator"}');
336INSERT INTO "public"."app_session" VALUES ('89332421a494a346057f5ccde787c6c4', 'admin', '2016-04-03 16:39:59', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-03 16:39:59', 'a48588774ab78fc45fe724146efa28e5', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
337INSERT INTO "public"."app_session" VALUES ('968761963c1b9b4ba25cc713e9ebc117', 'admin', '2016-04-13 13:01:49', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-13 13:01:49', '9218f8ac722b4fee6f09275db5325d75', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
338INSERT INTO "public"."app_session" VALUES ('ac099cc8dd2e41066336ac18c7f2a109', 'admin', '2016-04-03 16:49:32', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-03 16:49:32', '634739c1bd2be4ae02379329c6608895', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
339INSERT INTO "public"."app_session" VALUES ('b57a5c5a6d87918f2829dade7b15027c', 'admin', '2016-05-02 14:19:34', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-05-02 13:44:21', '08041c4bc4ea9c4d602362d3d8fe91aa', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
340INSERT INTO "public"."app_session" VALUES ('b80447766a674e09446a0df2b45fb15b', 'admin', '2016-05-12 14:11:21', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:46.0) Gecko/20100101 Firefox/46.0', '1', '2016-05-12 14:11:06', '7f71790289f0bca65cb030734e2d824f', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1","function_access":"Administrator","inquiry_access":"Administrator"}');
341INSERT INTO "public"."app_session" VALUES ('bf01df12545caccb6e795feed018f717', 'admin', '2016-04-16 14:23:48', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-16 14:23:48', '9db3dc49ea3e9fc1955c055ed5a32355', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
342INSERT INTO "public"."app_session" VALUES ('cfb69f23af72b1425d3fd444f7c59ed7', 'admin', '2017-08-08 18:14:57', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36', '1', '2017-08-08 17:47:47', '7acdb95e14f0abf0be0a0c21a66087d3', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1","function_access":"Administrator","inquiry_access":"Administrator"}');
343INSERT INTO "public"."app_session" VALUES ('e6f0372a7988c436ba8556e5f23dd738', 'admin', '2016-04-13 13:17:20', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-13 13:17:20', '5cd3189bd33d214e92422fa00da18840', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
344INSERT INTO "public"."app_session" VALUES ('e8315ae9fcae01c1e95473ea0307684c', 'admin', '2016-05-05 16:55:22', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-05-05 16:31:01', 'b19157f9338d93c34715460da7f100e0', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
345INSERT INTO "public"."app_session" VALUES ('ebc83c43b6f308e69e7f113129385dae', 'admin', '2016-05-07 02:13:48', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:46.0) Gecko/20100101 Firefox/46.0', '1', '2016-05-07 02:13:48', '12cf3db84d60815eaaa09e0e0abdbb76', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1","function_access":"Administrator","inquiry_access":"Administrator"}');
346INSERT INTO "public"."app_session" VALUES ('ebf77eeba9396d396de8be0897ed86ab', 'admin', '2017-08-09 14:00:57', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.90 Safari/537.36', '1', '2017-08-09 13:13:34', '4a64e3a7c1f8422dd6a3172bbbf88f05', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1","function_access":"Administrator","inquiry_access":"Administrator"}');
347INSERT INTO "public"."app_session" VALUES ('ef5a534f92dc016d0183c89309594f7d', 'admin', '2016-04-13 13:18:28', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:45.0) Gecko/20100101 Firefox/45.0', '1', '2016-04-13 13:18:28', '5d5b6a8f8d3a6f0865d849087463ca42', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1"}');
348INSERT INTO "public"."app_session" VALUES ('f532c51354fffe1972e3dd359775b024', 'admin', '2016-05-14 12:38:00', '192.168.56.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:46.0) Gecko/20100101 Firefox/46.0', '1', '2016-05-14 12:20:18', 'ef1d92aa466bca563acbc1603d168987', '{"username":"admin","first_name":"admin","last_name":"application","email":"admin@spasi.com","status":"1","function_access":"Administrator","inquiry_access":"Administrator"}');
349
350-- ----------------------------
351-- Table structure for app_upload
352-- ----------------------------
353DROP TABLE IF EXISTS "public"."app_upload";
354CREATE TABLE "public"."app_upload" (
355"upl_id" varchar(10) COLLATE "default" NOT NULL,
356"file_name" varchar(200) COLLATE "default" NOT NULL,
357"filepath" varchar(1000) COLLATE "default" NOT NULL,
358"filetype" varchar(10) COLLATE "default" NOT NULL,
359"filesize" float8 NOT NULL,
360"filetable" varchar(100) COLLATE "default" NOT NULL,
361"filefield" varchar(100) COLLATE "default" NOT NULL,
362"pk1_name" varchar(50) COLLATE "default" NOT NULL,
363"pk1_value" varchar(10) COLLATE "default" NOT NULL,
364"pk2_name" varchar(50) COLLATE "default",
365"pk2_value" varchar(10) COLLATE "default",
366"pk3_name" varchar(50) COLLATE "default",
367"pk3_value" varchar(10) COLLATE "default",
368"is_delete" int4,
369"c_time" timestamp(6),
370"c_user" varchar(50) COLLATE "default",
371"m_time" timestamp(6),
372"m_user" varchar(50) COLLATE "default",
373"d_time" timestamp(6),
374"d_user" varchar(50) COLLATE "default"
375)
376WITH (OIDS=FALSE)
377
378;
379
380-- ----------------------------
381-- Records of app_upload
382-- ----------------------------
383INSERT INTO "public"."app_upload" VALUES ('UPL-000001', 'IMG_1846.JPG', '/i/photo/0/b/e/0be0b0e204a5ed414e412dd5174b8c4b_img_1846.jpg', 'jpg', '934288', 'exp_basic_crud', 'photo', 'fra_id', 'FRA-000001', '', '', '', '', null, '2016-05-09 07:54:18', 'admin', null, null, null, null);
384INSERT INTO "public"."app_upload" VALUES ('UPL-000002', 'Tugas Data.docx', '/i/upload/1/6/8/168f9e3edde571ad1b8222d17750ec40_tugas_data.docx', 'docx', '19641', 'exp_basic_crud', 'attachment', 'fra_id', 'FRA-000001', '', '', '', '', null, '2016-05-09 07:54:18', 'admin', null, null, null, null);
385INSERT INTO "public"."app_upload" VALUES ('UPL-000003', 'Tugas Data.docx', '/i/upload/8/5/a/85a52513c9dc47033ccbbcbce5dc86cb_tugas_data.docx', 'docx', '19641', 'exp_basic_crud', 'attachment', 'fra_id', 'FRA-000001', '', '', '', '', null, '2016-05-09 07:54:18', 'admin', null, null, null, null);
386
387-- ----------------------------
388-- Table structure for app_user
389-- ----------------------------
390DROP TABLE IF EXISTS "public"."app_user";
391CREATE TABLE "public"."app_user" (
392"usr_id" varchar(10) COLLATE "default",
393"username" varchar(25) COLLATE "default",
394"email" varchar(255) COLLATE "default",
395"full_name" varchar(65) COLLATE "default",
396"password" varchar(60) COLLATE "default",
397"counter" numeric(38),
398"status" char(1) COLLATE "default",
399"remark" varchar(255) COLLATE "default",
400"change_password" int4,
401"function_access" varchar(100) COLLATE "default",
402"inquiry_access" varchar(100) COLLATE "default",
403"is_delete" char(1) COLLATE "default",
404"c_time" timestamp(6),
405"c_user" varchar(50) COLLATE "default",
406"m_time" timestamp(6),
407"m_user" varchar(50) COLLATE "default",
408"d_time" timestamp(6),
409"d_user" varchar(50) COLLATE "default"
410)
411WITH (OIDS=FALSE)
412
413;
414
415-- ----------------------------
416-- Records of app_user
417-- ----------------------------
418INSERT INTO "public"."app_user" VALUES ('USR-000001', 'admin', 'admin@dms_spasi.com', 'Administrator', '$2y$10$M3SBdEK5AXsLCKNk3bYQre7Vfz9c67hA3.8hjXCpGpKoEfxS/5pSu', '0', '1', null, null, 'SuperUser', 'SuperUser', 'N', '2016-05-13 08:34:45', 'USR-000001', '2016-05-13 08:34:45', 'USR-000001', null, null);
419INSERT INTO "public"."app_user" VALUES ('USR-000003', 'aldi', 'aldi@gmail.com', 'Aldi 24', '$2y$10$XpESax79tOUCVZFA4Y5uwO8MZ/sOHnIRGcOfFOEadmn7c1S7l0r0u', '0', '1', null, null, 'Default', 'Default', 'N', '2017-08-29 04:11:08', 'USR-000001', '2017-08-29 04:11:08', 'USR-000001', null, null);
420INSERT INTO "public"."app_user" VALUES ('USR-000004', 'luviann', 'user123@gmail.com', 'monkeydluffy', '$2y$10$XpESax79tOUCVZFA4Y5uwO8MZ/sOHnIRGcOfFOEadmn7c1S7l0r0u', '0', '1', null, null, 'Default', null, 'N', '2017-09-18 05:58:51', 'USR-000001', '2017-09-18 05:59:34', 'USR-000001', '2017-09-26 09:49:28', 'USR-000001');
421INSERT INTO "public"."app_user" VALUES ('USR-000006', 'monika', 'monika@gmail.com', 'Monika', '$2y$10$XpESax79tOUCVZFA4Y5uwO8MZ/sOHnIRGcOfFOEadmn7c1S7l0r0u', '0', '1', null, null, 'AdminDokumen', null, 'N', '2017-09-18 09:33:53', 'USR-000001', '2017-09-18 09:33:53', 'USR-000001', null, null);
422
423-- ----------------------------
424-- Table structure for app_user_password
425-- ----------------------------
426DROP TABLE IF EXISTS "public"."app_user_password";
427CREATE TABLE "public"."app_user_password" (
428"pass_log_id" varchar(10) COLLATE "default" NOT NULL,
429"account_user_code" varchar(10) COLLATE "default",
430"user_password" varchar(150) COLLATE "default",
431"c_time" timestamp(6),
432"c_user" varchar(10) COLLATE "default",
433"usr_id" varchar(10) COLLATE "default"
434)
435WITH (OIDS=FALSE)
436
437;
438COMMENT ON COLUMN "public"."app_user_password"."usr_id" IS 'foreign key from app_user';
439
440-- ----------------------------
441-- Records of app_user_password
442-- ----------------------------
443INSERT INTO "public"."app_user_password" VALUES ('201231', '20160101', 'CDE', '2017-02-22 22:27:32', null, null);
444INSERT INTO "public"."app_user_password" VALUES ('201232', '20160101', '123', '2017-02-22 22:36:05', null, null);
445INSERT INTO "public"."app_user_password" VALUES ('201233', '20160101', 'ABC123', '2017-02-22 22:39:14', '', null);
446INSERT INTO "public"."app_user_password" VALUES ('201234', '20160101', 'TEST123', '2017-03-27 23:15:19', null, null);
447INSERT INTO "public"."app_user_password" VALUES ('201235', '20160101', 'CACA', '2017-03-31 16:36:12', null, null);
448INSERT INTO "public"."app_user_password" VALUES ('201236', '20160102', 'Caca0505', '2017-04-12 21:54:06', null, null);
449
450-- ----------------------------
451-- Table structure for app_workflow
452-- ----------------------------
453DROP TABLE IF EXISTS "public"."app_workflow";
454CREATE TABLE "public"."app_workflow" (
455"wkf_id" varchar(10) COLLATE "default" NOT NULL,
456"workflow_name" varchar(100) COLLATE "default",
457"workflow_description" text COLLATE "default",
458"workflow_url" varchar(50) COLLATE "default" NOT NULL,
459"c_time" timestamp(6),
460"c_user" varchar(50) COLLATE "default",
461"m_time" timestamp(0),
462"m_user" varchar(50) COLLATE "default",
463"d_time" timestamp(6),
464"d_user" varchar(50) COLLATE "default",
465"is_deleted" char(1) COLLATE "default"
466)
467WITH (OIDS=FALSE)
468
469;
470
471-- ----------------------------
472-- Records of app_workflow
473-- ----------------------------
474INSERT INTO "public"."app_workflow" VALUES ('WF-000001', 'Upload Dokumen', 'Upload Dokumen', 'wf_upload_dokumen', '2017-09-14 06:31:41', 'USR-000001', '2017-09-28 07:08:28', 'USR-000001', '2017-09-27 05:58:39', 'USR-000001', 'N');
475INSERT INTO "public"."app_workflow" VALUES ('WF-000002', 'Revisi Dokumen', 'Revisi Dokumen', 'wf_revisi_dokumen', '2017-09-28 08:38:19', 'USR-000001', '2017-09-28 08:38:19', 'USR-000001', null, null, 'N');
476
477-- ----------------------------
478-- Table structure for app_workflow_activity
479-- ----------------------------
480DROP TABLE IF EXISTS "public"."app_workflow_activity";
481CREATE TABLE "public"."app_workflow_activity" (
482"wfa_id" varchar(10) COLLATE "default" NOT NULL,
483"wkf_id" varchar(10) COLLATE "default",
484"activity_order" varchar(2) COLLATE "default",
485"activity_name" varchar(100) COLLATE "default",
486"activity_description" varchar(50) COLLATE "default",
487"activity_type" varchar(10) COLLATE "default",
488"activity_distribution" varchar(10) COLLATE "default",
489"activity_actor" varchar(100) COLLATE "default",
490"activity_store_prosedure" varchar(255) COLLATE "default",
491"c_time" timestamp(6),
492"c_user" varchar(50) COLLATE "default",
493"m_time" timestamp(0),
494"m_user" varchar(50) COLLATE "default",
495"d_time" timestamp(6),
496"d_user" varchar(50) COLLATE "default",
497"is_deleted" char(1) COLLATE "default",
498"activity_event_sp" varchar(255) COLLATE "default",
499"activity_prosess" varchar(255) COLLATE "default",
500"id_model" varchar(10) COLLATE "default"
501)
502WITH (OIDS=FALSE)
503
504;
505
506-- ----------------------------
507-- Records of app_workflow_activity
508-- ----------------------------
509INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000004', 'WF-000001', '1', 'Upload/Scan Data Dokumen', 'Melakukan Upload/Scan Data Dokumen', 'TY-000002', 'DST-000001', 'Default', null, '2017-09-28 20:39:38', 'USR-000001', '2017-09-28 20:39:38', 'USR-000001', '2017-09-27 05:58:39', 'USR-000001', 'N', null, null, 'MDL-000001');
510INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000005', 'WF-000001', '2', 'Approval Admin Dokumen', 'Membutuhkan Approval Admin Dokumen', 'TY-000002', 'DST-000002', 'AdminDokumen', null, '2017-09-18 05:37:24', 'USR-000001', '2017-09-27 05:58:39', 'USR-000001', '2017-09-27 05:58:39', 'USR-000001', 'N', 'data_upload_dokumen.php', null, 'MDL-000001');
511INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000007', 'WF-000002', '1', 'Upload/Scan Dokumen Revisi', 'Melakukan Upload/Scan Dokumen Revisi', 'TY-000002', 'DST-000001', 'Default', null, '2017-09-28 20:57:42', 'USR-000001', '2017-09-28 20:57:42', 'USR-000001', null, null, 'N', null, null, 'MDL-000001');
512INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000008', 'WF-000002', '2', 'Approval Admin Dokumen', 'Membutuhkan Approval Admin Dokumen', 'TY-000002', 'DST-000002', 'AdminDokumen', null, '2017-09-29 05:40:19', 'USR-000001', '2017-09-29 05:40:19', 'USR-000001', null, null, 'N', 'data_revisi_dokumen.php', null, 'MDL-000001');
513INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000010', 'WF-000001', '4', 'Selesai', 'Upload Dokumen Selesai', 'TY-000002', 'DST-000003', 'AdminDokumen', null, '2017-10-02 21:34:22', 'USR-000001', '2017-10-02 21:34:22', 'USR-000001', null, null, 'N', '', 'simpan_upload_dokumen.php', 'MDL-000001');
514INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000011', 'WF-000001', '5', 'Penolakan Upload/Scan Dokumen', 'Penolakan Upload Dokumen', 'TY-000002', 'DST-000003', 'AdminDokumen', null, '2017-10-01 08:59:23', 'USR-000001', '2017-10-01 08:59:23', 'USR-000001', null, null, 'N', '', 'tolak_upload_dokumen.php', 'MDL-000001');
515INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000012', 'WF-000002', '4', 'Selesai', 'Selesai', 'TY-000002', 'DST-000003', 'AdminDokumen', null, '2017-09-30 20:07:53', 'USR-000001', '2017-09-30 20:07:53', 'USR-000001', null, null, 'N', '', 'simpan_revisi_dokumen.php', 'MDL-000001');
516INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000013', 'WF-000002', '5', 'Penolakan Revisi Dokumen', 'Penolakan Revisi Dokumen', 'TY-000002', 'DST-000003', 'AdminDokumen', null, '2017-09-30 20:08:08', 'USR-000001', '2017-09-30 20:08:08', 'USR-000001', null, null, 'N', '', 'tolak_revisi_dokumen.php', 'MDL-000001');
517INSERT INTO "public"."app_workflow_activity" VALUES ('ACT-000014', 'WF-000001', '3', 'Revisi Upload Dokumen', 'Revisi Upload Dokumen', 'TY-000002', 'DST-000001', 'Default', null, '2017-09-30 22:23:43', 'USR-000001', '2017-09-30 22:23:43', 'USR-000001', null, null, 'N', 'revisi_upload_dokumen.php', 'update_revisi_dokumen.php', 'MDL-000002');
518
519-- ----------------------------
520-- Table structure for app_workflow_case
521-- ----------------------------
522DROP TABLE IF EXISTS "public"."app_workflow_case";
523CREATE TABLE "public"."app_workflow_case" (
524"wfc_id" varchar(10) COLLATE "default" NOT NULL,
525"wkf_id" varchar(10) COLLATE "default",
526"case_activity" varchar(10) COLLATE "default",
527"case_type" varchar(10) COLLATE "default",
528"case_actor" varchar(100) COLLATE "default",
529"case_number" varchar(32) COLLATE "default",
530"case_date" timestamp(6),
531"case_status" varchar(2) COLLATE "default",
532"c_time" timestamp(6),
533"c_user" varchar(32) COLLATE "default",
534"m_time" timestamp(6),
535"m_user" varchar(32) COLLATE "default"
536)
537WITH (OIDS=FALSE)
538
539;
540COMMENT ON COLUMN "public"."app_workflow_case"."wkf_id" IS 'FK';
541COMMENT ON COLUMN "public"."app_workflow_case"."case_number" IS 'unique';
542COMMENT ON COLUMN "public"."app_workflow_case"."case_status" IS '0 = pending, 1 = tampil, 2= tolak';
543
544-- ----------------------------
545-- Records of app_workflow_case
546-- ----------------------------
547INSERT INTO "public"."app_workflow_case" VALUES ('WFC-000001', 'WF-000001', 'ACT-000010', 'TY-000002', 'AdminDokumen', 'KSO-000001', '2017-10-02 19:14:32', '1', '2017-10-02 19:14:32', 'USR-000003', '2017-10-02 21:12:00', 'USR-000006');
548INSERT INTO "public"."app_workflow_case" VALUES ('WFC-000002', 'WF-000001', 'ACT-000005', 'TY-000002', 'AdminDokumen', 'KSO-000002', '2017-10-02 21:13:57', '0', '2017-10-02 21:13:57', 'USR-000003', '2017-10-02 21:13:57', 'USR-000003');
549
550-- ----------------------------
551-- Table structure for app_workflow_case_detail
552-- ----------------------------
553DROP TABLE IF EXISTS "public"."app_workflow_case_detail";
554CREATE TABLE "public"."app_workflow_case_detail" (
555"id" int4 DEFAULT nextval('app_workflow_case_detail_id_seq'::regclass) NOT NULL,
556"wfc_id" varchar(10) COLLATE "default",
557"detail_activity" varchar(100) COLLATE "default",
558"detail_actor" varchar(32) COLLATE "default",
559"detail_status" varchar(2) COLLATE "default",
560"detail_remarks" text COLLATE "default",
561"detail_activity_code" varchar(10) COLLATE "default",
562"c_time" date,
563"c_user" varchar(32) COLLATE "default"
564)
565WITH (OIDS=FALSE)
566
567;
568COMMENT ON COLUMN "public"."app_workflow_case_detail"."wfc_id" IS 'FK';
569
570-- ----------------------------
571-- Records of app_workflow_case_detail
572-- ----------------------------
573INSERT INTO "public"."app_workflow_case_detail" VALUES ('95', 'WFC-000001', 'Upload/Scan Data Dokumen', 'Default', '1', 'adasdasf ', 'ACT-000004', '2017-10-02', 'USR-000003');
574INSERT INTO "public"."app_workflow_case_detail" VALUES ('96', 'WFC-000001', 'Approval Admin Dokumen', 'AdminDokumen', '1', 'done', 'ACT-000005', '2017-10-02', 'USR-000006');
575INSERT INTO "public"."app_workflow_case_detail" VALUES ('97', 'WFC-000001', 'Revisi Upload Dokumen', 'Default', '1', 'di coba', 'ACT-000014', '2017-10-02', 'USR-000003');
576INSERT INTO "public"."app_workflow_case_detail" VALUES ('98', 'WFC-000001', 'Approval Admin Dokumen', 'AdminDokumen', '1', 'done', 'ACT-000005', '2017-10-02', 'USR-000006');
577INSERT INTO "public"."app_workflow_case_detail" VALUES ('99', 'WFC-000001', 'Selesai', 'AdminDokumen', '1', 'done', 'ACT-000010', '2017-10-02', 'USR-000006');
578INSERT INTO "public"."app_workflow_case_detail" VALUES ('100', 'WFC-000002', 'Upload/Scan Data Dokumen', 'Default', '1', ' caca', 'ACT-000004', '2017-10-02', 'USR-000003');
579INSERT INTO "public"."app_workflow_case_detail" VALUES ('101', 'WFC-000002', 'Approval Admin Dokumen', 'AdminDokumen', '0', ' caca', 'ACT-000005', '2017-10-02', 'USR-000003');
580
581-- ----------------------------
582-- Table structure for app_workflow_sequence
583-- ----------------------------
584DROP TABLE IF EXISTS "public"."app_workflow_sequence";
585CREATE TABLE "public"."app_workflow_sequence" (
586"wfo_id" varchar(10) COLLATE "default" NOT NULL,
587"wkf_id" varchar(10) COLLATE "default",
588"sequence_type" varchar(10) COLLATE "default",
589"sequence_approve" varchar(10) COLLATE "default",
590"sequence_not_approve" varchar(10) COLLATE "default",
591"sequence_formula" varchar(200) COLLATE "default",
592"c_time" timestamp(6),
593"c_user" varchar(50) COLLATE "default",
594"m_time" timestamp(0),
595"m_user" varchar(50) COLLATE "default",
596"d_time" timestamp(6),
597"d_user" varchar(50) COLLATE "default",
598"is_deleted" char(1) COLLATE "default",
599"sequence_order" int4,
600"sequence_activity" varchar(10) COLLATE "default"
601)
602WITH (OIDS=FALSE)
603
604;
605
606-- ----------------------------
607-- Records of app_workflow_sequence
608-- ----------------------------
609INSERT INTO "public"."app_workflow_sequence" VALUES ('SEQ-000001', 'WF-000001', 'TYS-000001', 'ACT-000005', 'ACT-000011', null, '2017-09-28 20:42:17', 'USR-000001', '2017-09-28 20:42:17', 'USR-000001', null, null, 'N', '1', 'ACT-000004');
610INSERT INTO "public"."app_workflow_sequence" VALUES ('SEQ-000002', 'WF-000001', 'TYS-000001', 'ACT-000010', 'ACT-000014', null, '2017-09-28 20:43:43', 'USR-000001', '2017-09-30 22:08:13', 'USR-000001', null, null, 'N', '2', 'ACT-000005');
611INSERT INTO "public"."app_workflow_sequence" VALUES ('SEQ-000003', 'WF-000002', 'TYS-000001', 'ACT-000008', 'ACT-000013', null, '2017-09-28 20:59:50', 'USR-000001', '2017-09-28 20:59:50', 'USR-000001', null, null, 'N', '1', 'ACT-000007');
612INSERT INTO "public"."app_workflow_sequence" VALUES ('SEQ-000004', 'WF-000002', 'TYS-000001', 'ACT-000012', 'ACT-000013', null, '2017-09-28 21:02:54', 'USR-000001', '2017-09-28 21:02:54', 'USR-000001', null, null, 'N', '2', 'ACT-000008');
613INSERT INTO "public"."app_workflow_sequence" VALUES ('SEQ-000005', 'WF-000001', 'TYS-000001', 'ACT-000005', 'ACT-000011', null, '2017-09-30 22:08:42', 'USR-000001', '2017-09-30 22:08:42', 'USR-000001', null, null, 'N', '3', 'ACT-000014');
614
615-- ----------------------------
616-- Table structure for doc_files
617-- ----------------------------
618DROP TABLE IF EXISTS "public"."doc_files";
619CREATE TABLE "public"."doc_files" (
620"dfi_id" varchar(10) COLLATE "default" NOT NULL,
621"rca_id" varchar(10) COLLATE "default",
622"file_code" varchar(50) COLLATE "default" NOT NULL,
623"file_name" varchar(150) COLLATE "default",
624"file_description" text COLLATE "default",
625"file_keyword" varchar(250) COLLATE "default",
626"file_title" varchar(250) COLLATE "default",
627"file_size" varchar(10) COLLATE "default",
628"file_mime_type" varchar(30) COLLATE "default",
629"file_path" varchar(150) COLLATE "default",
630"c_time" timestamp(6),
631"c_user" varchar(255) COLLATE "default",
632"m_time" timestamp(6),
633"m_user" varchar(32) COLLATE "default",
634"is_deleted" char(1) COLLATE "default",
635"d_time" timestamp(6),
636"d_user" varchar(32) COLLATE "default",
637"jenis" char(1) COLLATE "default",
638"status" char(1) COLLATE "default",
639"case_number" varchar(32) COLLATE "default",
640"case_status" char(1) COLLATE "default"
641)
642WITH (OIDS=FALSE)
643
644;
645COMMENT ON COLUMN "public"."doc_files"."jenis" IS 'OCR = 1, Non OCR = 2, Upload = 3';
646COMMENT ON COLUMN "public"."doc_files"."status" IS '0 = pending, 1 = tampil, 2= tidak tampil / tolak';
647COMMENT ON COLUMN "public"."doc_files"."case_status" IS '0 = pending, 1 = tampil, 2= tidak tampil / tolak, null = tampil / tanpa workflow';
648
649-- ----------------------------
650-- Records of doc_files
651-- ----------------------------
652
653-- ----------------------------
654-- Table structure for doc_files_relation
655-- ----------------------------
656DROP TABLE IF EXISTS "public"."doc_files_relation";
657CREATE TABLE "public"."doc_files_relation" (
658"dfr_id" varchar(10) COLLATE "default" NOT NULL,
659"dfi_id" varchar(10) COLLATE "default",
660"relation_code" varchar(32) COLLATE "default",
661"relation_remarks" text COLLATE "default",
662"c_time" timestamp(0),
663"c_user" varchar(255) COLLATE "default",
664"m_time" timestamp(0),
665"m_user" varchar(32) COLLATE "default",
666"is_deleted" char(1) COLLATE "default",
667"d_time" timestamp(6),
668"d_user" varchar(32) COLLATE "default",
669"dfi_relation_id" varchar(10) COLLATE "default"
670)
671WITH (OIDS=FALSE)
672
673;
674
675-- ----------------------------
676-- Records of doc_files_relation
677-- ----------------------------
678
679-- ----------------------------
680-- Table structure for doc_files_version
681-- ----------------------------
682DROP TABLE IF EXISTS "public"."doc_files_version";
683CREATE TABLE "public"."doc_files_version" (
684"dfv_id" varchar(10) COLLATE "default" NOT NULL,
685"dfi_id" varchar(10) COLLATE "default",
686"version_code" varchar(32) COLLATE "default",
687"version_remarks" text COLLATE "default",
688"version_path" varchar(150) COLLATE "default",
689"c_time" timestamp(6),
690"c_user" varchar(32) COLLATE "default",
691"case_number" varchar(32) COLLATE "default",
692"case_status" char(1) COLLATE "default"
693)
694WITH (OIDS=FALSE)
695
696;
697COMMENT ON COLUMN "public"."doc_files_version"."case_status" IS '0 = pending, 1 = tampil, 2= tidak tampil / tolak, null = tampil / tanpa workflow';
698
699-- ----------------------------
700-- Records of doc_files_version
701-- ----------------------------
702
703-- ----------------------------
704-- Table structure for doc_notes
705-- ----------------------------
706DROP TABLE IF EXISTS "public"."doc_notes";
707CREATE TABLE "public"."doc_notes" (
708"doc_notes_id" varchar(10) COLLATE "default",
709"dfi_id" varchar(10) COLLATE "default",
710"notes" text COLLATE "default",
711"c_time" timestamp(6),
712"c_user" varchar(32) COLLATE "default",
713"is_deleted" char(1) COLLATE "default"
714)
715WITH (OIDS=FALSE)
716
717;
718
719-- ----------------------------
720-- Records of doc_notes
721-- ----------------------------
722INSERT INTO "public"."doc_notes" VALUES ('NOT-000001', 'DFI-000001', 'test', '2017-09-26 04:56:15', 'USR-000001', 'N');
723
724-- ----------------------------
725-- Table structure for reff_category
726-- ----------------------------
727DROP TABLE IF EXISTS "public"."reff_category";
728CREATE TABLE "public"."reff_category" (
729"rca_id" varchar(10) COLLATE "default" NOT NULL,
730"rca_parent_id" varchar(10) COLLATE "default",
731"category_code" varchar(50) COLLATE "default" NOT NULL,
732"category_name" varchar(150) COLLATE "default",
733"category_description" text COLLATE "default",
734"category_keyword" varchar(250) COLLATE "default",
735"category_icon" varchar(50) COLLATE "default",
736"c_time" timestamp(6),
737"c_user" varchar(32) COLLATE "default",
738"m_time" timestamp(6),
739"m_user" varchar(32) COLLATE "default",
740"is_deleted" char(1) COLLATE "default",
741"d_time" timestamp(6),
742"d_user" varchar(32) COLLATE "default",
743"url" varchar(255) COLLATE "default"
744)
745WITH (OIDS=FALSE)
746
747;
748
749-- ----------------------------
750-- Records of reff_category
751-- ----------------------------
752INSERT INTO "public"."reff_category" VALUES ('RCA-000001', '0', 'CC001', 'Category', 'Category', 'Category', 'fa fa-book', '2017-08-24 09:55:57', 'USR-000001', '2017-09-22 05:43:34', 'USR-000001', 'N', null, null, '#');
753INSERT INTO "public"."reff_category" VALUES ('RCA-000002', 'RCA-000001', 'CC002', 'Scan Non OCR', 'Scan Folder Non OCR', 'Non OCR, Folder of Scan Non OCR', 'fa fa-search', '2017-08-24 09:55:57', 'USR-000001', '2017-09-22 05:43:26', 'USR-000001', 'N', null, null, 'scan_non_ocr');
754INSERT INTO "public"."reff_category" VALUES ('RCA-000003', 'RCA-000001', 'CC003', 'Scan OCR', 'Scan Document OCR', 'ocr document, scan ocr', 'ocr-icon', '2017-08-28 04:47:59', 'USR-000001', '2017-09-28 06:35:24', 'USR-000001', 'N', null, null, 'scan_ocr');
755INSERT INTO "public"."reff_category" VALUES ('RCA-000004', 'RCA-000001', 'CC004', 'Document Upload', 'Only Document Upload Non Scan', 'Document Upload, Non Scan', 'non-scan', '2017-08-28 04:49:35', 'USR-000001', '2017-09-27 07:10:02', 'USR-000001', 'N', null, null, 'document_upload');
756
757-- ----------------------------
758-- Alter Sequences Owned By 
759-- ----------------------------
760ALTER SEQUENCE "public"."app_workflow_case_detail_id_seq" OWNED BY "app_workflow_case_detail"."id";
761
762-- ----------------------------
763-- Primary Key structure for table app_inquiry_access
764-- ----------------------------
765ALTER TABLE "public"."app_inquiry_access" ADD PRIMARY KEY ("id");
766
767-- ----------------------------
768-- Primary Key structure for table app_list_case_activity
769-- ----------------------------
770ALTER TABLE "public"."app_list_case_activity" ADD PRIMARY KEY ("id_model");
771
772-- ----------------------------
773-- Primary Key structure for table app_list_type_activity
774-- ----------------------------
775ALTER TABLE "public"."app_list_type_activity" ADD PRIMARY KEY ("id_list_type");
776
777-- ----------------------------
778-- Primary Key structure for table app_workflow
779-- ----------------------------
780ALTER TABLE "public"."app_workflow" ADD PRIMARY KEY ("wkf_id", "workflow_url");
781
782-- ----------------------------
783-- Primary Key structure for table app_workflow_activity
784-- ----------------------------
785ALTER TABLE "public"."app_workflow_activity" ADD PRIMARY KEY ("wfa_id");
786
787-- ----------------------------
788-- Primary Key structure for table app_workflow_case
789-- ----------------------------
790ALTER TABLE "public"."app_workflow_case" ADD PRIMARY KEY ("wfc_id");
791
792-- ----------------------------
793-- Primary Key structure for table app_workflow_case_detail
794-- ----------------------------
795ALTER TABLE "public"."app_workflow_case_detail" ADD PRIMARY KEY ("id");
796
797-- ----------------------------
798-- Primary Key structure for table app_workflow_sequence
799-- ----------------------------
800ALTER TABLE "public"."app_workflow_sequence" ADD PRIMARY KEY ("wfo_id");
801
802-- ----------------------------
803-- Primary Key structure for table doc_files
804-- ----------------------------
805ALTER TABLE "public"."doc_files" ADD PRIMARY KEY ("dfi_id", "file_code");
806
807-- ----------------------------
808-- Primary Key structure for table doc_files_relation
809-- ----------------------------
810ALTER TABLE "public"."doc_files_relation" ADD PRIMARY KEY ("dfr_id");
811
812-- ----------------------------
813-- Primary Key structure for table doc_files_version
814-- ----------------------------
815ALTER TABLE "public"."doc_files_version" ADD PRIMARY KEY ("dfv_id");
816
817-- ----------------------------
818-- Primary Key structure for table reff_category
819-- ----------------------------
820ALTER TABLE "public"."reff_category" ADD PRIMARY KEY ("rca_id", "category_code");