ecu

Tables (5)

Chat

  • chat_id — number — Primary key — NOT NULL
  • user_email — varChar2(100) — Foreign key → User.email — NOT NULL
  • model — varChar(200) — Foreign key → Models.model_name — NOT NULL
  • name — varChar2(500)
  • stream_enabled — char(1) — NOT NULL
  • memory_enabled — char(1) — NOT NULL
  • ceche_enabled — char(1) — NOT NULL

Chat_log

  • id (log_id) — number — Primary key — NOT NULL
  • chat_id — number — Foreign key → Chat.chat_id — NOT NULL
  • history_id — number — Foreign key → History.history_id
  • 입력 (request) — varChar2(4000)
  • 답변 (response) — varChar2(4000)
  • prompt_tokens — number — NOT NULL
  • completion_tokens — number — NOT NULL
  • create_at — timestamp — NOT NULL

History

  • history_id — number — Primary key — NOT NULL
  • chat_id — number — Foreign key → Chat.chat_id — NOT NULL
  • deps — number — NOT NULL
  • summary — varChar2(4000)
  • prompt_tokens — number — NOT NULL
  • completion_tokens — number — NOT NULL

Models

  • model_name (name) — varChar(200) — Primary key — NOT NULL
  • company — varChar2(1000)
  • price_per_ptoken — number — NOT NULL
  • price_per_ctoken — number — NOT NULL

User (Users)

  • email — varChar2(100) — Primary key — NOT NULL
  • password — varChar2(100) — NOT NULL
  • nicname — varChar2(100) — NOT NULL
  • isActive (is_active) — char(1) — NOT NULL