-- Table: "DOCTOR_PHOTOS"

-- DROP TABLE "DOCTOR_PHOTOS";

CREATE TABLE "DOCTOR_PHOTOS"
(
  "ID" bigint NOT NULL DEFAULT nextval('"DOCTOR_PHOTOS_seq"'::regclass),
  "DOCTOR_ID" bigint NOT NULL,
  "PHOTO" character varying(64),
  "IS_PRIMARY" boolean,
  "EXPIRATION_TIME" timestamp without time zone,
  "IS_ICON" boolean,
  CONSTRAINT "DOCTOR_PHOTOS_pkey" PRIMARY KEY ("ID" ),
  CONSTRAINT "DOCTOR_ID3" FOREIGN KEY ("DOCTOR_ID")
      REFERENCES "DOCTORS" ("ID") MATCH SIMPLE
      ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT positive_doctor_id CHECK ("DOCTOR_ID" > 0)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE "DOCTOR_PHOTOS"
  OWNER TO postgres;

-- Index: "fki_DOCTOR_ID3"

-- DROP INDEX "fki_DOCTOR_ID3";

CREATE INDEX "fki_DOCTOR_ID3"
  ON "DOCTOR_PHOTOS"
  USING btree
  ("DOCTOR_ID" );

-- Index: original_is_icon_photo

-- DROP INDEX original_is_icon_photo;

CREATE UNIQUE INDEX original_is_icon_photo
  ON "DOCTOR_PHOTOS"
  USING btree
  ("DOCTOR_ID" , "IS_ICON" )
  WHERE "IS_ICON" = true;

-- Index: original_primary_photo

-- DROP INDEX original_primary_photo;

CREATE UNIQUE INDEX original_primary_photo
  ON "DOCTOR_PHOTOS"
  USING btree
  ("DOCTOR_ID" , "IS_PRIMARY" )
  WHERE "IS_PRIMARY" = true;

CREATE UNIQUE INDEX original_is_icon_photo
  ON "DOCTOR_PHOTOS"
  USING btree
  ("DOCTOR_ID" , "IS_ICON" )
  WHERE "IS_ICON" = true;