--
-- PostgreSQL database dump
--

-- Dumped from database version 16.13
-- Dumped by pg_dump version 18.3

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: api_key_daily_stats; Type: TABLE; Schema: public
--

CREATE TABLE public.api_key_daily_stats (
 id integer NOT NULL,
 api_key_id integer NOT NULL,
 date character varying(10) NOT NULL,
 hour integer,
 requests integer,
 tokens integer,
 errors integer,
 rate_limited integer
);

--
-- Name: api_key_daily_stats_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.api_key_daily_stats_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.api_key_daily_stats_id_seq OWNED BY public.api_key_daily_stats.id;

--
-- Name: api_key_model_daily_stats; Type: TABLE; Schema: public
--

CREATE TABLE public.api_key_model_daily_stats (
 id integer NOT NULL,
 api_key_id integer NOT NULL,
 model_name character varying(100) NOT NULL,
 date character varying(10) NOT NULL,
 requests integer,
 tokens integer,
 errors integer,
 rate_limited integer
);

--
-- Name: api_key_model_daily_stats_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.api_key_model_daily_stats_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.api_key_model_daily_stats_id_seq OWNED BY public.api_key_model_daily_stats.id;

--
-- Name: api_key_models; Type: TABLE; Schema: public
--

CREATE TABLE public.api_key_models (
 id integer NOT NULL,
 api_key_id integer NOT NULL,
 provider_model_id integer NOT NULL
);

--
-- Name: api_key_models_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.api_key_models_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.api_key_models_id_seq OWNED BY public.api_key_models.id;

--
-- Name: api_keys; Type: TABLE; Schema: public
--

CREATE TABLE public.api_keys (
 id integer NOT NULL,
 name character varying(100) NOT NULL,
 key character varying(64) NOT NULL,
 is_active boolean,
 last_used_at timestamp without time zone,
 created_at timestamp without time zone DEFAULT now(),
 updated_at timestamp without time zone DEFAULT now()
);

--
-- Name: analysis_records; Type: TABLE; Schema: public
--

CREATE TABLE public.analysis_records (
 id integer NOT NULL,
 analysis_type character varying(50) NOT NULL,
 scope_key character varying(255) NOT NULL,
 status character varying(20) NOT NULL,
 language character varying(10),
 model_used character varying(150),
 template_id character varying(100),
 template_version character varying(50),
 params_json jsonb,
 content text,
 error text,
 expires_at timestamp without time zone,
 progress character varying(200),
 created_at timestamp without time zone DEFAULT now(),
 updated_at timestamp without time zone DEFAULT now()
);

--
-- Name: analysis_subtasks; Type: TABLE; Schema: public
--

CREATE TABLE public.analysis_subtasks (
 id integer NOT NULL,
 analysis_record_id integer NOT NULL,
 step_key character varying(100) NOT NULL,
 step_label character varying(150) NOT NULL,
 status character varying(20) NOT NULL,
 sort_order integer,
 attempt_count integer,
 max_attempts integer,
 output jsonb,
 error text,
 started_at timestamp without time zone,
 finished_at timestamp without time zone,
 created_at timestamp without time zone DEFAULT now(),
 updated_at timestamp without time zone DEFAULT now()
);

--
-- Name: analysis_subtasks_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.analysis_subtasks_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.analysis_subtasks_id_seq OWNED BY public.analysis_subtasks.id;

--
-- Name: analysis_artifacts; Type: TABLE; Schema: public
--

CREATE TABLE public.analysis_artifacts (
 id integer NOT NULL,
 analysis_record_id integer NOT NULL,
 subtask_id integer,
 artifact_key character varying(100) NOT NULL,
 artifact_type character varying(50) NOT NULL,
 title character varying(150),
 path text,
 status character varying(20) NOT NULL,
 meta jsonb,
 created_at timestamp without time zone DEFAULT now(),
 updated_at timestamp without time zone DEFAULT now()
);

--
-- Name: analysis_artifacts_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.analysis_artifacts_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.analysis_artifacts_id_seq OWNED BY public.analysis_artifacts.id;

--
-- Name: analysis_records_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.analysis_records_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.analysis_records_id_seq OWNED BY public.analysis_records.id;

