/*
 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: 08/01/2026 09:57:22
*/


-- ----------------------------
-- Table structure for abc_cost_categories
-- ----------------------------
DROP TABLE IF EXISTS "public"."abc_cost_categories";
CREATE TABLE "public"."abc_cost_categories" (
  "id" int8 NOT NULL DEFAULT nextval('abc_cost_categories_id_seq'::regclass),
  "category_code" varchar(20) COLLATE "pg_catalog"."default",
  "category_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "description" text COLLATE "pg_catalog"."default",
  "created_at" timestamp(6),
  "updated_at" timestamp(6),
  "deleted_at" timestamp(6),
  "cost_type_id" int8,
  "allowed_level_ids" varchar(255) COLLATE "pg_catalog"."default",
  "scope_level" varchar(50) COLLATE "pg_catalog"."default" DEFAULT 'ALL'::character varying,
  "report_group" varchar(50) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of abc_cost_categories
-- ----------------------------
INSERT INTO "public"."abc_cost_categories" VALUES (14, 'BTL-08', 'Penyusutan Aset', 'Biaya depresiasi gedung, kendaraan, dan peralatan utama.', NULL, NULL, NULL, 2, NULL, 'UNIV', 'DEPRESIASI');
INSERT INTO "public"."abc_cost_categories" VALUES (12, 'BTL-06', 'Akreditasi & Penjaminan Mutu', 'Biaya akreditasi institusi, ISO, audit internal/eksternal.', NULL, NULL, NULL, 2, NULL, 'UNIV', 'LAINNYA');
INSERT INTO "public"."abc_cost_categories" VALUES (2, 'BL-02', 'Honorarium Mengajar & Insentif', 'Honor Dosen LB, Dosen Tamu, Kelebihan Jam Ajar, Insentif Kinerja.', NULL, NULL, NULL, 1, NULL, 'PRODI', 'SDM');
INSERT INTO "public"."abc_cost_categories" VALUES (3, 'BL-03', 'Pengembangan SDM Prodi', 'Biaya seminar, workshop, sertifikasi dosen/tendik spesifik prodi.', NULL, NULL, NULL, 1, NULL, 'PRODI', 'SDM');
INSERT INTO "public"."abc_cost_categories" VALUES (5, 'BL-05', 'Sidang & Tugas Akhir', 'Honor pembimbing, penguji, konsumsi sidang skripsi/tesis/disertasi.', NULL, NULL, NULL, 1, NULL, 'PRODI', 'SDM');
INSERT INTO "public"."abc_cost_categories" VALUES (1, 'BL-01', 'Bahan Habis Pakai (BHP) Pembelajaran', 'Bahan praktikum, bahan kimia, spidol, kertas ujian, modul cetak.', NULL, NULL, NULL, 1, NULL, 'PRODI', 'BHP');
INSERT INTO "public"."abc_cost_categories" VALUES (4, 'BL-04', 'Kegiatan Kemahasiswaan', 'Dana HIMA, lomba mahasiswa, PKM, pameran karya mahasiswa.', NULL, NULL, NULL, 1, NULL, 'PRODI', 'BHP');
INSERT INTO "public"."abc_cost_categories" VALUES (6, 'BL-06', 'Praktikum & Kuliah Lapangan', 'Sewa bus/transportasi, sewa lahan/alat luar, biaya KKN/Magang.', NULL, NULL, NULL, 1, NULL, 'PRODI', 'BHP');
INSERT INTO "public"."abc_cost_categories" VALUES (7, 'BTL-01', 'Gaji & Tunjangan Pegawai Tetap', 'Gaji pokok, tunjangan fungsional, uang makan PNS/Non-PNS (Dosen & Tendik).', NULL, NULL, NULL, 2, NULL, 'UNIV', 'OPERATIONAL');
INSERT INTO "public"."abc_cost_categories" VALUES (8, 'BTL-02', 'Utilitas (Listrik, Air, Internet)', 'Tagihan PLN, PDAM, Bandwidth Internet, Telepon.', NULL, NULL, NULL, 2, NULL, 'UNIV', 'OPERATIONAL');
INSERT INTO "public"."abc_cost_categories" VALUES (10, 'BTL-04', 'Administrasi Perkantoran Umum', 'ATK Dekanat/Rektorat, Fotokopi, Surat Menyurat, Tinta Printer.', NULL, NULL, NULL, 2, NULL, 'FACULTY', 'OPERATIONAL');
INSERT INTO "public"."abc_cost_categories" VALUES (11, 'BTL-05', 'Keamanan & Kebersihan (Outsourcing)', 'Kontrak pihak ketiga untuk Satpam dan Cleaning Service.', NULL, NULL, NULL, 2, NULL, 'UNIV', 'OPERATIONAL');
INSERT INTO "public"."abc_cost_categories" VALUES (13, 'BTL-07', 'Rapat & Jamuan Tamu', 'Konsumsi rapat pimpinan, senat, tamu dinas.', NULL, NULL, NULL, 2, NULL, 'FACULTY', 'OPERATIONAL');
INSERT INTO "public"."abc_cost_categories" VALUES (9, 'BTL-03', 'Pemeliharaan Gedung & Sarpras', 'Servis AC, Lift, Genset, Kebersihan Taman, Renovasi Ringan.', NULL, NULL, NULL, 2, NULL, 'UNIV', 'PEMELIHARAAN');

-- ----------------------------
-- Primary Key structure for table abc_cost_categories
-- ----------------------------
ALTER TABLE "public"."abc_cost_categories" ADD CONSTRAINT "pk_abc_cost_categories" PRIMARY KEY ("id");

-- ----------------------------
-- Foreign Keys structure for table abc_cost_categories
-- ----------------------------
ALTER TABLE "public"."abc_cost_categories" ADD CONSTRAINT "fk_cost_type" FOREIGN KEY ("cost_type_id") REFERENCES "public"."abc_cost_types" ("id") ON DELETE SET NULL ON UPDATE CASCADE;