DROP TABLE IF EXISTS "public"."a_test";
CREATE TABLE "public"."a_test" (
"value" varchar(255) COLLATE "pg_catalog"."default"
);
ALTER TABLE "public"."a_test" OWNER TO "postgres";
> 在租户schema下建子表
DROP TABLE IF EXISTS "t201630688032706560"."a_test";
CREATE TABLE "t201630688032706560"."a_test" (
"value" varchar(255) COLLATE "pg_catalog"."default"
)
INHERITS (yqcloud_new."public"."a_test") -- 这里设置继承关系
;
ALTER TABLE "t201630688032706560"."a_test" OWNER TO "postgres";
DROP TABLE IF EXISTS "t201058255663910912"."a_test";
CREATE TABLE "t201058255663910912"."a_test" (
"value" varchar(255) COLLATE "pg_catalog"."default"
)
INHERITS (yqcloud_new."public"."a_test") -- 这里设置继承关系
;
ALTER TABLE "t201058255663910912"."a_test" OWNER TO "postgres";
SELECT
ref_id,
-- 员工编号
ref_values::json->>'input_syyntepj' as employee_num,
-- 员工姓名
ref_values::json->'input_cdxrtboz' as employee_name,
-- 交通车迟到日期
ref_values::json->'date_mmoisvtl' as bus_late_date,
-- 附件
ref_values::json->>'upload_cahrrpvj' as file
FROM sc_req_var_value
WHERE ref_id = '221960307189223424'
SELECT
s1.id,
s1.name bus_name,
s1.json_data::json#>>'{equalsConfig, name}' as rule_name,
s1.json_data::json#>>'{equalsConfig, value}' as rule_value,
s1.json_data::json#>'{equalsConfig, ruleType}' as value_rule,
s1.error_message
FROM lc_object_validation_rule s1
WHERE s1.id = '240413298825101312';