AISTOCK
Tables (12)
accounts
- account_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- account_number — VARCHAR(20) — NOT NULL
- opened_at — DATE — NOT NULL
- base_balance — BIGINT — NOT NULL
- balance — BIGINT — NOT NULL
- frozen_balance — BIGINT — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
ai_planning_messages
- message_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → ai_planning_sessions.session_id — NOT NULL
- role — ENUM('USER','AI') — NOT NULL
- content — TEXT — NOT NULL
- prompt_tokens — INT
- created_at — DATETIME — NOT NULL
- INDEX — idx_session_msg
ai_planning_sessions
- session_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(100)
- status — ENUM('ACTIVE','CLOSED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_user_session
holdings
- holding_id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Foreign key → accounts.account_id — NOT NULL
- stock_code — VARCHAR(10) — NOT NULL
- stock_name — VARCHAR(50) — NOT NULL
- quantity — INT — NOT NULL
- avg_price — BIGINT — NOT NULL
- updated_at — DATETIME — NOT NULL
investment_profile
- profile_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- investment_tendency — TINYINT — NOT NULL — 1:안정형 2:안정추구형 3:위험중립형 4:적극투자형 5:공격투자형
- fund_tendency — TINYINT — NOT NULL — 1:안정저축형 2:수익추구형 3:목표달성형 4:자유소비형
- investment_level — ENUM('초보자', '중급자', '전문가') — NOT NULL
- survey_answers — JSON
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notifications
- noti_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- type — ENUM('SYSTEM','ORDER','AI','SIMULATION') — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_user_noti
orders
- order_id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Foreign key → accounts.account_id — NOT NULL
- stock_code — VARCHAR(10) — NOT NULL
- stock_name — VARCHAR(50) — NOT NULL
- order_type — ENUM('BUY','SELL') — NOT NULL
- price_type — ENUM('LIMIT','MARKET') — NOT NULL
- order_price — BIGINT — NOT NULL
- exec_price — BIGINT
- quantity — INT — NOT NULL
- status — ENUM('PENDING','EXECUTED','CANCELLED') — NOT NULL
- ordered_at — DATETIME — NOT NULL
- executed_at — DATETIME
- INDEX — idx_account_order
- INDEX — idx_stock_pending
recent_viewed
- view_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- stock_code — VARCHAR(10) — NOT NULL
- stock_name — VARCHAR(50) — NOT NULL
- viewed_at — DATETIME — NOT NULL
simulations
- simulation_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- stock_code — VARCHAR(10) — NOT NULL
- stock_name — VARCHAR(50) — NOT NULL
- target_amount — BIGINT — NOT NULL
- target_months — INT — NOT NULL
- scenario_data — JSON — NOT NULL
- best_reach_date — DATE
- base_reach_date — DATE
- worst_reach_date — DATE
- dart_data — JSON
- news_data — JSON
- created_at — DATETIME — NOT NULL
- INDEX — idx_user_sim
social_accounts
- social_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — ENUM('KAKAO','NAVER','GOOGLE') — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_user_social
users
- user_id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50)
- password — VARCHAR(255)
- name — VARCHAR(50) — NOT NULL
- birthdate — DATE
- email — VARCHAR(100)
- role — ENUM('USER','ADMIN') — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — idx_email
- INDEX — idx_active
watchlist
- watchlist_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- stock_code — VARCHAR(10) — NOT NULL
- stock_name — VARCHAR(50) — NOT NULL
- added_at — DATETIME — NOT NULL