set client_encoding to 'win';
        copy "TAGS" from 'd:\\1.csv' delimiter ';' CSV;

CREATE TABLE "TAGS"
(
  "ID" bigint NOT NULL DEFAULT nextval('"TAGS_seq"'::regclass),
  "NAME" character varying(256) NOT NULL,
  "DOCTOR_TYPE_ID" integer,
  "DOCTOR_ID" bigint,
  "IS_PRINT" boolean,
  CONSTRAINT "TAGS_pkey" PRIMARY KEY ("ID"),
  CONSTRAINT "DOCTOR_ID2" FOREIGN KEY ("DOCTOR_ID")
      REFERENCES "DOCTORS" ("ID") MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT "DOCTOR_TYPE_ID3" FOREIGN KEY ("DOCTOR_TYPE_ID")
      REFERENCES "DOCTOR_TYPE_IDS" ("ID") MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT positive_doctor_id CHECK ("DOCTOR_ID" > 0),
  CONSTRAINT positive_doctor_type_id CHECK ("DOCTOR_TYPE_ID" > 0)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "TAGS"
  OWNER TO postgres;

-- Index: duplicate__name__doctor_id

-- DROP INDEX duplicate__name__doctor_id;

CREATE UNIQUE INDEX duplicate__name__doctor_id
  ON "TAGS"
  USING btree
  ("NAME" COLLATE pg_catalog."default", "DOCTOR_ID");

-- Index: duplicate__name__doctor_type_id

-- DROP INDEX duplicate__name__doctor_type_id;

CREATE UNIQUE INDEX duplicate__name__doctor_type_id
  ON "TAGS"
  USING btree
  ("NAME" COLLATE pg_catalog."default", "DOCTOR_TYPE_ID");

-- Index: "fki_DOCTOR_ID2"

-- DROP INDEX "fki_DOCTOR_ID2";

CREATE INDEX "fki_DOCTOR_ID2"
  ON "TAGS"
  USING btree
  ("DOCTOR_ID");

-- Index: "fki_DOCTOR_TYPE_ID3"

-- DROP INDEX "fki_DOCTOR_TYPE_ID3";

CREATE INDEX "fki_DOCTOR_TYPE_ID3"
  ON "TAGS"
  USING btree
  ("DOCTOR_TYPE_ID");