/* 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: 23/04/2026 11:48:07 */ -- ---------------------------- -- Table structure for akademik_jadwal_kuliah -- ---------------------------- DROP TABLE IF EXISTS "public"."akademik_jadwal_kuliah"; CREATE TABLE "public"."akademik_jadwal_kuliah" ( "id" int8 NOT NULL DEFAULT nextval('akademik_jadwal_kuliah_id_seq'::regclass), "year_id" int8 NOT NULL, "mk_id" int8 NOT NULL, "nama_kelas" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "program_kelas" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'REGULER'::character varying, "dosen_id" int8, "nama_dosen" varchar(255) COLLATE "pg_catalog"."default", "jabatan_fungsional_snapshot" varchar(50) COLLATE "pg_catalog"."default", "jumlah_mahasiswa" int4 NOT NULL DEFAULT 0, "jumlah_tatap_muka_realisasi" int4 NOT NULL DEFAULT 0, "total_honorarium" numeric(15,2) NOT NULL DEFAULT 0, "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of akademik_jadwal_kuliah -- ---------------------------- INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (38, 1, 71, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor', 30, 16, 5120000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (41, 1, 74, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 6320000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (43, 1, 76, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 3200000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (17, 1, 114, 'A', 'REGULER', NULL, '198005072023211014', 'Guru Besar', 30, 16, 6240000.00, '2025-12-27 06:10:37', '2026-01-27 01:32:49'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (52, 1, 85, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor', 30, 16, 6720000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (55, 1, 88, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor Kepala', 30, 16, 8320000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (48, 1, 81, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 4800000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (49, 1, 82, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 4800000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (54, 1, 87, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 9920000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (57, 1, 90, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 10240000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (56, 1, 89, 'B2', 'REGULER', NULL, 'Dr. Tri Ani Hastuti S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 346500000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (53, 1, 86, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor Kepala', 30, 16, 12960000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (51, 1, 84, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor', 30, 16, 4800000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (32, 1, 65, 'A', 'REGULER', NULL, 'Prof. Dr. Drs. Subagyo M.Pd.', 'Guru Besar', 30, 16, 4000000.00, '2025-12-27 06:10:37', '2026-01-20 12:16:26'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (40, 1, 73, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor', 30, 16, 6640000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (47, 1, 80, 'A', 'REGULER', NULL, 'Prof. Dr. Hari Yuliarto S.Pd., M.Kes.', 'Guru Besar', 30, 16, 138525000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (42, 1, 75, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 8640000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (44, 1, 77, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor', 30, 16, 2400000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (37, 1, 70, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 8320000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (46, 1, 79, 'A', 'REGULER', NULL, 'Prof. Dr. Hari Yuliarto S.Pd., M.Kes.', 'Guru Besar', 30, 16, 8640000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (34, 1, 67, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 8320000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (35, 1, 68, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 3200000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (45, 1, 78, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor', 30, 16, 3920000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (39, 1, 72, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Lektor Kepala', 30, 16, 3200000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (63, 1, 96, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 346500000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (18, 1, 115, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 2480000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (5, 1, 102, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 4240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:17'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (2, 1, 99, 'A', 'REGULER', NULL, 'Abdul Mahfudin Alim S.Pd.Kor., M.Pd.', 'Lektor', 30, 16, 3200000.00, '2025-12-27 06:10:37', '2026-01-27 06:08:36'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (4, 1, 101, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 4240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:17'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (13, 1, 110, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (9, 1, 106, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor Kepala', 30, 16, 3840000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (19, 1, 116, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor Kepala', 30, 16, 3840000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (3, 1, 100, 'A', 'REGULER', NULL, 'Riky Dwihandaka S.Pd.Kor., M.Or.', 'Lektor', 30, 16, 1440000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:17'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (22, 1, 119, 'RPL', 'REGULER', NULL, 'Dr. Putri Prastiwi Wulandari S.Pd., M.Pd.', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (26, 1, 123, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (59, 1, 92, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor Kepala', 30, 16, 17280000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (33, 1, 66, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 4000000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (36, 1, 69, 'Matrikulasi', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Guru Besar', 30, 16, 4000000.00, '2025-12-27 06:10:37', '2025-12-29 08:52:37'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (60, 1, 93, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 20480000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (50, 1, 83, 'A', 'REGULER', NULL, 'Dr. Drs. Amat Komari M.Si.', 'Lektor Kepala', 30, 16, 6000000.00, '2025-12-27 06:10:37', '2026-01-20 04:58:01'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (64, 1, 97, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 346500000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (61, 1, 94, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor Kepala', 30, 16, 12960000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (62, 1, 95, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Lektor', 30, 16, 346500000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (58, 1, 91, 'Matrikulasi', 'REGULER', NULL, '196707011994121001', 'Guru Besar', 30, 16, 10240000.00, '2025-12-27 06:10:37', '2026-01-15 07:53:47'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (28, 1, 125, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 5250000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (15, 1, 112, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (1, 1, 98, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 1440000.00, '2025-12-27 06:10:37', '2026-01-21 06:55:23'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (21, 1, 118, 'B', 'REGULER', NULL, '199204152023211021', 'Lektor', 30, 16, 1440000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (23, 1, 120, 'A', 'REGULER', NULL, 'Dr. Dennis Dwi Kurniawan S.Pd., M.Pd.', 'Lektor', 30, 16, 2160000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (24, 1, 121, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 3440000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (7, 1, 104, 'A', 'REGULER', NULL, '1199611012023091048', 'Guru Besar', 30, 16, 2240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (6, 1, 103, 'C', 'REGULER', NULL, 'Sulthon Abdul Aziz M.S.I.', 'Lektor Kepala', 30, 16, 1760000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (16, 1, 113, 'A', 'REGULER', NULL, 'Riesti Cahyaningrum M.Pd.', 'Guru Besar', 30, 16, 4800000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (8, 1, 105, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 1120000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (12, 1, 109, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 6240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (11, 1, 108, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 2000000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (27, 1, 124, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 5250000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (29, 1, 126, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 5250000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (10, 1, 107, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor Kepala', 30, 16, 5040000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (30, 1, 127, 'B', 'REGULER', NULL, '1199902122023091093', 'Guru Besar', 30, 16, 5120000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (31, 1, 128, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 29250000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (25, 1, 122, 'B', 'REGULER', NULL, '1199902122023091093', 'Asisten Ahli', 30, 16, 1120000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (14, 1, 111, 'C', 'REGULER', NULL, 'Dr. Pasca Tri Kaloka S.Pd., M.Pd.', 'Tenaga Pengajar', 30, 16, 1920000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); INSERT INTO "public"."akademik_jadwal_kuliah" VALUES (20, 1, 117, 'B', 'REGULER', NULL, '1199902122023091093', 'Lektor', 30, 16, 4240000.00, '2025-12-27 06:10:37', '2026-01-06 04:21:18'); -- ---------------------------- -- Table structure for akademik_jadwal_tim_teaching -- ---------------------------- DROP TABLE IF EXISTS "public"."akademik_jadwal_tim_teaching"; CREATE TABLE "public"."akademik_jadwal_tim_teaching" ( "id" int8 NOT NULL DEFAULT nextval('akademik_jadwal_tim_teaching_id_seq'::regclass), "jadwal_id" int8 NOT NULL, "dosen_id" int8, "nama_dosen" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "jabatan_fungsional" varchar(50) COLLATE "pg_catalog"."default" NOT NULL, "jumlah_tatap_muka" int4 NOT NULL DEFAULT 0, "sks_beban" numeric(5,2) NOT NULL DEFAULT 0, "honor_diterima" numeric(15,2) NOT NULL DEFAULT 0 ) ; -- ---------------------------- -- Records of akademik_jadwal_tim_teaching -- ---------------------------- -- ---------------------------- -- Table structure for akademik_matakuliah -- ---------------------------- DROP TABLE IF EXISTS "public"."akademik_matakuliah"; CREATE TABLE "public"."akademik_matakuliah" ( "id" int8 NOT NULL DEFAULT nextval('akademik_matakuliah_id_seq'::regclass), "prodi_id" int8 NOT NULL, "kode_mk" varchar(20) COLLATE "pg_catalog"."default" NOT NULL, "nama_mk" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "sks_total" int4 NOT NULL DEFAULT 0, "sks_teori" int4 NOT NULL DEFAULT 0, "sks_praktik" int4 NOT NULL DEFAULT 0, "sks_lapangan" int4 NOT NULL DEFAULT 0, "jenis_mk" varchar(20) COLLATE "pg_catalog"."default" NOT NULL DEFAULT 'KULIAH'::character varying, "semester_paket" int4, "created_at" timestamp(6), "updated_at" timestamp(6) ) ; -- ---------------------------- -- Records of akademik_matakuliah -- ---------------------------- INSERT INTO "public"."akademik_matakuliah" VALUES (65, 5, 'MAT501', 'Filsafat Ilmu & Pendidikan Jasmani', 2, 2, 0, 0, 'KULIAH', 0, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (66, 5, 'MAT502', 'Statistik Terapan Lanjut', 2, 2, 0, 0, 'KULIAH', 0, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (67, 5, 'MKP601', 'Metodologi Penelitian Pendidikan Olahraga', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (68, 5, 'MKP602', 'Pedagogi Olahraga Sekolah Dasar', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (69, 5, 'MKP603', 'Psikologi Pendidikan Jasmani SD', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (70, 5, 'MKK604', 'Model & Desain Pembelajaran Penjas SD', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (71, 5, 'MKK605', 'Asesmen & Evaluasi Pembelajaran Penjas', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (72, 5, 'MKK606', 'Pengembangan Kurikulum Penjas SD', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (73, 5, 'MKK701', 'Analisis Gerak & Biomekanika SD', 3, 1, 2, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (74, 5, 'MKK702', 'Pendidikan Jasmani Adaptif Lanjut', 2, 1, 1, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (75, 5, 'MKK703', 'Teknologi Informasi dalam Penjas', 3, 1, 2, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (76, 5, 'MKK704', 'Manajemen Penjas & Olahraga Sekolah', 2, 2, 0, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (78, 5, 'MKT801', 'Penulisan Karya Ilmiah Internasional', 2, 1, 1, 0, 'KULIAH', 3, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (80, 5, 'MKK901', 'Tesis (Penelitian & Ujian)', 6, 0, 0, 6, 'BIMBINGAN_UJI', 4, '2025-12-27 02:15:28', '2025-12-27 02:15:28'); INSERT INTO "public"."akademik_matakuliah" VALUES (81, 6, 'MAT901', 'Filsafat Ilmu Keolahragaan Lanjut', 2, 2, 0, 0, 'KULIAH', 0, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (82, 6, 'MAT902', 'Metodologi Riset Kuantitatif & Kualitatif', 2, 2, 0, 0, 'KULIAH', 0, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (83, 6, 'DOK101', 'Filsafat Pendidikan Jasmani & Olahraga', 3, 3, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (85, 6, 'DOK103', 'Desain & Analisis Statistik Lanjut', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (87, 6, 'DOK201', 'Pengembangan Model Kurikulum Penjas SD', 3, 2, 1, 0, 'KULIAH', 2, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (88, 6, 'DOK202', 'Evaluasi Program & Kebijakan Penjas', 3, 2, 1, 0, 'KULIAH', 2, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (89, 6, 'DOK203', 'Seminar Proposal Disertasi (Pra-Kualifikasi)', 2, 0, 2, 0, 'BIMBINGAN_UJI', 2, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (95, 6, 'DOK501', 'Ujian Kelayakan Naskah Disertasi', 2, 0, 0, 2, 'BIMBINGAN_UJI', 5, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (96, 6, 'DOK601', 'Ujian Tertutup Disertasi', 3, 0, 0, 3, 'BIMBINGAN_UJI', 6, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (97, 6, 'DOK602', 'Promosi Doktor (Ujian Terbuka)', 4, 0, 0, 4, 'BIMBINGAN_UJI', 6, '2025-12-27 02:15:45', '2025-12-27 02:15:45'); INSERT INTO "public"."akademik_matakuliah" VALUES (98, 4, 'PJD101', 'Landasan Pendidikan Jasmani', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (99, 4, 'PJD102', 'Anatomi Manusia', 3, 2, 1, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (100, 4, 'PJD103', 'Fisiologi Dasar', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (101, 4, 'PJD104', 'Atletik Dasar (Lari & Lompat)', 3, 1, 2, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (102, 4, 'PJD105', 'Senam Dasar & Ritmik', 3, 1, 2, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (103, 4, 'UNY101', 'Pendidikan Agama', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (104, 4, 'UNY102', 'Pancasila', 2, 2, 0, 0, 'KULIAH', 1, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (105, 4, 'PJD201', 'Perkembangan Peserta Didik SD', 2, 2, 0, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (106, 4, 'PJD202', 'Belajar Gerak (Motor Learning)', 3, 2, 1, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (107, 4, 'PJD203', 'Renang Dasar & Penyelamatan Air', 3, 1, 2, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (108, 4, 'PJD204', 'Permainan Bola Kecil', 2, 1, 1, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (109, 4, 'PJD205', 'Permainan Bola Besar', 3, 1, 2, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (110, 4, 'UNY201', 'Bahasa Indonesia', 2, 2, 0, 0, 'KULIAH', 2, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (111, 4, 'PJD301', 'Strategi Pembelajaran Penjas SD', 3, 2, 1, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (112, 4, 'PJD302', 'Kurikulum Penjas SD (Merdeka)', 2, 2, 0, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (113, 4, 'PJD303', 'Pendidikan Jasmani Adaptif', 3, 2, 1, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (114, 4, 'PJD304', 'Aktivitas Luar Kelas', 3, 1, 2, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (115, 4, 'PJD305', 'Pencak Silat & Beladiri SD', 2, 1, 1, 0, 'KULIAH', 3, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (116, 4, 'PJD401', 'Evaluasi Pembelajaran Penjas', 3, 2, 1, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (117, 4, 'PJD402', 'Teknologi & Media Pembelajaran', 3, 1, 2, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (118, 4, 'PJD403', 'Manajemen Pendidikan Jasmani', 2, 2, 0, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (119, 4, 'PJD404', 'Gizi Olahraga & Kesehatan Sekolah', 2, 2, 0, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (120, 4, 'PJD405', 'Metodologi Penelitian Pendidikan', 3, 3, 0, 0, 'KULIAH', 4, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (121, 4, 'PJD501', 'Micro Teaching', 3, 1, 2, 0, 'KULIAH', 5, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (122, 4, 'PJD502', 'Statistika Pendidikan', 2, 2, 0, 0, 'KULIAH', 5, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (123, 4, 'PJD503', 'K3 Olahraga', 2, 2, 0, 0, 'KULIAH', 5, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (124, 4, 'PJD601', 'PLP / Magang Kependidikan 1', 2, 0, 0, 2, 'BIMBINGAN', 6, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (125, 4, 'UNY601', 'Kuliah Kerja Nyata (KKN)', 4, 0, 0, 4, 'BIMBINGAN', 6, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (126, 4, 'PJD701', 'PLP / Magang Kependidikan 2', 4, 0, 0, 4, 'BIMBINGAN', 7, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (84, 6, 'DOK102', 'Teori & Isu Kritis Penjas SD', 3, 3, 0, 0, 'KULIAH', 1, '2025-12-27 02:15:45', '2025-12-27 22:07:35'); INSERT INTO "public"."akademik_matakuliah" VALUES (79, 5, 'MKK802', 'Seminar Proposal Tesis', 2, 0, 2, 0, 'KULIAH', 3, '2025-12-27 02:15:28', '2025-12-28 07:09:22'); INSERT INTO "public"."akademik_matakuliah" VALUES (92, 6, 'DOK302', 'Validasi Instrumen & Pengumpulan Data', 4, 0, 4, 0, 'KULIAH', 3, '2025-12-27 02:15:45', '2025-12-27 22:08:26'); INSERT INTO "public"."akademik_matakuliah" VALUES (93, 6, 'DOK401', 'Analisis Data & Penulisan Disertasi', 4, 0, 4, 0, 'KULIAH', 4, '2025-12-27 02:15:45', '2025-12-27 22:08:43'); INSERT INTO "public"."akademik_matakuliah" VALUES (94, 6, 'DOK402', 'Publikasi Ilmiah Internasional 2', 3, 0, 3, 0, 'KULIAH', 4, '2025-12-27 02:15:45', '2025-12-27 22:08:53'); INSERT INTO "public"."akademik_matakuliah" VALUES (77, 5, 'MKK705', 'Isu-isu Kontemporer Penjas SD', 2, 2, 0, 0, 'KULIAH', 2, '2025-12-27 02:15:28', '2025-12-27 22:10:13'); INSERT INTO "public"."akademik_matakuliah" VALUES (127, 4, 'PJD702', 'Seminar Proposal Skripsi', 2, 0, 2, 0, 'KULIAH', 7, '2025-12-27 02:16:03', '2025-12-27 22:18:30'); INSERT INTO "public"."akademik_matakuliah" VALUES (91, 6, 'DOK301', 'Ujian Kualifikasi (Komprehensif)', 2, 0, 2, 0, 'KULIAH', 3, '2025-12-27 02:15:45', '2025-12-28 01:04:06'); INSERT INTO "public"."akademik_matakuliah" VALUES (128, 4, 'PJD801', 'Skripsi / Tugas Akhir', 6, 0, 0, 6, 'BIMBINGAN_UJI', 8, '2025-12-27 02:16:03', '2025-12-27 02:16:03'); INSERT INTO "public"."akademik_matakuliah" VALUES (90, 6, 'DOK204', 'Publikasi Ilmiah Internasional 1', 2, 0, 2, 0, 'KULIAH', 2, '2025-12-27 02:15:45', '2025-12-27 14:37:47'); INSERT INTO "public"."akademik_matakuliah" VALUES (86, 6, 'DOK104', 'Studi Mandiri (Independent Study)', 3, 0, 3, 0, 'KULIAH', 1, '2025-12-27 02:15:45', '2025-12-27 22:07:48'); -- ---------------------------- -- Primary Key structure for table akademik_jadwal_kuliah -- ---------------------------- ALTER TABLE "public"."akademik_jadwal_kuliah" ADD CONSTRAINT "pk_akademik_jadwal_kuliah" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table akademik_jadwal_tim_teaching -- ---------------------------- ALTER TABLE "public"."akademik_jadwal_tim_teaching" ADD CONSTRAINT "pk_akademik_jadwal_tim_teaching" PRIMARY KEY ("id"); -- ---------------------------- -- Primary Key structure for table akademik_matakuliah -- ---------------------------- ALTER TABLE "public"."akademik_matakuliah" ADD CONSTRAINT "pk_akademik_matakuliah" PRIMARY KEY ("id"); -- ---------------------------- -- Foreign Keys structure for table akademik_jadwal_kuliah -- ---------------------------- ALTER TABLE "public"."akademik_jadwal_kuliah" ADD CONSTRAINT "akademik_jadwal_kuliah_mk_id_foreign" FOREIGN KEY ("mk_id") REFERENCES "public"."akademik_matakuliah" ("id") ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE "public"."akademik_jadwal_kuliah" ADD CONSTRAINT "akademik_jadwal_kuliah_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table akademik_jadwal_tim_teaching -- ---------------------------- ALTER TABLE "public"."akademik_jadwal_tim_teaching" ADD CONSTRAINT "akademik_jadwal_tim_teaching_jadwal_id_foreign" FOREIGN KEY ("jadwal_id") REFERENCES "public"."akademik_jadwal_kuliah" ("id") ON DELETE CASCADE ON UPDATE CASCADE; -- ---------------------------- -- Foreign Keys structure for table akademik_matakuliah -- ---------------------------- ALTER TABLE "public"."akademik_matakuliah" ADD CONSTRAINT "akademik_matakuliah_prodi_id_foreign" FOREIGN KEY ("prodi_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE CASCADE;