Quant_Service ERD
Tables (7)
portfolio_items
- id — BIGINT — NOT NULL
- portfolio_id — BIGINT — Foreign key → portfolios.id — NOT NULL
- stock_id — BIGINT — Foreign key → stocks.id — NOT NULL
- avg_price — DECIMAL(15, 2) — NOT NULL
- quantity — INT — NOT NULL
portfolios
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
price_histories
- id — BIGINT — NOT NULL
- stock_id — BIGINT — Foreign key → stocks.id — NOT NULL
- date — DATE — NOT NULL
- open_price — DECIMAL(15, 2) — NOT NULL
- close_price — DECIMAL(15, 2) — NOT NULL
- high_price — DECIMAL(15, 2) — NOT NULL
- low_price — DECIMAL(15, 2) — NOT NULL
- volume — BIGINT — NOT NULL
stocks
- id — BIGINT — NOT NULL
- ticker — VARCHAR(50) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- market — VARCHAR(50) — NOT NULL
trades
- id — BIGINT — NOT NULL
- portfolio_id — BIGINT — Foreign key → portfolios.id — NOT NULL
- stock_id — BIGINT — Foreign key → stocks.id — NOT NULL
- trade_type — VARCHAR(20) — NOT NULL
- price — DECIMAL(15, 2) — NOT NULL
- quantity — INT — NOT NULL
- trade_date — DATETIME — NOT NULL
users
- id — BIGINT — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
watch_lists
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- stock_id — BIGINT — Foreign key → stocks.id — NOT NULL