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


-- ----------------------------
-- Table structure for ms_user_levels
-- ----------------------------
DROP TABLE IF EXISTS "public"."ms_user_levels";
CREATE TABLE "public"."ms_user_levels" (
  "id" int8 NOT NULL DEFAULT nextval('ms_user_levels_id_seq'::regclass),
  "level_code" varchar(20) COLLATE "pg_catalog"."default" NOT NULL,
  "level_name" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "hierarchy_order" int4 NOT NULL DEFAULT 0
)
;

-- ----------------------------
-- Records of ms_user_levels
-- ----------------------------
INSERT INTO "public"."ms_user_levels" VALUES (1, 'UNIV', 'Universitas', 1);
INSERT INTO "public"."ms_user_levels" VALUES (2, 'FACULTY', 'Fakultas', 2);
INSERT INTO "public"."ms_user_levels" VALUES (3, 'DEPT', 'Departemen', 3);
INSERT INTO "public"."ms_user_levels" VALUES (4, 'PRODI', 'Program Studi', 4);
INSERT INTO "public"."ms_user_levels" VALUES (5, 'ALL', 'Semua Level', 0);

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