--
-- Name: api_keys_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.api_keys_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.api_keys_id_seq OWNED BY public.api_keys.id;

--
-- Name: hourly_stats; Type: TABLE; Schema: public
--

CREATE TABLE public.hourly_stats (
 id integer NOT NULL,
 provider_id integer,
 hour_key character varying(20) NOT NULL,
 requests integer,
 tokens integer,
 errors integer
);

--
-- Name: hourly_stats_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.hourly_stats_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.hourly_stats_id_seq OWNED BY public.hourly_stats.id;

--
-- Name: model_daily_stats; Type: TABLE; Schema: public
--

CREATE TABLE public.model_daily_stats (
 id integer NOT NULL,
 model_name character varying(100) NOT NULL,
 provider_name character varying(50),
 date character varying(10) NOT NULL,
 requests integer,
 tokens integer,
 errors integer,
 rate_limited integer
);

--
-- Name: model_daily_stats_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.model_daily_stats_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.model_daily_stats_id_seq OWNED BY public.model_daily_stats.id;

--
-- Name: models; Type: TABLE; Schema: public
--

CREATE TABLE public.models (
 id integer NOT NULL,
 name character varying(100) NOT NULL,
 display_name character varying(100),
 max_tokens integer,
 context_length integer DEFAULT 131072,
 thinking_enabled boolean DEFAULT true,
 thinking_budget integer DEFAULT 8192,
 is_multimodal boolean,
 is_active boolean,
 created_at timestamp without time zone DEFAULT now(),
 updated_at timestamp without time zone DEFAULT now()
);

--
-- Name: models_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.models_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.models_id_seq OWNED BY public.models.id;

--
-- Name: provider_daily_stats; Type: TABLE; Schema: public
--

CREATE TABLE public.provider_daily_stats (
 id integer NOT NULL,
 provider_name character varying(50) NOT NULL,
 date character varying(10) NOT NULL,
 hour integer,
 requests integer,
 tokens integer,
 errors integer,
 rate_limited integer
);

--
-- Name: provider_daily_stats_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.provider_daily_stats_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.provider_daily_stats_id_seq OWNED BY public.provider_daily_stats.id;

--
-- Name: provider_models; Type: TABLE; Schema: public
--

CREATE TABLE public.provider_models (
 id integer NOT NULL,
 provider_id integer NOT NULL,
 model_id integer NOT NULL,
 model_name_override character varying(100),
 max_concurrent integer DEFAULT 2,
 is_active boolean,
 created_at timestamp without time zone DEFAULT now()
);

--
-- Name: provider_models_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.provider_models_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.provider_models_id_seq OWNED BY public.provider_models.id;

--
-- Name: providers; Type: TABLE; Schema: public
--

CREATE TABLE public.providers (
 id integer NOT NULL,
 name character varying(50) NOT NULL,
 base_url character varying(255) NOT NULL,
 api_key character varying(255),
 is_active boolean,
 created_at timestamp without time zone DEFAULT now(),
 updated_at timestamp without time zone DEFAULT now(),
 max_concurrent integer DEFAULT 3,
 merge_consecutive_messages boolean DEFAULT false
);

--
-- Name: providers_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.providers_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.providers_id_seq OWNED BY public.providers.id;

--
-- Name: request_logs; Type: TABLE; Schema: public
--

CREATE TABLE public.request_logs (
 id integer NOT NULL,
 api_key_id integer,
 provider_id integer,
 model character varying(100) NOT NULL,
 response text,
 tokens jsonb,
 latency_ms double precision,
 request_context_tokens integer,
 status character varying(20) NOT NULL,
 upstream_status_code integer,
 client_ip character varying(64),
 user_agent character varying(1024),
 error text,
 created_at timestamp without time zone DEFAULT now(),
 updated_at timestamp without time zone DEFAULT now()
);

--
-- Name: request_logs_history; Type: TABLE; Schema: public
--

