attiya/ebike-plus
SHA256
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

sql新增字段

Browse Source
This commit is contained in:
yanglei 2026-03-11 16:59:12 +08:00
parent fa04a23293
commit 40ef5edac9
1 changed files with 6 additions and 2 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

8
ebike-operations/src/main/resources/db/init.sql
View File

@ -311,7 +311,8 @@ CREATE TABLE "public"."ebike_bike_order" (
"site_id" int8, "site_id" int8,
"dispatch_state" int2, "dispatch_state" int2,
"remarks" varchar(200) COLLATE "pg_catalog"."default", "remarks" varchar(200) COLLATE "pg_catalog"."default",
"fault_false_alarm" bool "fault_false_alarm" bool,
"is_user_reporting" bool
) )
; ;
COMMENT ON COLUMN "public"."ebike_bike_order"."order_id" IS '工单ID'; COMMENT ON COLUMN "public"."ebike_bike_order"."order_id" IS '工单ID';
@ -332,6 +333,7 @@ COMMENT ON COLUMN "public"."ebike_bike_order"."site_id" IS '站点ID（主要用
COMMENT ON COLUMN "public"."ebike_bike_order"."dispatch_state" IS '调度状态：0-工单已处理但暂不生效 1-生效 2-不生效'; COMMENT ON COLUMN "public"."ebike_bike_order"."dispatch_state" IS '调度状态：0-工单已处理但暂不生效 1-生效 2-不生效';
COMMENT ON COLUMN "public"."ebike_bike_order"."remarks" IS '故障描述/结果描述'; COMMENT ON COLUMN "public"."ebike_bike_order"."remarks" IS '故障描述/结果描述';
COMMENT ON COLUMN "public"."ebike_bike_order"."fault_false_alarm" IS '是否故障误报'; COMMENT ON COLUMN "public"."ebike_bike_order"."fault_false_alarm" IS '是否故障误报';
COMMENT ON COLUMN "public"."ebike_bike_order"."is_user_reporting" IS '是否用户上报';
COMMENT ON TABLE "public"."ebike_bike_order" IS '工单信息'; COMMENT ON TABLE "public"."ebike_bike_order" IS '工单信息';
@ -466,7 +468,8 @@ CREATE TABLE "public"."ebike_ecu_info" (
"created_by" int8, "created_by" int8,
"update_by" int8, "update_by" int8,
"bind_battery" bool, "bind_battery" bool,
"is_claim" bool NOT NULL "is_claim" bool NOT NULL,
"is_online" bool
); );
COMMENT ON COLUMN "public"."ebike_ecu_info"."ecu_id" IS '中控ID'; COMMENT ON COLUMN "public"."ebike_ecu_info"."ecu_id" IS '中控ID';
COMMENT ON COLUMN "public"."ebike_ecu_info"."operator_id" IS '运营商ID'; COMMENT ON COLUMN "public"."ebike_ecu_info"."operator_id" IS '运营商ID';
@ -480,6 +483,7 @@ COMMENT ON COLUMN "public"."ebike_ecu_info"."created_by" IS '创建人';
COMMENT ON COLUMN "public"."ebike_ecu_info"."update_by" IS '修改人'; COMMENT ON COLUMN "public"."ebike_ecu_info"."update_by" IS '修改人';
COMMENT ON COLUMN "public"."ebike_ecu_info"."bind_battery" IS '是否绑定电池（中控电池一体）'; COMMENT ON COLUMN "public"."ebike_ecu_info"."bind_battery" IS '是否绑定电池（中控电池一体）';
COMMENT ON COLUMN "public"."ebike_ecu_info"."is_claim" IS '是否被领取（主要针对绑定电池的中控可能被领取进行换电'; COMMENT ON COLUMN "public"."ebike_ecu_info"."is_claim" IS '是否被领取（主要针对绑定电池的中控可能被领取进行换电';
COMMENT ON COLUMN "public"."ebike_ecu_info"."is_online" IS '设备是否在线';
COMMENT ON TABLE "public"."ebike_ecu_info" IS '中控基本信息'; COMMENT ON TABLE "public"."ebike_ecu_info" IS '中控基本信息';
-- ---------------------------- -- ----------------------------