stockboard
Tables (9)
comment_likes
- id — INTEGER — Primary key — NOT NULL
- comment_id — INTEGER — Foreign key → comments.id — NOT NULL
- user_id — TEXT — Foreign key → profiles.id — NOT NULL
- created_at — TEXT
- UNIQUE(comment_id, — user_id)
comments
- id — INTEGER — Primary key — NOT NULL
- post_id — INTEGER — Foreign key → posts.id — NOT NULL
- user_id — TEXT — Foreign key → profiles.id — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — INTEGER
- created_at — DATETIME
- updated_at — DATETIME
- like_count — INTEGER
market_indices
- id — INTEGER — Primary key — NOT NULL
- symbol — TEXT — NOT NULL
- name — TEXT — NOT NULL
- current_value — REAL — NOT NULL
- change_amount — REAL
- change_percent — REAL
- display_order — INTEGER
- updated_at — TEXT
posts
- id — INTEGER — Primary key — NOT NULL
- user_id — TEXT — Foreign key → profiles.id — NOT NULL
- ticker — TEXT — Foreign key → stocks.ticker — NOT NULL
- title — TEXT — NOT NULL
- content — TEXT — NOT NULL
- sentiment — TEXT
- views — INTEGER
- is_deleted — INTEGER
- created_at — DATETIME
- updated_at — DATETIME
profiles
- id — TEXT — Primary key — NOT NULL
- nickname — TEXT — NOT NULL
- created_at — DATETIME
sectors
- id — INTEGER — Primary key — NOT NULL
- name — TEXT — NOT NULL
- description — TEXT
stock_prices
- id — INTEGER — Primary key — NOT NULL
- ticker — TEXT — Foreign key → stocks.ticker — NOT NULL
- price — REAL — NOT NULL
- open_price — REAL
- high_price — REAL
- low_price — REAL
- close_price — REAL — NOT NULL
- previous_close — REAL
- change_amount — REAL
- change_percent — REAL
- volume — INTEGER
- recorded_at — DATE — NOT NULL
- UNIQUE(ticker, — recorded_at)
stocks
- ticker — TEXT — Primary key — NOT NULL
- company_name — TEXT — NOT NULL
- sector_id — INTEGER — Foreign key → sectors.id
- exchange — TEXT
- market_cap — REAL
- per — REAL
- week52_high — REAL
- week52_low — REAL
- created_at — DATETIME
watchlists
- id — INTEGER — Primary key — NOT NULL
- user_id — TEXT — Foreign key → profiles.id — NOT NULL
- ticker — TEXT — Foreign key → stocks.ticker — NOT NULL
- created_at — DATETIME
- UNIQUE(user_id, — ticker)