llm-agents

Tables (11)

experiment_items

  • preset_id — BIGINT — Primary key — NOT NULL
  • experiment_id — BIGINT — Foreign key → experiments.experiment_id — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL — 이 항목의 이름 (예: GPT-4 창의적)
  • model_name — ENUM('gpt-4', 'gpt-3.5-turbo', 'claude-3', 'gemini-pro') — NOT NULL
  • prompt_content — TEXT — NOT NULL
  • response_content — TEXT — AI 응답 결과
  • parameters — JSON — NOT NULL
  • execution_time — INT
  • token_usage — JSON
  • cost — DECIMAL(10, 4)
  • user_rating — TINYINT
  • from_experiments — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • top_p — DECIMAL(4,2)
  • temperature — DECIMAL(4,2)

experiments

  • experiment_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • experiment_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — ENUM('success', 'failed', 'paused', 'test') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • consistency_rate — DECIMAL(3,2)

payments

  • payment_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • amount — DECIMAL(10,2) — NOT NULL
  • payment_method — ENUM('card', 'bank_transfer', 'toss', 'kakao_pay') — NOT NULL
  • status — ENUM('pending', 'completed', 'failed', 'refunded') — NOT NULL
  • transaction_id — VARCHAR(255)
  • billing_period — ENUM('monthly', 'yearly') — NOT NULL
  • service_start_date — DATE — NOT NULL
  • service_end_date — DATE — NOT NULL
  • paid_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

prompts

  • prompt_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — VARCHAR(50)
  • is_permanent — BOOLEAN — NOT NULL
  • rating — TINYINT
  • is_shared — BOOLEAN — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_ai_keys

  • ai_api_id — BIGINT — Primary key — NOT NULL
  • api_key_id — BIGINT — Foreign key → user_api_keys.api_key_id — NOT NULL
  • provider (platform) — ENUM('openai', 'anthropic', 'google_gemini') — NOT NULL
  • Field (ai_api_key) — TEXT
  • model_names — TEXT — 지원 모델 목록 (gpt-4, claude-3 등)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_api_keys

  • api_key_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • platform_type — ENUM('openai', 'anthropic', 'google_gemini', 'google_drive', 'slack', 'kakao', 'linkedin', 'naver_blog', 'github') — NOT NULL
  • key_name — VARCHAR(100) — NOT NULL

user_blog_keys

  • Key (blog_api_id) — BIGINT — Primary key — NOT NULL
  • api_key_id — BIGINT — Foreign key → user_api_keys.api_key_id — NOT NULL
  • platform — ENUM('naver_blog', 'tistory', 'brunch', 'medium') — NOT NULL
  • access_token — TEXT — NOT NULL
  • Field (blog_api_key) — TEXT
  • Field (extra_token) — TEXT
  • Field (contents) — TEXT
  • expires_at — TIMESTAMP
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_dev_keys

  • Key (user_dev_id) — BIGINT — Primary key — NOT NULL
  • api_key_id — BIGINT — Foreign key → user_api_keys.api_key_id — NOT NULL
  • platform — ENUM('github', 'gitlab', 'bitbucket') — NOT NULL
  • personal_token — TEXT — NOT NULL
  • repo_scope (dev_api_key) — TEXT
  • Field2 (contents) — TEXT
  • Field2 (picture) — JSON
  • Field — TEXT
  • expires_at — TIMESTAMP
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_messenger_keys

  • Key (messenger_api_id) — BIGINT — Primary key — NOT NULL
  • api_key_id — BIGINT — Foreign key → user_api_keys.api_key_id — NOT NULL
  • platform — ENUM('slack', 'kakao', 'discord') — NOT NULL
  • access_token — TEXT — NOT NULL
  • Field (messenger_api_key) — TEXT
  • Field (message) — TEXT
  • Field (picture) — JSON
  • Field (chatroom_key) — TEXT
  • refresh_token — TEXT
  • expires_at — TIMESTAMP
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_subscriptions

  • subscription_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — ENUM('active', 'expired', 'cancelled') — NOT NULL
  • expires_at — TIMESTAMP
  • auto_renewal — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • status — ENUM('active', 'inactive', 'deleted') — NOT NULL
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL