/* Navicat Premium Data Transfer Source Server : anjabbawah Source Server Type : PostgreSQL Source Server Version : 150003 (150003) Source Host : localhost:5432 Source Catalog : sppai Source Schema : public Target Server Type : PostgreSQL Target Server Version : 150003 (150003) File Encoding : 65001 Date: 28/01/2026 08:48:56 */ -- ---------------------------- -- Table structure for trans_resources -- ---------------------------- DROP TABLE IF EXISTS "public"."trans_resources"; CREATE TABLE "public"."trans_resources" ( "id" int8 NOT NULL DEFAULT nextval('trans_resources_id_seq'::regclass), "year_id" int4 NOT NULL, "cost_category_id" int4 NOT NULL, "amount" numeric(15,2) NOT NULL DEFAULT 0, "level_scope" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "faculty_id" int4, "department_id" int4, "study_program_id" int4, "description" text COLLATE "pg_catalog"."default", "created_by" int4, "created_at" timestamp(6), "updated_at" timestamp(6), "details" jsonb, "resource_name" varchar(255) COLLATE "pg_catalog"."default" ) ; -- ---------------------------- -- Records of trans_resources -- ---------------------------- INSERT INTO "public"."trans_resources" VALUES (47, 1, 33, 4240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 5', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 720000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 3520000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honor Mengajar: Senam Dasar & Ritmik'); INSERT INTO "public"."trans_resources" VALUES (44, 1, 33, 5250000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 29', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 5250000, "vol": "30 Mhs", "item": "Honor Pembimbing Lapangan", "rate": "175000.00"}]', 'Honor Mengajar: PLP / Magang Kependidikan 2'); INSERT INTO "public"."trans_resources" VALUES (45, 1, 33, 5040000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 10', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 880000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "55000.00"}, {"sub": 4160000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "65000.00"}]', 'Honor Mengajar: Renang Dasar & Penyelamatan Air'); INSERT INTO "public"."trans_resources" VALUES (46, 1, 33, 5120000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 30', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 5120000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "80000.00"}]', 'Honor Mengajar: Seminar Proposal Skripsi'); INSERT INTO "public"."trans_resources" VALUES (49, 1, 33, 1120000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 25', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1120000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Asisten Ahli)", "rate": "35000.00"}]', 'Honor Mengajar: Statistika Pendidikan'); INSERT INTO "public"."trans_resources" VALUES (19, 1, 10, 48000000.00, 'FACULTY', NULL, NULL, NULL, NULL, 1, '2026-01-16 23:21:38', '2026-01-16 23:21:38', '{"item": "kertas", "type": "barang", "harga": "40000", "satuan": "rim", "qty_barang": "1200"}', 'Gaji & Tunjangan Manajemen Pusat (Rektorat)'); INSERT INTO "public"."trans_resources" VALUES (20, 1, 2, 390000.00, 'UNIVERSITY', NULL, NULL, NULL, 'Gaji dan Remun', NULL, '2026-01-19 07:07:54', '2026-01-19 07:08:22', '{"qty": "15000", "type": "honor", "tarif": "26", "penerima": ""}', 'Gaji & Tunjangan Manajemen Pusat (Rektorat)'); INSERT INTO "public"."trans_resources" VALUES (18, 1, 3, 150000000.00, 'UNIVERSITY', NULL, NULL, NULL, '', 1, '2026-01-16 23:11:38', '2026-01-19 07:09:28', '{"qty": "", "type": "honor", "tarif": "", "penerima": ""}', 'Gaji pegawai'); INSERT INTO "public"."trans_resources" VALUES (50, 1, 33, 1920000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 14', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 800000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Tenaga Pengajar)", "rate": "25000.00"}, {"sub": 1120000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Tenaga Pengajar)", "rate": "35000.00"}]', 'Honor Mengajar: Strategi Pembelajaran Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (51, 1, 33, 4240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 20', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 720000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 3520000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honor Mengajar: Teknologi & Media Pembelajaran'); INSERT INTO "public"."trans_resources" VALUES (11, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 60', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Analisis Data & Penulisan Disertasi'); INSERT INTO "public"."trans_resources" VALUES (3, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 52', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Desain & Analisis Statistik Lanjut'); INSERT INTO "public"."trans_resources" VALUES (6, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 55', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Evaluasi Program & Kebijakan Penjas'); INSERT INTO "public"."trans_resources" VALUES (48, 1, 33, 29250000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 31', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 18000000, "vol": "30 Mhs", "item": "Pembimbing (Lektor)", "rate": "600000.00"}, {"sub": 3750000, "vol": "30 Mhs", "item": "Ketua Penguji", "rate": "125000.00"}, {"sub": 3750000, "vol": "30 Mhs", "item": "Sekretaris Penguji", "rate": "125000.00"}, {"sub": 3750000, "vol": "30 Mhs", "item": "Anggota Penguji (1 org)", "rate": "125000.00"}]', 'Honor Mengajar: Skripsi / Tugas Akhir'); INSERT INTO "public"."trans_resources" VALUES (21, 1, 33, 6240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 17', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1120000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}, {"sub": 5120000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "80000.00"}]', 'Honor Mengajar: Aktivitas Luar Kelas'); INSERT INTO "public"."trans_resources" VALUES (23, 1, 33, 4240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 4', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 720000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 3520000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honor Mengajar: Atletik Dasar (Lari & Lompat)'); INSERT INTO "public"."trans_resources" VALUES (24, 1, 33, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 13', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honor Mengajar: Bahasa Indonesia'); INSERT INTO "public"."trans_resources" VALUES (22, 1, 33, 3200000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 2', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1440000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 1760000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honor Mengajar: Anatomi Manusia'); INSERT INTO "public"."trans_resources" VALUES (28, 1, 33, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 22', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honor Mengajar: Gizi Olahraga & Kesehatan Sekolah'); INSERT INTO "public"."trans_resources" VALUES (29, 1, 33, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 26', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honor Mengajar: K3 Olahraga'); INSERT INTO "public"."trans_resources" VALUES (25, 1, 33, 3840000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 9', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1760000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "55000.00"}, {"sub": 2080000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "65000.00"}]', 'Honor Mengajar: Belajar Gerak (Motor Learning)'); INSERT INTO "public"."trans_resources" VALUES (26, 1, 33, 3840000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 19', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1760000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "55000.00"}, {"sub": 2080000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor Kepala)", "rate": "65000.00"}]', 'Honor Mengajar: Evaluasi Pembelajaran Penjas'); INSERT INTO "public"."trans_resources" VALUES (27, 1, 33, 1440000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 3', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1440000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}]', 'Honor Mengajar: Fisiologi Dasar'); INSERT INTO "public"."trans_resources" VALUES (35, 1, 33, 3440000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 24', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 560000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Asisten Ahli)", "rate": "35000.00"}, {"sub": 2880000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Asisten Ahli)", "rate": "45000.00"}]', 'Honor Mengajar: Micro Teaching'); INSERT INTO "public"."trans_resources" VALUES (36, 1, 33, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 7', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honor Mengajar: Pancasila'); INSERT INTO "public"."trans_resources" VALUES (37, 1, 33, 2480000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 18', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 720000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}, {"sub": 1760000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Lektor)", "rate": "55000.00"}]', 'Honor Mengajar: Pencak Silat & Beladiri SD'); INSERT INTO "public"."trans_resources" VALUES (38, 1, 33, 1760000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 6', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1760000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor Kepala)", "rate": "55000.00"}]', 'Honor Mengajar: Pendidikan Agama'); INSERT INTO "public"."trans_resources" VALUES (39, 1, 33, 4800000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 16', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}, {"sub": 2560000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "80000.00"}]', 'Honor Mengajar: Pendidikan Jasmani Adaptif'); INSERT INTO "public"."trans_resources" VALUES (30, 1, 33, 5250000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 28', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 5250000, "vol": "30 Mhs", "item": "Honor Pembimbing Lapangan", "rate": "175000.00"}]', 'Honor Mengajar: Kuliah Kerja Nyata (KKN)'); INSERT INTO "public"."trans_resources" VALUES (31, 1, 33, 2240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 15', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 2240000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}]', 'Honor Mengajar: Kurikulum Penjas SD (Merdeka)'); INSERT INTO "public"."trans_resources" VALUES (32, 1, 33, 1440000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 1', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1440000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}]', 'Honor Mengajar: Landasan Pendidikan Jasmani'); INSERT INTO "public"."trans_resources" VALUES (33, 1, 33, 1440000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 21', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1440000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}]', 'Honor Mengajar: Manajemen Pendidikan Jasmani'); INSERT INTO "public"."trans_resources" VALUES (34, 1, 33, 2160000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 23', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 2160000, "vol": "3 SKS x 16 TM", "item": "Kuliah Teori (Lektor)", "rate": "45000.00"}]', 'Honor Mengajar: Metodologi Penelitian Pendidikan'); INSERT INTO "public"."trans_resources" VALUES (40, 1, 33, 1120000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 8', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1120000, "vol": "2 SKS x 16 TM", "item": "Kuliah Teori (Asisten Ahli)", "rate": "35000.00"}]', 'Honor Mengajar: Perkembangan Peserta Didik SD'); INSERT INTO "public"."trans_resources" VALUES (43, 1, 33, 5250000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 27', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 5250000, "vol": "30 Mhs", "item": "Honor Pembimbing Lapangan", "rate": "175000.00"}]', 'Honor Mengajar: PLP / Magang Kependidikan 1'); INSERT INTO "public"."trans_resources" VALUES (41, 1, 33, 6240000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 12', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 1120000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Guru Besar)", "rate": "70000.00"}, {"sub": 5120000, "vol": "2 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Guru Besar)", "rate": "80000.00"}]', 'Honor Mengajar: Permainan Bola Besar'); INSERT INTO "public"."trans_resources" VALUES (42, 1, 33, 2000000.00, 'PRODI', 1, 1, 4, 'Otomatis dari Jadwal ID: 11', 7, NULL, '2026-01-27 09:14:46', '[{"sub": 560000, "vol": "1 SKS x 16 TM", "item": "Kuliah Teori (Asisten Ahli)", "rate": "35000.00"}, {"sub": 1440000, "vol": "1 SKS x 2 x 16 TM", "item": "Kuliah Praktik (Asisten Ahli)", "rate": "45000.00"}]', 'Honor Mengajar: Permainan Bola Kecil'); INSERT INTO "public"."trans_resources" VALUES (16, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 48', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Filsafat Ilmu Keolahragaan Lanjut'); INSERT INTO "public"."trans_resources" VALUES (52, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 50', NULL, NULL, '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Filsafat Pendidikan Jasmani & Olahraga'); INSERT INTO "public"."trans_resources" VALUES (17, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 49', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Metodologi Riset Kuantitatif & Kualitatif'); INSERT INTO "public"."trans_resources" VALUES (5, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 54', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Pengembangan Model Kurikulum Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (15, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 64', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Promosi Doktor (Ujian Terbuka)'); INSERT INTO "public"."trans_resources" VALUES (8, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 57', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Publikasi Ilmiah Internasional 1'); INSERT INTO "public"."trans_resources" VALUES (12, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 61', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Publikasi Ilmiah Internasional 2'); INSERT INTO "public"."trans_resources" VALUES (7, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 56', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Seminar Proposal Disertasi (Pra-Kualifikasi)'); INSERT INTO "public"."trans_resources" VALUES (4, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 53', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Studi Mandiri (Independent Study)'); INSERT INTO "public"."trans_resources" VALUES (2, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 51', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Teori & Isu Kritis Penjas SD'); INSERT INTO "public"."trans_resources" VALUES (13, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 62', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Ujian Kelayakan Naskah Disertasi'); INSERT INTO "public"."trans_resources" VALUES (9, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 58', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Ujian Kualifikasi (Komprehensif)'); INSERT INTO "public"."trans_resources" VALUES (14, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 63', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Ujian Tertutup Disertasi'); INSERT INTO "public"."trans_resources" VALUES (10, 1, 33, 75000.00, 'PRODI', NULL, 1, 6, 'Otomatis dari Jadwal ID: 59', NULL, '2026-01-15 07:53:47', '2026-01-23 08:05:07', '[{"sub": 75000, "vol": "30 Mhs", "item": "Ujian", "rate": 2500}]', 'Honor Mengajar: Validasi Instrumen & Pengumpulan Data'); -- ---------------------------- -- Indexes structure for table trans_resources -- ---------------------------- CREATE INDEX "idx_trans_resources_scope" ON "public"."trans_resources" USING btree ( "level_scope" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST ); -- ---------------------------- -- Primary Key structure for table trans_resources -- ---------------------------- ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "pk_trans_resources" PRIMARY KEY ("id"); -- ---------------------------- -- Foreign Keys structure for table trans_resources -- ---------------------------- ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_cost_category_id_foreign" FOREIGN KEY ("cost_category_id") REFERENCES "public"."abc_cost_categories" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_department_id_foreign" FOREIGN KEY ("department_id") REFERENCES "public"."ms_departments" ("id") ON DELETE CASCADE ON UPDATE SET NULL; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_faculty_id_foreign" FOREIGN KEY ("faculty_id") REFERENCES "public"."ms_faculties" ("id") ON DELETE CASCADE ON UPDATE SET NULL; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_study_program_id_foreign" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE SET NULL; ALTER TABLE "public"."trans_resources" ADD CONSTRAINT "trans_resources_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE;