sql表结构更改

This commit is contained in:
yanglei 2026-03-10 09:44:34 +08:00
parent 88791e13b1
commit fa04a23293

View File

@ -397,6 +397,7 @@ CREATE TABLE "public"."ebike_default_billing_configuration" (
"charge_duration_minutes" int4 NOT NULL DEFAULT 1,
"no_parking_zone_fee" numeric(10,2) NOT NULL DEFAULT 2.00,
"helmet_management_fee" numeric(10,2) NOT NULL DEFAULT 2.00,
"prepaid_amount" numeric(10,2) NOT NULL DEFAULT 2.50,
"created_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
"created_by" int8,
"updated_at" timestamp(6) DEFAULT CURRENT_TIMESTAMP,
@ -414,6 +415,7 @@ COMMENT ON COLUMN "public"."ebike_default_billing_configuration"."base_duration_
COMMENT ON COLUMN "public"."ebike_default_billing_configuration"."charge_duration_minutes" IS '时长(分钟)';
COMMENT ON COLUMN "public"."ebike_default_billing_configuration"."no_parking_zone_fee" IS '禁停区调度费(元)';
COMMENT ON COLUMN "public"."ebike_default_billing_configuration"."helmet_management_fee" IS '头盔管理费(元)';
COMMENT ON COLUMN "public"."ebike_default_billing_configuration"."prepaid_amount" IS '订单预付金额(元)';
COMMENT ON COLUMN "public"."ebike_default_billing_configuration"."created_at" IS '记录创建时间';
COMMENT ON COLUMN "public"."ebike_default_billing_configuration"."updated_at" IS '记录最后更新时间';
COMMENT ON TABLE "public"."ebike_default_billing_configuration" IS '运营区默认计费规则';