/*
 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: 11/01/2026 10:24:56
*/


-- ----------------------------
-- Table structure for ms_menus
-- ----------------------------
DROP TABLE IF EXISTS "public"."ms_menus";
CREATE TABLE "public"."ms_menus" (
  "id" int4 NOT NULL DEFAULT nextval('ms_menus_id_seq'::regclass),
  "parent_id" int4 DEFAULT 0,
  "title" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "url" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "icon" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "sequence" int4 NOT NULL DEFAULT 0,
  "is_active" bool NOT NULL DEFAULT true,
  "allowed_roles" text COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of ms_menus
-- ----------------------------
INSERT INTO "public"."ms_menus" VALUES (1, 0, 'Dashboard', 'dashboard', 'fas fa-tachometer-alt', 1, 't', NULL);
INSERT INTO "public"."ms_menus" VALUES (2, 0, 'Data Master', '#', 'fas fa-database', 2, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (3, 2, 'Tahun Anggaran', 'master/tahun', 'far fa-calendar-alt', 1, 't', 'superuser,admin_univ');
INSERT INTO "public"."ms_menus" VALUES (4, 2, 'Fakultas', 'master/fakultas', 'far fa-building', 2, 't', 'superuser,admin_univ,admin_fakultas');
INSERT INTO "public"."ms_menus" VALUES (5, 2, 'Departemen', 'master/departemen', 'far fa-building', 3, 't', 'superuser,admin_univ,admin_dept');
INSERT INTO "public"."ms_menus" VALUES (6, 2, 'Program Studi', 'master/prodi', 'fas fa-graduation-cap', 4, 't', 'superuser,admin_univ,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (7, 2, 'Kurikulum / MK', 'master/kurikulum', 'fas fa-book', 5, 't', 'superuser,admin_univ,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (9, 2, 'Kategori Biaya', 'master/biaya', 'fas fa-tags', 7, 't', 'superuser,admin_univ');
INSERT INTO "public"."ms_menus" VALUES (10, 2, 'Driver / Pemicu', 'master/driver', 'fas fa-sort-amount-up', 8, 't', 'superuser,admin_univ');
INSERT INTO "public"."ms_menus" VALUES (11, 2, 'Konfigurasi SSBOPT', 'master/config-ssbopt', 'fas fa-cogs', 9, 't', 'superuser,admin_univ');
INSERT INTO "public"."ms_menus" VALUES (12, 2, 'Standar Tarif Honor', 'master/labor-rate', 'fas fa-money-bill-wave', 10, 't', 'superuser,admin_univ');
INSERT INTO "public"."ms_menus" VALUES (13, 0, 'Transaksi', '#', 'fas fa-exchange-alt', 3, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (14, 13, 'Jadwal Kuliah', 'akademik/jadwal', 'fas fa-calendar-alt', 1, 't', 'superuser,admin_univ,admin_fakultas,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (21, 0, 'Laporan', '#', 'fas fa-file-alt', 4, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (22, 21, 'Laporan Unit Cost', 'laporan/unit-cost', 'fas fa-file-contract', 1, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (23, 0, 'System Admin', '#', 'fas fa-user-shield', 99, 't', 'superuser');
INSERT INTO "public"."ms_menus" VALUES (24, 23, 'Manajemen User', 'system/users', 'fas fa-users', 1, 't', 'superuser');
INSERT INTO "public"."ms_menus" VALUES (25, 23, 'Manajemen Menu', 'system/menu', 'fas fa-list', 2, 't', 'superuser');
INSERT INTO "public"."ms_menus" VALUES (26, 23, 'Audit Database', 'system/database', 'fas fa-server', 3, 't', 'superuser');
INSERT INTO "public"."ms_menus" VALUES (27, 13, 'Proses Alokasi Biaya', 'transaksi/alokasi', 'fas fa-network-wired', 5, 't', 'superuser,admin_univ');
INSERT INTO "public"."ms_menus" VALUES (28, 13, 'Target Pendapatan', 'transaksi/revenue', 'fas fa-bullseye', 8, 't', 'superuser,admin_univ,admin_fakultas,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (29, 21, 'Analisis Gap (SPK)', 'laporan/gap-analysis', 'fas fa-chart-area', 2, 't', 'superuser,admin_univ,admin_fakultas,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (17, 13, 'Kalkulasi Honor Mengajar', 'transaksi/teaching-cost', 'fas fa-calculator', 2, 't', 'superuser,admin_univ,admin_fakultas,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (16, 13, 'Nilai Statistik (Driver)', 'transaksi/driver-values', 'fas fa-chart-bar', 4, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (15, 13, 'Input Sumber Daya', 'transaksi/resources', 'fas fa-file-invoice-dollar', 3, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (30, 21, 'Rekap Kategori Biaya', 'laporan/rekap-kategori', 'fas fa-chart-pie', 3, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi');
INSERT INTO "public"."ms_menus" VALUES (31, 13, 'Input Rincian Kategori', 'transaksi/rinciankategori', 'fas fa-file-invoice-dollar', 3, 't', 'superuser,admin_univ,admin_fakultas,admin_dept,admin_prodi');

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