/*
 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:25
*/


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

-- ----------------------------
-- Records of ms_faculties
-- ----------------------------
INSERT INTO "public"."ms_faculties" VALUES (1, 'FIKK', 'Fakultas Ilmu Keolahragaan dan Kesehatan', NULL, NULL, NULL);
INSERT INTO "public"."ms_faculties" VALUES (2, 'FV', 'Fakultas Vokasi', '2025-12-27 00:46:50', '2025-12-27 00:46:50', NULL);

-- ----------------------------
-- Uniques structure for table ms_faculties
-- ----------------------------
ALTER TABLE "public"."ms_faculties" ADD CONSTRAINT "unique_faculty_code" UNIQUE ("faculty_code");

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