/*
 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:15:39
*/


-- ----------------------------
-- Table structure for ms_academic_years
-- ----------------------------
DROP TABLE IF EXISTS "public"."ms_academic_years";
CREATE TABLE "public"."ms_academic_years" (
  "id" int4 NOT NULL DEFAULT nextval('ms_academic_years_id_seq'::regclass),
  "year_name" varchar(20) COLLATE "pg_catalog"."default" NOT NULL,
  "is_active" bool NOT NULL DEFAULT false,
  "description" text COLLATE "pg_catalog"."default",
  "created_at" timestamp(6),
  "updated_at" timestamp(6)
)
;

-- ----------------------------
-- Records of ms_academic_years
-- ----------------------------
INSERT INTO "public"."ms_academic_years" VALUES (2, '2025/2026', 'f', '', '2025-12-07 23:46:46', '2026-01-27 04:25:11');
INSERT INTO "public"."ms_academic_years" VALUES (1, '2024/2025', 't', '', NULL, '2026-01-27 04:25:15');

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