/*
 Navicat Premium Data Transfer

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

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

 Date: 03/05/2023 11:28:11
*/


-- ----------------------------
-- Table structure for cand_verification
-- ----------------------------
DROP TABLE IF EXISTS "KGTENOV2022"."cand_verification";
CREATE TABLE "KGTENOV2022"."cand_verification" (
  "id" int8 NOT NULL DEFAULT nextval('"KGTENOV2022".candverifyid_seq'::regclass),
  "application_id" char(7) COLLATE "pg_catalog"."default" NOT NULL,
  "fee_verify" char(2) COLLATE "pg_catalog"."default",
  "lower_part_verify" char(6) COLLATE "pg_catalog"."default" NOT NULL,
  "qualification_verify" char(3) COLLATE "pg_catalog"."default" NOT NULL,
  "verified_id" char(4) COLLATE "pg_catalog"."default" NOT NULL,
  "verified_date" timestamp(6),
  "rejection_id" char(4) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of cand_verification
-- ----------------------------
INSERT INTO "KGTENOV2022"."cand_verification" VALUES (8, '4JE45  ', 'N ', 'N     ', 'N  ', '1   ', '2023-04-27 15:34:28', NULL);

-- ----------------------------
-- Primary Key structure for table cand_verification
-- ----------------------------
ALTER TABLE "KGTENOV2022"."cand_verification" ADD CONSTRAINT "cand_verification_pkey1" PRIMARY KEY ("application_id");
