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)