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