자산관리
테이블 (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