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