test
Tables (10)
categories
- category_id — BIGINT
- code — VARCHAR(50) — NOT NULL
- label — VARCHAR(100) — NOT NULL
- group_id — BIGINT — Foreign key → category_groups.group_id — NOT NULL
category_groups
- group_id — BIGINT
- code — VARCHAR(50) — NOT NULL
- label — VARCHAR(100) — NOT NULL
daily_prices
- stnd_date — DATE — Primary key — NOT NULL
- ticker — VARCHAR(20) — Foreign key → etfs.ticker — NOT NULL
- adj_close — DECIMAL(38,2)
- close — DECIMAL(38,2) — NOT NULL
- high — DECIMAL(38,2)
- low — DECIMAL(38,2)
- nav — DECIMAL(38,2)
- open — DECIMAL(38,2)
- premium_pct — DECIMAL(38,2)
- volume — BIGINT
dividends
- stnd_date — DATE — Primary key — NOT NULL
- ticker — VARCHAR(20) — Foreign key → etfs.ticker — NOT NULL
- dividend_amount — DECIMAL(19,4)
etf_category_map
- category_category_id — BIGINT — Foreign key → categories.category_id — NOT NULL
- etf_ticker — VARCHAR(20) — Foreign key → etfs.ticker — NOT NULL
etfs
- ticker — VARCHAR(20) — NOT NULL
- kr_isnm — VARCHAR(255)
- market — VARCHAR(255)
favorites
- etf_ticker — VARCHAR(20) — Foreign key → etfs.ticker — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- created_at — DATETIME(6)
portfolio_items
- etf_ticker — VARCHAR(20) — Foreign key → etfs.ticker — NOT NULL
- portfolio_id — BIGINT — Foreign key → portfolios.portfolio_id — NOT NULL
- created_at — DATETIME(6)
portfolios
- portfolio_id — BIGINT
- created_at — DATETIME(6)
- name — VARCHAR(20) — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
users
- user_id — BIGINT
- created_at — DATETIME(6)
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- password_hash — VARCHAR(255) — NOT NULL