CREATE TABLE public.request_logs_history (
 id integer NOT NULL,
 api_key_id integer,
 provider_id integer,
 model character varying(100) NOT NULL,
 response text,
 tokens jsonb,
 latency_ms double precision,
 request_context_tokens integer,
 status character varying(20) NOT NULL,
 upstream_status_code integer,
 client_ip character varying(64),
 user_agent character varying(1024),
 error text,
 created_at timestamp without time zone NOT NULL,
 updated_at timestamp without time zone,
 archive_month character varying(7) NOT NULL,
 archived_at timestamp without time zone DEFAULT now() NOT NULL
);

--
-- Name: request_logs_all; Type: VIEW; Schema: public
--

CREATE VIEW public.request_logs_all AS
 SELECT id, api_key_id, provider_id, model, response, tokens, latency_ms, request_context_tokens, status, upstream_status_code, client_ip, user_agent, error, created_at, updated_at
 FROM public.request_logs
UNION ALL
 SELECT id, api_key_id, provider_id, model, response, tokens, latency_ms, request_context_tokens, status, upstream_status_code, client_ip, user_agent, error, created_at, updated_at
 FROM public.request_logs_history;

--
-- Name: request_logs_id_seq; Type: SEQUENCE; Schema: public
--

CREATE SEQUENCE public.request_logs_id_seq
 AS integer
 START WITH 1
 INCREMENT BY 1
 NO MINVALUE
 NO MAXVALUE
 CACHE 1;

ALTER SEQUENCE public.request_logs_id_seq OWNED BY public.request_logs.id;

--
-- DEFAULT VALUES
--

ALTER TABLE ONLY public.api_key_daily_stats ALTER COLUMN id SET DEFAULT nextval('public.api_key_daily_stats_id_seq'::regclass);
ALTER TABLE ONLY public.analysis_records ALTER COLUMN id SET DEFAULT nextval('public.analysis_records_id_seq'::regclass);
ALTER TABLE ONLY public.api_key_model_daily_stats ALTER COLUMN id SET DEFAULT nextval('public.api_key_model_daily_stats_id_seq'::regclass);
ALTER TABLE ONLY public.api_key_models ALTER COLUMN id SET DEFAULT nextval('public.api_key_models_id_seq'::regclass);
ALTER TABLE ONLY public.api_keys ALTER COLUMN id SET DEFAULT nextval('public.api_keys_id_seq'::regclass);
ALTER TABLE ONLY public.hourly_stats ALTER COLUMN id SET DEFAULT nextval('public.hourly_stats_id_seq'::regclass);
ALTER TABLE ONLY public.model_daily_stats ALTER COLUMN id SET DEFAULT nextval('public.model_daily_stats_id_seq'::regclass);
ALTER TABLE ONLY public.models ALTER COLUMN id SET DEFAULT nextval('public.models_id_seq'::regclass);
ALTER TABLE ONLY public.provider_daily_stats ALTER COLUMN id SET DEFAULT nextval('public.provider_daily_stats_id_seq'::regclass);
ALTER TABLE ONLY public.provider_models ALTER COLUMN id SET DEFAULT nextval('public.provider_models_id_seq'::regclass);
ALTER TABLE ONLY public.providers ALTER COLUMN id SET DEFAULT nextval('public.providers_id_seq'::regclass);
ALTER TABLE ONLY public.request_logs ALTER COLUMN id SET DEFAULT nextval('public.request_logs_id_seq'::regclass);

--
-- PRIMARY KEYS
--

ALTER TABLE ONLY public.api_key_daily_stats ADD CONSTRAINT api_key_daily_stats_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.analysis_records ADD CONSTRAINT analysis_records_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.api_key_model_daily_stats ADD CONSTRAINT api_key_model_daily_stats_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.api_key_models ADD CONSTRAINT api_key_models_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.api_keys ADD CONSTRAINT api_keys_key_key UNIQUE (key);
ALTER TABLE ONLY public.api_keys ADD CONSTRAINT api_keys_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.hourly_stats ADD CONSTRAINT hourly_stats_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.model_daily_stats ADD CONSTRAINT model_daily_stats_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.models ADD CONSTRAINT models_name_key UNIQUE (name);
ALTER TABLE ONLY public.models ADD CONSTRAINT models_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.provider_daily_stats ADD CONSTRAINT provider_daily_stats_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.provider_models ADD CONSTRAINT provider_models_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.providers ADD CONSTRAINT providers_name_key UNIQUE (name);
ALTER TABLE ONLY public.providers ADD CONSTRAINT providers_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.request_logs ADD CONSTRAINT request_logs_pkey PRIMARY KEY (id);
ALTER TABLE ONLY public.request_logs_history ADD CONSTRAINT request_logs_history_pkey PRIMARY KEY (id);

