seta_1
Tables (16)
app_user
- user_id — UUID
- username — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(64)
- created_at — TIMESTAMPTZ — NOT NULL
chat_message
- message_id — UUID
- chat_room_id — UUID — NOT NULL
- author_id — UUID
- role — VARCHAR(16) — NOT NULL
- content — TEXT — NOT NULL
- filtered_content — TEXT
- external_id — VARCHAR(64)
- created_at — TIMESTAMPTZ — NOT NULL
chat_room
- chat_room_id — UUID
- owner_id — UUID — NOT NULL
- title — VARCHAR(255)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
error_log
- trace_id — VARCHAR(64)
- error_type — VARCHAR(32) — NOT NULL
- error_message — TEXT — NOT NULL
- stack_trace — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
filter_result
- filter_id — BIGSERIAL
- chat_room_id — UUID — NOT NULL
- message_id — UUID
- stage — VARCHAR(16) — NOT NULL
- action — VARCHAR(8) — NOT NULL
- rule_name — VARCHAR(64)
- score — NUMERIC(5,3)
- created_at — TIMESTAMPTZ — NOT NULL
global_saved_token_daily
- stat_date — DATE
- request_count — BIGINT — NOT NULL
- saved_tokens — BIGINT — NOT NULL
- token_sum — BIGINT — NOT NULL
- cost_sum_usd — NUMERIC(14,6) — NOT NULL
global_saved_token_minute
- window_start — TIMESTAMPTZ
- request_count — BIGINT — NOT NULL
- saved_tokens — BIGINT — NOT NULL
- token_sum — BIGINT — NOT NULL
- cost_sum_usd — NUMERIC(14,6) — NOT NULL
llm_response
- trace_id — VARCHAR(64)
- model_name — VARCHAR(64) — NOT NULL
- temperature — FLOAT
- top_p — FLOAT
- response_text — TEXT
- response_tokens — INT
- latency_ms — INT
- total_cost_usd — NUMERIC(14,6)
- created_at — TIMESTAMPTZ — NOT NULL
message_attachment
- attachment_id — UUID
- message_id — UUID — NOT NULL
- type — VARCHAR(32) — NOT NULL
- url — TEXT — NOT NULL
- meta — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
prompt_built
- trace_id — VARCHAR(64)
- built_prompt — TEXT — NOT NULL
- context_messages — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
room_stat_daily
- chat_room_id — UUID — Primary key — NOT NULL
- stat_date — DATE — Primary key — NOT NULL
- request_count — INT — NOT NULL
- pass_count — INT — NOT NULL
- drop_count — INT — NOT NULL
- total_tokens — INT — NOT NULL
- total_cost_usd — NUMERIC(14,6) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
token_usage
- id — UUID
- message_id — UUID — NOT NULL
- prompt_tokens — INT — NOT NULL
- completion_tokens — INT — NOT NULL
- total_tokens — INT — NOT NULL
- cost_usd — NUMERIC(14,6) — NOT NULL
- energy_wh — NUMERIC(14,6)
- co2_g — NUMERIC(14,6)
- saved_tokens — INT — NOT NULL
- saved_cost_usd — NUMERIC(14,6) — NOT NULL
- saved_energy_wh — NUMERIC(14,6)
- saved_co2_g — NUMERIC(14,6)
user_memory_embedding
- embedding_id — UUID
- user_id — UUID — NOT NULL
- chat_room_id — UUID
- source_type — VARCHAR(16) — NOT NULL
- source_id — UUID
- content — TEXT — NOT NULL
- embedding — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
user_saved_token_daily
- user_id — TEXT — Primary key — NOT NULL
- stat_date — DATE — Primary key — NOT NULL
- request_count — BIGINT — NOT NULL
- saved_tokens — BIGINT — NOT NULL
- token_sum — BIGINT — NOT NULL
- cost_sum_usd — NUMERIC(14,6) — NOT NULL
user_saved_token_minute
- user_id — TEXT — Primary key — NOT NULL
- window_start — TIMESTAMPTZ — Primary key — NOT NULL
- request_count — BIGINT — NOT NULL
- saved_tokens — BIGINT — NOT NULL
- token_sum — BIGINT — NOT NULL
- cost_sum_usd — NUMERIC(14,6) — NOT NULL
user_setting
- user_setting_id — UUID
- user_id — UUID — NOT NULL
- call_me — VARCHAR(64)
- role_description — TEXT
- preferred_tone — TEXT
- traits — TEXT
- additional_context — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL