· 7 years ago · Oct 30, 2018, 05:52 PM
1-- Adminer 4.6.3 PostgreSQL dump
2
3/*
4
5THIS SQL FILE HAS NO INSERT COMMAND
6IF U WANT THE ONE WITH INSERT, POST HELP IN PHP INDONESIA
7
8DB_CONNECTION=pg
9DB_HOST=ec2-107-21-248-177.compute-1.amazonaws.com
10DB_PORT=5432
11DB_USER=oxrqdbshwwdjjz
12DB_PASSWORD=****
13DB_DATABASE=d385b7g060r9bk
14
15*/
16
17\connect "d385b7g060r9bk";
18
19DROP VIEW IF EXISTS "daftar_item";
20CREATE TABLE "daftar_item" ("id_item" integer, "nm_item" character varying(100), "geojson" json, "id_titem" smallint, "tipe_item" character varying(50), "kategori_item" character varying(100), "id_kitem" smallint);
21
22
23DROP VIEW IF EXISTS "lap_jawaban";
24CREATE TABLE "lap_jawaban" ("id_jawaban" integer, "nobp" character varying(15), "id_ujian" character varying(60), "id_soal" integer, "isi_soal" text, "jawaban" character varying(5), "jawaban_peserta" text, "bobot" smallint);
25
26
27DROP VIEW IF EXISTS "lap_kelas_kuliah";
28CREATE TABLE "lap_kelas_kuliah" ("id_kkuliah" integer, "id_kelas" integer, "id_kuliah" character varying(60), "nm_kelas" character varying(10));
29
30
31DROP VIEW IF EXISTS "lap_kuliah";
32CREATE TABLE "lap_kuliah" ("id_kuliah" character varying(40), "kd_matkul" character varying(15), "nm_matkul" character varying(100), "nidn" character varying(11), "nm_dosen" character varying(100), "id_kelas" integer[], "nm_kelas" character varying[], "tahun_akademik" character varying(5), "status_kuliah" smallint, "nm_status_kuliah" character varying(20));
33
34
35DROP VIEW IF EXISTS "lap_peserta_kuliah";
36CREATE TABLE "lap_peserta_kuliah" ("id_peserta" character varying(60), "id_kuliah" character varying(40), "kd_matkul" character varying(15), "nm_matkul" character varying(100), "nidn" character varying(11), "nm_dosen" character varying(100), "tahun_akademik" character varying(5), "nobp" character varying(15), "nm_mahasiswa" character varying(100), "status_peserta" smallint, "nm_status_peserta" character varying(20), "status_kelas_peserta" smallint, "nm_status_kelas_peserta" character varying(20), "id_kelas" integer, "nm_kelas" character varying(10));
37
38
39DROP VIEW IF EXISTS "lap_peserta_ujian";
40CREATE TABLE "lap_peserta_ujian" ("id_ujian" character varying(40), "hari" date, "mulai" time without time zone, "selesai" time without time zone, "deskripsi" character varying(100), "status_ujian" smallint, "nm_status_ujian" character varying(20), "id_jsoal" smallint, "nm_jsoal" character varying(20), "id_jujian" smallint, "nm_jujian" character varying(10), "kd_matkul" character varying(15), "nm_matkul" character varying(100), "nidn" character varying(11), "nm_dosen" character varying(100), "id_kuliah" character varying(40), "nobp" character varying(15), "nm_mahasiswa" character varying(100), "id_kelas" integer, "nm_kelas" character varying(10), "nm_ujian" text);
41
42
43DROP VIEW IF EXISTS "lap_soal";
44CREATE TABLE "lap_soal" ("id_soal" integer, "isi_soal" text, "pilihanGanda" json, "id_jsoal" smallint, "bobot" smallint, "jawaban" character varying(5), "nm_jsoal" character varying(20));
45
46
47DROP VIEW IF EXISTS "lap_soal_ujian";
48CREATE TABLE "lap_soal_ujian" ("id_ujian" character varying(40), "id_soal" integer, "isi_soal" text, "pilihanGanda" json, "id_jsoal" smallint, "bobot" smallint, "jawaban" character varying(5));
49
50
51DROP VIEW IF EXISTS "lap_ujian";
52CREATE TABLE "lap_ujian" ("id_ujian" character varying(40), "hari" date, "mulai" time without time zone, "selesai" time without time zone, "deskripsi" character varying(100), "status_ujian" smallint, "nm_status_ujian" character varying(20), "id_jsoal" smallint, "nm_jsoal" character varying(20), "id_jujian" smallint, "nm_jujian" character varying(10), "id_kuliah" character varying(40), "kd_matkul" character varying(15), "nm_matkul" character varying(100), "nidn" character varying(11), "nm_dosen" character varying(100), "id_kelas" integer[], "nm_kelas" character varying[], "tahun_akademik" character varying(5));
53
54
55DROP VIEW IF EXISTS "lap_user";
56CREATE TABLE "lap_user" ("id_user" integer, "username" character varying(30), "password" text, "id_juser" smallint, "nm_juser" character varying(20), "status_user" smallint);
57
58
59DROP VIEW IF EXISTS "nilai_rata";
60CREATE TABLE "nilai_rata" ("nm_dosen" character varying(100), "nm_matkul" character varying(100), "nm_jujian" character varying(10), "id_ujian" character varying(40), "avg" numeric(5,2));
61
62
63DROP TABLE IF EXISTS "peserta_ujian";
64CREATE TABLE "public"."peserta_ujian" (
65 "id_ujian" character varying(40),
66 "nobp" character varying(15),
67 "nm_mahasiswa" character varying(100),
68 "id_kelas" integer,
69 "nm_kelas" character varying(10),
70 "nilai" integer,
71 "status_ujian_peserta" integer,
72 "nm_status_ujian_peserta" text
73) WITH (oids = false);
74
75
76DROP VIEW IF EXISTS "statistik";
77CREATE TABLE "statistik" ("total_kuliah" bigint, "total_ujian" bigint, "total_mahasiswa" bigint, "total_dosen" bigint);
78
79
80DROP TABLE IF EXISTS "tbdosen";
81DROP SEQUENCE IF EXISTS tbdosen_id_dosen_seq;
82CREATE SEQUENCE tbdosen_id_dosen_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
83
84CREATE TABLE "public"."tbdosen" (
85 "id_dosen" integer DEFAULT nextval('tbdosen_id_dosen_seq') NOT NULL,
86 "nm_dosen" character varying(100) NOT NULL,
87 "nidn" character varying(15) NOT NULL,
88 "status_dosen" smallint DEFAULT '1' NOT NULL,
89 CONSTRAINT "tbdosen_id_dosen" PRIMARY KEY ("id_dosen"),
90 CONSTRAINT "tbdosen_nidn" UNIQUE ("nidn")
91) WITH (oids = false);
92
93DELIMITER ;;
94
95CREATE TRIGGER "tambahUserDosen" BEFORE INSERT ON "public"."tbdosen" FOR EACH ROW EXECUTE PROCEDURE tambahuserdosen();;
96
97DELIMITER ;
98
99DROP TABLE IF EXISTS "tbhasil_ujian";
100DROP SEQUENCE IF EXISTS tbhasil_ujian_id_hasil_seq;
101CREATE SEQUENCE tbhasil_ujian_id_hasil_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
102
103CREATE TABLE "public"."tbhasil_ujian" (
104 "id_hasil" integer DEFAULT nextval('tbhasil_ujian_id_hasil_seq') NOT NULL,
105 "id_ujian" character varying(40) NOT NULL,
106 "nobp" character varying(15) NOT NULL,
107 "nilai" smallint NOT NULL,
108 CONSTRAINT "tbhasil_ujian_id_hasil" PRIMARY KEY ("id_hasil"),
109 CONSTRAINT "tbhasil_ujian_id_ujian_fkey" FOREIGN KEY (id_ujian) REFERENCES tbujian(id_ujian) ON UPDATE CASCADE ON DELETE CASCADE NOT DEFERRABLE
110) WITH (oids = false);
111
112CREATE INDEX "tbhasil_ujian_id_ujian" ON "public"."tbhasil_ujian" USING btree ("id_ujian");
113
114CREATE INDEX "tbhasil_ujian_nobp" ON "public"."tbhasil_ujian" USING btree ("nobp");
115
116DROP TABLE IF EXISTS "tbjawaban";
117DROP SEQUENCE IF EXISTS tbjawaban_id_jawaban_seq;
118CREATE SEQUENCE tbjawaban_id_jawaban_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
119
120CREATE TABLE "public"."tbjawaban" (
121 "id_jawaban" integer DEFAULT nextval('tbjawaban_id_jawaban_seq') NOT NULL,
122 "id_ujian" character varying(60) NOT NULL,
123 "nobp" character varying(15) NOT NULL,
124 "jawaban" text NOT NULL,
125 "id_soal" integer NOT NULL,
126 CONSTRAINT "tbjawaban_id_jawaban" PRIMARY KEY ("id_jawaban"),
127 CONSTRAINT "tbjawaban_id_ujian_fkey" FOREIGN KEY (id_ujian) REFERENCES tbujian(id_ujian) ON UPDATE CASCADE ON DELETE CASCADE NOT DEFERRABLE
128) WITH (oids = false);
129
130CREATE INDEX "tbjawaban_id_soal" ON "public"."tbjawaban" USING btree ("id_soal");
131
132CREATE INDEX "tbjawaban_id_ujian" ON "public"."tbjawaban" USING btree ("id_ujian");
133
134CREATE INDEX "tbjawaban_nobp" ON "public"."tbjawaban" USING btree ("nobp");
135
136DROP TABLE IF EXISTS "tbjenis_soal";
137DROP SEQUENCE IF EXISTS tbjenis_soal_id_jsoal_seq;
138CREATE SEQUENCE tbjenis_soal_id_jsoal_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
139
140CREATE TABLE "public"."tbjenis_soal" (
141 "id_jsoal" integer DEFAULT nextval('tbjenis_soal_id_jsoal_seq') NOT NULL,
142 "nm_jsoal" character varying(20) NOT NULL,
143 CONSTRAINT "tbjenis_soal_id_jsoal" PRIMARY KEY ("id_jsoal")
144) WITH (oids = false);
145
146DROP TABLE IF EXISTS "tbjenis_ujian";
147DROP SEQUENCE IF EXISTS tbjenis_ujian_id_jujian_seq;
148CREATE SEQUENCE tbjenis_ujian_id_jujian_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
149
150CREATE TABLE "public"."tbjenis_ujian" (
151 "id_jujian" integer DEFAULT nextval('tbjenis_ujian_id_jujian_seq') NOT NULL,
152 "nm_jujian" character varying(10) NOT NULL,
153 CONSTRAINT "tbjenis_ujian_id_jujian" PRIMARY KEY ("id_jujian")
154) WITH (oids = false);
155
156DROP TABLE IF EXISTS "tbjenis_user";
157DROP SEQUENCE IF EXISTS tbjenis_user_id_juser_seq;
158CREATE SEQUENCE tbjenis_user_id_juser_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
159
160CREATE TABLE "public"."tbjenis_user" (
161 "id_juser" integer DEFAULT nextval('tbjenis_user_id_juser_seq') NOT NULL,
162 "nm_juser" character varying(20) NOT NULL,
163 CONSTRAINT "tbjenis_user_id_juser" PRIMARY KEY ("id_juser")
164) WITH (oids = false);
165
166DROP TABLE IF EXISTS "tbkelas";
167DROP SEQUENCE IF EXISTS tbnama_kelas_id_kelas_seq;
168CREATE SEQUENCE tbnama_kelas_id_kelas_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
169
170CREATE TABLE "public"."tbkelas" (
171 "id_kelas" integer DEFAULT nextval('tbnama_kelas_id_kelas_seq') NOT NULL,
172 "nm_kelas" character varying(10) NOT NULL,
173 CONSTRAINT "tbkelas_id_kelas" PRIMARY KEY ("id_kelas")
174) WITH (oids = false);
175
176DROP TABLE IF EXISTS "tbkelas_kuliah";
177DROP SEQUENCE IF EXISTS tbkelas_ujian_id_kujian_seq;
178CREATE SEQUENCE tbkelas_ujian_id_kujian_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
179
180CREATE TABLE "public"."tbkelas_kuliah" (
181 "id_kkuliah" integer DEFAULT nextval('tbkelas_ujian_id_kujian_seq') NOT NULL,
182 "id_kuliah" character varying(60) NOT NULL,
183 "id_kelas" integer NOT NULL,
184 CONSTRAINT "tbkelas_kuliah_id_kkuliah" PRIMARY KEY ("id_kkuliah"),
185 CONSTRAINT "tbkelas_kuliah_id_kuliah_fkey" FOREIGN KEY (id_kuliah) REFERENCES tbkuliah(id_kuliah) ON UPDATE CASCADE ON DELETE CASCADE NOT DEFERRABLE
186) WITH (oids = false);
187
188DROP TABLE IF EXISTS "tbkuliah";
189CREATE TABLE "public"."tbkuliah" (
190 "id_kuliah" character varying(40) NOT NULL,
191 "nidn" character varying(11) NOT NULL,
192 "kd_matkul" character varying(15) NOT NULL,
193 "tahun_akademik" character varying(5) NOT NULL,
194 "status_kuliah" smallint DEFAULT '0' NOT NULL,
195 CONSTRAINT "tbkuliah_id_kuliah" PRIMARY KEY ("id_kuliah")
196) WITH (oids = false);
197
198CREATE INDEX "tbkuliah_kd_matkul" ON "public"."tbkuliah" USING btree ("kd_matkul");
199
200CREATE INDEX "tbkuliah_nidn" ON "public"."tbkuliah" USING btree ("nidn");
201
202DROP TABLE IF EXISTS "tbl_item_peta";
203DROP SEQUENCE IF EXISTS tbl_item_peta_id_item_seq;
204CREATE SEQUENCE tbl_item_peta_id_item_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
205
206CREATE TABLE "public"."tbl_item_peta" (
207 "id_item" integer DEFAULT nextval('tbl_item_peta_id_item_seq') NOT NULL,
208 "nm_item" character varying(100) NOT NULL,
209 "geojson" json NOT NULL,
210 "id_titem" smallint,
211 "id_kitem" smallint DEFAULT '1' NOT NULL,
212 CONSTRAINT "tbl_item_peta_id_item" PRIMARY KEY ("id_item")
213) WITH (oids = false);
214
215DROP TABLE IF EXISTS "tbl_kategori_item";
216DROP SEQUENCE IF EXISTS tbl_kategori_item_id_kitem_seq;
217CREATE SEQUENCE tbl_kategori_item_id_kitem_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
218
219CREATE TABLE "public"."tbl_kategori_item" (
220 "id_kitem" integer DEFAULT nextval('tbl_kategori_item_id_kitem_seq') NOT NULL,
221 "nm_kitem" character varying(100) NOT NULL,
222 "detail" character varying(255) NOT NULL,
223 CONSTRAINT "tbl_kategori_item_id_kitem" PRIMARY KEY ("id_kitem")
224) WITH (oids = false);
225
226
227DROP TABLE IF EXISTS "tbl_tipe_item";
228DROP SEQUENCE IF EXISTS tbl_tipe_item_id_titem_seq;
229CREATE SEQUENCE tbl_tipe_item_id_titem_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
230
231CREATE TABLE "public"."tbl_tipe_item" (
232 "id_titem" integer DEFAULT nextval('tbl_tipe_item_id_titem_seq') NOT NULL,
233 "nm_titem" character varying(50) NOT NULL,
234 "style" json NOT NULL,
235 CONSTRAINT "tbl_tipe_item_id_titem" PRIMARY KEY ("id_titem")
236) WITH (oids = false);
237
238DROP TABLE IF EXISTS "tbmahasiswa";
239DROP SEQUENCE IF EXISTS tbmahasiswa_id_mahasiswa_seq;
240CREATE SEQUENCE tbmahasiswa_id_mahasiswa_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
241
242CREATE TABLE "public"."tbmahasiswa" (
243 "id_mahasiswa" integer DEFAULT nextval('tbmahasiswa_id_mahasiswa_seq') NOT NULL,
244 "nm_mahasiswa" character varying(100) NOT NULL,
245 "nobp" character varying(15) NOT NULL,
246 "status_mahasiswa" smallint DEFAULT '1' NOT NULL,
247 CONSTRAINT "tbmahasiswa_id_mahasiswa" PRIMARY KEY ("id_mahasiswa"),
248 CONSTRAINT "tbmahasiswa_nobp" UNIQUE ("nobp")
249) WITH (oids = false);
250
251DELIMITER ;;
252
253CREATE TRIGGER "tambahUserMahasiswa" AFTER INSERT ON "public"."tbmahasiswa" FOR EACH ROW EXECUTE PROCEDURE tambahusermahasiswa();;
254
255DELIMITER ;
256
257DROP TABLE IF EXISTS "tbmatkul";
258DROP SEQUENCE IF EXISTS tbmatkul_id_matkul_seq1;
259CREATE SEQUENCE tbmatkul_id_matkul_seq1 INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
260
261CREATE TABLE "public"."tbmatkul" (
262 "id_matkul" integer DEFAULT nextval('tbmatkul_id_matkul_seq1') NOT NULL,
263 "kd_matkul" character varying(15) NOT NULL,
264 "nm_matkul" character varying(100) NOT NULL,
265 "sks" smallint NOT NULL,
266 "smt" smallint NOT NULL,
267 "status_matkul" smallint DEFAULT '1' NOT NULL,
268 CONSTRAINT "tbmatkul_id_matkul" PRIMARY KEY ("id_matkul")
269) WITH (oids = false);
270
271DROP TABLE IF EXISTS "tbpengaturan";
272CREATE TABLE "public"."tbpengaturan" (
273 "pengaturan" json
274) WITH (oids = false);
275
276
277DROP TABLE IF EXISTS "tbpeserta_kuliah";
278CREATE TABLE "public"."tbpeserta_kuliah" (
279 "id_peserta" character varying(60) NOT NULL,
280 "nobp" character varying(15) NOT NULL,
281 "id_kuliah" character varying(40) NOT NULL,
282 "status_peserta" smallint DEFAULT '1' NOT NULL,
283 "status_kelas_peserta" smallint DEFAULT '3' NOT NULL,
284 "id_kelas" integer DEFAULT '0' NOT NULL,
285 CONSTRAINT "tbpeserta_kuliah_id_peserta" PRIMARY KEY ("id_peserta"),
286 CONSTRAINT "tbpeserta_kuliah_id_kuliah_fkey" FOREIGN KEY (id_kuliah) REFERENCES tbkuliah(id_kuliah) ON UPDATE CASCADE ON DELETE CASCADE NOT DEFERRABLE
287) WITH (oids = false);
288
289CREATE INDEX "tbpeserta_kuliah_id_kuliah" ON "public"."tbpeserta_kuliah" USING btree ("id_kuliah");
290
291CREATE INDEX "tbpeserta_kuliah_nobp" ON "public"."tbpeserta_kuliah" USING btree ("nobp");
292
293DELIMITER ;;
294
295CREATE TRIGGER "updateStatusKuliah" AFTER INSERT ON "public"."tbpeserta_kuliah" FOR EACH ROW EXECUTE PROCEDURE updatestatuskuliah();;
296
297DELIMITER ;
298
299DROP TABLE IF EXISTS "tbsoal";
300DROP SEQUENCE IF EXISTS tbsoal_id_soal_seq;
301CREATE SEQUENCE tbsoal_id_soal_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
302
303CREATE TABLE "public"."tbsoal" (
304 "id_soal" integer DEFAULT nextval('tbsoal_id_soal_seq') NOT NULL,
305 "isi_soal" text NOT NULL,
306 "pilihanGanda" json,
307 "id_jsoal" smallint NOT NULL,
308 "bobot" smallint DEFAULT '1' NOT NULL,
309 "jawaban" character varying(5),
310 CONSTRAINT "tbsoal_id_soal" PRIMARY KEY ("id_soal")
311) WITH (oids = false);
312
313DROP TABLE IF EXISTS "tbsoal_ujian";
314DROP SEQUENCE IF EXISTS tbsoal_ujian_id_sujian_seq1;
315CREATE SEQUENCE tbsoal_ujian_id_sujian_seq1 INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
316
317CREATE TABLE "public"."tbsoal_ujian" (
318 "id_sujian" integer DEFAULT nextval('tbsoal_ujian_id_sujian_seq1') NOT NULL,
319 "id_ujian" character varying(40) NOT NULL,
320 "id_soal" integer NOT NULL,
321 CONSTRAINT "tbsoal_ujian_id_sujian" PRIMARY KEY ("id_sujian"),
322 CONSTRAINT "tbsoal_ujian_id_ujian_fkey" FOREIGN KEY (id_ujian) REFERENCES tbujian(id_ujian) ON UPDATE CASCADE ON DELETE CASCADE NOT DEFERRABLE
323) WITH (oids = false);
324
325CREATE INDEX "tbsoal_ujian_id_soal" ON "public"."tbsoal_ujian" USING btree ("id_soal");
326
327CREATE INDEX "tbsoal_ujian_id_ujian" ON "public"."tbsoal_ujian" USING btree ("id_ujian");
328
329DELIMITER ;;
330
331CREATE TRIGGER "updateStatusUjian" AFTER INSERT ON "public"."tbsoal_ujian" FOR EACH ROW EXECUTE PROCEDURE updatestatusujian();;
332
333DELIMITER ;
334
335DROP TABLE IF EXISTS "tbstatus";
336DROP SEQUENCE IF EXISTS tbstatus_status_seq;
337CREATE SEQUENCE tbstatus_status_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
338
339CREATE TABLE "public"."tbstatus" (
340 "status" integer DEFAULT nextval('tbstatus_status_seq') NOT NULL,
341 "nm_status" character varying(20) NOT NULL,
342 CONSTRAINT "tbstatus_status" PRIMARY KEY ("status")
343) WITH (oids = false);
344
345
346DROP TABLE IF EXISTS "tbujian";
347CREATE TABLE "public"."tbujian" (
348 "id_ujian" character varying(40) NOT NULL,
349 "hari" date NOT NULL,
350 "mulai" time without time zone NOT NULL,
351 "selesai" time without time zone NOT NULL,
352 "deskripsi" character varying(100) NOT NULL,
353 "status_ujian" smallint DEFAULT '0' NOT NULL,
354 "id_jujian" smallint NOT NULL,
355 "id_jsoal" smallint NOT NULL,
356 "id_kuliah" character varying(40) NOT NULL,
357 CONSTRAINT "tbujian_id_ujian" PRIMARY KEY ("id_ujian")
358) WITH (oids = false);
359
360CREATE INDEX "tbujian_id_kuliah" ON "public"."tbujian" USING btree ("id_kuliah");
361
362DROP TABLE IF EXISTS "tbuser";
363DROP SEQUENCE IF EXISTS tbuser_id_user_seq;
364CREATE SEQUENCE tbuser_id_user_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1 CACHE 1;
365
366CREATE TABLE "public"."tbuser" (
367 "id_user" integer DEFAULT nextval('tbuser_id_user_seq') NOT NULL,
368 "username" character varying(30) NOT NULL,
369 "password" text NOT NULL,
370 "id_juser" smallint NOT NULL,
371 "status_user" smallint DEFAULT '1' NOT NULL,
372 CONSTRAINT "tbuser_id_user" PRIMARY KEY ("id_user"),
373 CONSTRAINT "tbuser_username" UNIQUE ("username")
374) WITH (oids = false);
375
376DROP TABLE IF EXISTS "daftar_item";
377CREATE TABLE "public"."daftar_item" (
378 "id_item" integer,
379 "nm_item" character varying(100),
380 "geojson" json,
381 "id_titem" smallint,
382 "tipe_item" character varying(50),
383 "kategori_item" character varying(100),
384 "id_kitem" smallint
385) WITH (oids = false);
386
387DROP TABLE IF EXISTS "lap_jawaban";
388CREATE TABLE "public"."lap_jawaban" (
389 "id_jawaban" integer,
390 "nobp" character varying(15),
391 "id_ujian" character varying(60),
392 "id_soal" integer,
393 "isi_soal" text,
394 "jawaban" character varying(5),
395 "jawaban_peserta" text,
396 "bobot" smallint
397) WITH (oids = false);
398
399DROP TABLE IF EXISTS "lap_kelas_kuliah";
400CREATE TABLE "public"."lap_kelas_kuliah" (
401 "id_kkuliah" integer,
402 "id_kelas" integer,
403 "id_kuliah" character varying(60),
404 "nm_kelas" character varying(10)
405) WITH (oids = false);
406
407DROP TABLE IF EXISTS "lap_kuliah";
408CREATE TABLE "public"."lap_kuliah" (
409 "id_kuliah" character varying(40),
410 "kd_matkul" character varying(15),
411 "nm_matkul" character varying(100),
412 "nidn" character varying(11),
413 "nm_dosen" character varying(100),
414 "id_kelas" integer[],
415 "nm_kelas" character varying[],
416 "tahun_akademik" character varying(5),
417 "status_kuliah" smallint,
418 "nm_status_kuliah" character varying(20)
419) WITH (oids = false);
420
421DROP TABLE IF EXISTS "lap_peserta_kuliah";
422CREATE TABLE "public"."lap_peserta_kuliah" (
423 "id_peserta" character varying(60),
424 "id_kuliah" character varying(40),
425 "kd_matkul" character varying(15),
426 "nm_matkul" character varying(100),
427 "nidn" character varying(11),
428 "nm_dosen" character varying(100),
429 "tahun_akademik" character varying(5),
430 "nobp" character varying(15),
431 "nm_mahasiswa" character varying(100),
432 "status_peserta" smallint,
433 "nm_status_peserta" character varying(20),
434 "status_kelas_peserta" smallint,
435 "nm_status_kelas_peserta" character varying(20),
436 "id_kelas" integer,
437 "nm_kelas" character varying(10)
438) WITH (oids = false);
439
440DROP TABLE IF EXISTS "lap_peserta_ujian";
441CREATE TABLE "public"."lap_peserta_ujian" (
442 "id_ujian" character varying(40),
443 "hari" date,
444 "mulai" time without time zone,
445 "selesai" time without time zone,
446 "deskripsi" character varying(100),
447 "status_ujian" smallint,
448 "nm_status_ujian" character varying(20),
449 "id_jsoal" smallint,
450 "nm_jsoal" character varying(20),
451 "id_jujian" smallint,
452 "nm_jujian" character varying(10),
453 "kd_matkul" character varying(15),
454 "nm_matkul" character varying(100),
455 "nidn" character varying(11),
456 "nm_dosen" character varying(100),
457 "id_kuliah" character varying(40),
458 "nobp" character varying(15),
459 "nm_mahasiswa" character varying(100),
460 "id_kelas" integer,
461 "nm_kelas" character varying(10),
462 "nm_ujian" text
463) WITH (oids = false);
464
465DROP TABLE IF EXISTS "lap_soal";
466CREATE TABLE "public"."lap_soal" (
467 "id_soal" integer,
468 "isi_soal" text,
469 "pilihanGanda" json,
470 "id_jsoal" smallint,
471 "bobot" smallint,
472 "jawaban" character varying(5),
473 "nm_jsoal" character varying(20)
474) WITH (oids = false);
475
476DROP TABLE IF EXISTS "lap_soal_ujian";
477CREATE TABLE "public"."lap_soal_ujian" (
478 "id_ujian" character varying(40),
479 "id_soal" integer,
480 "isi_soal" text,
481 "pilihanGanda" json,
482 "id_jsoal" smallint,
483 "bobot" smallint,
484 "jawaban" character varying(5)
485) WITH (oids = false);
486
487DROP TABLE IF EXISTS "lap_ujian";
488CREATE TABLE "public"."lap_ujian" (
489 "id_ujian" character varying(40),
490 "hari" date,
491 "mulai" time without time zone,
492 "selesai" time without time zone,
493 "deskripsi" character varying(100),
494 "status_ujian" smallint,
495 "nm_status_ujian" character varying(20),
496 "id_jsoal" smallint,
497 "nm_jsoal" character varying(20),
498 "id_jujian" smallint,
499 "nm_jujian" character varying(10),
500 "id_kuliah" character varying(40),
501 "kd_matkul" character varying(15),
502 "nm_matkul" character varying(100),
503 "nidn" character varying(11),
504 "nm_dosen" character varying(100),
505 "id_kelas" integer[],
506 "nm_kelas" character varying[],
507 "tahun_akademik" character varying(5)
508) WITH (oids = false);
509
510DROP TABLE IF EXISTS "lap_user";
511CREATE TABLE "public"."lap_user" (
512 "id_user" integer,
513 "username" character varying(30),
514 "password" text,
515 "id_juser" smallint,
516 "nm_juser" character varying(20),
517 "status_user" smallint
518) WITH (oids = false);
519
520DROP TABLE IF EXISTS "nilai_rata";
521CREATE TABLE "public"."nilai_rata" (
522 "nm_dosen" character varying(100),
523 "nm_matkul" character varying(100),
524 "nm_jujian" character varying(10),
525 "id_ujian" character varying(40),
526 "avg" numeric(5,2)
527) WITH (oids = false);
528
529DROP TABLE IF EXISTS "statistik";
530CREATE TABLE "public"."statistik" (
531 "total_kuliah" bigint,
532 "total_ujian" bigint,
533 "total_mahasiswa" bigint,
534 "total_dosen" bigint
535) WITH (oids = false);
536
537-- 2018-10-30 17:22:00.654502+00