db

Tables (5)

buy_strategy

  • buy_strategy_id — BIGINT — Primary key — NOT NULL
  • strategy_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • buy_logic — JSON
  • buy_price — DECIMAL(18,4) — NOT NULL
  • qty — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

sell_strategy

  • sell_strategy_id — BIGINT — Primary key — NOT NULL
  • strategy_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • sell_logic — JSON
  • sell_price — DECIMAL(18,4) — NOT NULL
  • qty — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

strategies

  • strategy_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • symbol_id — BIGINT
  • strategy_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

symbols

  • symbol_id — BIGINT — Primary key — NOT NULL
  • ticker — VARCHAR(32) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(60) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL