---
id: document_item.order-database
page_type: documentation_article
title: "订单数据库"
description: "Moonbot 订单数据库结构（Orders 表）：标识符、币种、日期、数量、买入价与卖出价、盈利、策略、Delta 以及其他交易参数的字段。"
section: documentation
category: "补充材料 / MoonCMD 远程控制协议"
url: https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol/order-database?format=md
locale: zh
alternate_ru: https://moonbot.eu/documentation/mooncmd-remote-control-protocol/order-database?format=md
alternate_en: https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol/order-database?format=md
parent: https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol?format=md
previous: https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol/mooncmd-protocol-description?format=md
next: https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol/structure-of-repositories?format=md
status: published
updated_at: 2026-11-11T00:08:11+03:00
---

# 订单数据库

CREATE TABLE Orders (

ID INTEGER PRIMARY KEY,

exOrderID TEXT,

Coin TEXT,

BuyDate INT,

SellSetDate INT,

CloseDate INT,

Quantity REAL,

BuyPrice REAL,

SellPrice REAL,

SpentBTC REAL,

GainedBTC REAL,

ProfitBTC REAL,

Source INT,

Channel INT,

ChannelName TEXT,

Status INT,

Comment TEXT,

BaseCurrency INT DEFAULT 0,

BoughtQ REAL,

BTC1hDelta REAL,

Exchange1hDelta REAL,

SignalType TEXT,

SellReason TEXT,

StrategyID sqlite3_uint64 DEFAULT 0,

FName TEXT,

deleted INT DEFAULT 0,

Emulator INT DEFAULT 0,

Imp INT DEFAULT 0,

BTC24hDelta REAL DEFAULT 0,

Exchange24hDelta REAL DEFAULT 0,

bvsvRatio REAL DEFAULT 0,

BTC5mDelta REAL DEFAULT 0,

IsShort INT DEFAULT 0,

Pump1H REAL DEFAULT 0,

Dump1H REAL DEFAULT 0,

d24h REAL DEFAULT 0,

d3h REAL DEFAULT 0,

d1h REAL DEFAULT 0,

d15m REAL DEFAULT 0,

d5m REAL DEFAULT 0,

d1m REAL DEFAULT 0,

dBTC1m REAL DEFAULT 0,

PriceBug REAL DEFAULT 0,

Vd1m REAL DEFAULT 0,

Lev INT DEFAULT 1,

hVol REAL DEFAULT 0,

hVolF REAL DEFAULT 0,

dVol REAL DEFAULT 0,

TaskID INT DEFAULT 0

);

## 导航

路径: [首页](https://moonbot.eu/zh?format=md) / [文档](https://moonbot.eu/zh/documentation?format=md) / [补充材料](https://moonbot.eu/zh/documentation/additional-materials?format=md) / [MoonCMD 远程控制协议](https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol?format=md) / 订单数据库

上级栏目: [MoonCMD 远程控制协议](https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol?format=md)

上一页: [MoonCMD 协议说明](https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol/mooncmd-protocol-description?format=md)

下一页: [仓库结构](https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol/structure-of-repositories?format=md)

## 相关内容

- [仓库结构](https://moonbot.eu/zh/documentation/mooncmd-remote-control-protocol/structure-of-repositories?format=md)