hi
Tables (22)
account
- account_id — INT
- user_id — INT
- seed_money — INT
- balance — INT
- profit_rate — FLOAT
- profit — INT
- created_at — DATETIME
account_transaction
- transaction_id — INT
- account_id — INT
- type — VARCHAR(20)
- amount — INT
- before_balance — INT
- after_balance — INT
- related_trade_id — INT
- created_at — DATETIME
ai_bot_trade
- bot_trade_id — INT
- user_id — INT
- strategy — VARCHAR(100)
- result — VARCHAR(255)
- log — TEXT
- trade_time — DATETIME
ai_strategy
- strategy_id — INT
- user_id — INT
- prompt — TEXT
- created_at — DATETIME
chart_pattern
- pattern_id — INT
- user_id — INT
- symbol — VARCHAR(20)
- pattern_type — VARCHAR(50)
- detected_at — DATETIME
frame
- frame_id — INT
- frame_img — VARCHAR(255)
- price — INT
investment_personality
- id — INT
- user_id — INT
- test_result — VARCHAR(255)
- tested_at — DATETIME
investment_ranking
- ranking_id — INT
- user_id — INT
- account_id — INT
- rank_type — VARCHAR(20)
- value — FLOAT
- calculated_at — DATETIME
investment_term
- term_id — INT
- term — VARCHAR(255)
- description — TEXT
- created_at — DATETIME
mock_trade
- trade_id — INT
- user_id — INT
- symbol — VARCHAR(20)
- buy_sell — VARCHAR(10)
- quantity — FLOAT
- price — DOUBLE
- trade_time — DATETIME
news_analysis
- news_id — INT
- user_id — INT
- title — VARCHAR(255)
- content — TEXT
- sentiment — VARCHAR(20)
- created_at — DATETIME
push_notification
- push_id — INT
- user_id — INT
- message — VARCHAR(255)
- sent_at — DATETIME
- type — VARCHAR(50)
quiz
- quiz_id — INT
- question — TEXT
- answer — BOOLEAN
- date — DATETIME
- category — VARCHAR(50)
- level — INT
- explanation — TEXT
- creator_id — INT
shop_item
- item_id — INT
- name — VARCHAR(100)
- type — VARCHAR(50)
- price — INT
stock
- stock_id — INT
- stock_code — VARCHAR(20)
- stock_name — VARCHAR(100)
- date — DATETIME
- start_price — INT
- high_price — INT
- low_price — INT
- current_price — INT
- fluctuation_rate — FLOAT
- volume — INT
- trading_value — INT
- mar_cap — INT
stock_holding
- holding_id — INT
- stock_id — INT
- account_id — INT
- profit — INT
- profit_rate — FLOAT
- quantity — FLOAT
- avg_buying — INT
user
- user_id — INT
- email — VARCHAR(255)
- firebase_uid — VARCHAR(255)
- nickname — VARCHAR(255)
- personality — VARCHAR(255)
- created_at — DATETIME
- profile_img — VARCHAR(255)
- frame_id — INT
- is_deleted — BOOLEAN
user_behavior
- behavior_id — INT
- user_id — INT
- action_type — VARCHAR(50)
- data — TEXT
- date — DATETIME
user_frame
- _id — INT
- user_id — INT
- frame_id — INT
user_progress
- progress_id — INT
- user_id — INT
- quiz_id — INT
- solved — BOOLEAN
- score — INT
- date — DATE
- streak — INT
user_purchase
- purchase_id — INT
- user_id — INT
- item_id — INT
- purchased_at — DATETIME
user_token
- id — INT
- user_id — INT
- refresh_token — VARCHAR(255)
- expired_at — DATETIME
- created_at — DATETIME