DROP TABLE IF EXISTS "public"."account_practitioner_info";
CREATE TABLE "public"."account_practitioner_info" (
  "account_id" int8 NOT NULL,
  "practitioner_id" int8 NOT NULL
)
;

DROP TABLE IF EXISTS "public"."account_practitioners";
CREATE TABLE "public"."account_practitioners" (
  "account_id" int8 NOT NULL,
  "practitioner_id" int8 NOT NULL
)
;

ALTER TABLE "public"."account_practitioner_info" ADD CONSTRAINT "account_practitioner_info_pkey" PRIMARY KEY ("account_id");

ALTER TABLE "public"."account_practitioners" ADD CONSTRAINT "account_id_uniq" UNIQUE ("account_id");

ALTER TABLE "public"."account_practitioners" ADD CONSTRAINT "account_practitioners_pkey" PRIMARY KEY ("account_id", "practitioner_id");

ALTER TABLE "public"."account_practitioner_info" ADD CONSTRAINT "link" FOREIGN KEY ("account_id", "practitioner_id") REFERENCES "public"."account_practitioners" ("account_id", "practitioner_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
ALTER TABLE "public"."account_practitioner_info" ADD CONSTRAINT "link1" FOREIGN KEY ("account_id") REFERENCES "public"."account_practitioners" ("account_id") ON DELETE NO ACTION ON UPDATE NO ACTION;