ykt_server_hnswdx/sql/2025-6-9/kingbase/ddl.sql

CREATE TABLE "dbo"."t_xf_failed_record" (
    "id" character varying(64 char) NOT NULL,
    "tenant_id" character varying(20 char) NOT NULL DEFAULT ''::varchar,
    "consume_type" character varying(10 char) NULL,
	"user_no" character varying(20 char) NULL,
	"factory_id" character varying(20 char) NULL,
	"consume_date" timestamp NULL,
	"term_record_id" character varying(20 char) NULL,
	"consume_money" character varying(10 char) NULL,
	"term_mac" character varying(20 char) NOT NULL DEFAULT ''::varchar,
	"term_no" character varying(20 char) NULL,
	"fail_msg" character varying(2000 char) NULL,
	"status" character(1 char) NOT NULL DEFAULT 'f'::bpchar,
	"del_flag" character(1 char) NOT NULL DEFAULT '0'::bpchar,
	"create_by" bigint NULL,
	"create_dept" bigint NULL,
	"create_time" timestamp NULL,
	"update_by" bigint NULL,
	"update_time" timestamp NULL,
	CONSTRAINT "t_xf_failed_record_pkey" PRIMARY KEY (id)
);
ALTER TABLE "dbo"."t_xf_failed_record" COMMENT '海康消费失败记录';

-- Column comments
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "id" COMMENT '主键';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "tenant_id" COMMENT '租户Id';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "user_no" COMMENT '用户流水号';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "factory_id" COMMENT '物理卡号';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "term_record_id" COMMENT '设备记录流水号';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "consume_money" COMMENT '消费金额';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "consume_date" COMMENT '消费时间';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "term_mac" COMMENT '设备mac地址';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "term_no" COMMENT '设备机号';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "fail_msg" COMMENT '上次失败的原因';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "status" COMMENT '处理结果，s成功f失败';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "del_flag" COMMENT '删除标志(0-未删除 2-已删除)';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "create_by" COMMENT '创建者';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "create_time" COMMENT '创建时间';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "update_by" COMMENT '更新者';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "update_time" COMMENT '更新时间';
ALTER TABLE "dbo"."t_xf_failed_record" MODIFY "consume_type" COMMENT '消费类型，在线current离线offLine';