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 '更新时间';
|
