dd
Tables (3)
tb_conclusion
- id — INT(11) — Primary key — NOT NULL
- odno — VARCHAR(20)
- cano — VARCHAR(10)
- symbol — VARCHAR(10) — NOT NULL
- exchange — VARCHAR(10)
- datetime — VARCHAR(20)
- type — TINYINT(4)
- price — FLOAT — NOT NULL
- qty — INT(11) — NOT NULL
tb_order
- id — INT(11) — Primary key — NOT NULL
- id (strategy_id) — INT(11) — Foreign key → tb_strategy.id — NOT NULL
- odno — VARCHAR(20)
- cano — VARCHAR(10)
- symbol — VARCHAR(10)
- exchange — VARCHAR(10)
- datetime — VARCHAR(20)
- type — TINYINT(4) — 1: buy, 2: sell
- price — FLOAT
- qty — INT(11)
- cancel — TINYINT(4)
tb_strategy
- id — INT(11) — Primary key — NOT NULL
- symbol — VARCHAR(10) — NOT NULL
- exchange — VARCHAR(10) — NOT NULL
- cano — VARCHAR(10) — NOT NULL
- author — VARCHAR(20) — NOT NULL
- datetime — VARCHAR(20) — NOT NULL
- buy — FLOAT — NOT NULL
- sell — FLOAT — NOT NULL
- stoploss — FLOAT — NOT NULL
- amount — FLOAT
- qty — INT(11)
- tradable — TINYINT(4) — NOT NULL
- buy_completed — TINYINT(4)
- sell_completed — TINYINT(4)