펀드관리 DB

테이블 (5)

Account

  • account_id — INT
  • investor_id — INT — NOT NULL
  • bank_name — VARCHAR(100)
  • account_number — VARCHAR(50)
  • account_type — ENUM('입출금', '증권', 'CMA')
  • open_date — DATE
  • status — ENUM('ACTIVE', 'INACTIVE')

Financial_Product

  • product_id — INT
  • product_name — VARCHAR(100) — NOT NULL
  • product_type — ENUM('주식형', '채권형', '혼합형')
  • provider — VARCHAR(100)
  • risk_grade — TINYINT
  • fee_rate — DECIMAL(5,2)
  • release_date — DATE
  • description — TEXT
  • current_price — DECIMAL(15,2)

Investor

  • investor_id — INT
  • name — VARCHAR(100) — NOT NULL
  • gender — ENUM('M', 'F', 'Other')
  • birth_date — DATE
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • signup_date — DATE
  • password_hash — VARCHAR(255) — NOT NULL

Portfolio

  • account_id — INT — 기본 키 — NOT NULL
  • product_id — INT — 기본 키 — NOT NULL
  • total_quantity — DECIMAL(15,4)
  • average_purchase_price — DECIMAL(15,2)
  • evaluation_value — DECIMAL(15,2)
  • profit_loss — DECIMAL(15,2)

Transaction

  • transaction_id — INT
  • account_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • transaction_type — ENUM('BUY', 'SELL')
  • transaction_date — DATE
  • quantity — DECIMAL(15,4)
  • unit_price — DECIMAL(15,2)
  • total_amount — DECIMAL(15,2)
  • fee — DECIMAL(10,2)
  • note — TEXT