--
-- INDEXES
--

CREATE UNIQUE INDEX idx_api_key_model ON public.api_key_models USING btree (api_key_id, provider_model_id);
CREATE INDEX idx_analysis_records_expires_at ON public.analysis_records USING btree (expires_at);
CREATE INDEX idx_analysis_records_status ON public.analysis_records USING btree (status);
CREATE UNIQUE INDEX idx_analysis_records_type_scope ON public.analysis_records USING btree (analysis_type, scope_key);
CREATE INDEX idx_apikey_stats_date ON public.api_key_daily_stats USING btree (date);
CREATE INDEX idx_apikey_model_stats_date ON public.api_key_model_daily_stats USING btree (date);
CREATE UNIQUE INDEX idx_apikey_model_stats_unique ON public.api_key_model_daily_stats USING btree (api_key_id, model_name, date);
CREATE INDEX idx_model_stats_date ON public.model_daily_stats USING btree (date);
CREATE UNIQUE INDEX idx_model_stats_unique ON public.model_daily_stats USING btree (model_name, provider_name, date);
CREATE UNIQUE INDEX idx_provider_model ON public.provider_models USING btree (provider_id, model_id);
CREATE INDEX idx_provider_stats_date ON public.provider_daily_stats USING btree (date);
CREATE INDEX idx_request_logs_api_key_id ON public.request_logs USING btree (api_key_id);
CREATE INDEX idx_request_logs_created_at ON public.request_logs USING btree (created_at);
CREATE INDEX idx_request_logs_provider_id ON public.request_logs USING btree (provider_id);
CREATE INDEX idx_request_logs_status ON public.request_logs USING btree (status);
CREATE INDEX idx_request_logs_history_api_key_id ON public.request_logs_history USING btree (api_key_id);
CREATE INDEX idx_request_logs_history_archive_month ON public.request_logs_history USING btree (archive_month);
CREATE INDEX idx_request_logs_history_created_at ON public.request_logs_history USING btree (created_at);
CREATE INDEX idx_request_logs_history_provider_id ON public.request_logs_history USING btree (provider_id);
CREATE INDEX idx_request_logs_history_status ON public.request_logs_history USING btree (status);
CREATE INDEX ix_request_logs_created_at ON public.request_logs USING btree (created_at);

--
-- FOREIGN KEYS
--

ALTER TABLE ONLY public.api_key_daily_stats ADD CONSTRAINT api_key_daily_stats_api_key_id_fkey FOREIGN KEY (api_key_id) REFERENCES public.api_keys(id);
ALTER TABLE ONLY public.api_key_model_daily_stats ADD CONSTRAINT api_key_model_daily_stats_api_key_id_fkey FOREIGN KEY (api_key_id) REFERENCES public.api_keys(id);
ALTER TABLE ONLY public.api_key_models ADD CONSTRAINT api_key_models_api_key_id_fkey FOREIGN KEY (api_key_id) REFERENCES public.api_keys(id);
ALTER TABLE ONLY public.api_key_models ADD CONSTRAINT api_key_models_provider_model_id_fkey FOREIGN KEY (provider_model_id) REFERENCES public.provider_models(id);
ALTER TABLE ONLY public.provider_models ADD CONSTRAINT provider_models_model_id_fkey FOREIGN KEY (model_id) REFERENCES public.models(id);
ALTER TABLE ONLY public.provider_models ADD CONSTRAINT provider_models_provider_id_fkey FOREIGN KEY (provider_id) REFERENCES public.providers(id);
ALTER TABLE ONLY public.request_logs ADD CONSTRAINT request_logs_api_key_id_fkey FOREIGN KEY (api_key_id) REFERENCES public.api_keys(id);

--
-- COMMENTS
--

