Agentic trading

Tables (6)

Untitled (Stock)

  • Key (id) — Primary key — NOT NULL
  • Field (name)
  • Field (ticker)

Untitled (StockHistory)

  • Key (id) — Primary key — NOT NULL
  • Key (stock_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (price)
  • Field (timestamp)

Untitled (Trading)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → User.id — NOT NULL
  • Key (stock_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (type)
  • Field (timestamp)

Untitled (Portfolio)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → User.id — NOT NULL
  • Key (stock_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (revenue)

Untitled (Profile)

  • Key (id) — Primary key — NOT NULL
  • id (user_id) — Foreign key → User.id — NOT NULL
  • Field (total_revenue)

User

  • id — Primary key — NOT NULL
  • username
  • Field2 (email)