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