全球化多语言ST5外汇交易系统源码：精仿美股交易平台，支持UniApp多端适配（PC+移动端）

CREATE TABLE user_assets (
  asset_id BIGINT AUTO_INCREMENT PRIMARY KEY,
  user_id BIGINT NOT NULL,
  currency VARCHAR(10) COMMENT '币种代码: USD/BTC等',
  balance DECIMAL(24,8) COMMENT '可用余额',
  frozen DECIMAL(24,8) COMMENT '冻结金额',
  wallet_address VARCHAR(42) COMMENT '链上地址',
  INDEX idx_user_currency (user_id, currency)
) ENGINE=InnoDB PARTITION BY HASH(user_id) PARTITIONS 32;

-- 杠杆账户表
CREATE TABLE margin_accounts (
  account_id VARCHAR(32) PRIMARY KEY,
  user_id BIGINT NOT NULL,
  leverage INT DEFAULT 1 COMMENT '杠杆倍数',
  risk_rate DECIMAL(10,4) COMMENT '风险率=净值/占用保证金',
  margin DECIMAL(24,8) COMMENT '已用保证金'
) ENGINE=InnoDB;

CREATE TABLE forex_orders (
  order_id VARCHAR(32) PRIMARY KEY,
  symbol VARCHAR(12) COMMENT '货币对: EURUSD.OTC',
  direction ENUM('BUY','SELL'),
  price DECIMAL(18,5) COMMENT '成交价',
  volume DECIMAL(18,2) COMMENT '手数',
  status ENUM('OPEN','CLOSED','CANCELED'),
  create_time DATETIME(6),
  INDEX idx_symbol_time (symbol, create_time)
) ENGINE=InnoDB;

-- 美股CFD持仓表
CREATE TABLE stock_positions (
  position_id VARCHAR(32) PRIMARY KEY,
  symbol VARCHAR(10) COMMENT '股票代码: AAPL.US',
  avg_price DECIMAL(18,2) COMMENT '开仓均价',
  quantity INT COMMENT '持仓数量',
  floating_pnl DECIMAL(18,2) COMMENT '浮动盈亏'
) ENGINE=InnoDB;

CREATE TABLE i18n_terms (
  term_key VARCHAR(64) PRIMARY KEY COMMENT '词条键名: trade.risk_warning',
  en TEXT COMMENT '英文内容',
  zh TEXT COMMENT '中文内容',
  ja TEXT COMMENT '日文内容',
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;

-- 产品说明库
CREATE TABLE product_i18n (
  product_id INT,
  lang VARCHAR(5) COMMENT '语言代码: en_US',
  title VARCHAR(255),
  description TEXT,
  PRIMARY KEY (product_id, lang)
) ENGINE=InnoDB;