ALTER TABLE HUGETEST.dyh_case_info_unfold ADD is_risk INT DEFAULT 0
COMMENT ON COLUMN HUGETEST.dyh_case_info_unfold.is_risk IS '是否风险案件';

CREATE TABLE "HUGETEST"."dyh_case_repeat"
(
    "id" VARCHAR(100) NOT NULL,
    "case_id" VARCHAR(100),
    "case_main_id" VARCHAR(100),
    "oper_user_id" VARCHAR(100),
    "oper_user_name" VARCHAR(100),
    "create_time" TIMESTAMP(6),
    "update_time" TIMESTAMP(6),
    NOT CLUSTER PRIMARY KEY("id")) STORAGE(ON "MAIN", CLUSTERBTR) ;

COMMENT ON TABLE "HUGETEST"."dyh_case_repeat" IS '重复来访案件合并关系表';
COMMENT ON COLUMN "HUGETEST"."dyh_case_repeat"."case_id" IS '合并案件编号';
COMMENT ON COLUMN "HUGETEST"."dyh_case_repeat"."case_main_id" IS '主案件编号';
COMMENT ON COLUMN "HUGETEST"."dyh_case_repeat"."create_time" IS '创建时间';
COMMENT ON COLUMN "HUGETEST"."dyh_case_repeat"."id" IS '主键编号';
COMMENT ON COLUMN "HUGETEST"."dyh_case_repeat"."oper_user_id" IS '操作人编号';
COMMENT ON COLUMN "HUGETEST"."dyh_case_repeat"."oper_user_name" IS '操作人名称';
COMMENT ON COLUMN "HUGETEST"."dyh_case_repeat"."update_time" IS '更新时间';