펀드관리 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