CREATE TABLE IF NOT EXISTS "eacg_mall_settle_strategy" (
"id" serial4 NOT NULL,
"type" int2 NOT NULL,
"name" varchar(64),
"info" varchar(256),
"s_time" timestamp(0) NOT NULL,
"e_time" timestamp(0) NOT NULL,
"mall_id" varchar(16) NOT NULL,
"main_sit_id" varchar(16),
"ext_sites" varchar(16)[],
"ext_brands" varchar(16)[],
"sett_code" varchar(32),
"sett_temp" varchar(32),
"sett_rule" JSONB,
"cert_img" varchar(256)[],
"status" int2 DEFAULT 1,
"apv_status" int2,
"apv_user" int4,
"apv_memo" varchar(256),
"apv_time" timestamp(0),
"crt_user" int4,
"crt_time" timestamp(0) DEFAULT CURRENT_TIMESTAMP,
"rec_user" int4,
"rec_time" timestamp(0) DEFAULT CURRENT_TIMESTAMP,
CONSTRAINT "eacg_mall_settle_strategy_pkey" PRIMARY KEY ("id")
);
varchar(16)[]的含义是一个逗号里面的值不能超过16字符
{ahajauajau,ajauajajau111111111}