CREATE TABLE "mailbox"."mail_ai_determine" (
                                      "id" serial8 NOT NULL,
                                      "source_mail_id" varchar(40),
                                      "target_mail_id" varchar(40),
                                      "score" float4,
                                      "create_time" timestamp,
                                      "determine_type" varchar(255),
                                      PRIMARY KEY ("id")
);

COMMENT ON COLUMN "mailbox"."mail_ai_determine"."source_mail_id" IS '源信件ID';

COMMENT ON COLUMN "mailbox"."mail_ai_determine"."target_mail_id" IS '目标信件ID';

COMMENT ON COLUMN "mailbox"."mail_ai_determine"."score" IS '相识度';

COMMENT ON COLUMN "mailbox"."mail_ai_determine"."determine_type" IS '类型 repeat-重复 similarity-相识';

ALTER TABLE "mailbox"."mail_source"
    ADD COLUMN "ai_determine_state" varchar(20);

COMMENT ON COLUMN "mailbox"."mail_source"."ai_determine_state" IS 'AI 判断状态';

ALTER TABLE "mailbox"."mail_source"
    ADD COLUMN "ai_determine_total" int;
COMMENT ON COLUMN "mailbox"."mail_source"."ai_determine_total" IS 'AI 判断数量';

update mail set mail_source_id = id;

ALTER TABLE "mailbox"."notice"
    ADD COLUMN "notify" varchar(255),
  ADD COLUMN "device" varchar(255);

COMMENT ON COLUMN "mailbox"."notice"."notify" IS '通知人';

COMMENT ON COLUMN "mailbox"."notice"."device" IS '通知设备';