DbScripts/Tables.txt

CREATE TABLE IF NOT EXISTS public.jdmaster
(
    jdmasterid integer NOT NULL,
    jobdescription text COLLATE pg_catalog."default",
    filename character varying(1032) COLLATE pg_catalog."default",
    uploadeddate character varying(32) COLLATE pg_catalog."default",
    isdetailsextracted integer,
    isskillsextracted integer,
    source character varying(255) COLLATE pg_catalog."default" DEFAULT 'JD'::character varying,
    uploadedby character(100) COLLATE pg_catalog."default",
    CONSTRAINT jdmaster_pkey PRIMARY KEY (jdmasterid)
);

CREATE TABLE IF NOT EXISTS public.jdskilldetails
(
    skilldetailsid integer NOT NULL DEFAULT nextval('jdskilldetails_skilldetailsid_seq'::regclass),
    skillid integer NOT NULL,
    jdmasterid integer,
    modifieddate timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT jdskilldetails_pkey PRIMARY KEY (skilldetailsid)
);

CREATE TABLE IF NOT EXISTS public.skillmaster
(
    skillid integer NOT NULL DEFAULT nextval('skillmaster_skillid_seq'::regclass),
    skilldetails character varying(255) COLLATE pg_catalog."default" NOT NULL,
    skilltype character varying(50) COLLATE pg_catalog."default",
    weightage numeric(10,2),
    updateddate timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    isactive boolean DEFAULT true,
    skill_score character varying(20) COLLATE pg_catalog."default",
    CONSTRAINT skillmaster_pkey PRIMARY KEY (skillid)
);

CREATE TABLE IF NOT EXISTS public.coursemaster
(
    masterid integer NOT NULL,
    description text COLLATE pg_catalog."default",
    filename character varying(1032) COLLATE pg_catalog."default",
    uploadeddate character varying(32) COLLATE pg_catalog."default",
    isdetailsextracted integer,
    isskillsextracted integer,
    source character varying(255) COLLATE pg_catalog."default" DEFAULT 'Online'::character varying,
    CONSTRAINT master_pkey PRIMARY KEY (masterid)
);

CREATE TABLE IF NOT EXISTS public.courseskilldetails
(
    skilldetailsid integer NOT NULL DEFAULT nextval('courseskilldetails_skilldetailsid_seq'::regclass),
    skillid integer NOT NULL,
    masterid integer,
    modifieddate timestamp without time zone DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT skilldetails_pkey PRIMARY KEY (skilldetailsid)
);

CREATE TABLE IF NOT EXISTS public.courseskillmatch
(
    skillmatchid integer NOT NULL,
    courseid integer NOT NULL,
    jdmasterid integer NOT NULL,
    matchscore double precision NOT NULL,
    isactive integer DEFAULT 1
);