-- 提供商表
COMMENT ON TABLE public.providers IS 'API提供商';
COMMENT ON COLUMN public.providers.id IS '主键ID';
COMMENT ON COLUMN public.providers.name IS '提供商名称,如zhipu、deepseek';
COMMENT ON COLUMN public.providers.base_url IS 'API基础URL';
COMMENT ON COLUMN public.providers.api_key IS '提供商API密钥';
COMMENT ON COLUMN public.providers.is_active IS '是否启用';
COMMENT ON COLUMN public.providers.created_at IS '创建时间';
COMMENT ON COLUMN public.providers.updated_at IS '更新时间';
COMMENT ON COLUMN public.providers.max_concurrent IS '最大并发数,默认3';
COMMENT ON COLUMN public.providers.merge_consecutive_messages IS '是否合并连续相同角色的消息';

-- 模型表
COMMENT ON TABLE public.models IS '模型信息';
COMMENT ON COLUMN public.models.id IS '主键ID';
COMMENT ON COLUMN public.models.name IS '模型标识,如glm-4';
COMMENT ON COLUMN public.models.display_name IS '显示名称';
COMMENT ON COLUMN public.models.max_tokens IS '最大输出token数';
COMMENT ON COLUMN public.models.context_length IS '上下文窗口长度';
COMMENT ON COLUMN public.models.thinking_enabled IS '是否支持思考模式';
COMMENT ON COLUMN public.models.thinking_budget IS '思考模式预算token数';
COMMENT ON COLUMN public.models.is_multimodal IS '是否支持多模态(图片)';
COMMENT ON COLUMN public.models.is_active IS '是否启用';
COMMENT ON COLUMN public.models.created_at IS '创建时间';
COMMENT ON COLUMN public.models.updated_at IS '更新时间';

-- 提供商-模型关联表
COMMENT ON TABLE public.provider_models IS '提供商与模型的关联关系';
COMMENT ON COLUMN public.provider_models.id IS '主键ID';
COMMENT ON COLUMN public.provider_models.provider_id IS '提供商ID';
COMMENT ON COLUMN public.provider_models.model_id IS '模型ID';
COMMENT ON COLUMN public.provider_models.model_name_override IS '模型名称覆盖,用于指定提供商特定的模型名';
COMMENT ON COLUMN public.provider_models.max_concurrent IS '模型级最大并发数,NULL时使用供应商默认值';
COMMENT ON COLUMN public.provider_models.is_active IS '是否启用';
COMMENT ON COLUMN public.provider_models.created_at IS '创建时间';

-- API密钥表
COMMENT ON TABLE public.api_keys IS 'API密钥';
COMMENT ON COLUMN public.api_keys.id IS '主键ID';
COMMENT ON COLUMN public.api_keys.name IS '密钥名称';
COMMENT ON COLUMN public.api_keys.key IS '密钥值,sk-开头';
COMMENT ON COLUMN public.api_keys.is_active IS '是否启用';
COMMENT ON COLUMN public.api_keys.created_at IS '创建时间';
COMMENT ON COLUMN public.api_keys.updated_at IS '更新时间';

-- API密钥-模型关联表
COMMENT ON TABLE public.api_key_models IS 'API密钥可访问的模型';
COMMENT ON COLUMN public.api_key_models.id IS '主键ID';
COMMENT ON COLUMN public.api_key_models.api_key_id IS 'API密钥ID';
COMMENT ON COLUMN public.api_key_models.provider_model_id IS '提供商-模型关联ID';

