{"id":228,"date":"2026-05-30T15:05:09","date_gmt":"2026-05-30T07:05:09","guid":{"rendered":"https:\/\/www.houzhibin.top\/?p=228"},"modified":"2026-05-30T15:50:01","modified_gmt":"2026-05-30T07:50:01","slug":"%e6%96%b0%e8%83%bd%e6%ba%90%e9%80%89%e8%bd%a6agent","status":"publish","type":"post","link":"https:\/\/www.houzhibin.top\/?p=228","title":{"rendered":"\u65b0\u80fd\u6e90\u9009\u8f66Agent"},"content":{"rendered":"\n

Dify\u642d\u5efa\u6d41\u7a0b\uff1a<\/h2>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n

\u9996\u5148,\u53bbsupabase\u5efa\u8868\uff0c\u6570\u636e\u5e93\u5206\u4e3a\u4e24\u4e2a\u8868 ev_model \u548c favourites ,<\/p>\n\n\n\n

ev_model<\/summary>\n

— \u53ef\u9009\uff1a\u542f\u7528 pgcrypto \u4ee5\u4f7f\u7528 gen_random_uuid()
CREATE EXTENSION IF NOT EXISTS pgcrypto;<\/p>\n\n\n\n

CREATE TABLE IF NOT EXISTS public.ev_models (
id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
brand text NOT NULL, — \u54c1\u724c
model text NOT NULL, — \u578b\u53f7
variant text, — \u7248\u672c\/\u914d\u7f6e
body_type text NOT NULL, — \u8f66\u8eab\u7c7b\u578b\uff08\u5982 \u8f7f\u8f66\/SUV\/MPV\/\u76ae\u5361\uff09
release_date date, — \u53d1\u5e03\u65e5\u671f<\/p>\n\n\n\n

price_min numeric(10,2), — \u6700\u4f4e\u4ef7\u683c
price_max numeric(10,2), — \u6700\u2fbc\u4ef7\u683c
market_position text, — \u5e02\u573a\u5b9a\u4f4d\uff08\u7d27\u51d1\u578bSUV\/\u4e2d\u5927\u578b\u8f7f\u8f66 \u7b49\uff09<\/p>\n\n\n\n

power_type text NOT NULL, — \u52a8\u529b\u7c7b\u578b\uff08\u7eaf\u7535\/\u63d2\u6df7\/\u589e\u7a0b\/\u71c3\u6cb9\uff09
range_km integer, — \u7eed\u822a\u91cc\u7a0b\uff08km\uff09
battery_capacity_kwh numeric(6,2), — \u7535\u6c60\u5bb9\u91cf\uff08kWh\uff09<\/p>\n\n\n\n

autonomous_level text, — \u667a\u9a7e\u7b49\u7ea7\uff08L0~L4 \u6587\u672c\u5b58\u50a8\uff09
driver_assist_features jsonb, — \u9a7e\u9a76\u8f85\u52a9\u529f\u80fd JSON<\/p>\n\n\n\n

source text, — \u6570\u636e\u6765\u6e90
created_at timestamptz NOT NULL DEFAULT now(),
updated_at timestamptz NOT NULL DEFAULT now(),<\/p>\n\n\n\n

— \u7ea6\u675f
CONSTRAINT uq_brand_model_variant UNIQUE (brand, model, variant),
CONSTRAINT ck_price_nonneg CHECK (
(price_min IS NULL OR price_min >= 0) AND
(price_max IS NULL OR price_max >= 0)
),
CONSTRAINT ck_price_range CHECK (
price_min IS NULL OR price_max IS NULL OR price_max >= price_min
),
CONSTRAINT ck_range_nonneg CHECK (range_km IS NULL OR range_km >= 0),
CONSTRAINT ck_battery_nonneg CHECK (battery_capacity_kwh IS NULL OR battery_capacity_kwh >= 0)
);<\/p>\n\n\n\n

— \u5e38\u7528\u67e5\u8be2\u7d22\u5f15\uff08\u6309\u9700\u4fdd\u7559\uff09
CREATE INDEX IF NOT EXISTS idx_ev_models_brand ON public.ev_models (brand);
CREATE INDEX IF NOT EXISTS idx_ev_models_body_type ON public.ev_models (body_type);
CREATE INDEX IF NOT EXISTS idx_ev_models_power_type ON public.ev_models (power_type);<\/p>\n<\/details>\n\n\n\n

favourites <\/summary>\n

create table public.favorites (
user_id uuid not null,
brand text not null,
model text not null,
reason text null,
id uuid not null,
constraint favorites_pkey primary key (brand, model, id)
) TABLESPACE pg_default;<\/p>\n\n\n\n

<\/p>\n<\/details>\n\n\n\n

\u4e00\u4e2a\u5b58\u50a8\u65b0\u80fd\u6e90\u6c7d\u8f66\u7684\u54c1\u724c\u3001\u578b\u53f7\u3001\u4ef7\u683c\u3001\u8f66\u8f86\u7c7b\u578b\uff08\u4f8b\u5982\u8f7f\u8f66\u6216 SUV\uff09\u3001\u7eed\u822a\u91cc\u7a0b\u3001\u667a\u80fd\u9a7e\u9a76\u80fd\u529b\u3001\u53d1\u5e03\u65e5\u671f\u3001\u4eae\u70b9\uff08Highlights\uff09\u3001\u4ee5\u53ca\u5b89\u5168\u6027\u914d\u7f6e
\u53e6\u4e00\u4e2a\u8868\u7528\u4e8e\u5b58\u50a8\u5f53\u7528\u6237\u8f93\u5165\u559c\u6b22\u65f6\uff0c\u628a\u8fd9\u4e2a\u8f66\u578b\u52a0\u5165\u6b64\u8868<\/p>\n\n\n\n

\u589e\u52a0\u6570\u636e\u5e93\uff1a<\/p>\n\n\n\n

\u5728\u5de5\u5177\u4e2d\u641c\u7d22supabase,<\/p>\n\n\n\n

\u628a\u9875\u9762\u5c55\u793a\u8f66\u578b\u56fe\u7247\uff0c\u4ecb\u7ecd\u5b58\u5165supabase\u4e2d\uff0c\u4f9bagent\u53bb\u68c0\u7d22\u3002<\/p>\n\n\n\n

google \u5de5\u5177\uff0c<\/p>\n\n\n\n

\u5f53\u641c\u7d22\u4e0d\u5230\u6700\u8fd1\u8f66\u578b\u65f6\uff0c\u907f\u514dagent\u53bb\u80e1\u8bf4\u516b\u9053\uff0c\u505a\u7684\u515c\u5e95\u5904\u7406\u3002<\/p>\n\n\n\n

\u98de\u4e66\u5de5\u5177\uff0c<\/p>\n\n\n\n

\u7528\u6765\u8fdb\u884c\u8054\u7cfb\u9500\u552e\uff0c\u8bd5\u9a7e\uff0c\u9884\u7ea6\uff0c\u4f7fagent\u4e0d\u518d\u662f\u95ee\u7b54\u800c\u662f\u53bb\u771f\u5b9e\u7684\u8fde\u63a5\u5230\u771f\u5b9e\u7684\u4e1a\u52a1\u3002<\/p>\n\n\n\n

GitHub\uff1ahttps:\/\/github.com\/qiuxuezhe345\/car_choose<\/a><\/p>\n\n\n\n

\u90e8\u7f72\u4e0a\u7ebf\u7f51\u5740\uff1ahttps:\/\/carchoose.houzhibin.top\/<\/a><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Dify\u642d\u5efa\u6d41\u7a0b\uff1a \u9996\u5148,\u53bbsupabase\u5efa\u8868\uff0c\u6570\u636e\u5e93\u5206\u4e3a\u4e24\u4e2a\u8868 ev_model \u548c favourites […]<\/p>\n","protected":false},"author":1,"featured_media":234,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-228","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-5"],"_links":{"self":[{"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=\/wp\/v2\/posts\/228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=228"}],"version-history":[{"count":1,"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=\/wp\/v2\/posts\/228\/revisions"}],"predecessor-version":[{"id":232,"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=\/wp\/v2\/posts\/228\/revisions\/232"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=\/wp\/v2\/media\/234"}],"wp:attachment":[{"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.houzhibin.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}