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