-- 请求日志表
COMMENT ON TABLE public.request_logs IS '请求日志';
COMMENT ON COLUMN public.request_logs.id IS '主键ID';
COMMENT ON COLUMN public.request_logs.api_key_id IS 'API密钥ID';
COMMENT ON COLUMN public.request_logs.provider_id IS '提供商ID';
COMMENT ON COLUMN public.request_logs.model IS '模型名称';
COMMENT ON COLUMN public.request_logs.response IS '响应内容(非流式)';
COMMENT ON COLUMN public.request_logs.tokens IS 'token统计,JSON格式:{input, output}';
COMMENT ON COLUMN public.request_logs.latency_ms IS '响应延迟(毫秒)';
COMMENT ON COLUMN public.request_logs.request_context_tokens IS '请求发起前估算的输入上下文token数';
COMMENT ON COLUMN public.request_logs.status IS '状态:pending/success/error/timeout';
COMMENT ON COLUMN public.request_logs.upstream_status_code IS '外部供应商返回的HTTP状态码';
COMMENT ON COLUMN public.request_logs.client_ip IS '用户请求来源IP';
COMMENT ON COLUMN public.request_logs.user_agent IS '用户请求来源User-Agent';
COMMENT ON COLUMN public.request_logs.error IS '错误信息';
COMMENT ON COLUMN public.request_logs.created_at IS '创建时间';
COMMENT ON COLUMN public.request_logs.updated_at IS '更新时间';
COMMENT ON TABLE public.request_logs_history IS '请求日志历史归档表';
COMMENT ON COLUMN public.request_logs_history.archive_month IS '按月份归档分区键,格式YYYY-MM';
COMMENT ON COLUMN public.request_logs_history.archived_at IS '归档时间';
COMMENT ON COLUMN public.api_keys.last_used_at IS '最近一次使用时间';

-- 提供商每日统计表
COMMENT ON TABLE public.provider_daily_stats IS '提供商每日/每小时统计';
COMMENT ON COLUMN public.provider_daily_stats.id IS '主键ID';
COMMENT ON COLUMN public.provider_daily_stats.provider_name IS '提供商名称';
COMMENT ON COLUMN public.provider_daily_stats.date IS '日期,格式YYYY-MM-DD';
COMMENT ON COLUMN public.provider_daily_stats.hour IS '小时(0-23),为空表示全天汇总';
COMMENT ON COLUMN public.provider_daily_stats.requests IS '请求数';
COMMENT ON COLUMN public.provider_daily_stats.tokens IS 'token数';
COMMENT ON COLUMN public.provider_daily_stats.errors IS '错误数';

-- 模型每日统计表
COMMENT ON TABLE public.model_daily_stats IS '模型每日统计';
COMMENT ON COLUMN public.model_daily_stats.id IS '主键ID';
COMMENT ON COLUMN public.model_daily_stats.model_name IS '模型名称';
COMMENT ON COLUMN public.model_daily_stats.provider_name IS '提供商名称';
COMMENT ON COLUMN public.model_daily_stats.date IS '日期,格式YYYY-MM-DD';
COMMENT ON COLUMN public.model_daily_stats.requests IS '请求数';
COMMENT ON COLUMN public.model_daily_stats.tokens IS 'token数';
COMMENT ON COLUMN public.model_daily_stats.errors IS '错误数';

-- API密钥每日统计表
COMMENT ON TABLE public.api_key_daily_stats IS 'API密钥每日/每小时统计';
COMMENT ON COLUMN public.api_key_daily_stats.id IS '主键ID';
COMMENT ON COLUMN public.api_key_daily_stats.api_key_id IS 'API密钥ID';
COMMENT ON COLUMN public.api_key_daily_stats.date IS '日期,格式YYYY-MM-DD';
COMMENT ON COLUMN public.api_key_daily_stats.hour IS '小时(0-23),为空表示全天汇总';
COMMENT ON COLUMN public.api_key_daily_stats.requests IS '请求数';
COMMENT ON COLUMN public.api_key_daily_stats.tokens IS 'token数';
COMMENT ON COLUMN public.api_key_daily_stats.errors IS '错误数';

-- 小时统计表(旧版)
COMMENT ON TABLE public.hourly_stats IS '小时统计(旧版,逐步废弃)';
COMMENT ON COLUMN public.hourly_stats.id IS '主键ID';
COMMENT ON COLUMN public.hourly_stats.provider_id IS '提供商ID';
COMMENT ON COLUMN public.hourly_stats.hour_key IS '小时标识,格式YYYY-MM-DD-HH';
COMMENT ON COLUMN public.hourly_stats.requests IS '请求数';
COMMENT ON COLUMN public.hourly_stats.tokens IS 'token数';
COMMENT ON COLUMN public.hourly_stats.errors IS '错误数';

--
-- PostgreSQL database dump complete
--