/*
 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: 24/04/2026 17:08:14
*/


-- ----------------------------
-- Table structure for ms_departments
-- ----------------------------
DROP TABLE IF EXISTS "public"."ms_departments";
CREATE TABLE "public"."ms_departments" (
  "id" int8 NOT NULL DEFAULT nextval('ms_departments_id_seq'::regclass),
  "department_code" varchar(20) COLLATE "pg_catalog"."default",
  "department_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "faculty_id" int8,
  "created_at" timestamp(6),
  "updated_at" timestamp(6),
  "deleted_at" timestamp(6)
)
;

-- ----------------------------
-- Records of ms_departments
-- ----------------------------
INSERT INTO "public"."ms_departments" VALUES (1, 'DEPT-PJSD', 'Departemen Pendidikan Jasmani Sekolah Dasar', 1, NULL, NULL, NULL);
INSERT INTO "public"."ms_departments" VALUES (2, 'DEPT-PO', 'Departemen Pendidikan Olahraga', 1, NULL, NULL, NULL);

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