자산관리

테이블 (5)

asset_history

  • id — INT
  • asset_id — INT — NOT NULL
  • transaction_type — ENUM('입금', '출금') — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP

assets

  • id — INT
  • user_id — INT — NOT NULL
  • asset_name — VARCHAR(50) — NOT NULL
  • balance — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP

stock_interest

  • id — INT
  • user_id — INT — NOT NULL
  • stock_id — INT — NOT NULL

stocks

  • id — INT
  • symbol — VARCHAR(20) — NOT NULL
  • company_name — VARCHAR(100) — NOT NULL
  • current_price — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP

users

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • username — VARCHAR(20) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP