/*
 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: 02/05/2026 17:03:43
*/


-- ----------------------------
-- Table structure for trans_driver_values
-- ----------------------------
DROP TABLE IF EXISTS "public"."trans_driver_values";
CREATE TABLE "public"."trans_driver_values" (
  "id" int8 NOT NULL DEFAULT nextval('trans_driver_values_id_seq'::regclass),
  "year_id" int4 NOT NULL,
  "driver_id" int4 NOT NULL,
  "study_program_id" int4,
  "value_amount" numeric(10,2) NOT NULL DEFAULT 0,
  "description" text COLLATE "pg_catalog"."default",
  "created_at" timestamp(6),
  "updated_at" timestamp(6),
  "faculty_code" varchar(20) COLLATE "pg_catalog"."default",
  "department_id" int4
)
;

-- ----------------------------
-- Records of trans_driver_values
-- ----------------------------
INSERT INTO "public"."trans_driver_values" VALUES (5, 1, 7, 5, 400.00, 'Gedung Pasca Lt 3', '2026-01-02 09:37:22', NULL, NULL, NULL);
INSERT INTO "public"."trans_driver_values" VALUES (6, 1, 7, 6, 200.00, 'Gedung Pasca Lt 4', '2026-01-02 09:37:22', NULL, NULL, NULL);
INSERT INTO "public"."trans_driver_values" VALUES (10, 1, 9, 4, 25.00, 'MK Praktik Lapangan', '2026-01-02 09:37:22', NULL, NULL, NULL);
INSERT INTO "public"."trans_driver_values" VALUES (11, 1, 9, 5, 5.00, 'MK Tes & Pengukuran Fisik', '2026-01-02 09:37:22', NULL, NULL, NULL);
INSERT INTO "public"."trans_driver_values" VALUES (7, 1, 8, 4, 6.00, 'Dosen pengampu mata kuliah dasar & praktik', '2026-01-02 09:37:22', '2026-01-06 01:33:29', NULL, NULL);
INSERT INTO "public"."trans_driver_values" VALUES (8, 1, 8, 5, 6.00, 'Dosen kualifikasi Doktor/Lektor Kepala', '2026-01-02 09:37:22', '2026-01-06 01:34:22', NULL, NULL);
INSERT INTO "public"."trans_driver_values" VALUES (9, 1, 8, 6, 6.00, 'Guru Besar (Profesor)', '2026-01-02 09:37:22', '2026-01-06 01:34:35', NULL, NULL);
INSERT INTO "public"."trans_driver_values" VALUES (12, 1, 1, 4, 5000.00, '', '2026-04-04 06:41:23', NULL, 'FIKK', 1);
INSERT INTO "public"."trans_driver_values" VALUES (4, 1, 7, NULL, 1500.00, 'Gedung A Lt 1-2 + GOR Basket', '2026-01-02 09:37:22', '2026-04-04 06:44:36', 'FIKK', 1);
INSERT INTO "public"."trans_driver_values" VALUES (1, 1, 2, 4, 90.00, 'Data Registrasi Semester Ganjil 2024', '2026-01-02 09:37:22', '2026-04-04 23:56:26', 'FIKK', 1);
INSERT INTO "public"."trans_driver_values" VALUES (3, 1, 2, 6, 30.00, 'Data Registrasi Semester Ganjil 2024', '2026-01-02 09:37:22', '2026-04-05 01:58:58', 'FIKK', 1);
INSERT INTO "public"."trans_driver_values" VALUES (2, 1, 2, 5, 40.00, 'Data Registrasi Semester Ganjil 2024', '2026-01-02 09:37:22', '2026-04-05 02:00:41', 'FIKK', 1);

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

-- ----------------------------
-- Foreign Keys structure for table trans_driver_values
-- ----------------------------
ALTER TABLE "public"."trans_driver_values" ADD CONSTRAINT "fk_trans_driver_faculty_code" FOREIGN KEY ("faculty_code") REFERENCES "public"."ms_faculties" ("faculty_code") ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE "public"."trans_driver_values" ADD CONSTRAINT "trans_driver_values_study_program_id_foreign" FOREIGN KEY ("study_program_id") REFERENCES "public"."ms_study_programs" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE "public"."trans_driver_values" ADD CONSTRAINT "trans_driver_values_year_id_foreign" FOREIGN KEY ("year_id") REFERENCES "public"."ms_academic_years" ("id") ON DELETE CASCADE ON UPDATE CASCADE;
