/*
 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;
