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,
  "TAG_ID" bigint,
  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");

CREATE TABLE "TAG_IDS"
(
  "ID" bigint NOT NULL DEFAULT nextval('"TAG_IDS_seq"'::regclass),
  "NAME" character varying(64),
  CONSTRAINT "TAG_IDS_pkey" PRIMARY KEY ("ID"),
  CONSTRAINT unique_tag_ids UNIQUE ("NAME")
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "TAG_IDS"
  OWNER TO postgres;