/*
 Navicat Premium Data Transfer

 Source Server         : kgte_2022
 Source Server Type    : PostgreSQL
 Source Server Version : 90525
 Source Host           : localhost:5432
 Source Catalog        : kgte2022
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 90525
 File Encoding         : 65001

 Date: 29/03/2023 14:13:18
*/


-- ----------------------------
-- Table structure for subject_details
-- ----------------------------
DROP TABLE IF EXISTS "public"."subject_details";
CREATE TABLE "public"."subject_details" (
  "subject_code" char(8) COLLATE "pg_catalog"."default" NOT NULL,
  "subject_descr" varchar(150) COLLATE "pg_catalog"."default",
  "grade" char(50) COLLATE "pg_catalog"."default",
  "shortdescr" varchar(255) COLLATE "pg_catalog"."default",
  "papers" int4,
  "fees" int4,
  "pvt" bool
)
;

-- ----------------------------
-- Records of subject_details
-- ----------------------------
INSERT INTO "public"."subject_details" VALUES ('01      ', 'Typewriting English  and Computer Word Processing(Lower)', 'Lower                                             ', 'Type Eng & CWP Lower', 3, 90, 'f');
INSERT INTO "public"."subject_details" VALUES ('02      ', 'Typewriting English  and Computer Word Processing(Higher)', 'Higher                                            ', 'Type Eng & CWP Higher', 3, 115, 'f');
INSERT INTO "public"."subject_details" VALUES ('03      ', 'Typewriting English(High Speed) ', 'High Speed                                        ', 'Type English High speed', 1, 115, 'f');
INSERT INTO "public"."subject_details" VALUES ('04      ', 'Typewriting Malayalam  and Computer Word Processing(Lower)', 'Lower                                             ', 'Type Mal & CWP Lower', 3, 90, 'f');
INSERT INTO "public"."subject_details" VALUES ('05      ', 'Typewriting Malayalam  and Computer Word Processing(Higher)', 'Higher                                            ', 'Type Mal & CWP Higher', 3, 115, 'f');
INSERT INTO "public"."subject_details" VALUES ('06      ', 'Typewriting Hindi(Lower)', 'Lower                                             ', 'Type Writing Hindi Lower', 2, 90, 'f');
INSERT INTO "public"."subject_details" VALUES ('07      ', 'Typewriting Hindi(Higher) ', 'Higher                                            ', 'Type Writing Hindi Higher', 2, 115, 'f');
INSERT INTO "public"."subject_details" VALUES ('08      ', 'Shorthand English(Lower) ', 'Lower                                             ', 'Shorthand English Lower', 2, 70, 'f');
INSERT INTO "public"."subject_details" VALUES ('09      ', 'Shorthand English(Higher) ', 'Higher                                            ', 'Shorthand English Higher', 3, 90, 'f');
INSERT INTO "public"."subject_details" VALUES ('10      ', 'Shorthand English(High Speed) ', 'High Speed                                        ', 'Short.English High Speed', 2, 115, 'f');
INSERT INTO "public"."subject_details" VALUES ('11      ', 'Shorthand Malayalam(Lower)', 'Lower                                             ', 'Short. Malayalam Lower', 2, 70, 'f');
INSERT INTO "public"."subject_details" VALUES ('12      ', 'Shorthand Malayalam(Higher) ', 'Higher                                            ', 'Short. Malayalam Higher', 3, 90, 'f');
INSERT INTO "public"."subject_details" VALUES ('17      ', 'Typewriting English (Lower)  Part', 'Lower                                             ', 'Type Eng Lower', 3, 90, 't');
INSERT INTO "public"."subject_details" VALUES ('18      ', 'Typewriting English (Higher) Part', 'Higher                                            ', 'Type Eng Higher', 3, 115, 't');
INSERT INTO "public"."subject_details" VALUES ('19      ', 'Typewriting Malayalam (Lower) Part', 'Lower                                             ', 'Type Mal Lower', 3, 90, 't');
INSERT INTO "public"."subject_details" VALUES ('20      ', 'Typewriting Malayalam (Higher) Part', 'Higher                                            ', 'Type Mal  Higher', 3, 115, 't');
INSERT INTO "public"."subject_details" VALUES ('16      ', ' Word processing Malayalam(Higher) Part', 'Higher                                            ', 'Word proc.Mal.Higher', 1, 0, 't');
INSERT INTO "public"."subject_details" VALUES ('14      ', ' Word Processing English(Higher) Part', 'Higher                                            ', 'Word Proc Eng Higher', 1, 0, 't');
INSERT INTO "public"."subject_details" VALUES ('21      ', 'Computer word processing English(Lower)  Regular', 'Lower                                             ', 'Word Proc Eng Lower', 1, 0, 'f');
INSERT INTO "public"."subject_details" VALUES ('23      ', 'Computer word processing Malayalam(Lower)  Regular', 'Lower                                             ', 'Word Proc Mal Lower', 1, 0, 't');
INSERT INTO "public"."subject_details" VALUES ('22      ', 'Computer word processing English(Higher)  Regular', 'Higher                                            ', 'Word Proc Eng Higher', 1, 0, 'f');
INSERT INTO "public"."subject_details" VALUES ('24      ', 'Computer word processing Malayalam(Higher)  Regular', 'Higher                                            ', 'Word proc.Mal.Higher', 1, 0, 'f');
INSERT INTO "public"."subject_details" VALUES ('15      ', ' Word processing Malayalam(Lower) Part', 'Lower                                             ', 'Word Proc Mal Lower', 1, 0, 't');
INSERT INTO "public"."subject_details" VALUES ('13      ', ' Word Processing  English(Lower) Part', 'Lower                                             ', 'Word proc.Eng.Lower', 1, 0, 't');

-- ----------------------------
-- Primary Key structure for table subject_details
-- ----------------------------
ALTER TABLE "public"."subject_details" ADD CONSTRAINT "subject_details_old_copy1_pkey" PRIMARY KEY ("subject_code");