/*
 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: 27/12/2025 21:55:23
*/


-- ----------------------------
-- Table structure for ms_honor_rates
-- ----------------------------
DROP TABLE IF EXISTS "public"."ms_honor_rates";
CREATE TABLE "public"."ms_honor_rates" (
  "id" int8 NOT NULL DEFAULT nextval('ms_honor_rates_id_seq'::regclass),
  "year_id" int8 NOT NULL,
  "kategori_kegiatan" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "jabatan_fungsional" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "jenjang_prodi" varchar(20) COLLATE "pg_catalog"."default" NOT NULL,
  "program_kelas" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'REGULER'::character varying,
  "tipe_mk" varchar(5) COLLATE "pg_catalog"."default",
  "peran_bimbingan" varchar(100) COLLATE "pg_catalog"."default",
  "tarif_per_satuan" numeric(15,2) NOT NULL DEFAULT 0,
  "satuan_hitung" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'PER_SKS_TM'::character varying,
  "deskripsi" text COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of ms_honor_rates
-- ----------------------------
INSERT INTO "public"."ms_honor_rates" VALUES (5, 1, 'MENGAJAR', 'Tenaga Pengajar', 'S1', 'REGULER', 'T', NULL, 25000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Tenaga Pengajar');
INSERT INTO "public"."ms_honor_rates" VALUES (6, 1, 'MENGAJAR', 'Asisten Ahli', 'S1', 'REGULER', 'P', NULL, 45000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (P) - Asisten Ahli');
INSERT INTO "public"."ms_honor_rates" VALUES (7, 1, 'MENGAJAR', 'Lektor', 'S1', 'REGULER', 'P', NULL, 55000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (P) - Lektor');
INSERT INTO "public"."ms_honor_rates" VALUES (8, 1, 'MENGAJAR', 'Lektor Kepala', 'S1', 'REGULER', 'P', NULL, 65000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (P) - Lektor Kepala');
INSERT INTO "public"."ms_honor_rates" VALUES (1, 1, 'MENGAJAR', 'Asisten Ahli', 'S1', 'REGULER', 'T', NULL, 35000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Asisten Ahli');
INSERT INTO "public"."ms_honor_rates" VALUES (2, 1, 'MENGAJAR', 'Lektor', 'S1', 'REGULER', 'T', NULL, 45000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Lektor');
INSERT INTO "public"."ms_honor_rates" VALUES (3, 1, 'MENGAJAR', 'Lektor Kepala', 'S1', 'REGULER', 'T', NULL, 55000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Lektor Kepala');
INSERT INTO "public"."ms_honor_rates" VALUES (4, 1, 'MENGAJAR', 'Guru Besar', 'S1', 'REGULER', 'T', NULL, 70000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (T) - Guru Besar');
INSERT INTO "public"."ms_honor_rates" VALUES (9, 1, 'MENGAJAR', 'Guru Besar', 'S1', 'REGULER', 'P', NULL, 80000.00, 'PER_SKS_TM', 'Honor Mengajar S1 (P) - Guru Besar');
INSERT INTO "public"."ms_honor_rates" VALUES (10, 1, 'MENGAJAR', 'Lektor', 'S2', 'REGULER', 'T', NULL, 75000.00, 'PER_SKS_TM', 'Honor Mengajar S2 (T) - Lektor');
INSERT INTO "public"."ms_honor_rates" VALUES (11, 1, 'MENGAJAR', 'Lektor Kepala', 'S2', 'REGULER', 'T', NULL, 100000.00, 'PER_SKS_TM', 'Honor Mengajar S2 (T) - Lektor Kepala');
INSERT INTO "public"."ms_honor_rates" VALUES (12, 1, 'MENGAJAR', 'Guru Besar', 'S2', 'REGULER', 'T', NULL, 125000.00, 'PER_SKS_TM', 'Honor Mengajar S2 (T) - Guru Besar');
INSERT INTO "public"."ms_honor_rates" VALUES (13, 1, 'MENGAJAR', 'Guru Besar', 'S3', 'REGULER', 'T', NULL, 150000.00, 'PER_SKS_TM', 'Honor Mengajar S3 (T) - Guru Besar');
INSERT INTO "public"."ms_honor_rates" VALUES (14, 1, 'MEMBIMBING', 'Lektor', 'S1', 'REGULER', NULL, 'Pembimbing Utama', 500000.00, 'PER_MAHASISWA', 'Honor Pembimbing Utama S1');
INSERT INTO "public"."ms_honor_rates" VALUES (15, 1, 'MEMBIMBING', 'Lektor', 'S1', 'REGULER', NULL, 'Pembimbing Pendamping', 350000.00, 'PER_MAHASISWA', 'Honor Pembimbing Pendamping S1');
INSERT INTO "public"."ms_honor_rates" VALUES (16, 1, 'MEMBIMBING', 'Lektor Kepala', 'S1', 'REGULER', NULL, 'Pembimbing Utama', 600000.00, 'PER_MAHASISWA', 'Honor Pembimbing Utama S1');
INSERT INTO "public"."ms_honor_rates" VALUES (17, 1, 'MEMBIMBING', 'Lektor Kepala', 'S2', 'REGULER', NULL, 'Pembimbing Utama', 1500000.00, 'PER_MAHASISWA', 'Honor Pembimbing Utama S2');
INSERT INTO "public"."ms_honor_rates" VALUES (18, 1, 'MEMBIMBING', 'Guru Besar', 'S2', 'REGULER', NULL, 'Pembimbing Utama', 2000000.00, 'PER_MAHASISWA', 'Honor Pembimbing Utama S2');
INSERT INTO "public"."ms_honor_rates" VALUES (19, 1, 'MEMBIMBING', 'Guru Besar', 'S3', 'REGULER', NULL, 'Promotor', 3500000.00, 'PER_MAHASISWA', 'Honor Promotor S3');
INSERT INTO "public"."ms_honor_rates" VALUES (20, 1, 'MEMBIMBING', 'Guru Besar', 'S3', 'REGULER', NULL, 'Co-Promotor', 2500000.00, 'PER_MAHASISWA', 'Honor Co-Promotor S3');
INSERT INTO "public"."ms_honor_rates" VALUES (24, 1, 'MEMBIMBING', 'SEMUA', 'S1', 'REGULER', NULL, 'Pembimbing PK', 175000.00, 'PER_MAHASISWA', 'Honor Pembimbing PK S1');
INSERT INTO "public"."ms_honor_rates" VALUES (25, 1, 'MEMBIMBING', 'SEMUA', 'S1', 'REGULER', NULL, 'Pembimbing KKN', 175000.00, 'PER_MAHASISWA', 'Honor Pembimbing KKN S1');
INSERT INTO "public"."ms_honor_rates" VALUES (21, 1, 'MENGUJI', 'Lektor', 'S1', 'REGULER', NULL, 'Ketua Penguji', 150000.00, 'PER_MAHASISWA', 'Honor Ketua Penguji S1');
INSERT INTO "public"."ms_honor_rates" VALUES (22, 1, 'MENGUJI', 'Lektor', 'S1', 'REGULER', NULL, 'Anggota Penguji', 100000.00, 'PER_MAHASISWA', 'Honor Anggota Penguji S1');
INSERT INTO "public"."ms_honor_rates" VALUES (23, 1, 'MENGUJI', 'Lektor Kepala', 'S2', 'REGULER', NULL, 'Penguji Tesis', 300000.00, 'PER_MAHASISWA', 'Honor Penguji Tesis S2');

-- ----------------------------
-- Indexes structure for table ms_honor_rates
-- ----------------------------
CREATE INDEX "ms_honor_rates_year_id_kategori_kegiatan_jabatan_fungsional_jen" ON "public"."ms_honor_rates" USING btree (
  "year_id" "pg_catalog"."int8_ops" ASC NULLS LAST,
  "kategori_kegiatan" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "jabatan_fungsional" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "jenjang_prodi" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

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

-- ----------------------------
-- Foreign Keys structure for table ms_honor_rates
-- ----------------------------
ALTER TABLE "public"."ms_honor_rates" ADD CONSTRAINT "ms_honor_rates_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE;