text: -- Table: public.pubcode_table1
  
  -- DROP TABLE public.pubcode_table1;
  
  CREATE TABLE public.pubcode_table1
  (
      "CodeTitle" character varying(20) COLLATE pg_catalog."default" NOT NULL,
      "PCID" character varying(20) COLLATE pg_catalog."default" NOT NULL,
      "PMID" character varying(20) COLLATE pg_catalog."default",
      "PMCID" character varying(20) COLLATE pg_catalog."default",
      "PaperPubDate" date,
      "CodePubDate" date,
      "Authors" character varying(500) COLLATE pg_catalog."default" NOT NULL,
      "CodeLanguage" character varying(50) COLLATE pg_catalog."default",
      "OS" character varying(20) COLLATE pg_catalog."default",
      "Dependencies" character varying(500) COLLATE pg_catalog."default",
      "Licensing" character varying(20) COLLATE pg_catalog."default",
      "Version" varchar(10) COLLATE pg_catalog."default",
      "Keywords" character varying(500) COLLATE pg_catalog."default",
      "Dataset_IDs" character varying(20) COLLATE pg_catalog."default",
      "GitHub_URL" character varying(50) COLLATE pg_catalog."default",
      "GH_Forks" integer,
      "GH_OpenIssues" integer,
      "GH_ClosedIssues" integer,
      "GH_DateUpdate" date,
      "Description" varchar(1000) COLLATE pg_catalog."default",
      "WhoShouldUse" varchar(1000) COLLATE pg_catalog."default",
      "HowToUse" varchar(1000) COLLATE pg_catalog."default",
      CONSTRAINT "pubcode_table1_pkey" PRIMARY KEY ("CodeTitle", "PCID")
  )
  WITH (
      OIDS = FALSE
  )
  TABLESPACE pg_default;
  
  ALTER TABLE public.pubcode_table1
      OWNER to postgres;
  