---
id: document_item.order-database
page_type: documentation_article
title: "Order Database"
description: "Moonbot order database schema with fields for order IDs, coins, dates, quantities, buy and sell prices, profit, strategy data, deltas, volumes and other trade attributes."
section: documentation
category: "Additional materials / MoonCMD Remote Control Protocol"
url: https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol/order-database?format=md
locale: en
alternate_ru: https://moonbot.eu/documentation/mooncmd-remote-control-protocol/order-database?format=md
parent: https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol?format=md
previous: https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol/mooncmd-protocol-description?format=md
next: https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol/structure-of-repositories?format=md
status: published
updated_at: 2026-10-16T17:59:02+03:00
---

# Order Database

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

);

## Navigation

Path: [Main](https://moonbot.eu/en?format=md) / [Documentation](https://moonbot.eu/en/documentation?format=md) / [Additional materials](https://moonbot.eu/en/documentation/additional-materials?format=md) / [MoonCMD Remote Control Protocol](https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol?format=md) / Order Database

Parent section: [MoonCMD Remote Control Protocol](https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol?format=md)

Previous: [MoonCDM Protocol Description](https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol/mooncmd-protocol-description?format=md)

Next: [Structure of repositories](https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol/structure-of-repositories?format=md)

## Related

- [Structure of repositories](https://moonbot.eu/en/documentation/mooncmd-remote-control-protocol/structure-of-repositories?format=md)