From baac505052a5d9e63536eb7de32ba346d7e98ca7 Mon Sep 17 00:00:00 2001
From: p-honggang.li <p-honggang.li@pcitc.com>
Date: 星期六, 06 九月 2025 10:44:03 +0800
Subject: [PATCH] 修改审核订单查询获取正确taskid的问题
---
sql/public.sql | 1504 +++++++++++++++++----------------------------------------
1 files changed, 458 insertions(+), 1,046 deletions(-)
diff --git a/sql/public.sql b/sql/public.sql
index 906f831..7cc8522 100644
--- a/sql/public.sql
+++ b/sql/public.sql
@@ -12,289 +12,25 @@
Target Server Version : 130000
File Encoding : 65001
- Date: 15/08/2025 19:07:13
+ Date: 28/08/2025 08:22:54
*/
-- ----------------------------
--- Sequence structure for cart_id_seq
+-- Table structure for tb_cart
-- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."cart_id_seq";
-CREATE SEQUENCE "public"."cart_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for cart_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."cart_id_seq1";
-CREATE SEQUENCE "public"."cart_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for order_approval_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_approval_id_seq";
-CREATE SEQUENCE "public"."order_approval_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for order_approval_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_approval_id_seq1";
-CREATE SEQUENCE "public"."order_approval_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for order_attachment_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_attachment_id_seq";
-CREATE SEQUENCE "public"."order_attachment_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for order_attachment_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_attachment_id_seq1";
-CREATE SEQUENCE "public"."order_attachment_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for order_detail_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_detail_id_seq";
-CREATE SEQUENCE "public"."order_detail_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for order_detail_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_detail_id_seq1";
-CREATE SEQUENCE "public"."order_detail_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for order_evaluation_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_evaluation_id_seq";
-CREATE SEQUENCE "public"."order_evaluation_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for order_evaluation_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_evaluation_id_seq1";
-CREATE SEQUENCE "public"."order_evaluation_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for points_account_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."points_account_id_seq";
-CREATE SEQUENCE "public"."points_account_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for points_flow_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."points_flow_id_seq";
-CREATE SEQUENCE "public"."points_flow_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for points_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."points_id_seq";
-CREATE SEQUENCE "public"."points_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for points_rule_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."points_rule_id_seq";
-CREATE SEQUENCE "public"."points_rule_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for points_transaction_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."points_transaction_id_seq";
-CREATE SEQUENCE "public"."points_transaction_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for product_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."product_id_seq";
-CREATE SEQUENCE "public"."product_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for product_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."product_id_seq1";
-CREATE SEQUENCE "public"."product_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for product_pricing_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."product_pricing_id_seq";
-CREATE SEQUENCE "public"."product_pricing_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for product_pricing_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."product_pricing_id_seq1";
-CREATE SEQUENCE "public"."product_pricing_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for unit_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."unit_id_seq";
-CREATE SEQUENCE "public"."unit_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for unit_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."unit_id_seq1";
-CREATE SEQUENCE "public"."unit_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for user_points_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."user_points_id_seq";
-CREATE SEQUENCE "public"."user_points_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for users_id_seq
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."users_id_seq";
-CREATE SEQUENCE "public"."users_id_seq"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Sequence structure for users_id_seq1
--- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."users_id_seq1";
-CREATE SEQUENCE "public"."users_id_seq1"
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-CACHE 1;
-
--- ----------------------------
--- Table structure for cart
--- ----------------------------
-DROP TABLE IF EXISTS "public"."cart";
-CREATE TABLE "public"."cart" (
+DROP TABLE IF EXISTS "public"."tb_cart";
+CREATE TABLE "public"."tb_cart" (
"id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
-START 1
+START 25
),
- "user_id" int8 NOT NULL,
- "unit_id" int8 NOT NULL,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "unit_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"pricing_id" int8 NOT NULL,
- "product_id" int8 NOT NULL,
+ "product_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"product_name" text COLLATE "pg_catalog"."default",
"suite_name" text COLLATE "pg_catalog"."default",
"sales_form" text COLLATE "pg_catalog"."default",
@@ -315,17 +51,18 @@
"deleted" int4 DEFAULT 0
)
;
-COMMENT ON TABLE "public"."cart" IS '璐墿杞﹁〃';
+COMMENT ON TABLE "public"."tb_cart" IS '璐墿杞﹁〃';
-- ----------------------------
--- Records of cart
+-- Records of tb_cart
-- ----------------------------
+INSERT INTO "public"."tb_cart" OVERRIDING SYSTEM VALUE VALUES (24, '1', '1', 1, '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '閽㈢瓔鏁板瓧鍖栫敓浜у姞宸�', '鍩虹鐗�', '涔版柇', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�', 1000.00, 2, 1, 2000.00, NULL, NULL, NULL, '2025-08-27 18:45:19', '2025-08-27 18:47:01.852', 0);
-- ----------------------------
--- Table structure for order_approval
+-- Table structure for tb_order_approval
-- ----------------------------
-DROP TABLE IF EXISTS "public"."order_approval";
-CREATE TABLE "public"."order_approval" (
+DROP TABLE IF EXISTS "public"."tb_order_approval";
+CREATE TABLE "public"."tb_order_approval" (
"id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
INCREMENT 1
MINVALUE 1
@@ -349,17 +86,17 @@
"deleted" int4 DEFAULT 0
)
;
-COMMENT ON TABLE "public"."order_approval" IS '璁㈠崟瀹℃牳琛�';
+COMMENT ON TABLE "public"."tb_order_approval" IS '璁㈠崟瀹℃牳琛�';
-- ----------------------------
--- Records of order_approval
+-- Records of tb_order_approval
-- ----------------------------
-- ----------------------------
--- Table structure for order_attachment
+-- Table structure for tb_order_attachment
-- ----------------------------
-DROP TABLE IF EXISTS "public"."order_attachment";
-CREATE TABLE "public"."order_attachment" (
+DROP TABLE IF EXISTS "public"."tb_order_attachment";
+CREATE TABLE "public"."tb_order_attachment" (
"id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
INCREMENT 1
MINVALUE 1
@@ -384,26 +121,26 @@
"deleted" int4 DEFAULT 0
)
;
-COMMENT ON TABLE "public"."order_attachment" IS '璁㈠崟闄勪欢琛�';
+COMMENT ON TABLE "public"."tb_order_attachment" IS '璁㈠崟闄勪欢琛�';
-- ----------------------------
--- Records of order_attachment
+-- Records of tb_order_attachment
-- ----------------------------
-- ----------------------------
--- Table structure for order_detail
+-- Table structure for tb_order_detail
-- ----------------------------
-DROP TABLE IF EXISTS "public"."order_detail";
-CREATE TABLE "public"."order_detail" (
+DROP TABLE IF EXISTS "public"."tb_order_detail";
+CREATE TABLE "public"."tb_order_detail" (
"id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
-START 1
+START 16
),
"order_id" text COLLATE "pg_catalog"."default" NOT NULL,
"pricing_id" int8 NOT NULL,
- "product_id" int8 NOT NULL,
+ "product_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"suite_name" text COLLATE "pg_catalog"."default" NOT NULL,
"sales_form" text COLLATE "pg_catalog"."default" NOT NULL,
"customer_type" text COLLATE "pg_catalog"."default" NOT NULL,
@@ -415,7 +152,7 @@
"quantity" int4 NOT NULL,
"duration" int4,
"total_price" numeric(15,2) NOT NULL,
- "provider_id" int8 NOT NULL,
+ "provider_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"provider_name" text COLLATE "pg_catalog"."default",
"created_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
"updated_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
@@ -423,17 +160,32 @@
"deleted" int4 DEFAULT 0
)
;
-COMMENT ON TABLE "public"."order_detail" IS '璁㈠崟璇︽儏琛�';
+COMMENT ON TABLE "public"."tb_order_detail" IS '璁㈠崟璇︽儏琛�';
-- ----------------------------
--- Records of order_detail
+-- Records of tb_order_detail
-- ----------------------------
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (1, '202508191718590806528000', 5, '1', '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉佹湁澧為噺鍖�', '涓汉', '2', '3', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:18:59.649', '2025-08-19 17:18:59.649', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (2, '202508191718590806528000', 4, '1', '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '1', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:18:59.66', '2025-08-19 17:18:59.66', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (3, '202508191718590806528000', 9, '1', '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧為噺鍖�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', 0.00, 1, 1, 0.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:18:59.664', '2025-08-19 17:18:59.664', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (4, '202508191730018270442496', 2, '1', '涓撲笟鐗�', '绉熻祦', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�/骞�', 500.00, 1, 1, 500.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:30:01.814', '2025-08-19 17:30:01.814', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (5, '202508191732232175500288', 1, '1', '鍩虹鐗�', '涔版柇', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�', 1000.00, 1, 1, 1000.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:32:23.412', '2025-08-19 17:32:23.412', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (6, '202508191735337897883648', 9, '1', '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧為噺鍖�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', 0.00, 1, 1, 0.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:35:33.127', '2025-08-19 17:35:33.127', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (7, '202508191745527049352192', 5, '1', '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉佹湁澧為噺鍖�', '涓汉', '2', '3', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:45:52.815', '2025-08-19 17:45:52.815', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (8, '202508191752392071676928', 9, '1', '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧為噺鍖�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', 0.00, 1, 1, 0.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:52:39.325', '2025-08-19 17:52:39.325', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (9, '202508191809061614843904', 4, '1', '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '1', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 18:09:06.269', '2025-08-19 18:09:06.269', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (10, '202508191809061614843904', 9, '1', '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧為噺鍖�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', 0.00, 1, 1, 0.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 18:09:06.275', '2025-08-19 18:09:06.275', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (11, '202508221423519599931392', 4, '1', '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '1', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-22 14:23:51.376', '2025-08-22 14:23:51.376', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (12, '202508221423519599931392', 10, '1', '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '2', '绉垎', '濂�/骞�', 100.00, 1, 1, 100.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-22 14:23:51.385', '2025-08-22 14:23:51.386', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (13, '202508261002538948777984', 2, '1', '涓撲笟鐗�', '绉熻祦', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�/骞�', 500.00, 1, 1, 500.00, '3', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-26 10:02:53.913', '2025-08-26 10:02:53.913', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (14, '202508272131080287679488', 10, '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '2', '绉垎', '濂�/骞�', 100.00, 2, 1, 200.00, '1', '涓氦绗簩鑸姟宸ョ▼灞�鏈夐檺鍏徃', '2025-08-27 21:31:09.024', '2025-08-27 21:31:09.024', '', 0);
+INSERT INTO "public"."tb_order_detail" OVERRIDING SYSTEM VALUE VALUES (15, '202508272131080287679488', 4, '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '1', '绉垎', '濂�/骞�', 200.00, 2, 1, 400.00, '1', '涓氦绗簩鑸姟宸ョ▼灞�鏈夐檺鍏徃', '2025-08-27 21:31:09.295', '2025-08-27 21:31:09.295', '', 0);
-- ----------------------------
--- Table structure for order_evaluation
+-- Table structure for tb_order_evaluation
-- ----------------------------
-DROP TABLE IF EXISTS "public"."order_evaluation";
-CREATE TABLE "public"."order_evaluation" (
+DROP TABLE IF EXISTS "public"."tb_order_evaluation";
+CREATE TABLE "public"."tb_order_evaluation" (
"id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
INCREMENT 1
MINVALUE 1
@@ -458,24 +210,24 @@
"deleted" int4 DEFAULT 0
)
;
-COMMENT ON TABLE "public"."order_evaluation" IS '璁㈠崟璇勪环琛�';
+COMMENT ON TABLE "public"."tb_order_evaluation" IS '璁㈠崟璇勪环琛�';
-- ----------------------------
--- Records of order_evaluation
+-- Records of tb_order_evaluation
-- ----------------------------
-- ----------------------------
--- Table structure for order_info
+-- Table structure for tb_order_info
-- ----------------------------
-DROP TABLE IF EXISTS "public"."order_info";
-CREATE TABLE "public"."order_info" (
+DROP TABLE IF EXISTS "public"."tb_order_info";
+CREATE TABLE "public"."tb_order_info" (
"order_id" text COLLATE "pg_catalog"."default" NOT NULL,
- "product_id" int8 NOT NULL,
- "user_id" int8 NOT NULL,
- "unit_id" int8,
+ "product_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "unit_id" varchar(64) COLLATE "pg_catalog"."default",
"product_name" text COLLATE "pg_catalog"."default" NOT NULL,
"provider_name" text COLLATE "pg_catalog"."default" NOT NULL,
- "provider_id" int8 NOT NULL,
+ "provider_id" varchar(64) COLLATE "pg_catalog"."default",
"apply_time" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
"order_status" text COLLATE "pg_catalog"."default" NOT NULL DEFAULT '寰呭鎵�'::text,
"total_amount" numeric(15,2) NOT NULL,
@@ -491,18 +243,33 @@
"deleted" int4 DEFAULT 0
)
;
-COMMENT ON TABLE "public"."order_info" IS '璁㈠崟琛�';
+COMMENT ON TABLE "public"."tb_order_info" IS '璁㈠崟琛�';
-- ----------------------------
--- Records of order_info
+-- Records of tb_order_info
-- ----------------------------
+INSERT INTO "public"."tb_order_info" VALUES ('202508191718590806528000', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-19 17:18:59.608', '寰呭鎵�', 400.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:18:59.608', '2025-08-19 17:18:59.608', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508191730018270442496', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-19 17:30:01.807', '寰呭鎵�', 500.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:30:01.807', '2025-08-19 17:30:01.807', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508191732232175500288', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-19 17:32:23.405', '寰呭鎵�', 1000.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:32:23.405', '2025-08-19 17:32:23.405', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508191735337897883648', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-19 17:35:33.12', '寰呭鎵�', 0.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:35:33.12', '2025-08-19 17:35:33.12', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508191745527049352192', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-19 17:45:52.806', '寰呭鎵�', 200.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:45:52.807', '2025-08-19 17:45:52.807', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508191752392071676928', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-19 17:52:39.316', '寰呭鎵�', 0.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:52:39.316', '2025-08-19 17:52:39.316', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508191809061614843904', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-19 18:09:06.259', '寰呭鎵�', 200.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 18:09:06.259', '2025-08-19 18:09:06.259', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508221423519599931392', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-22 14:23:51.357', '寰呭鎵�', 300.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-22 14:23:51.357', '2025-08-22 14:23:51.357', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508261002538948777984', '1', '1', '1', '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '3', '2025-08-26 10:02:53.904', '寰呮巿鏉�', 500.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-26 10:02:53.904', '2025-08-26 10:02:53.904', 0);
+INSERT INTO "public"."tb_order_info" VALUES ('202508272131080287679488', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '2', '', '閽㈢瓔鏁板瓧鍖栫敓浜у姞宸�', '涓氦绗簩鑸姟宸ョ▼灞�鏈夐檺鍏徃', '2', '2025-08-27 21:31:08.83', '寰呮巿鏉�', 600.00, '绉垎', '鏈敮浠�', 'f43f7af4-095b-11f0-bea3-fa163eb62b1f', NULL, NULL, '', NULL, '2025-08-27 21:31:08.83', '2025-08-27 21:31:08.831', 0);
-- ----------------------------
--- Table structure for points
+-- Table structure for tb_points
-- ----------------------------
-DROP TABLE IF EXISTS "public"."points";
-CREATE TABLE "public"."points" (
- "id" int8 NOT NULL DEFAULT nextval('points_id_seq'::regclass),
+DROP TABLE IF EXISTS "public"."tb_points";
+CREATE TABLE "public"."tb_points" (
+ "id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
+ INCREMENT 1
+MINVALUE 1
+MAXVALUE 9223372036854775807
+START 7
+),
"points_name" varchar COLLATE "pg_catalog"."default" NOT NULL,
"effective_start" timestamp(0) NOT NULL,
"modifier_id" int8 NOT NULL,
@@ -515,30 +282,35 @@
"deleted" int2 DEFAULT 0
)
;
-COMMENT ON COLUMN "public"."points"."points_name" IS '绉垎鍚嶇О';
-COMMENT ON COLUMN "public"."points"."effective_start" IS '鐢熸晥寮�濮嬫椂闂�';
-COMMENT ON COLUMN "public"."points"."modifier_id" IS '淇敼浜篒D';
-COMMENT ON COLUMN "public"."points"."modifier_name" IS '淇敼浜哄鍚�';
-COMMENT ON COLUMN "public"."points"."version" IS '鐗堟湰鍙�';
-COMMENT ON COLUMN "public"."points"."description" IS '绉垎鎻忚堪';
-COMMENT ON COLUMN "public"."points"."status" IS '鐘舵��(0鍚敤1绂佺敤)';
-COMMENT ON COLUMN "public"."points"."created_at" IS '鍒涘缓鏃堕棿';
-COMMENT ON COLUMN "public"."points"."updated_at" IS '鏇存柊鏃堕棿';
-COMMENT ON COLUMN "public"."points"."deleted" IS '閫昏緫鍒犻櫎(1鍒犻櫎)';
-COMMENT ON TABLE "public"."points" IS '绉垎涓昏〃';
+COMMENT ON COLUMN "public"."tb_points"."points_name" IS '绉垎鍚嶇О';
+COMMENT ON COLUMN "public"."tb_points"."effective_start" IS '鐢熸晥寮�濮嬫椂闂�';
+COMMENT ON COLUMN "public"."tb_points"."modifier_id" IS '淇敼浜篒D';
+COMMENT ON COLUMN "public"."tb_points"."modifier_name" IS '淇敼浜哄鍚�';
+COMMENT ON COLUMN "public"."tb_points"."version" IS '鐗堟湰鍙�';
+COMMENT ON COLUMN "public"."tb_points"."description" IS '绉垎鎻忚堪';
+COMMENT ON COLUMN "public"."tb_points"."status" IS '鐘舵��(0鍚敤1绂佺敤)';
+COMMENT ON COLUMN "public"."tb_points"."created_at" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points"."updated_at" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points"."deleted" IS '閫昏緫鍒犻櫎(1鍒犻櫎)';
+COMMENT ON TABLE "public"."tb_points" IS '绉垎涓昏〃';
-- ----------------------------
--- Records of points
+-- Records of tb_points
-- ----------------------------
-INSERT INTO "public"."points" VALUES (1, '绉垎杩愯瑙勫垯', '2025-08-14 00:00:00', 1, '绠＄悊鍛�', 1.0, NULL, 0, '2025-08-14 11:01:32.086436', '2025-08-14 11:01:32.086436', 0);
-INSERT INTO "public"."points" VALUES (6, '绉垎杩愯瑙勫垯', '2025-08-15 01:04:45', 1, 'admin', 1.1, NULL, 0, '2025-08-15 01:04:44.998', '2025-08-15 01:04:45', 0);
+INSERT INTO "public"."tb_points" OVERRIDING SYSTEM VALUE VALUES (1, '绉垎杩愯瑙勫垯', '2025-08-14 00:00:00', 1, '绠＄悊鍛�', 1.0, NULL, 0, '2025-08-14 11:01:32.086436', '2025-08-14 11:01:32.086436', 0);
+INSERT INTO "public"."tb_points" OVERRIDING SYSTEM VALUE VALUES (6, '绉垎杩愯瑙勫垯', '2025-08-15 01:04:45', 1, 'admin', 1.1, NULL, 0, '2025-08-15 01:04:44.998', '2025-08-15 01:04:45', 0);
-- ----------------------------
--- Table structure for points_account
+-- Table structure for tb_points_account
-- ----------------------------
-DROP TABLE IF EXISTS "public"."points_account";
-CREATE TABLE "public"."points_account" (
- "id" int8 NOT NULL DEFAULT nextval('points_account_id_seq'::regclass),
+DROP TABLE IF EXISTS "public"."tb_points_account";
+CREATE TABLE "public"."tb_points_account" (
+ "id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
+ INCREMENT 1
+MINVALUE 1
+MAXVALUE 9223372036854775807
+START 1
+),
"user_id" int8 NOT NULL,
"points_balance" int4 NOT NULL DEFAULT 0,
"total_earned" int4 NOT NULL DEFAULT 0,
@@ -551,30 +323,35 @@
"deleted" int2 DEFAULT 0
)
;
-COMMENT ON COLUMN "public"."points_account"."user_id" IS '鐢ㄦ埛ID';
-COMMENT ON COLUMN "public"."points_account"."points_balance" IS '绉垎浣欓';
-COMMENT ON COLUMN "public"."points_account"."total_earned" IS '绱鑾峰彇绉垎';
-COMMENT ON COLUMN "public"."points_account"."total_consumed" IS '绱娑堣�楃Н鍒�';
-COMMENT ON COLUMN "public"."points_account"."account_type" IS '璐︽埛绫诲瀷';
-COMMENT ON COLUMN "public"."points_account"."account_status" IS '璐︽埛鐘舵��';
-COMMENT ON COLUMN "public"."points_account"."last_transaction_time" IS '鏈�鍚庝氦鏄撴椂闂�';
-COMMENT ON COLUMN "public"."points_account"."created_at" IS '鍒涘缓鏃堕棿';
-COMMENT ON COLUMN "public"."points_account"."updated_at" IS '鏇存柊鏃堕棿';
-COMMENT ON COLUMN "public"."points_account"."deleted" IS '閫昏緫鍒犻櫎';
-COMMENT ON TABLE "public"."points_account" IS '绉垎璐︽埛琛�';
+COMMENT ON COLUMN "public"."tb_points_account"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."tb_points_account"."points_balance" IS '绉垎浣欓';
+COMMENT ON COLUMN "public"."tb_points_account"."total_earned" IS '绱鑾峰彇绉垎';
+COMMENT ON COLUMN "public"."tb_points_account"."total_consumed" IS '绱娑堣�楃Н鍒�';
+COMMENT ON COLUMN "public"."tb_points_account"."account_type" IS '璐︽埛绫诲瀷';
+COMMENT ON COLUMN "public"."tb_points_account"."account_status" IS '璐︽埛鐘舵��';
+COMMENT ON COLUMN "public"."tb_points_account"."last_transaction_time" IS '鏈�鍚庝氦鏄撴椂闂�';
+COMMENT ON COLUMN "public"."tb_points_account"."created_at" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_account"."updated_at" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_account"."deleted" IS '閫昏緫鍒犻櫎';
+COMMENT ON TABLE "public"."tb_points_account" IS '绉垎璐︽埛琛�';
-- ----------------------------
--- Records of points_account
+-- Records of tb_points_account
-- ----------------------------
-- ----------------------------
--- Table structure for points_flow
+-- Table structure for tb_points_flow
-- ----------------------------
-DROP TABLE IF EXISTS "public"."points_flow";
-CREATE TABLE "public"."points_flow" (
- "id" int8 NOT NULL DEFAULT nextval('points_flow_id_seq'::regclass),
- "user_id" int8,
- "unit_id" int8,
+DROP TABLE IF EXISTS "public"."tb_points_flow";
+CREATE TABLE "public"."tb_points_flow" (
+ "id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
+ INCREMENT 1
+MINVALUE 1
+MAXVALUE 9223372036854775807
+START 18
+),
+ "user_id" varchar(64) COLLATE "pg_catalog"."default",
+ "unit_id" varchar(64) COLLATE "pg_catalog"."default",
"data_category" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
"data_type" int2 NOT NULL,
"name" text COLLATE "pg_catalog"."default" NOT NULL,
@@ -586,40 +363,45 @@
"rule_id" int4
)
;
-COMMENT ON COLUMN "public"."points_flow"."user_id" IS '鐢ㄦ埛ID';
-COMMENT ON COLUMN "public"."points_flow"."unit_id" IS '鍗曚綅ID';
-COMMENT ON COLUMN "public"."points_flow"."data_category" IS '鏁版嵁绫荤洰';
-COMMENT ON COLUMN "public"."points_flow"."data_type" IS '鏁版嵁绫诲瀷';
-COMMENT ON COLUMN "public"."points_flow"."name" IS '鍚嶇О/鎻忚堪';
-COMMENT ON COLUMN "public"."points_flow"."points" IS '绉垎鍊�';
-COMMENT ON COLUMN "public"."points_flow"."flow_time" IS '娴佹按鏃堕棿';
-COMMENT ON COLUMN "public"."points_flow"."create_time" IS '鍒涘缓鏃堕棿';
-COMMENT ON COLUMN "public"."points_flow"."update_time" IS '鏇存柊鏃堕棿';
-COMMENT ON COLUMN "public"."points_flow"."deleted" IS '閫昏緫鍒犻櫎锛�1-宸插垹闄わ紝0-鏈垹闄�';
-COMMENT ON COLUMN "public"."points_flow"."rule_id" IS '瑙勫垯ID';
-COMMENT ON TABLE "public"."points_flow" IS '绉垎娴佹按琛�';
+COMMENT ON COLUMN "public"."tb_points_flow"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."tb_points_flow"."unit_id" IS '鍗曚綅ID';
+COMMENT ON COLUMN "public"."tb_points_flow"."data_category" IS '鏁版嵁绫荤洰';
+COMMENT ON COLUMN "public"."tb_points_flow"."data_type" IS '鏁版嵁绫诲瀷';
+COMMENT ON COLUMN "public"."tb_points_flow"."name" IS '鍚嶇О/鎻忚堪';
+COMMENT ON COLUMN "public"."tb_points_flow"."points" IS '绉垎鍊�';
+COMMENT ON COLUMN "public"."tb_points_flow"."flow_time" IS '娴佹按鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_flow"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_flow"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_flow"."deleted" IS '閫昏緫鍒犻櫎锛�1-宸插垹闄わ紝0-鏈垹闄�';
+COMMENT ON COLUMN "public"."tb_points_flow"."rule_id" IS '瑙勫垯ID';
+COMMENT ON TABLE "public"."tb_points_flow" IS '绉垎娴佹按琛�';
-- ----------------------------
--- Records of points_flow
+-- Records of tb_points_flow
-- ----------------------------
-INSERT INTO "public"."points_flow" VALUES (1, 1, 1, '璧勬簮璐＄尞', 0, '鐢ㄦ埛姣忔棩棣栨鐧诲綍', 1, '2025-05-18 16:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (3, 1, 1, '璧勬簮璐＄尞', 0, '鐢ㄦ埛姣忔棩棣栨鐧诲綍', 1, '2025-05-16 14:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (2, 1, 1, '浜ゆ祦绀惧尯浜掑姩', 0, '浜ゆ祦绀惧尯鍙戝竷璇勮"鍩哄缓琛屼笟濡備綍鍒╃敤AI鎶�鏈彁楂樻晥鐜�"', 1, '2025-05-17 15:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (4, 1, 1, '浜ゆ祦绀惧尯浜掑姩', 1, '浜ゆ祦绀惧尯鍒犻櫎鎻愰棶"鍩哄缓椤圭洰濡備綍搴旂敤鏁板瓧瀛敓鎶�鏈�?"', -1, '2025-05-15 13:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (8, 1, 1, '浜ゆ祦绀惧尯浜掑姩', 0, '浜ゆ祦绀惧尯鍙戝竷鎻愰棶"鍩哄缓椤圭洰濡備綍搴旂敤鏁板瓧瀛敓鎶�鏈�?"', 1, '2025-05-02 09:10:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (17, 1, 1, '鍏朵粬', 0, '绉垎濂栧姳', 100, '2025-08-08 18:34:36', '2025-08-08 18:34:39', '2025-08-08 18:34:41', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (10, 1, 1, '鍏朵粬', 0, '鍒濆鍖栫Н鍒�', 100, '2025-05-01 09:01:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (7, 1, 1, '鍏朵粬', 0, '绉垎濂栧姳', 100, '2025-05-04 10:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (6, 1, 1, '璧勬簮浼犳挱', 0, '鐢ㄦ埛姣忔棩棣栨鐧诲綍', 1, '2025-05-05 11:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (9, 1, 1, '璧勬簮浼犳挱', 0, '鐢ㄦ埛姣忔棩棣栨鐧诲綍', 1, '2025-05-02 09:02:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-INSERT INTO "public"."points_flow" VALUES (5, 1, 1, '璧勬簮浼犳挱', 0, '鍗曚綅绉垎杞叆', 1000, '2025-05-06 12:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (1, '1', '1', '璧勬簮璐＄尞', 0, '鐢ㄦ埛姣忔棩棣栨鐧诲綍', 1, '2025-05-18 16:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (3, '1', '1', '璧勬簮璐＄尞', 0, '鐢ㄦ埛姣忔棩棣栨鐧诲綍', 1, '2025-05-16 14:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (2, '1', '1', '浜ゆ祦绀惧尯浜掑姩', 0, '浜ゆ祦绀惧尯鍙戝竷璇勮"鍩哄缓琛屼笟濡備綍鍒╃敤AI鎶�鏈彁楂樻晥鐜�"', 1, '2025-05-17 15:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (4, '1', '1', '浜ゆ祦绀惧尯浜掑姩', 1, '浜ゆ祦绀惧尯鍒犻櫎鎻愰棶"鍩哄缓椤圭洰濡備綍搴旂敤鏁板瓧瀛敓鎶�鏈�?"', -1, '2025-05-15 13:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (8, '1', '1', '浜ゆ祦绀惧尯浜掑姩', 0, '浜ゆ祦绀惧尯鍙戝竷鎻愰棶"鍩哄缓椤圭洰濡備綍搴旂敤鏁板瓧瀛敓鎶�鏈�?"', 1, '2025-05-02 09:10:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (17, '1', '1', '鍏朵粬', 0, '绉垎濂栧姳', 100, '2025-08-08 18:34:36', '2025-08-08 18:34:39', '2025-08-08 18:34:41', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (10, '1', '1', '鍏朵粬', 0, '鍒濆鍖栫Н鍒�', 100, '2025-05-01 09:01:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (7, '1', '1', '鍏朵粬', 0, '绉垎濂栧姳', 100, '2025-05-04 10:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (6, '1', '1', '璧勬簮浼犳挱', 0, '鐢ㄦ埛姣忔棩棣栨鐧诲綍', 1, '2025-05-05 11:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (9, '1', '1', '璧勬簮浼犳挱', 0, '鐢ㄦ埛姣忔棩棣栨鐧诲綍', 1, '2025-05-02 09:02:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
+INSERT INTO "public"."tb_points_flow" OVERRIDING SYSTEM VALUE VALUES (5, '1', '1', '璧勬簮浼犳挱', 0, '鍗曚綅绉垎杞叆', 1000, '2025-05-06 12:00:00', '2025-08-07 11:48:21.579058', '2025-08-07 11:48:21.579058', 0, NULL);
-- ----------------------------
--- Table structure for points_rule
+-- Table structure for tb_points_rule
-- ----------------------------
-DROP TABLE IF EXISTS "public"."points_rule";
-CREATE TABLE "public"."points_rule" (
- "id" int8 NOT NULL DEFAULT nextval('points_rule_id_seq'::regclass),
+DROP TABLE IF EXISTS "public"."tb_points_rule";
+CREATE TABLE "public"."tb_points_rule" (
+ "id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
+ INCREMENT 1
+MINVALUE 1
+MAXVALUE 9223372036854775807
+START 85
+),
"points_id" int8 NOT NULL,
"rule_type" int2 NOT NULL,
"category" varchar COLLATE "pg_catalog"."default" NOT NULL,
@@ -637,95 +419,100 @@
"rule_name_code" varchar(255) COLLATE "pg_catalog"."default" NOT NULL
)
;
-COMMENT ON COLUMN "public"."points_rule"."points_id" IS '鍏宠仈绉垎ID';
-COMMENT ON COLUMN "public"."points_rule"."rule_type" IS '绉垎瑙勫垯绫诲瀷(0鑾峰彇1娑堣��)';
-COMMENT ON COLUMN "public"."points_rule"."category" IS '绉垎绫诲埆';
-COMMENT ON COLUMN "public"."points_rule"."rule_name" IS '瑙勫垯鍚嶇О';
-COMMENT ON COLUMN "public"."points_rule"."rule_description" IS '瑙勫垯鎻忚堪';
-COMMENT ON COLUMN "public"."points_rule"."is_enabled" IS '瑙勫垯鐘舵��(0鍚姩1绂佺敤)';
-COMMENT ON COLUMN "public"."points_rule"."created_at" IS '鍒涘缓鏃堕棿';
-COMMENT ON COLUMN "public"."points_rule"."updated_at" IS '鏇存柊鏃堕棿';
-COMMENT ON COLUMN "public"."points_rule"."deleted" IS '閫昏緫鍒犻櫎';
-COMMENT ON COLUMN "public"."points_rule"."points_winner" IS '绉垎鑾峰緱鑰咃紙0璐＄尞鑰�1鐢ㄦ埛锛�';
-COMMENT ON COLUMN "public"."points_rule"."is_limit" IS '绉垎鏄惁鏈変笂闄�(0娌℃湁1鏈�)';
-COMMENT ON COLUMN "public"."points_rule"."rule_order" IS '鎺掑簭瑙勫垯';
-COMMENT ON COLUMN "public"."points_rule"."points_value" IS '绉垎鍊�';
-COMMENT ON COLUMN "public"."points_rule"."daily_limit" IS '绉垎鏃ヤ笂闄�';
-COMMENT ON COLUMN "public"."points_rule"."rule_name_code" IS '瑙勫垯鍚嶇О缂栫爜';
-COMMENT ON TABLE "public"."points_rule" IS '绉垎瑙勫垯琛�';
+COMMENT ON COLUMN "public"."tb_points_rule"."points_id" IS '鍏宠仈绉垎ID';
+COMMENT ON COLUMN "public"."tb_points_rule"."rule_type" IS '绉垎瑙勫垯绫诲瀷(0鑾峰彇1娑堣��)';
+COMMENT ON COLUMN "public"."tb_points_rule"."category" IS '绉垎绫诲埆';
+COMMENT ON COLUMN "public"."tb_points_rule"."rule_name" IS '瑙勫垯鍚嶇О';
+COMMENT ON COLUMN "public"."tb_points_rule"."rule_description" IS '瑙勫垯鎻忚堪';
+COMMENT ON COLUMN "public"."tb_points_rule"."is_enabled" IS '瑙勫垯鐘舵��(0鍚姩1绂佺敤)';
+COMMENT ON COLUMN "public"."tb_points_rule"."created_at" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_rule"."updated_at" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_rule"."deleted" IS '閫昏緫鍒犻櫎';
+COMMENT ON COLUMN "public"."tb_points_rule"."points_winner" IS '绉垎鑾峰緱鑰咃紙0璐＄尞鑰�1鐢ㄦ埛锛�';
+COMMENT ON COLUMN "public"."tb_points_rule"."is_limit" IS '绉垎鏄惁鏈変笂闄�(0娌℃湁1鏈�)';
+COMMENT ON COLUMN "public"."tb_points_rule"."rule_order" IS '鎺掑簭瑙勫垯';
+COMMENT ON COLUMN "public"."tb_points_rule"."points_value" IS '绉垎鍊�';
+COMMENT ON COLUMN "public"."tb_points_rule"."daily_limit" IS '绉垎鏃ヤ笂闄�';
+COMMENT ON COLUMN "public"."tb_points_rule"."rule_name_code" IS '瑙勫垯鍚嶇О缂栫爜';
+COMMENT ON TABLE "public"."tb_points_rule" IS '绉垎瑙勫垯琛�';
-- ----------------------------
--- Records of points_rule
+-- Records of tb_points_rule
-- ----------------------------
-INSERT INTO "public"."points_rule" VALUES (17, 1, 0, '璧勬簮浜ゆ槗', '鏁板瓧鍖栦骇鍝佹帴鍏�', '姣忔垚鍔熸帴鍏�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.738396', '2025-08-14 15:07:54.738396', 0, 0, 0, 3, NULL, NULL, 'digital_product_access');
-INSERT INTO "public"."points_rule" VALUES (18, 1, 0, '璧勬簮浜ゆ槗', '鏁板瓧鍖栦骇鍝佷氦鏄�', '姣忔垚鍔熶氦鏄�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.739469', '2025-08-14 15:07:54.739469', 0, 0, 0, 3, NULL, NULL, 'digital_product_transaction');
-INSERT INTO "public"."points_rule" VALUES (34, 1, 0, '浜ゆ祦绀惧尯浜掑姩', '鍥炲甯栧瓙', '姣忓洖澶�1娆″笘瀛愶紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.324645', '2025-08-14 15:08:19.324645', 0, 0, 1, 4, NULL, NULL, 'post_reply');
-INSERT INTO "public"."points_rule" VALUES (35, 1, 0, '浜ゆ祦绀惧尯浜掑姩', '甯栧瓙鐐硅禐', '鍙戝竷鐨勫笘瀛愭垨鍋氬嚭鐨勫洖绛旀瘡琚偣璧炰竴娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.325826', '2025-08-14 15:08:19.325826', 0, 0, 0, 4, NULL, NULL, 'post_like');
-INSERT INTO "public"."points_rule" VALUES (36, 1, 0, '浜ゆ祦绀惧尯浜掑姩', '甯栧瓙鏀惰棌', '鍙戝竷鐨勫笘瀛愭瘡琚敹钘忎竴娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.326955', '2025-08-14 15:08:19.326955', 0, 0, 0, 4, NULL, NULL, 'post_collect');
-INSERT INTO "public"."points_rule" VALUES (52, 1, 1, '浜ゆ祦绀惧尯浜掑姩', '鍙栨秷鏀惰棌', '鍙戝竷鐨勫笘瀛愯鏀惰棌锛屽悗鍙堝彇娑堟敹钘忥紝璐＄尞鑰� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.333528', '2025-08-14 15:15:13.333528', 0, 0, 0, 4, NULL, NULL, 'collect_cancel');
-INSERT INTO "public"."points_rule" VALUES (2, 1, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栨爣鏉�', '姣忔垚鍔熶笂鏋�1涓爣鏉嗭紝璐＄尞鑰� 鑾�', 0, '2025-08-14 14:24:00.753678', '2025-08-14 14:24:00.753678', 0, 0, 0, 1, NULL, NULL, 'new_digital_benchmark');
-INSERT INTO "public"."points_rule" VALUES (4, 1, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栦骇鍝�', '姣忔垚鍔熶笂鏋�1涓骇鍝侊紝璐＄尞鑰� 鑾�', 0, '2025-08-14 14:44:37.128422', '2025-08-14 14:44:37.128422', 0, 0, 0, 1, NULL, NULL, 'new_digital_product');
-INSERT INTO "public"."points_rule" VALUES (3, 1, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栫煡璇�', '姣忔垚鍔熶笂鏋�1涓煡璇嗭紝璐＄尞鑰� 鑾�', 0, '2025-08-14 14:44:37.124901', '2025-08-14 14:44:37.124901', 0, 0, 0, 1, NULL, NULL, 'new_digital_knowledge');
-INSERT INTO "public"."points_rule" VALUES (11, 1, 0, '璧勬簮浼犳挱', '璇勪环鏁板瓧鍖栬祫婧�', '姣忚璇勪环1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.732016', '2025-08-14 15:07:54.732016', 0, 0, 1, 2, NULL, NULL, 'resource_review');
-INSERT INTO "public"."points_rule" VALUES (12, 1, 0, '璧勬簮浼犳挱', '璇勪环鏁板瓧鍖栬祫婧�', '璇勪环鑰� 鑾�', 0, '2025-08-14 15:07:54.733588', '2025-08-14 15:07:54.733588', 0, 1, 1, 2, NULL, NULL, 'resource_review');
-INSERT INTO "public"."points_rule" VALUES (15, 1, 0, '璧勬簮浼犳挱', '璁㈤槄鏁板瓧鍖栬祫婧�', '姣忚璁㈤槄1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.736641', '2025-08-14 15:07:54.736641', 0, 0, 0, 2, NULL, NULL, 'resource_subscribe');
-INSERT INTO "public"."points_rule" VALUES (16, 1, 0, '璧勬簮浼犳挱', '璁㈤槄鏁板瓧鍖栬祫婧�', '璁㈤槄鑰� 鑾�', 0, '2025-08-14 15:07:54.737529', '2025-08-14 15:07:54.737529', 0, 1, 0, 2, NULL, NULL, 'resource_subscribe');
-INSERT INTO "public"."points_rule" VALUES (20, 1, 0, '璧勬簮浼犳挱', '娴忚鏁板瓧鍖栬祫婧�', '娴忚鑰�', 0, '2025-08-14 15:08:19.309681', '2025-08-14 15:08:19.309681', 0, 1, 1, 2, NULL, NULL, 'resource_view');
-INSERT INTO "public"."points_rule" VALUES (21, 1, 0, '璧勬簮浼犳挱', '鏀惰棌鏁板瓧鍖栬祫婧�', '姣忚鏀惰棌1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.311096', '2025-08-14 15:08:19.311096', 0, 0, 1, 2, NULL, NULL, 'resource_collect');
-INSERT INTO "public"."points_rule" VALUES (42, 1, 1, '璧勬簮浼犳挱', '鍙栨秷璁㈤槄', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-14 15:12:29.49397', '2025-08-14 15:12:29.49397', 0, 1, 0, 2, NULL, NULL, 'subscribe_cancel');
-INSERT INTO "public"."points_rule" VALUES (43, 1, 1, '璧勬簮浼犳挱', '鍙栨秷鏀惰棌', '鏁板瓧鍖栬祫婧愯鍙栨秷鏀惰棌锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.324114', '2025-08-14 15:15:13.324114', 0, 0, 0, 2, NULL, NULL, 'collect_cancel');
-INSERT INTO "public"."points_rule" VALUES (44, 1, 1, '璧勬簮浼犳挱', '鍙栨秷鏀惰棌', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.325517', '2025-08-14 15:15:13.325517', 0, 1, 0, 2, NULL, NULL, 'collect_cancel');
-INSERT INTO "public"."points_rule" VALUES (22, 1, 0, '璧勬簮浼犳挱', '鏀惰棌鏁板瓧鍖栬祫婧�', '鏀惰棌鑰� 鑾�', 0, '2025-08-14 15:08:19.312482', '2025-08-14 15:08:19.312482', 0, 1, 1, 2, NULL, NULL, 'resource_collect');
-INSERT INTO "public"."points_rule" VALUES (23, 1, 0, '璧勬簮浼犳挱', '鐐硅禐鏁板瓧鍖栬祫婧�', '姣忚鐐硅禐1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.313654', '2025-08-14 15:08:19.313654', 0, 0, 1, 2, NULL, NULL, 'resource_like');
-INSERT INTO "public"."points_rule" VALUES (24, 1, 0, '璧勬簮浼犳挱', '鐐硅禐鏁板瓧鍖栬祫婧�', '鐐硅禐鑰� 鑾�', 0, '2025-08-14 15:08:19.314647', '2025-08-14 15:08:19.314647', 0, 1, 1, 2, NULL, NULL, 'resource_like');
-INSERT INTO "public"."points_rule" VALUES (28, 1, 0, '璧勬簮浼犳挱', '璇曠敤鏁板瓧鍖栬祫婧�', '璇曠敤鑰� 鑾�', 0, '2025-08-14 15:08:19.318477', '2025-08-14 15:08:19.318477', 0, 1, 0, 2, NULL, NULL, 'resource_trial');
-INSERT INTO "public"."points_rule" VALUES (39, 1, 1, '璧勬簮浼犳挱', '鍙栨秷鐐硅禐', '鏁板瓧鍖栬祫婧愯鍙栨秷鐐硅禐锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:12:29.490075', '2025-08-14 15:12:29.490075', 0, 0, 0, 2, NULL, NULL, 'like_cancel');
-INSERT INTO "public"."points_rule" VALUES (40, 1, 1, '璧勬簮浼犳挱', '鍙栨秷鐐硅禐', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-14 15:12:29.49113', '2025-08-14 15:12:29.49113', 0, 1, 0, 2, NULL, NULL, 'like_cancel');
-INSERT INTO "public"."points_rule" VALUES (41, 1, 1, '璧勬簮浼犳挱', '鍙栨秷璁㈤槄', '鏁板瓧鍖栦骇鍝佽鍙栨秷璁㈤槄锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:12:29.492296', '2025-08-14 15:12:29.492296', 0, 0, 0, 2, NULL, NULL, 'subscribe_cancel');
-INSERT INTO "public"."points_rule" VALUES (49, 1, 1, '浜ゆ祦绀惧尯浜掑姩', '鍒犻櫎甯栧瓙', '鑷繁鍙戝竷鐨勫笘瀛愯鍒犻櫎锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.330326', '2025-08-14 15:15:13.330326', 0, 0, 0, 4, NULL, NULL, 'post_delete');
-INSERT INTO "public"."points_rule" VALUES (50, 1, 1, '浜ゆ祦绀惧尯浜掑姩', '鍒犻櫎鍥炲', '鑷繁鐨勫洖澶嶈鍒犻櫎锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.331467', '2025-08-14 15:15:13.331467', 0, 0, 0, 4, NULL, NULL, 'reply_delete');
-INSERT INTO "public"."points_rule" VALUES (51, 1, 1, '浜ゆ祦绀惧尯浜掑姩', '鍙栨秷鐐硅禐', '鍙戝竷鐨勫笘瀛愭垨鍋氬嚭鐨勫洖绛旇鐐硅禐鍚庡張鍙栨秷鐐硅禐锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.332602', '2025-08-14 15:15:13.332602', 0, 0, 0, 4, NULL, NULL, 'like_cancel');
-INSERT INTO "public"."points_rule" VALUES (33, 1, 0, '浜ゆ祦绀惧尯浜掑姩', '鍙戝竷甯栧瓙', '姣忔垚鍔熷彂甯�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.323293', '2025-08-14 15:08:19.323293', 0, 0, 1, 4, NULL, NULL, 'post_create');
-INSERT INTO "public"."points_rule" VALUES (13, 1, 0, '璧勬簮浼犳挱', '璇曠敤鏁板瓧鍖栬祫婧�', '姣忚璇曠敤1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.734444', '2025-08-14 15:07:54.734444', 0, 0, 0, 2, NULL, NULL, 'resource_trial');
-INSERT INTO "public"."points_rule" VALUES (19, 1, 0, '璧勬簮浼犳挱', '娴忚鏁板瓧鍖栬祫婧�', '姣忚娴忚1娆★紝璐＄尞鑰�', 0, '2025-08-14 15:08:19.308203', '2025-08-14 15:08:19.308203', 0, 0, 1, 2, NULL, NULL, 'resource_view');
-INSERT INTO "public"."points_rule" VALUES (54, 6, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栨爣鏉�', '姣忔垚鍔熶笂鏋�1涓爣鏉嗭紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.022', '2025-08-15 01:04:45.016', 0, 0, 0, 1, 1, NULL, 'new_digital_benchmark');
-INSERT INTO "public"."points_rule" VALUES (55, 6, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栦骇鍝�', '姣忔垚鍔熶笂鏋�1涓骇鍝侊紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.146', '2025-08-15 01:04:45.146', 0, 0, 0, 1, 1, NULL, 'new_digital_product');
-INSERT INTO "public"."points_rule" VALUES (56, 6, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栫煡璇�', '姣忔垚鍔熶笂鏋�1涓煡璇嗭紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.149', '2025-08-15 01:04:45.148', 0, 0, 0, 1, 1, NULL, 'new_digital_knowledge');
-INSERT INTO "public"."points_rule" VALUES (57, 6, 0, '璧勬簮浼犳挱', '璇勪环鏁板瓧鍖栬祫婧�', '姣忚璇勪环1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.153', '2025-08-15 01:04:45.153', 0, 0, 1, 2, 1, 10, 'resource_review');
-INSERT INTO "public"."points_rule" VALUES (58, 6, 0, '璧勬簮浼犳挱', '璇勪环鏁板瓧鍖栬祫婧�', '璇勪环鑰� 鑾�', 0, '2025-08-15 01:04:45.161', '2025-08-15 01:04:45.159', 0, 1, 1, 2, 1, 10, 'resource_review');
-INSERT INTO "public"."points_rule" VALUES (59, 6, 0, '璧勬簮浼犳挱', '璁㈤槄鏁板瓧鍖栬祫婧�', '姣忚璁㈤槄1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.167', '2025-08-15 01:04:45.164', 0, 0, 0, 2, 1, NULL, 'resource_subscribe');
-INSERT INTO "public"."points_rule" VALUES (60, 6, 0, '璧勬簮浼犳挱', '璁㈤槄鏁板瓧鍖栬祫婧�', '璁㈤槄鑰� 鑾�', 0, '2025-08-15 01:04:45.171', '2025-08-15 01:04:45.17', 0, 1, 0, 2, 1, NULL, 'resource_subscribe');
-INSERT INTO "public"."points_rule" VALUES (61, 6, 0, '璧勬簮浼犳挱', '娴忚鏁板瓧鍖栬祫婧�', '娴忚鑰�', 0, '2025-08-15 01:04:45.176', '2025-08-15 01:04:45.174', 0, 1, 1, 2, 1, 10, 'resource_view');
-INSERT INTO "public"."points_rule" VALUES (62, 6, 0, '璧勬簮浼犳挱', '鏀惰棌鏁板瓧鍖栬祫婧�', '姣忚鏀惰棌1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.181', '2025-08-15 01:04:45.18', 0, 0, 1, 2, 1, 10, 'resource_collect');
-INSERT INTO "public"."points_rule" VALUES (63, 6, 0, '璧勬簮浼犳挱', '鏀惰棌鏁板瓧鍖栬祫婧�', '鏀惰棌鑰� 鑾�', 0, '2025-08-15 01:04:45.184', '2025-08-15 01:04:45.184', 0, 1, 1, 2, 1, 10, 'resource_collect');
-INSERT INTO "public"."points_rule" VALUES (64, 6, 0, '璧勬簮浼犳挱', '鐐硅禐鏁板瓧鍖栬祫婧�', '姣忚鐐硅禐1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.187', '2025-08-15 01:04:45.187', 0, 0, 1, 2, 1, 10, 'resource_like');
-INSERT INTO "public"."points_rule" VALUES (65, 6, 0, '璧勬簮浼犳挱', '鐐硅禐鏁板瓧鍖栬祫婧�', '鐐硅禐鑰� 鑾�', 0, '2025-08-15 01:04:45.191', '2025-08-15 01:04:45.19', 0, 1, 1, 2, 1, 10, 'resource_like');
-INSERT INTO "public"."points_rule" VALUES (66, 6, 0, '璧勬簮浼犳挱', '璇曠敤鏁板瓧鍖栬祫婧�', '璇曠敤鑰� 鑾�', 0, '2025-08-15 01:04:45.196', '2025-08-15 01:04:45.195', 0, 1, 0, 2, 1, NULL, 'resource_trial');
-INSERT INTO "public"."points_rule" VALUES (67, 6, 0, '璧勬簮浼犳挱', '璇曠敤鏁板瓧鍖栬祫婧�', '姣忚璇曠敤1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.199', '2025-08-15 01:04:45.199', 0, 0, 0, 2, 1, NULL, 'resource_trial');
-INSERT INTO "public"."points_rule" VALUES (68, 6, 0, '璧勬簮浼犳挱', '娴忚鏁板瓧鍖栬祫婧�', '姣忚娴忚1娆★紝璐＄尞鑰�', 0, '2025-08-15 01:04:45.207', '2025-08-15 01:04:45.205', 0, 0, 1, 2, 1, 10, 'resource_view');
-INSERT INTO "public"."points_rule" VALUES (69, 6, 0, '璧勬簮浜ゆ槗', '鏁板瓧鍖栦骇鍝佹帴鍏�', '姣忔垚鍔熸帴鍏�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.218', '2025-08-15 01:04:45.216', 0, 0, 0, 3, 1, NULL, 'digital_product_access');
-INSERT INTO "public"."points_rule" VALUES (70, 6, 0, '璧勬簮浜ゆ槗', '鏁板瓧鍖栦骇鍝佷氦鏄�', '姣忔垚鍔熶氦鏄�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.222', '2025-08-15 01:04:45.221', 0, 0, 0, 3, 1, NULL, 'digital_product_transaction');
-INSERT INTO "public"."points_rule" VALUES (71, 6, 0, '浜ゆ祦绀惧尯浜掑姩', '鍥炲甯栧瓙', '姣忓洖澶�1娆″笘瀛愶紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.225', '2025-08-15 01:04:45.224', 0, 0, 1, 4, 1, 10, 'post_reply');
-INSERT INTO "public"."points_rule" VALUES (72, 6, 0, '浜ゆ祦绀惧尯浜掑姩', '甯栧瓙鐐硅禐', '鍙戝竷鐨勫笘瀛愭垨鍋氬嚭鐨勫洖绛旀瘡琚偣璧炰竴娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.23', '2025-08-15 01:04:45.23', 0, 0, 0, 4, 1, NULL, 'post_like');
-INSERT INTO "public"."points_rule" VALUES (73, 6, 0, '浜ゆ祦绀惧尯浜掑姩', '甯栧瓙鏀惰棌', '鍙戝竷鐨勫笘瀛愭瘡琚敹钘忎竴娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.246', '2025-08-15 01:04:45.245', 0, 0, 0, 4, 1, NULL, 'post_collect');
-INSERT INTO "public"."points_rule" VALUES (74, 6, 0, '浜ゆ祦绀惧尯浜掑姩', '鍙戝竷甯栧瓙', '姣忔垚鍔熷彂甯�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.247', '2025-08-15 01:04:45.247', 0, 0, 1, 4, 1, 10, 'post_create');
-INSERT INTO "public"."points_rule" VALUES (75, 6, 1, '璧勬簮浼犳挱', '鍙栨秷璁㈤槄', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.248', '2025-08-15 01:04:45.248', 0, 1, 0, 2, 1, NULL, 'subscribe_cancel');
-INSERT INTO "public"."points_rule" VALUES (76, 6, 1, '璧勬簮浼犳挱', '鍙栨秷鏀惰棌', '鏁板瓧鍖栬祫婧愯鍙栨秷鏀惰棌锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.261', '2025-08-15 01:04:45.261', 0, 0, 0, 2, 1, NULL, 'collect_cancel');
-INSERT INTO "public"."points_rule" VALUES (77, 6, 1, '璧勬簮浼犳挱', '鍙栨秷鏀惰棌', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.263', '2025-08-15 01:04:45.262', 0, 1, 0, 2, 1, NULL, 'collect_cancel');
-INSERT INTO "public"."points_rule" VALUES (78, 6, 1, '璧勬簮浼犳挱', '鍙栨秷鐐硅禐', '鏁板瓧鍖栬祫婧愯鍙栨秷鐐硅禐锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.264', '2025-08-15 01:04:45.264', 0, 0, 0, 2, 1, NULL, 'like_cancel');
-INSERT INTO "public"."points_rule" VALUES (79, 6, 1, '璧勬簮浼犳挱', '鍙栨秷鐐硅禐', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.266', '2025-08-15 01:04:45.265', 0, 1, 0, 2, 1, NULL, 'like_cancel');
-INSERT INTO "public"."points_rule" VALUES (80, 6, 1, '璧勬簮浼犳挱', '鍙栨秷璁㈤槄', '鏁板瓧鍖栦骇鍝佽鍙栨秷璁㈤槄锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.267', '2025-08-15 01:04:45.267', 0, 0, 0, 2, 1, NULL, 'subscribe_cancel');
-INSERT INTO "public"."points_rule" VALUES (81, 6, 1, '浜ゆ祦绀惧尯浜掑姩', '鍙栨秷鏀惰棌', '鍙戝竷鐨勫笘瀛愯鏀惰棌锛屽悗鍙堝彇娑堟敹钘忥紝璐＄尞鑰� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.268', '2025-08-15 01:04:45.268', 0, 0, 0, 4, 1, NULL, 'collect_cancel');
-INSERT INTO "public"."points_rule" VALUES (82, 6, 1, '浜ゆ祦绀惧尯浜掑姩', '鍒犻櫎甯栧瓙', '鑷繁鍙戝竷鐨勫笘瀛愯鍒犻櫎锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.27', '2025-08-15 01:04:45.27', 0, 0, 0, 4, 1, NULL, 'post_delete');
-INSERT INTO "public"."points_rule" VALUES (83, 6, 1, '浜ゆ祦绀惧尯浜掑姩', '鍒犻櫎鍥炲', '鑷繁鐨勫洖澶嶈鍒犻櫎锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.271', '2025-08-15 01:04:45.271', 0, 0, 0, 4, 1, NULL, 'reply_delete');
-INSERT INTO "public"."points_rule" VALUES (84, 6, 1, '浜ゆ祦绀惧尯浜掑姩', '鍙栨秷鐐硅禐', '鍙戝竷鐨勫笘瀛愭垨鍋氬嚭鐨勫洖绛旇鐐硅禐鍚庡張鍙栨秷鐐硅禐锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.273', '2025-08-15 01:04:45.273', 0, 0, 0, 4, 1, NULL, 'like_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (17, 1, 0, '璧勬簮浜ゆ槗', '鏁板瓧鍖栦骇鍝佹帴鍏�', '姣忔垚鍔熸帴鍏�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.738396', '2025-08-14 15:07:54.738396', 0, 0, 0, 3, NULL, NULL, 'digital_product_access');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (18, 1, 0, '璧勬簮浜ゆ槗', '鏁板瓧鍖栦骇鍝佷氦鏄�', '姣忔垚鍔熶氦鏄�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.739469', '2025-08-14 15:07:54.739469', 0, 0, 0, 3, NULL, NULL, 'digital_product_transaction');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (34, 1, 0, '浜ゆ祦绀惧尯浜掑姩', '鍥炲甯栧瓙', '姣忓洖澶�1娆″笘瀛愶紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.324645', '2025-08-14 15:08:19.324645', 0, 0, 1, 4, NULL, NULL, 'post_reply');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (35, 1, 0, '浜ゆ祦绀惧尯浜掑姩', '甯栧瓙鐐硅禐', '鍙戝竷鐨勫笘瀛愭垨鍋氬嚭鐨勫洖绛旀瘡琚偣璧炰竴娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.325826', '2025-08-14 15:08:19.325826', 0, 0, 0, 4, NULL, NULL, 'post_like');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (36, 1, 0, '浜ゆ祦绀惧尯浜掑姩', '甯栧瓙鏀惰棌', '鍙戝竷鐨勫笘瀛愭瘡琚敹钘忎竴娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.326955', '2025-08-14 15:08:19.326955', 0, 0, 0, 4, NULL, NULL, 'post_collect');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (52, 1, 1, '浜ゆ祦绀惧尯浜掑姩', '鍙栨秷鏀惰棌', '鍙戝竷鐨勫笘瀛愯鏀惰棌锛屽悗鍙堝彇娑堟敹钘忥紝璐＄尞鑰� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.333528', '2025-08-14 15:15:13.333528', 0, 0, 0, 4, NULL, NULL, 'collect_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (2, 1, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栨爣鏉�', '姣忔垚鍔熶笂鏋�1涓爣鏉嗭紝璐＄尞鑰� 鑾�', 0, '2025-08-14 14:24:00.753678', '2025-08-14 14:24:00.753678', 0, 0, 0, 1, NULL, NULL, 'new_digital_benchmark');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (4, 1, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栦骇鍝�', '姣忔垚鍔熶笂鏋�1涓骇鍝侊紝璐＄尞鑰� 鑾�', 0, '2025-08-14 14:44:37.128422', '2025-08-14 14:44:37.128422', 0, 0, 0, 1, NULL, NULL, 'new_digital_product');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (3, 1, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栫煡璇�', '姣忔垚鍔熶笂鏋�1涓煡璇嗭紝璐＄尞鑰� 鑾�', 0, '2025-08-14 14:44:37.124901', '2025-08-14 14:44:37.124901', 0, 0, 0, 1, NULL, NULL, 'new_digital_knowledge');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (11, 1, 0, '璧勬簮浼犳挱', '璇勪环鏁板瓧鍖栬祫婧�', '姣忚璇勪环1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.732016', '2025-08-14 15:07:54.732016', 0, 0, 1, 2, NULL, NULL, 'resource_review');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (12, 1, 0, '璧勬簮浼犳挱', '璇勪环鏁板瓧鍖栬祫婧�', '璇勪环鑰� 鑾�', 0, '2025-08-14 15:07:54.733588', '2025-08-14 15:07:54.733588', 0, 1, 1, 2, NULL, NULL, 'resource_review');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (15, 1, 0, '璧勬簮浼犳挱', '璁㈤槄鏁板瓧鍖栬祫婧�', '姣忚璁㈤槄1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.736641', '2025-08-14 15:07:54.736641', 0, 0, 0, 2, NULL, NULL, 'resource_subscribe');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (16, 1, 0, '璧勬簮浼犳挱', '璁㈤槄鏁板瓧鍖栬祫婧�', '璁㈤槄鑰� 鑾�', 0, '2025-08-14 15:07:54.737529', '2025-08-14 15:07:54.737529', 0, 1, 0, 2, NULL, NULL, 'resource_subscribe');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (20, 1, 0, '璧勬簮浼犳挱', '娴忚鏁板瓧鍖栬祫婧�', '娴忚鑰�', 0, '2025-08-14 15:08:19.309681', '2025-08-14 15:08:19.309681', 0, 1, 1, 2, NULL, NULL, 'resource_view');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (21, 1, 0, '璧勬簮浼犳挱', '鏀惰棌鏁板瓧鍖栬祫婧�', '姣忚鏀惰棌1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.311096', '2025-08-14 15:08:19.311096', 0, 0, 1, 2, NULL, NULL, 'resource_collect');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (42, 1, 1, '璧勬簮浼犳挱', '鍙栨秷璁㈤槄', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-14 15:12:29.49397', '2025-08-14 15:12:29.49397', 0, 1, 0, 2, NULL, NULL, 'subscribe_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (43, 1, 1, '璧勬簮浼犳挱', '鍙栨秷鏀惰棌', '鏁板瓧鍖栬祫婧愯鍙栨秷鏀惰棌锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.324114', '2025-08-14 15:15:13.324114', 0, 0, 0, 2, NULL, NULL, 'collect_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (44, 1, 1, '璧勬簮浼犳挱', '鍙栨秷鏀惰棌', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.325517', '2025-08-14 15:15:13.325517', 0, 1, 0, 2, NULL, NULL, 'collect_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (22, 1, 0, '璧勬簮浼犳挱', '鏀惰棌鏁板瓧鍖栬祫婧�', '鏀惰棌鑰� 鑾�', 0, '2025-08-14 15:08:19.312482', '2025-08-14 15:08:19.312482', 0, 1, 1, 2, NULL, NULL, 'resource_collect');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (23, 1, 0, '璧勬簮浼犳挱', '鐐硅禐鏁板瓧鍖栬祫婧�', '姣忚鐐硅禐1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.313654', '2025-08-14 15:08:19.313654', 0, 0, 1, 2, NULL, NULL, 'resource_like');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (24, 1, 0, '璧勬簮浼犳挱', '鐐硅禐鏁板瓧鍖栬祫婧�', '鐐硅禐鑰� 鑾�', 0, '2025-08-14 15:08:19.314647', '2025-08-14 15:08:19.314647', 0, 1, 1, 2, NULL, NULL, 'resource_like');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (28, 1, 0, '璧勬簮浼犳挱', '璇曠敤鏁板瓧鍖栬祫婧�', '璇曠敤鑰� 鑾�', 0, '2025-08-14 15:08:19.318477', '2025-08-14 15:08:19.318477', 0, 1, 0, 2, NULL, NULL, 'resource_trial');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (39, 1, 1, '璧勬簮浼犳挱', '鍙栨秷鐐硅禐', '鏁板瓧鍖栬祫婧愯鍙栨秷鐐硅禐锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:12:29.490075', '2025-08-14 15:12:29.490075', 0, 0, 0, 2, NULL, NULL, 'like_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (40, 1, 1, '璧勬簮浼犳挱', '鍙栨秷鐐硅禐', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-14 15:12:29.49113', '2025-08-14 15:12:29.49113', 0, 1, 0, 2, NULL, NULL, 'like_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (41, 1, 1, '璧勬簮浼犳挱', '鍙栨秷璁㈤槄', '鏁板瓧鍖栦骇鍝佽鍙栨秷璁㈤槄锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:12:29.492296', '2025-08-14 15:12:29.492296', 0, 0, 0, 2, NULL, NULL, 'subscribe_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (49, 1, 1, '浜ゆ祦绀惧尯浜掑姩', '鍒犻櫎甯栧瓙', '鑷繁鍙戝竷鐨勫笘瀛愯鍒犻櫎锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.330326', '2025-08-14 15:15:13.330326', 0, 0, 0, 4, NULL, NULL, 'post_delete');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (50, 1, 1, '浜ゆ祦绀惧尯浜掑姩', '鍒犻櫎鍥炲', '鑷繁鐨勫洖澶嶈鍒犻櫎锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.331467', '2025-08-14 15:15:13.331467', 0, 0, 0, 4, NULL, NULL, 'reply_delete');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (51, 1, 1, '浜ゆ祦绀惧尯浜掑姩', '鍙栨秷鐐硅禐', '鍙戝竷鐨勫笘瀛愭垨鍋氬嚭鐨勫洖绛旇鐐硅禐鍚庡張鍙栨秷鐐硅禐锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-14 15:15:13.332602', '2025-08-14 15:15:13.332602', 0, 0, 0, 4, NULL, NULL, 'like_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (33, 1, 0, '浜ゆ祦绀惧尯浜掑姩', '鍙戝竷甯栧瓙', '姣忔垚鍔熷彂甯�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:08:19.323293', '2025-08-14 15:08:19.323293', 0, 0, 1, 4, NULL, NULL, 'post_create');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (13, 1, 0, '璧勬簮浼犳挱', '璇曠敤鏁板瓧鍖栬祫婧�', '姣忚璇曠敤1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-14 15:07:54.734444', '2025-08-14 15:07:54.734444', 0, 0, 0, 2, NULL, NULL, 'resource_trial');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (19, 1, 0, '璧勬簮浼犳挱', '娴忚鏁板瓧鍖栬祫婧�', '姣忚娴忚1娆★紝璐＄尞鑰�', 0, '2025-08-14 15:08:19.308203', '2025-08-14 15:08:19.308203', 0, 0, 1, 2, NULL, NULL, 'resource_view');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (54, 6, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栨爣鏉�', '姣忔垚鍔熶笂鏋�1涓爣鏉嗭紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.022', '2025-08-15 01:04:45.016', 0, 0, 0, 1, 1, NULL, 'new_digital_benchmark');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (55, 6, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栦骇鍝�', '姣忔垚鍔熶笂鏋�1涓骇鍝侊紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.146', '2025-08-15 01:04:45.146', 0, 0, 0, 1, 1, NULL, 'new_digital_product');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (56, 6, 0, '璧勬簮璐＄尞', '鏂板鏁板瓧鍖栫煡璇�', '姣忔垚鍔熶笂鏋�1涓煡璇嗭紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.149', '2025-08-15 01:04:45.148', 0, 0, 0, 1, 1, NULL, 'new_digital_knowledge');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (57, 6, 0, '璧勬簮浼犳挱', '璇勪环鏁板瓧鍖栬祫婧�', '姣忚璇勪环1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.153', '2025-08-15 01:04:45.153', 0, 0, 1, 2, 1, 10, 'resource_review');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (58, 6, 0, '璧勬簮浼犳挱', '璇勪环鏁板瓧鍖栬祫婧�', '璇勪环鑰� 鑾�', 0, '2025-08-15 01:04:45.161', '2025-08-15 01:04:45.159', 0, 1, 1, 2, 1, 10, 'resource_review');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (59, 6, 0, '璧勬簮浼犳挱', '璁㈤槄鏁板瓧鍖栬祫婧�', '姣忚璁㈤槄1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.167', '2025-08-15 01:04:45.164', 0, 0, 0, 2, 1, NULL, 'resource_subscribe');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (60, 6, 0, '璧勬簮浼犳挱', '璁㈤槄鏁板瓧鍖栬祫婧�', '璁㈤槄鑰� 鑾�', 0, '2025-08-15 01:04:45.171', '2025-08-15 01:04:45.17', 0, 1, 0, 2, 1, NULL, 'resource_subscribe');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (61, 6, 0, '璧勬簮浼犳挱', '娴忚鏁板瓧鍖栬祫婧�', '娴忚鑰�', 0, '2025-08-15 01:04:45.176', '2025-08-15 01:04:45.174', 0, 1, 1, 2, 1, 10, 'resource_view');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (62, 6, 0, '璧勬簮浼犳挱', '鏀惰棌鏁板瓧鍖栬祫婧�', '姣忚鏀惰棌1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.181', '2025-08-15 01:04:45.18', 0, 0, 1, 2, 1, 10, 'resource_collect');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (63, 6, 0, '璧勬簮浼犳挱', '鏀惰棌鏁板瓧鍖栬祫婧�', '鏀惰棌鑰� 鑾�', 0, '2025-08-15 01:04:45.184', '2025-08-15 01:04:45.184', 0, 1, 1, 2, 1, 10, 'resource_collect');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (64, 6, 0, '璧勬簮浼犳挱', '鐐硅禐鏁板瓧鍖栬祫婧�', '姣忚鐐硅禐1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.187', '2025-08-15 01:04:45.187', 0, 0, 1, 2, 1, 10, 'resource_like');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (65, 6, 0, '璧勬簮浼犳挱', '鐐硅禐鏁板瓧鍖栬祫婧�', '鐐硅禐鑰� 鑾�', 0, '2025-08-15 01:04:45.191', '2025-08-15 01:04:45.19', 0, 1, 1, 2, 1, 10, 'resource_like');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (66, 6, 0, '璧勬簮浼犳挱', '璇曠敤鏁板瓧鍖栬祫婧�', '璇曠敤鑰� 鑾�', 0, '2025-08-15 01:04:45.196', '2025-08-15 01:04:45.195', 0, 1, 0, 2, 1, NULL, 'resource_trial');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (67, 6, 0, '璧勬簮浼犳挱', '璇曠敤鏁板瓧鍖栬祫婧�', '姣忚璇曠敤1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.199', '2025-08-15 01:04:45.199', 0, 0, 0, 2, 1, NULL, 'resource_trial');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (68, 6, 0, '璧勬簮浼犳挱', '娴忚鏁板瓧鍖栬祫婧�', '姣忚娴忚1娆★紝璐＄尞鑰�', 0, '2025-08-15 01:04:45.207', '2025-08-15 01:04:45.205', 0, 0, 1, 2, 1, 10, 'resource_view');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (69, 6, 0, '璧勬簮浜ゆ槗', '鏁板瓧鍖栦骇鍝佹帴鍏�', '姣忔垚鍔熸帴鍏�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.218', '2025-08-15 01:04:45.216', 0, 0, 0, 3, 1, NULL, 'digital_product_access');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (70, 6, 0, '璧勬簮浜ゆ槗', '鏁板瓧鍖栦骇鍝佷氦鏄�', '姣忔垚鍔熶氦鏄�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.222', '2025-08-15 01:04:45.221', 0, 0, 0, 3, 1, NULL, 'digital_product_transaction');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (71, 6, 0, '浜ゆ祦绀惧尯浜掑姩', '鍥炲甯栧瓙', '姣忓洖澶�1娆″笘瀛愶紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.225', '2025-08-15 01:04:45.224', 0, 0, 1, 4, 1, 10, 'post_reply');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (72, 6, 0, '浜ゆ祦绀惧尯浜掑姩', '甯栧瓙鐐硅禐', '鍙戝竷鐨勫笘瀛愭垨鍋氬嚭鐨勫洖绛旀瘡琚偣璧炰竴娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.23', '2025-08-15 01:04:45.23', 0, 0, 0, 4, 1, NULL, 'post_like');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (73, 6, 0, '浜ゆ祦绀惧尯浜掑姩', '甯栧瓙鏀惰棌', '鍙戝竷鐨勫笘瀛愭瘡琚敹钘忎竴娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.246', '2025-08-15 01:04:45.245', 0, 0, 0, 4, 1, NULL, 'post_collect');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (74, 6, 0, '浜ゆ祦绀惧尯浜掑姩', '鍙戝竷甯栧瓙', '姣忔垚鍔熷彂甯�1娆★紝璐＄尞鑰� 鑾�', 0, '2025-08-15 01:04:45.247', '2025-08-15 01:04:45.247', 0, 0, 1, 4, 1, 10, 'post_create');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (75, 6, 1, '璧勬簮浼犳挱', '鍙栨秷璁㈤槄', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.248', '2025-08-15 01:04:45.248', 0, 1, 0, 2, 1, NULL, 'subscribe_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (76, 6, 1, '璧勬簮浼犳挱', '鍙栨秷鏀惰棌', '鏁板瓧鍖栬祫婧愯鍙栨秷鏀惰棌锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.261', '2025-08-15 01:04:45.261', 0, 0, 0, 2, 1, NULL, 'collect_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (77, 6, 1, '璧勬簮浼犳挱', '鍙栨秷鏀惰棌', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.263', '2025-08-15 01:04:45.262', 0, 1, 0, 2, 1, NULL, 'collect_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (78, 6, 1, '璧勬簮浼犳挱', '鍙栨秷鐐硅禐', '鏁板瓧鍖栬祫婧愯鍙栨秷鐐硅禐锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.264', '2025-08-15 01:04:45.264', 0, 0, 0, 2, 1, NULL, 'like_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (79, 6, 1, '璧勬簮浼犳挱', '鍙栨秷鐐硅禐', '鎿嶄綔鑰� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.266', '2025-08-15 01:04:45.265', 0, 1, 0, 2, 1, NULL, 'like_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (80, 6, 1, '璧勬簮浼犳挱', '鍙栨秷璁㈤槄', '鏁板瓧鍖栦骇鍝佽鍙栨秷璁㈤槄锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.267', '2025-08-15 01:04:45.267', 0, 0, 0, 2, 1, NULL, 'subscribe_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (81, 6, 1, '浜ゆ祦绀惧尯浜掑姩', '鍙栨秷鏀惰棌', '鍙戝竷鐨勫笘瀛愯鏀惰棌锛屽悗鍙堝彇娑堟敹钘忥紝璐＄尞鑰� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.268', '2025-08-15 01:04:45.268', 0, 0, 0, 4, 1, NULL, 'collect_cancel');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (82, 6, 1, '浜ゆ祦绀惧尯浜掑姩', '鍒犻櫎甯栧瓙', '鑷繁鍙戝竷鐨勫笘瀛愯鍒犻櫎锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.27', '2025-08-15 01:04:45.27', 0, 0, 0, 4, 1, NULL, 'post_delete');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (83, 6, 1, '浜ゆ祦绀惧尯浜掑姩', '鍒犻櫎鍥炲', '鑷繁鐨勫洖澶嶈鍒犻櫎锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.271', '2025-08-15 01:04:45.271', 0, 0, 0, 4, 1, NULL, 'reply_delete');
+INSERT INTO "public"."tb_points_rule" OVERRIDING SYSTEM VALUE VALUES (84, 6, 1, '浜ゆ祦绀惧尯浜掑姩', '鍙栨秷鐐硅禐', '鍙戝竷鐨勫笘瀛愭垨鍋氬嚭鐨勫洖绛旇鐐硅禐鍚庡張鍙栨秷鐐硅禐锛岃础鐚�� 鎵ｉ櫎', 0, '2025-08-15 01:04:45.273', '2025-08-15 01:04:45.273', 0, 0, 0, 4, 1, NULL, 'like_cancel');
-- ----------------------------
--- Table structure for points_transaction
+-- Table structure for tb_points_transaction
-- ----------------------------
-DROP TABLE IF EXISTS "public"."points_transaction";
-CREATE TABLE "public"."points_transaction" (
- "id" int8 NOT NULL DEFAULT nextval('points_transaction_id_seq'::regclass),
+DROP TABLE IF EXISTS "public"."tb_points_transaction";
+CREATE TABLE "public"."tb_points_transaction" (
+ "id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
+ INCREMENT 1
+MINVALUE 1
+MAXVALUE 9223372036854775807
+START 1
+),
"data_category" text COLLATE "pg_catalog"."default" NOT NULL,
"transaction_name" text COLLATE "pg_catalog"."default" NOT NULL,
"transaction_time" timestamptz(6) DEFAULT CURRENT_TIMESTAMP,
@@ -740,74 +527,33 @@
"deleted" int2 DEFAULT 0
)
;
-COMMENT ON COLUMN "public"."points_transaction"."data_category" IS '鏁版嵁绫荤洰';
-COMMENT ON COLUMN "public"."points_transaction"."transaction_name" IS '鍚嶇О';
-COMMENT ON COLUMN "public"."points_transaction"."transaction_time" IS '鏃堕棿';
-COMMENT ON COLUMN "public"."points_transaction"."points_change" IS '绉垎鍙樺姩鍊�';
-COMMENT ON COLUMN "public"."points_transaction"."rule_type" IS '绉垎瑙勫垯绫诲瀷';
-COMMENT ON COLUMN "public"."points_transaction"."user_id" IS '鐢ㄦ埛ID';
-COMMENT ON COLUMN "public"."points_transaction"."unit_id" IS '浼佷笟ID';
-COMMENT ON COLUMN "public"."points_transaction"."user_type" IS '鐢ㄦ埛绫诲瀷';
-COMMENT ON COLUMN "public"."points_transaction"."rule_id" IS '鍏宠仈瑙勫垯ID';
-COMMENT ON COLUMN "public"."points_transaction"."detail_id" IS '鍏宠仈瑙勫垯璇︽儏ID';
-COMMENT ON COLUMN "public"."points_transaction"."created_at" IS '鍒涘缓鏃堕棿';
-COMMENT ON COLUMN "public"."points_transaction"."deleted" IS '閫昏緫鍒犻櫎';
-COMMENT ON TABLE "public"."points_transaction" IS '绉垎娴佹按琛�';
+COMMENT ON COLUMN "public"."tb_points_transaction"."data_category" IS '鏁版嵁绫荤洰';
+COMMENT ON COLUMN "public"."tb_points_transaction"."transaction_name" IS '鍚嶇О';
+COMMENT ON COLUMN "public"."tb_points_transaction"."transaction_time" IS '鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_transaction"."points_change" IS '绉垎鍙樺姩鍊�';
+COMMENT ON COLUMN "public"."tb_points_transaction"."rule_type" IS '绉垎瑙勫垯绫诲瀷';
+COMMENT ON COLUMN "public"."tb_points_transaction"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."tb_points_transaction"."unit_id" IS '浼佷笟ID';
+COMMENT ON COLUMN "public"."tb_points_transaction"."user_type" IS '鐢ㄦ埛绫诲瀷';
+COMMENT ON COLUMN "public"."tb_points_transaction"."rule_id" IS '鍏宠仈瑙勫垯ID';
+COMMENT ON COLUMN "public"."tb_points_transaction"."detail_id" IS '鍏宠仈瑙勫垯璇︽儏ID';
+COMMENT ON COLUMN "public"."tb_points_transaction"."created_at" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."tb_points_transaction"."deleted" IS '閫昏緫鍒犻櫎';
+COMMENT ON TABLE "public"."tb_points_transaction" IS '绉垎娴佹按琛�';
-- ----------------------------
--- Records of points_transaction
+-- Records of tb_points_transaction
-- ----------------------------
-
-- ----------------------------
--- Table structure for product
+-- Table structure for tb_product_pricing
-- ----------------------------
-DROP TABLE IF EXISTS "public"."product";
-CREATE TABLE "public"."product" (
+DROP TABLE IF EXISTS "public"."tb_product_pricing";
+CREATE TABLE "public"."tb_product_pricing" (
"id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
-START 1
-),
- "product_name" text COLLATE "pg_catalog"."default" NOT NULL,
- "product_code" text COLLATE "pg_catalog"."default" NOT NULL,
- "product_type" text COLLATE "pg_catalog"."default",
- "category" text COLLATE "pg_catalog"."default",
- "description" text COLLATE "pg_catalog"."default",
- "provider_id" int8 NOT NULL,
- "provider_name" text COLLATE "pg_catalog"."default" NOT NULL,
- "provider_type" text COLLATE "pg_catalog"."default",
- "status" text COLLATE "pg_catalog"."default" DEFAULT '涓婃灦'::text,
- "audit_status" text COLLATE "pg_catalog"."default" DEFAULT '寰呭鏍�'::text,
- "tags" text COLLATE "pg_catalog"."default",
- "cover_image" text COLLATE "pg_catalog"."default",
- "demo_url" text COLLATE "pg_catalog"."default",
- "doc_url" text COLLATE "pg_catalog"."default",
- "created_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
- "updated_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
- "created_by" int8,
- "updated_by" int8,
- "deleted" int4 DEFAULT 0
-)
-;
-COMMENT ON TABLE "public"."product" IS '浜у搧琛�';
-
--- ----------------------------
--- Records of product
--- ----------------------------
-INSERT INTO "public"."product" OVERRIDING SYSTEM VALUE VALUES (1, '娴嬭瘯浜у搧1', 'TEST_PRODUCT_001', '杞欢浜у搧', '浼佷笟绠＄悊', '杩欐槸涓�涓祴璇曚骇鍝�', 3, '娴嬭瘯鎻愪緵鑰�', NULL, '涓婃灦', '瀹℃牳閫氳繃', NULL, NULL, NULL, NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0);
-INSERT INTO "public"."product" OVERRIDING SYSTEM VALUE VALUES (2, '娴嬭瘯浜у搧2', 'TEST_PRODUCT_002', '鏈嶅姟浜у搧', '鎶�鏈湇鍔�', '杩欐槸鍙︿竴涓祴璇曚骇鍝�', 3, '娴嬭瘯鎻愪緵鑰�', NULL, '涓婃灦', '瀹℃牳閫氳繃', NULL, NULL, NULL, NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0);
-
--- ----------------------------
--- Table structure for product_pricing
--- ----------------------------
-DROP TABLE IF EXISTS "public"."product_pricing";
-CREATE TABLE "public"."product_pricing" (
- "id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
+START 12
),
"suite_name" text COLLATE "pg_catalog"."default" NOT NULL,
"sales_form" text COLLATE "pg_catalog"."default" NOT NULL,
@@ -816,76 +562,53 @@
"concurrent_nodes" text COLLATE "pg_catalog"."default" DEFAULT '涓嶉檺'::text,
"price_type" text COLLATE "pg_catalog"."default" NOT NULL,
"price_unit" text COLLATE "pg_catalog"."default" NOT NULL,
- "price" numeric(15,2) NOT NULL,
+ "points_price" numeric(15,2),
"is_active" bool DEFAULT true,
- "product_id" int8 NOT NULL,
+ "product_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
"product_name" text COLLATE "pg_catalog"."default",
- "provider_id" int8,
+ "provider_id" varchar(64) COLLATE "pg_catalog"."default",
"provider_name" text COLLATE "pg_catalog"."default",
"description" text COLLATE "pg_catalog"."default",
"created_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
"updated_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
"created_by" int8,
"updated_by" int8,
- "deleted" int4 DEFAULT 0
+ "deleted" int4 DEFAULT 0,
+ "currency_price" numeric(15,2)
)
;
-COMMENT ON COLUMN "public"."product_pricing"."suite_name" IS '浜у搧濂椾欢鍚嶇О';
-COMMENT ON COLUMN "public"."product_pricing"."sales_form" IS '閿�鍞舰寮�';
-COMMENT ON TABLE "public"."product_pricing" IS '浜у搧瀹氫环琛�';
+COMMENT ON COLUMN "public"."tb_product_pricing"."suite_name" IS '浜у搧濂椾欢鍚嶇О';
+COMMENT ON COLUMN "public"."tb_product_pricing"."sales_form" IS '閿�鍞舰寮�';
+COMMENT ON COLUMN "public"."tb_product_pricing"."points_price" IS '绉垎浠锋牸';
+COMMENT ON COLUMN "public"."tb_product_pricing"."currency_price" IS '璐у竵浠锋牸';
+COMMENT ON TABLE "public"."tb_product_pricing" IS '浜у搧瀹氫环琛�';
-- ----------------------------
--- Records of product_pricing
+-- Records of tb_product_pricing
-- ----------------------------
-INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (1, '鍩虹鐗�', '涔版柇', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�', 1000.00, 't', 1, '娴嬭瘯浜у搧1', 3, '娴嬭瘯鎻愪緵鑰�', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0);
-INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (2, '涓撲笟鐗�', '绉熻祦', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�/骞�', 500.00, 't', 1, '娴嬭瘯浜у搧1', 3, '娴嬭瘯鎻愪緵鑰�', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0);
-INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (3, '浼佷笟鐗�', '涔版柇', '浼佷笟', '涓嶉檺', '涓嶉檺', '璐у竵', '濂�', 10000.00, 't', 2, '娴嬭瘯浜у搧2', 3, '娴嬭瘯鎻愪緵鑰�', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (3, '浼佷笟鐗�', '涔版柇', '浼佷笟', '涓嶉檺', '涓嶉檺', '璐у竵', '濂�', 10000.00, 't', '2', '娴嬭瘯浜у搧2', '3', '娴嬭瘯鎻愪緵鑰�', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0, NULL);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (1, '鍩虹鐗�', '涔版柇', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�', 1000.00, 't', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '娴嬭瘯浜у搧1', '3', '娴嬭瘯鎻愪緵鑰�', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0, NULL);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (2, '涓撲笟鐗�', '绉熻祦', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�/骞�', 500.00, 't', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '娴嬭瘯浜у搧1', '3', '娴嬭瘯鎻愪緵鑰�', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0, NULL);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (4, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '1', '绉垎,璐у竵', '濂�/骞�', 200.00, 't', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-18 16:53:39.407', '2025-08-18 16:53:39.407', NULL, NULL, 0, 100.00);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (6, '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉熻祦', '涓汉', '2', '2', '璐у竵', '濂�/骞�', 200.00, 't', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-18 17:13:29.332', '2025-08-18 17:13:29.332', NULL, NULL, 0, 100.00);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (9, '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧炲寘閲�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', NULL, 't', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-19 17:17:41.644', '2025-08-19 17:17:41.644', NULL, NULL, 0, NULL);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (5, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉佹湁澧炲寘閲�', '涓汉', '2', '3', '绉垎,璐у竵', '濂�/骞�', 200.00, 'f', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-18 16:53:57.726', '2025-08-19 17:54:06.25', NULL, NULL, 1, 100.00);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (10, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '2', '绉垎,璐у竵,鍗忚', '濂�/骞�', 100.00, 't', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-22 14:21:52.591', '2025-08-22 14:22:20.653', NULL, NULL, 0, 100.00);
+INSERT INTO "public"."tb_product_pricing" OVERRIDING SYSTEM VALUE VALUES (11, 'web杞欢', '绉熻祦', '涓汉', '1', '涓嶉檺', '鍏嶈垂', '骞�', 0.00, 't', '7439040f-cf34-4e8a-a3da-0b7990f79e4d', '閽㈢瓔鏁板瓧鍖栫敓浜у姞宸�', NULL, NULL, '', '2025-08-27 16:03:36.041', '2025-08-27 16:04:06.647', NULL, NULL, 0, 0.00);
-- ----------------------------
--- Table structure for unit
+-- Table structure for tb_user_points
-- ----------------------------
-DROP TABLE IF EXISTS "public"."unit";
-CREATE TABLE "public"."unit" (
+DROP TABLE IF EXISTS "public"."tb_user_points";
+CREATE TABLE "public"."tb_user_points" (
"id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
-INCREMENT 1
+ INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
-START 1
+START 2
),
- "unit_name" text COLLATE "pg_catalog"."default" NOT NULL,
- "unit_code" text COLLATE "pg_catalog"."default",
- "unit_type" text COLLATE "pg_catalog"."default",
- "industry" text COLLATE "pg_catalog"."default",
- "address" text COLLATE "pg_catalog"."default",
- "contact_person" text COLLATE "pg_catalog"."default",
- "contact_phone" text COLLATE "pg_catalog"."default",
- "contact_email" text COLLATE "pg_catalog"."default",
- "business_license" text COLLATE "pg_catalog"."default",
- "legal_person" text COLLATE "pg_catalog"."default",
- "registered_capital" numeric(15,2),
- "establishment_date" date,
- "status" text COLLATE "pg_catalog"."default" DEFAULT '姝ｅ父'::text,
- "created_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
- "updated_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
- "deleted" int4 DEFAULT 0
-)
-;
-COMMENT ON TABLE "public"."unit" IS '鍗曚綅琛�';
-
--- ----------------------------
--- Records of unit
--- ----------------------------
-INSERT INTO "public"."unit" OVERRIDING SYSTEM VALUE VALUES (1, '娴嬭瘯浼佷笟', 'TEST_ENTERPRISE', '浼佷笟', '淇℃伅鎶�鏈�', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '姝ｅ父', '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', 0);
-INSERT INTO "public"."unit" OVERRIDING SYSTEM VALUE VALUES (2, '娴嬭瘯鍗曚綅', 'TEST_UNIT', '浜嬩笟鍗曚綅', '鏁欒偛', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '姝ｅ父', '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', 0);
-
--- ----------------------------
--- Table structure for user_points
--- ----------------------------
-DROP TABLE IF EXISTS "public"."user_points";
-CREATE TABLE "public"."user_points" (
- "id" int8 NOT NULL DEFAULT nextval('user_points_id_seq'::regclass),
- "user_id" int8 NOT NULL,
- "unit_id" int8,
+ "user_id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
+ "unit_id" varchar(64) COLLATE "pg_catalog"."default",
"balance" int4 NOT NULL DEFAULT 0,
"total_earned" int4 NOT NULL DEFAULT 0,
"total_consumed" int4 NOT NULL DEFAULT 0,
@@ -895,654 +618,343 @@
"deleted" int4 DEFAULT 0
)
;
-COMMENT ON COLUMN "public"."user_points"."user_id" IS '鐢ㄦ埛ID';
-COMMENT ON COLUMN "public"."user_points"."unit_id" IS '鍗曚綅ID';
-COMMENT ON COLUMN "public"."user_points"."balance" IS '绉垎浣欓';
-COMMENT ON COLUMN "public"."user_points"."total_earned" IS '绱鑾峰彇绉垎';
-COMMENT ON COLUMN "public"."user_points"."total_consumed" IS '绱娑堣�楃Н鍒�';
-COMMENT ON COLUMN "public"."user_points"."total_converted" IS '绱杞崲绉垎';
-COMMENT ON COLUMN "public"."user_points"."create_time" IS '鍒涘缓鏃堕棿';
-COMMENT ON COLUMN "public"."user_points"."update_time" IS '鏇存柊鏃堕棿';
-COMMENT ON COLUMN "public"."user_points"."deleted" IS '閫昏緫鍒犻櫎锛�1-宸插垹闄わ紝0-鏈垹闄�';
-COMMENT ON TABLE "public"."user_points" IS '鐢ㄦ埛绉垎琛�';
+COMMENT ON COLUMN "public"."tb_user_points"."user_id" IS '鐢ㄦ埛ID';
+COMMENT ON COLUMN "public"."tb_user_points"."unit_id" IS '鍗曚綅ID';
+COMMENT ON COLUMN "public"."tb_user_points"."balance" IS '绉垎浣欓';
+COMMENT ON COLUMN "public"."tb_user_points"."total_earned" IS '绱鑾峰彇绉垎';
+COMMENT ON COLUMN "public"."tb_user_points"."total_consumed" IS '绱娑堣�楃Н鍒�';
+COMMENT ON COLUMN "public"."tb_user_points"."total_converted" IS '绱杞崲绉垎';
+COMMENT ON COLUMN "public"."tb_user_points"."create_time" IS '鍒涘缓鏃堕棿';
+COMMENT ON COLUMN "public"."tb_user_points"."update_time" IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN "public"."tb_user_points"."deleted" IS '閫昏緫鍒犻櫎锛�1-宸插垹闄わ紝0-鏈垹闄�';
+COMMENT ON TABLE "public"."tb_user_points" IS '鐢ㄦ埛绉垎琛�';
-- ----------------------------
--- Records of user_points
+-- Records of tb_user_points
-- ----------------------------
-INSERT INTO "public"."user_points" VALUES (1, 1, 1, 20000, 10000, 200, 0, '2025-08-07 11:48:21.574933', '2025-08-07 11:48:21.574933', 0);
+INSERT INTO "public"."tb_user_points" OVERRIDING SYSTEM VALUE VALUES (1, '1', '1', 20000, 10000, 200, 0, '2025-08-07 11:48:21.574933', '2025-08-07 11:48:21.574933', 0);
+
-- ----------------------------
--- Table structure for users
+-- Indexes structure for table tb_cart
-- ----------------------------
-DROP TABLE IF EXISTS "public"."users";
-CREATE TABLE "public"."users" (
- "id" int8 NOT NULL GENERATED ALWAYS AS IDENTITY (
-INCREMENT 1
-MINVALUE 1
-MAXVALUE 9223372036854775807
-START 1
-),
- "username" text COLLATE "pg_catalog"."default" NOT NULL,
- "real_name" text COLLATE "pg_catalog"."default",
- "email" text COLLATE "pg_catalog"."default",
- "phone" text COLLATE "pg_catalog"."default",
- "avatar" text COLLATE "pg_catalog"."default",
- "user_type" text COLLATE "pg_catalog"."default" DEFAULT '涓汉鐢ㄦ埛'::text,
- "unit_id" int8,
- "unit_name" text COLLATE "pg_catalog"."default",
- "status" text COLLATE "pg_catalog"."default" DEFAULT '姝ｅ父'::text,
- "last_login_time" timestamp(6),
- "created_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
- "updated_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
- "deleted" int4 DEFAULT 0
-)
-;
-COMMENT ON TABLE "public"."users" IS '鐢ㄦ埛琛�';
-
--- ----------------------------
--- Records of users
--- ----------------------------
-INSERT INTO "public"."users" OVERRIDING SYSTEM VALUE VALUES (1, 'admin', '绯荤粺绠＄悊鍛�', NULL, NULL, NULL, '涓汉鐢ㄦ埛', NULL, NULL, '姝ｅ父', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', 0);
-INSERT INTO "public"."users" OVERRIDING SYSTEM VALUE VALUES (2, 'test_user', '娴嬭瘯鐢ㄦ埛', NULL, NULL, NULL, '涓汉鐢ㄦ埛', 1, NULL, '姝ｅ父', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', 0);
-INSERT INTO "public"."users" OVERRIDING SYSTEM VALUE VALUES (3, 'test_provider', '娴嬭瘯鎻愪緵鑰�', NULL, NULL, NULL, '鍗曚綅鐢ㄦ埛', 1, NULL, '姝ｅ父', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', 0);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."cart_id_seq"
-OWNED BY "public"."cart"."id";
-SELECT setval('"public"."cart_id_seq"', 3, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."cart_id_seq1"
-OWNED BY "public"."cart"."id";
-SELECT setval('"public"."cart_id_seq1"', 2, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."order_approval_id_seq"
-OWNED BY "public"."order_approval"."id";
-SELECT setval('"public"."order_approval_id_seq"', 3, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."order_approval_id_seq1"
-OWNED BY "public"."order_approval"."id";
-SELECT setval('"public"."order_approval_id_seq1"', 2, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."order_attachment_id_seq"
-OWNED BY "public"."order_attachment"."id";
-SELECT setval('"public"."order_attachment_id_seq"', 3, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."order_attachment_id_seq1"
-OWNED BY "public"."order_attachment"."id";
-SELECT setval('"public"."order_attachment_id_seq1"', 2, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."order_detail_id_seq"
-OWNED BY "public"."order_detail"."id";
-SELECT setval('"public"."order_detail_id_seq"', 3, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."order_detail_id_seq1"
-OWNED BY "public"."order_detail"."id";
-SELECT setval('"public"."order_detail_id_seq1"', 2, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."order_evaluation_id_seq"
-OWNED BY "public"."order_evaluation"."id";
-SELECT setval('"public"."order_evaluation_id_seq"', 3, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."order_evaluation_id_seq1"
-OWNED BY "public"."order_evaluation"."id";
-SELECT setval('"public"."order_evaluation_id_seq1"', 2, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."points_account_id_seq"
-OWNED BY "public"."points_account"."id";
-SELECT setval('"public"."points_account_id_seq"', 3, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."points_flow_id_seq"
-OWNED BY "public"."points_flow"."id";
-SELECT setval('"public"."points_flow_id_seq"', 19, true);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."points_id_seq"
-OWNED BY "public"."points"."id";
-SELECT setval('"public"."points_id_seq"', 7, true);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."points_rule_id_seq"
-OWNED BY "public"."points_rule"."id";
-SELECT setval('"public"."points_rule_id_seq"', 85, true);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."points_transaction_id_seq"
-OWNED BY "public"."points_transaction"."id";
-SELECT setval('"public"."points_transaction_id_seq"', 3, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."product_id_seq"
-OWNED BY "public"."product"."id";
-SELECT setval('"public"."product_id_seq"', 4, true);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."product_id_seq1"
-OWNED BY "public"."product"."id";
-SELECT setval('"public"."product_id_seq1"', 2, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."product_pricing_id_seq"
-OWNED BY "public"."product_pricing"."id";
-SELECT setval('"public"."product_pricing_id_seq"', 5, true);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."product_pricing_id_seq1"
-OWNED BY "public"."product_pricing"."id";
-SELECT setval('"public"."product_pricing_id_seq1"', 2, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."unit_id_seq"
-OWNED BY "public"."unit"."id";
-SELECT setval('"public"."unit_id_seq"', 4, true);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."unit_id_seq1"
-OWNED BY "public"."unit"."id";
-SELECT setval('"public"."unit_id_seq1"', 2, false);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."user_points_id_seq"
-OWNED BY "public"."user_points"."id";
-SELECT setval('"public"."user_points_id_seq"', 3, true);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."users_id_seq"
-OWNED BY "public"."users"."id";
-SELECT setval('"public"."users_id_seq"', 5, true);
-
--- ----------------------------
--- Alter sequences owned by
--- ----------------------------
-ALTER SEQUENCE "public"."users_id_seq1"
-OWNED BY "public"."users"."id";
-SELECT setval('"public"."users_id_seq1"', 2, false);
-
--- ----------------------------
--- Indexes structure for table cart
--- ----------------------------
-CREATE INDEX "idx_cart_add_time" ON "public"."cart" USING btree (
+CREATE INDEX "idx_cart_add_time" ON "public"."tb_cart" USING btree (
"add_time" "pg_catalog"."timestamp_ops" ASC NULLS LAST,
"deleted" "pg_catalog"."int4_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_cart_pricing" ON "public"."cart" USING btree (
+CREATE INDEX "idx_cart_pricing" ON "public"."tb_cart" USING btree (
"pricing_id" "pg_catalog"."int8_ops" ASC NULLS LAST,
"deleted" "pg_catalog"."int4_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_cart_product" ON "public"."cart" USING btree (
- "product_id" "pg_catalog"."int8_ops" ASC NULLS LAST,
+CREATE INDEX "idx_cart_product" ON "public"."tb_cart" USING btree (
+ "product_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
"deleted" "pg_catalog"."int4_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_cart_provider" ON "public"."cart" USING btree (
+CREATE INDEX "idx_cart_provider" ON "public"."tb_cart" USING btree (
"provider_id" "pg_catalog"."int8_ops" ASC NULLS LAST,
"deleted" "pg_catalog"."int4_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_cart_user_unit" ON "public"."cart" USING btree (
- "user_id" "pg_catalog"."int8_ops" ASC NULLS LAST,
- "unit_id" "pg_catalog"."int8_ops" ASC NULLS LAST,
+CREATE INDEX "idx_cart_user_unit" ON "public"."tb_cart" USING btree (
+ "user_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
+ "unit_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
"deleted" "pg_catalog"."int4_ops" ASC NULLS LAST
);
-- ----------------------------
--- Uniques structure for table cart
+-- Uniques structure for table tb_cart
-- ----------------------------
-ALTER TABLE "public"."cart" ADD CONSTRAINT "cart_user_id_unit_id_pricing_id_deleted_key" UNIQUE ("user_id", "unit_id", "pricing_id", "deleted");
+ALTER TABLE "public"."tb_cart" ADD CONSTRAINT "cart_user_id_unit_id_pricing_id_deleted_key" UNIQUE ("user_id", "unit_id", "pricing_id", "deleted");
-- ----------------------------
--- Checks structure for table cart
+-- Checks structure for table tb_cart
-- ----------------------------
-ALTER TABLE "public"."cart" ADD CONSTRAINT "cart_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_cart" ADD CONSTRAINT "cart_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-- ----------------------------
--- Primary Key structure for table cart
+-- Primary Key structure for table tb_cart
-- ----------------------------
-ALTER TABLE "public"."cart" ADD CONSTRAINT "cart_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_cart" ADD CONSTRAINT "cart_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Indexes structure for table order_approval
+-- Indexes structure for table tb_order_approval
-- ----------------------------
-CREATE INDEX "idx_order_approval_approver_id" ON "public"."order_approval" USING btree (
+CREATE INDEX "idx_order_approval_approver_id" ON "public"."tb_order_approval" USING btree (
"approver_id" "pg_catalog"."int8_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_order_approval_order_id" ON "public"."order_approval" USING btree (
+CREATE INDEX "idx_order_approval_order_id" ON "public"."tb_order_approval" USING btree (
"order_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
--- Checks structure for table order_approval
+-- Checks structure for table tb_order_approval
-- ----------------------------
-ALTER TABLE "public"."order_approval" ADD CONSTRAINT "order_approval_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-ALTER TABLE "public"."order_approval" ADD CONSTRAINT "order_approval_approval_type_check" CHECK (approval_type = ANY (ARRAY['瀹℃壒'::text, '鎺堟潈'::text]));
-ALTER TABLE "public"."order_approval" ADD CONSTRAINT "order_approval_approval_result_check" CHECK (approval_result = ANY (ARRAY['閫氳繃'::text, '椹冲洖'::text, '寰呭鐞�'::text]));
+ALTER TABLE "public"."tb_order_approval" ADD CONSTRAINT "order_approval_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_order_approval" ADD CONSTRAINT "order_approval_approval_type_check" CHECK (approval_type = ANY (ARRAY['瀹℃壒'::text, '鎺堟潈'::text]));
+ALTER TABLE "public"."tb_order_approval" ADD CONSTRAINT "order_approval_approval_result_check" CHECK (approval_result = ANY (ARRAY['閫氳繃'::text, '椹冲洖'::text, '寰呭鐞�'::text]));
-- ----------------------------
--- Primary Key structure for table order_approval
+-- Primary Key structure for table tb_order_approval
-- ----------------------------
-ALTER TABLE "public"."order_approval" ADD CONSTRAINT "order_approval_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_order_approval" ADD CONSTRAINT "order_approval_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Indexes structure for table order_attachment
+-- Indexes structure for table tb_order_attachment
-- ----------------------------
-CREATE INDEX "idx_order_attachment_order_id" ON "public"."order_attachment" USING btree (
+CREATE INDEX "idx_order_attachment_order_id" ON "public"."tb_order_attachment" USING btree (
"order_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
--- Checks structure for table order_attachment
+-- Checks structure for table tb_order_attachment
-- ----------------------------
-ALTER TABLE "public"."order_attachment" ADD CONSTRAINT "order_attachment_attachment_type_check" CHECK (attachment_type = ANY (ARRAY['鍚堝悓'::text, '鍙戠エ'::text, '鍏朵粬'::text]));
-ALTER TABLE "public"."order_attachment" ADD CONSTRAINT "order_attachment_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_order_attachment" ADD CONSTRAINT "order_attachment_attachment_type_check" CHECK (attachment_type = ANY (ARRAY['鍚堝悓'::text, '鍙戠エ'::text, '鍏朵粬'::text]));
+ALTER TABLE "public"."tb_order_attachment" ADD CONSTRAINT "order_attachment_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-- ----------------------------
--- Primary Key structure for table order_attachment
+-- Primary Key structure for table tb_order_attachment
-- ----------------------------
-ALTER TABLE "public"."order_attachment" ADD CONSTRAINT "order_attachment_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_order_attachment" ADD CONSTRAINT "order_attachment_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Indexes structure for table order_detail
+-- Indexes structure for table tb_order_detail
-- ----------------------------
-CREATE INDEX "idx_order_detail_order_id" ON "public"."order_detail" USING btree (
+CREATE INDEX "idx_order_detail_order_id" ON "public"."tb_order_detail" USING btree (
"order_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
--- Checks structure for table order_detail
+-- Checks structure for table tb_order_detail
-- ----------------------------
-ALTER TABLE "public"."order_detail" ADD CONSTRAINT "order_detail_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_order_detail" ADD CONSTRAINT "order_detail_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-- ----------------------------
--- Primary Key structure for table order_detail
+-- Primary Key structure for table tb_order_detail
-- ----------------------------
-ALTER TABLE "public"."order_detail" ADD CONSTRAINT "order_detail_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_order_detail" ADD CONSTRAINT "order_detail_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Indexes structure for table order_evaluation
+-- Indexes structure for table tb_order_evaluation
-- ----------------------------
-CREATE INDEX "idx_order_evaluation_evaluator_id" ON "public"."order_evaluation" USING btree (
+CREATE INDEX "idx_order_evaluation_evaluator_id" ON "public"."tb_order_evaluation" USING btree (
"evaluator_id" "pg_catalog"."int8_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_order_evaluation_order_id" ON "public"."order_evaluation" USING btree (
+CREATE INDEX "idx_order_evaluation_order_id" ON "public"."tb_order_evaluation" USING btree (
"order_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
--- Checks structure for table order_evaluation
+-- Checks structure for table tb_order_evaluation
-- ----------------------------
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_service_rating_check" CHECK (service_rating >= 1 AND service_rating <= 5);
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_quality_rating_check" CHECK (quality_rating >= 1 AND quality_rating <= 5);
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_delivery_rating_check" CHECK (delivery_rating >= 1 AND delivery_rating <= 5);
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_evaluator_type_check" CHECK (evaluator_type = ANY (ARRAY['涔板'::text, '鍗栧'::text]));
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_rating_check" CHECK (rating >= 1 AND rating <= 5);
+ALTER TABLE "public"."tb_order_evaluation" ADD CONSTRAINT "order_evaluation_service_rating_check" CHECK (service_rating >= 1 AND service_rating <= 5);
+ALTER TABLE "public"."tb_order_evaluation" ADD CONSTRAINT "order_evaluation_quality_rating_check" CHECK (quality_rating >= 1 AND quality_rating <= 5);
+ALTER TABLE "public"."tb_order_evaluation" ADD CONSTRAINT "order_evaluation_delivery_rating_check" CHECK (delivery_rating >= 1 AND delivery_rating <= 5);
+ALTER TABLE "public"."tb_order_evaluation" ADD CONSTRAINT "order_evaluation_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_order_evaluation" ADD CONSTRAINT "order_evaluation_evaluator_type_check" CHECK (evaluator_type = ANY (ARRAY['涔板'::text, '鍗栧'::text]));
+ALTER TABLE "public"."tb_order_evaluation" ADD CONSTRAINT "order_evaluation_rating_check" CHECK (rating >= 1 AND rating <= 5);
-- ----------------------------
--- Primary Key structure for table order_evaluation
+-- Primary Key structure for table tb_order_evaluation
-- ----------------------------
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_order_evaluation" ADD CONSTRAINT "order_evaluation_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Indexes structure for table order_info
+-- Indexes structure for table tb_order_info
-- ----------------------------
-CREATE INDEX "idx_order_info_apply_time" ON "public"."order_info" USING btree (
+CREATE INDEX "idx_order_info_apply_time" ON "public"."tb_order_info" USING btree (
"apply_time" "pg_catalog"."timestamp_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_order_info_provider_id" ON "public"."order_info" USING btree (
- "provider_id" "pg_catalog"."int8_ops" ASC NULLS LAST
+CREATE INDEX "idx_order_info_provider_id" ON "public"."tb_order_info" USING btree (
+ "provider_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_order_info_status" ON "public"."order_info" USING btree (
+CREATE INDEX "idx_order_info_status" ON "public"."tb_order_info" USING btree (
"order_status" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_order_info_user_id" ON "public"."order_info" USING btree (
+CREATE INDEX "idx_order_info_user_id" ON "public"."tb_order_info" USING btree (
+ "user_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
+);
+
+-- ----------------------------
+-- Checks structure for table tb_order_info
+-- ----------------------------
+ALTER TABLE "public"."tb_order_info" ADD CONSTRAINT "order_info_payment_type_check" CHECK (payment_type = ANY (ARRAY['绉垎'::text, '璐у竵'::text, '鍗忚'::text]));
+ALTER TABLE "public"."tb_order_info" ADD CONSTRAINT "order_info_payment_status_check" CHECK (payment_status = ANY (ARRAY['鏈敮浠�'::text, '宸叉敮浠�'::text, '鏀粯澶辫触'::text, '宸查��娆�'::text]));
+ALTER TABLE "public"."tb_order_info" ADD CONSTRAINT "order_info_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_order_info" ADD CONSTRAINT "order_info_order_status_check" CHECK (order_status = ANY (ARRAY['寰呭鎵�'::text, '寰呭鎵规巿鏉�'::text, '寰呮巿鏉�'::text, '寰呬笂浼犳枃浠�'::text, '寰呬氦鏄撶‘璁�'::text, '宸插畬鎴�'::text, '宸插彇娑�'::text, '宸查┏鍥�'::text]));
+
+-- ----------------------------
+-- Primary Key structure for table tb_order_info
+-- ----------------------------
+ALTER TABLE "public"."tb_order_info" ADD CONSTRAINT "order_info_pkey" PRIMARY KEY ("order_id");
+
+-- ----------------------------
+-- Checks structure for table tb_points
+-- ----------------------------
+ALTER TABLE "public"."tb_points" ADD CONSTRAINT "chk_deleted" CHECK (deleted = ANY (ARRAY[0, 1]));
+
+-- ----------------------------
+-- Primary Key structure for table tb_points
+-- ----------------------------
+ALTER TABLE "public"."tb_points" ADD CONSTRAINT "points_pkey" PRIMARY KEY ("id");
+
+-- ----------------------------
+-- Indexes structure for table tb_points_account
+-- ----------------------------
+CREATE INDEX "idx_account_user" ON "public"."tb_points_account" USING btree (
"user_id" "pg_catalog"."int8_ops" ASC NULLS LAST
);
-- ----------------------------
--- Checks structure for table order_info
+-- Checks structure for table tb_points_account
-- ----------------------------
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_payment_status_check" CHECK (payment_status = ANY (ARRAY['鏈敮浠�'::text, '宸叉敮浠�'::text, '鏀粯澶辫触'::text, '宸查��娆�'::text]));
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_order_status_check" CHECK (order_status = ANY (ARRAY['寰呭鎵�'::text, '寰呭鎵规巿鏉�'::text, '寰呮巿鏉�'::text, '寰呬笂浼犳枃浠�'::text, '寰呬氦鏄撶‘璁�'::text, '宸插畬鎴�'::text, '宸插彇娑�'::text, '宸查┏鍥�'::text]));
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_payment_type_check" CHECK (payment_type = ANY (ARRAY['绉垎'::text, '璐у竵'::text, '鍗忚'::text]));
+ALTER TABLE "public"."tb_points_account" ADD CONSTRAINT "chk_account_type" CHECK (account_type = ANY (ARRAY['涓汉绉垎'::text, '鍗曚綅绉垎'::text]));
+ALTER TABLE "public"."tb_points_account" ADD CONSTRAINT "chk_account_status" CHECK (account_status = ANY (ARRAY['姝ｅ父'::text, '鍐荤粨'::text, '娉ㄩ攢'::text]));
+ALTER TABLE "public"."tb_points_account" ADD CONSTRAINT "chk_account_deleted" CHECK (deleted = ANY (ARRAY[0, 1]));
-- ----------------------------
--- Primary Key structure for table order_info
+-- Primary Key structure for table tb_points_account
-- ----------------------------
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_pkey" PRIMARY KEY ("order_id");
+ALTER TABLE "public"."tb_points_account" ADD CONSTRAINT "points_account_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Checks structure for table points
+-- Indexes structure for table tb_points_flow
-- ----------------------------
-ALTER TABLE "public"."points" ADD CONSTRAINT "chk_deleted" CHECK (deleted = ANY (ARRAY[0, 1]));
-
--- ----------------------------
--- Primary Key structure for table points
--- ----------------------------
-ALTER TABLE "public"."points" ADD CONSTRAINT "points_pkey" PRIMARY KEY ("id");
-
--- ----------------------------
--- Indexes structure for table points_account
--- ----------------------------
-CREATE INDEX "idx_account_user" ON "public"."points_account" USING btree (
- "user_id" "pg_catalog"."int8_ops" ASC NULLS LAST
-);
-
--- ----------------------------
--- Checks structure for table points_account
--- ----------------------------
-ALTER TABLE "public"."points_account" ADD CONSTRAINT "chk_account_type" CHECK (account_type = ANY (ARRAY['涓汉绉垎'::text, '鍗曚綅绉垎'::text]));
-ALTER TABLE "public"."points_account" ADD CONSTRAINT "chk_account_status" CHECK (account_status = ANY (ARRAY['姝ｅ父'::text, '鍐荤粨'::text, '娉ㄩ攢'::text]));
-ALTER TABLE "public"."points_account" ADD CONSTRAINT "chk_account_deleted" CHECK (deleted = ANY (ARRAY[0, 1]));
-
--- ----------------------------
--- Primary Key structure for table points_account
--- ----------------------------
-ALTER TABLE "public"."points_account" ADD CONSTRAINT "points_account_pkey" PRIMARY KEY ("id");
-
--- ----------------------------
--- Indexes structure for table points_flow
--- ----------------------------
-CREATE INDEX "idx_points_flow_data_category" ON "public"."points_flow" USING btree (
+CREATE INDEX "idx_points_flow_data_category" ON "public"."tb_points_flow" USING btree (
"data_category" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_points_flow_flow_time" ON "public"."points_flow" USING btree (
+CREATE INDEX "idx_points_flow_flow_time" ON "public"."tb_points_flow" USING btree (
"flow_time" "pg_catalog"."timestamp_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_points_flow_unit_id" ON "public"."points_flow" USING btree (
- "unit_id" "pg_catalog"."int8_ops" ASC NULLS LAST
+CREATE INDEX "idx_points_flow_unit_id" ON "public"."tb_points_flow" USING btree (
+ "unit_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_points_flow_user_id" ON "public"."points_flow" USING btree (
- "user_id" "pg_catalog"."int8_ops" ASC NULLS LAST
+CREATE INDEX "idx_points_flow_user_id" ON "public"."tb_points_flow" USING btree (
+ "user_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
--- Primary Key structure for table points_flow
+-- Primary Key structure for table tb_points_flow
-- ----------------------------
-ALTER TABLE "public"."points_flow" ADD CONSTRAINT "points_flow_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_points_flow" ADD CONSTRAINT "points_flow_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Indexes structure for table points_rule
+-- Indexes structure for table tb_points_rule
-- ----------------------------
-CREATE INDEX "idx_points_rule_points" ON "public"."points_rule" USING btree (
+CREATE INDEX "idx_points_rule_points" ON "public"."tb_points_rule" USING btree (
"points_id" "pg_catalog"."int8_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_points_rule_points_id" ON "public"."points_rule" USING btree (
+CREATE INDEX "idx_points_rule_points_id" ON "public"."tb_points_rule" USING btree (
"points_id" "pg_catalog"."int8_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_points_rule_type" ON "public"."points_rule" USING btree (
+CREATE INDEX "idx_points_rule_type" ON "public"."tb_points_rule" USING btree (
"rule_type" "pg_catalog"."int2_ops" ASC NULLS LAST
);
-- ----------------------------
--- Checks structure for table points_rule
+-- Checks structure for table tb_points_rule
-- ----------------------------
-ALTER TABLE "public"."points_rule" ADD CONSTRAINT "chk_rule_deleted" CHECK (deleted = ANY (ARRAY[0, 1]));
-ALTER TABLE "public"."points_rule" ADD CONSTRAINT "chk_category" CHECK (category::text = ANY (ARRAY['璧勬簮璐＄尞'::text, '璧勬簮浼犳挱'::text, '璧勬簮浜ゆ槗'::text, '浜ゆ祦绀惧尯浜掑姩'::text]));
+ALTER TABLE "public"."tb_points_rule" ADD CONSTRAINT "chk_rule_deleted" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_points_rule" ADD CONSTRAINT "chk_category" CHECK (category::text = ANY (ARRAY['璧勬簮璐＄尞'::text, '璧勬簮浼犳挱'::text, '璧勬簮浜ゆ槗'::text, '浜ゆ祦绀惧尯浜掑姩'::text]));
-- ----------------------------
--- Primary Key structure for table points_rule
+-- Primary Key structure for table tb_points_rule
-- ----------------------------
-ALTER TABLE "public"."points_rule" ADD CONSTRAINT "points_rule_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_points_rule" ADD CONSTRAINT "points_rule_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Indexes structure for table points_transaction
+-- Indexes structure for table tb_points_transaction
-- ----------------------------
-CREATE INDEX "idx_transaction_time" ON "public"."points_transaction" USING btree (
+CREATE INDEX "idx_transaction_time" ON "public"."tb_points_transaction" USING btree (
"transaction_time" "pg_catalog"."timestamptz_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_transaction_user" ON "public"."points_transaction" USING btree (
+CREATE INDEX "idx_transaction_user" ON "public"."tb_points_transaction" USING btree (
"user_id" "pg_catalog"."int8_ops" ASC NULLS LAST
);
-- ----------------------------
--- Checks structure for table points_transaction
+-- Checks structure for table tb_points_transaction
-- ----------------------------
-ALTER TABLE "public"."points_transaction" ADD CONSTRAINT "chk_data_category" CHECK (data_category = ANY (ARRAY['鐢ㄦ埛鍙備笌'::text, '鍏朵粬'::text]));
-ALTER TABLE "public"."points_transaction" ADD CONSTRAINT "chk_trans_rule_type" CHECK (rule_type = ANY (ARRAY['鑾峰彇'::text, '娑堣��'::text]));
-ALTER TABLE "public"."points_transaction" ADD CONSTRAINT "chk_user_type" CHECK (user_type = ANY (ARRAY['鍗曚綅鐢ㄦ埛'::text, '涓汉鐢ㄦ埛'::text]));
-ALTER TABLE "public"."points_transaction" ADD CONSTRAINT "chk_trans_deleted" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_points_transaction" ADD CONSTRAINT "chk_data_category" CHECK (data_category = ANY (ARRAY['鐢ㄦ埛鍙備笌'::text, '鍏朵粬'::text]));
+ALTER TABLE "public"."tb_points_transaction" ADD CONSTRAINT "chk_trans_rule_type" CHECK (rule_type = ANY (ARRAY['鑾峰彇'::text, '娑堣��'::text]));
+ALTER TABLE "public"."tb_points_transaction" ADD CONSTRAINT "chk_user_type" CHECK (user_type = ANY (ARRAY['鍗曚綅鐢ㄦ埛'::text, '涓汉鐢ㄦ埛'::text]));
+ALTER TABLE "public"."tb_points_transaction" ADD CONSTRAINT "chk_trans_deleted" CHECK (deleted = ANY (ARRAY[0, 1]));
-- ----------------------------
--- Primary Key structure for table points_transaction
+-- Primary Key structure for table tb_points_transaction
-- ----------------------------
-ALTER TABLE "public"."points_transaction" ADD CONSTRAINT "points_transaction_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_points_transaction" ADD CONSTRAINT "points_transaction_pkey" PRIMARY KEY ("id");
+
-- ----------------------------
--- Indexes structure for table product
+-- Indexes structure for table tb_product_pricing
-- ----------------------------
-CREATE INDEX "idx_product_provider_id" ON "public"."product" USING btree (
- "provider_id" "pg_catalog"."int8_ops" ASC NULLS LAST
+CREATE INDEX "idx_product_pricing_product_id" ON "public"."tb_product_pricing" USING btree (
+ "product_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_product_status" ON "public"."product" USING btree (
- "status" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
-);
-
--- ----------------------------
--- Uniques structure for table product
--- ----------------------------
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_product_code_key" UNIQUE ("product_code");
-
--- ----------------------------
--- Checks structure for table product
--- ----------------------------
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_status_check" CHECK (status = ANY (ARRAY['涓婃灦'::text, '涓嬫灦'::text, '瀹℃牳涓�'::text, '宸蹭笅鏋�'::text]));
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_audit_status_check" CHECK (audit_status = ANY (ARRAY['寰呭鏍�'::text, '瀹℃牳閫氳繃'::text, '瀹℃牳椹冲洖'::text]));
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_provider_type_check" CHECK (provider_type = ANY (ARRAY['浼佷笟'::text, '涓汉'::text]));
-
--- ----------------------------
--- Primary Key structure for table product
--- ----------------------------
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_pkey" PRIMARY KEY ("id");
-
--- ----------------------------
--- Indexes structure for table product_pricing
--- ----------------------------
-CREATE INDEX "idx_product_pricing_product_id" ON "public"."product_pricing" USING btree (
- "product_id" "pg_catalog"."int8_ops" ASC NULLS LAST
-);
-CREATE INDEX "idx_product_pricing_status" ON "public"."product_pricing" USING btree (
+CREATE INDEX "idx_product_pricing_status" ON "public"."tb_product_pricing" USING btree (
"is_active" "pg_catalog"."bool_ops" ASC NULLS LAST
);
-- ----------------------------
--- Checks structure for table product_pricing
+-- Checks structure for table tb_product_pricing
-- ----------------------------
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_customer_type_check" CHECK (customer_type = ANY (ARRAY['浼佷笟'::text, '涓汉'::text, '椤圭洰閮�'::text]));
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_price_unit_check" CHECK (price_unit = ANY (ARRAY['濂�'::text, '濂�/骞�'::text, '骞�'::text, '涓�'::text, '娆�'::text]));
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_sales_form_check" CHECK (sales_form = ANY (ARRAY['涔版柇'::text, '绉熻祦'::text, '绉佹湁澧炲寘閲�'::text, '鍏湁澧炲寘閲�'::text, 'OTA鏈嶅姟'::text, '璧勬簮鍖�'::text, '涓汉'::text]));
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_price_type_check" CHECK (price_type = ANY (ARRAY['绉垎'::text, '鍗忚'::text, '璐у竵'::text, '鍏嶈垂'::text]));
+ALTER TABLE "public"."tb_product_pricing" ADD CONSTRAINT "product_pricing_customer_type_check" CHECK (customer_type = ANY (ARRAY['浼佷笟'::text, '涓汉'::text, '椤圭洰閮�'::text]));
+ALTER TABLE "public"."tb_product_pricing" ADD CONSTRAINT "product_pricing_price_unit_check" CHECK (price_unit = ANY (ARRAY['濂�'::text, '濂�/骞�'::text, '骞�'::text, '涓�'::text, '娆�'::text]));
+ALTER TABLE "public"."tb_product_pricing" ADD CONSTRAINT "product_pricing_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_product_pricing" ADD CONSTRAINT "product_pricing_sales_form_check" CHECK (sales_form = ANY (ARRAY['涔版柇'::text, '绉熻祦'::text, '绉佹湁澧炲寘閲�'::text, '鍏湁澧炲寘閲�'::text, 'OTA鏈嶅姟'::text, '璧勬簮鍖�'::text, '涓汉'::text]));
-- ----------------------------
--- Primary Key structure for table product_pricing
+-- Primary Key structure for table tb_product_pricing
-- ----------------------------
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_product_pricing" ADD CONSTRAINT "product_pricing_pkey" PRIMARY KEY ("id");
-- ----------------------------
--- Uniques structure for table unit
+-- Indexes structure for table tb_user_points
-- ----------------------------
-ALTER TABLE "public"."unit" ADD CONSTRAINT "unit_unit_code_key" UNIQUE ("unit_code");
-
--- ----------------------------
--- Checks structure for table unit
--- ----------------------------
-ALTER TABLE "public"."unit" ADD CONSTRAINT "unit_status_check" CHECK (status = ANY (ARRAY['姝ｅ父'::text, '鍐荤粨'::text, '娉ㄩ攢'::text]));
-ALTER TABLE "public"."unit" ADD CONSTRAINT "unit_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
-
--- ----------------------------
--- Primary Key structure for table unit
--- ----------------------------
-ALTER TABLE "public"."unit" ADD CONSTRAINT "unit_pkey" PRIMARY KEY ("id");
-
--- ----------------------------
--- Indexes structure for table user_points
--- ----------------------------
-CREATE INDEX "idx_user_points_unit_id" ON "public"."user_points" USING btree (
- "unit_id" "pg_catalog"."int8_ops" ASC NULLS LAST
+CREATE INDEX "idx_user_points_unit_id" ON "public"."tb_user_points" USING btree (
+ "unit_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-CREATE INDEX "idx_user_points_user_id" ON "public"."user_points" USING btree (
- "user_id" "pg_catalog"."int8_ops" ASC NULLS LAST
+CREATE INDEX "idx_user_points_user_id" ON "public"."tb_user_points" USING btree (
+ "user_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
-- ----------------------------
--- Primary Key structure for table user_points
+-- Primary Key structure for table tb_user_points
-- ----------------------------
-ALTER TABLE "public"."user_points" ADD CONSTRAINT "user_points_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_user_points" ADD CONSTRAINT "user_points_pkey" PRIMARY KEY ("id");
+
-- ----------------------------
--- Indexes structure for table users
+-- Foreign Keys structure for table tb_cart
-- ----------------------------
-CREATE INDEX "idx_users_status" ON "public"."users" USING btree (
- "status" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
-);
-CREATE INDEX "idx_users_unit_id" ON "public"."users" USING btree (
- "unit_id" "pg_catalog"."int8_ops" ASC NULLS LAST
-);
+ALTER TABLE "public"."tb_cart" ADD CONSTRAINT "cart_pricing_id_fkey" FOREIGN KEY ("pricing_id") REFERENCES "public"."tb_product_pricing" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-- ----------------------------
--- Uniques structure for table users
+-- Foreign Keys structure for table tb_order_approval
-- ----------------------------
-ALTER TABLE "public"."users" ADD CONSTRAINT "users_username_key" UNIQUE ("username");
+ALTER TABLE "public"."tb_order_approval" ADD CONSTRAINT "order_approval_order_id_fkey" FOREIGN KEY ("order_id") REFERENCES "public"."tb_order_info" ("order_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-- ----------------------------
--- Checks structure for table users
+-- Foreign Keys structure for table tb_order_attachment
-- ----------------------------
-ALTER TABLE "public"."users" ADD CONSTRAINT "users_user_type_check" CHECK (user_type = ANY (ARRAY['涓汉鐢ㄦ埛'::text, '鍗曚綅鐢ㄦ埛'::text]));
-ALTER TABLE "public"."users" ADD CONSTRAINT "users_status_check" CHECK (status = ANY (ARRAY['姝ｅ父'::text, '鍐荤粨'::text, '娉ㄩ攢'::text]));
-ALTER TABLE "public"."users" ADD CONSTRAINT "users_deleted_check" CHECK (deleted = ANY (ARRAY[0, 1]));
+ALTER TABLE "public"."tb_order_attachment" ADD CONSTRAINT "order_attachment_order_id_fkey" FOREIGN KEY ("order_id") REFERENCES "public"."tb_order_info" ("order_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
+-- ----------------------------
+-- Foreign Keys structure for table tb_order_detail
+-- ----------------------------
+ALTER TABLE "public"."tb_order_detail" ADD CONSTRAINT "order_detail_order_id_fkey" FOREIGN KEY ("order_id") REFERENCES "public"."tb_order_info" ("order_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
+ALTER TABLE "public"."tb_order_detail" ADD CONSTRAINT "order_detail_pricing_id_fkey" FOREIGN KEY ("pricing_id") REFERENCES "public"."tb_product_pricing" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-- ----------------------------
--- Primary Key structure for table users
+-- Foreign Keys structure for table tb_order_evaluation
-- ----------------------------
-ALTER TABLE "public"."users" ADD CONSTRAINT "users_pkey" PRIMARY KEY ("id");
+ALTER TABLE "public"."tb_order_evaluation" ADD CONSTRAINT "order_evaluation_order_id_fkey" FOREIGN KEY ("order_id") REFERENCES "public"."tb_order_info" ("order_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-- ----------------------------
--- Foreign Keys structure for table cart
+-- Foreign Keys structure for table tb_points_rule
-- ----------------------------
-ALTER TABLE "public"."cart" ADD CONSTRAINT "cart_pricing_id_fkey" FOREIGN KEY ("pricing_id") REFERENCES "public"."product_pricing" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."cart" ADD CONSTRAINT "cart_product_id_fkey" FOREIGN KEY ("product_id") REFERENCES "public"."product" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."cart" ADD CONSTRAINT "cart_provider_id_fkey" FOREIGN KEY ("provider_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."cart" ADD CONSTRAINT "cart_unit_id_fkey" FOREIGN KEY ("unit_id") REFERENCES "public"."unit" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."cart" ADD CONSTRAINT "cart_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
+ALTER TABLE "public"."tb_points_rule" ADD CONSTRAINT "fk_points" FOREIGN KEY ("points_id") REFERENCES "public"."tb_points" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-- ----------------------------
--- Foreign Keys structure for table order_approval
+-- Foreign Keys structure for table tb_points_transaction
-- ----------------------------
-ALTER TABLE "public"."order_approval" ADD CONSTRAINT "order_approval_approver_id_fkey" FOREIGN KEY ("approver_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_approval" ADD CONSTRAINT "order_approval_next_approver_id_fkey" FOREIGN KEY ("next_approver_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_approval" ADD CONSTRAINT "order_approval_order_id_fkey" FOREIGN KEY ("order_id") REFERENCES "public"."order_info" ("order_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
+ALTER TABLE "public"."tb_points_transaction" ADD CONSTRAINT "fk_rule_id" FOREIGN KEY ("rule_id") REFERENCES "public"."tb_points_rule" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
--- ----------------------------
--- Foreign Keys structure for table order_attachment
--- ----------------------------
-ALTER TABLE "public"."order_attachment" ADD CONSTRAINT "order_attachment_order_id_fkey" FOREIGN KEY ("order_id") REFERENCES "public"."order_info" ("order_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_attachment" ADD CONSTRAINT "order_attachment_upload_user_id_fkey" FOREIGN KEY ("upload_user_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-
--- ----------------------------
--- Foreign Keys structure for table order_detail
--- ----------------------------
-ALTER TABLE "public"."order_detail" ADD CONSTRAINT "order_detail_order_id_fkey" FOREIGN KEY ("order_id") REFERENCES "public"."order_info" ("order_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_detail" ADD CONSTRAINT "order_detail_pricing_id_fkey" FOREIGN KEY ("pricing_id") REFERENCES "public"."product_pricing" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_detail" ADD CONSTRAINT "order_detail_product_id_fkey" FOREIGN KEY ("product_id") REFERENCES "public"."product" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_detail" ADD CONSTRAINT "order_detail_provider_id_fkey" FOREIGN KEY ("provider_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-
--- ----------------------------
--- Foreign Keys structure for table order_evaluation
--- ----------------------------
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_evaluator_id_fkey" FOREIGN KEY ("evaluator_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_order_id_fkey" FOREIGN KEY ("order_id") REFERENCES "public"."order_info" ("order_id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_evaluation" ADD CONSTRAINT "order_evaluation_reply_user_id_fkey" FOREIGN KEY ("reply_user_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-
--- ----------------------------
--- Foreign Keys structure for table order_info
--- ----------------------------
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_product_id_fkey" FOREIGN KEY ("product_id") REFERENCES "public"."product" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_provider_id_fkey" FOREIGN KEY ("provider_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_unit_id_fkey" FOREIGN KEY ("unit_id") REFERENCES "public"."unit" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."order_info" ADD CONSTRAINT "order_info_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-
--- ----------------------------
--- Foreign Keys structure for table points_rule
--- ----------------------------
-ALTER TABLE "public"."points_rule" ADD CONSTRAINT "fk_points" FOREIGN KEY ("points_id") REFERENCES "public"."points" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-
--- ----------------------------
--- Foreign Keys structure for table points_transaction
--- ----------------------------
-ALTER TABLE "public"."points_transaction" ADD CONSTRAINT "fk_rule_id" FOREIGN KEY ("rule_id") REFERENCES "public"."points_rule" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-
--- ----------------------------
--- Foreign Keys structure for table product
--- ----------------------------
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_created_by_fkey" FOREIGN KEY ("created_by") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_provider_id_fkey" FOREIGN KEY ("provider_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."product" ADD CONSTRAINT "product_updated_by_fkey" FOREIGN KEY ("updated_by") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-
--- ----------------------------
--- Foreign Keys structure for table product_pricing
--- ----------------------------
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_created_by_fkey" FOREIGN KEY ("created_by") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_product_id_fkey" FOREIGN KEY ("product_id") REFERENCES "public"."product" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_provider_id_fkey" FOREIGN KEY ("provider_id") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-ALTER TABLE "public"."product_pricing" ADD CONSTRAINT "product_pricing_updated_by_fkey" FOREIGN KEY ("updated_by") REFERENCES "public"."users" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
-
--- ----------------------------
--- Foreign Keys structure for table users
--- ----------------------------
-ALTER TABLE "public"."users" ADD CONSTRAINT "users_unit_id_fkey" FOREIGN KEY ("unit_id") REFERENCES "public"."unit" ("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
--
Gitblit v1.8.0