Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Comments | |
PK | ID | Integer | YES | NO | ||
Created | Timestamp | YES | NO | GMT | ||
Modified | Timestamp | NO | NO | GMT | ||
Type | Enum | YES | NO | Forex | Metals | Synthetic | ||
Symbol | Varchar (11) | YES | YES | |||
Description | Varchar (63) | YES | NO | long name | ||
Digits | Tinyint | YES | NO | |||
HistoryStartTicks | Datetime | NO | NO | FXT | ||
HistoryStartM1 | Datetime | NO | NO | FXT | ||
HistoryStartD1 | Datetime | NO | NO | FXT |
Name | Value |
Temporary table | No |
If not exists | No |
Table type | Default |
Character Set | |
Row Format | Default |
Collation | |
Database Name | |
Initial AUTO_INCREMENT |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Comments | |
PK | ID | Integer | YES | NO | ||
Created | Timestamp | YES | NO | GMT | ||
Modified | Timestamp | NO | NO | GMT | ||
Ticket | Integer | YES | NO | |||
Type | Enum | YES | NO | Buy | Sell | ||
Lots | Decimal (10,2) | YES | NO | |||
Symbol | Varchar (11) | YES | NO | |||
OpenPrice | Decimal (10,5) | YES | NO | |||
OpenTime | Datetime | YES | NO | FXT | ||
StopLoss | Decimal (10,5) | NO | NO | |||
TakeProfit | Decimal (10,5) | NO | NO | |||
ClosePrice | Decimal (10,5) | YES | NO | |||
CloseTime | Datetime | YES | NO | FXT | ||
Commission | Decimal (10,2) | YES | NO | |||
Swap | Decimal (10,2) | YES | NO | |||
Profit | Decimal (10,2) | YES | NO | gross profit | ||
MagicNumber | Integer | NO | NO | |||
Comment | Varchar (27) | NO | NO | |||
FK | ID/Test | Integer | YES | NO |
Relationship name | Type | Parent entity | Child entity | Card. |
fk_order_test | Non-identifying | Test | Order | 1:N |
Name | Attributes |
Test,Ticket | ID, Ticket |
Name | Value |
Temporary table | No |
If not exists | No |
Table type | Default |
Character Set | |
Row Format | Default |
Collation | |
Database Name | |
Initial AUTO_INCREMENT |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Comments | |
PK | ID | Integer | YES | NO | ||
Trades | Integer | YES | NO | |||
TradesPerDay | Decimal (10,1) | YES | NO | trades per day | ||
MinDuration | Integer | YES | NO | minimum trade duration in seconds | ||
AvgDuration | Integer | YES | NO | average trade duration in seconds | ||
MaxDuration | Integer | YES | NO | maximum trade duration in seconds | ||
MinPips | Decimal (10,1) | YES | NO | minimum trade profit in pips | ||
AvgPips | Decimal (10,1) | YES | NO | average profit in pips | ||
MaxPips | Decimal (10,1) | YES | NO | maximum trade profit in pips | ||
Pips | Decimal (10,1) | YES | NO | total profit in pips | ||
SharpeRatio | Decimal (10,4) | YES | NO | simplified non-normalized Sharpe ratio | ||
SortinoRatio | Decimal (10,4) | YES | NO | simplified non-normalized Sortino ratio | ||
CalmarRatio | Decimal (10,4) | YES | NO | simplified monthly Calmar ratio | ||
MaxRecoveryTime | Integer | YES | NO | maximum drawdown recovery time in seconds | ||
GrossProfit | Decimal (10,2) | YES | NO | total gross profit in money | ||
Commission | Decimal (10,2) | YES | NO | total commission | ||
Swap | Decimal (10,2) | YES | NO | total swap | ||
FK | ID/Test | Integer | YES | YES |
Relationship name | Type | Parent entity | Child entity | Card. |
fk_statistic_test | Non-identifying | Test | Statistic | 1:N |
Name | Value |
Temporary table | No |
If not exists | No |
Table type | Default |
Character Set | |
Row Format | Default |
Collation | |
Database Name | |
Initial AUTO_INCREMENT |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | ||
PK | ID | Integer | YES | NO | ||
Name | Varchar (32) | YES | NO | |||
Value | Varchar (255) | YES | NO | |||
FK | ID/Test | Integer | YES | NO |
Relationship name | Type | Parent entity | Child entity | Card. |
fk_strategyparameter_test | Non-identifying | Test | StrategyParameter | 1:N |
Name | Attributes |
Test,Name | ID, Name |
Name | Value |
Temporary table | No |
If not exists | No |
Table type | Default |
Character Set | |
Row Format | Default |
Collation | |
Database Name | |
Initial AUTO_INCREMENT |
Entity type: | independent |
Key | Attribute/role name | Data type | Not null | Unique | Comments | |
PK | ID | Integer | YES | NO | ||
Created | Timestamp | YES | NO | GMT | ||
Modified | Timestamp | NO | NO | GMT | ||
Strategy | Varchar (255) | YES | NO | tested strategy | ||
ReportingID | Integer | YES | NO | the test's reporting id | ||
ReportingSymbol | Varchar (11) | YES | YES | the test's reporting symbol | ||
Symbol | Varchar (11) | YES | NO | tested symbol | ||
Timeframe | Integer | YES | NO | tested timeframe in minutes | ||
StartTime | Datetime | YES | NO | FXT | ||
EndTime | Datetime | YES | NO | FXT | ||
BarModel | Enum | YES | NO | EveryTick | ControlPoints | BarOpen | ||
Spread | Decimal (2,1) | YES | NO | |||
Bars | Integer | YES | NO | |||
Ticks | Integer | YES | NO | |||
TradeDirections | Enum | YES | NO | Long | Short | Both |
Relationship name | Type | Parent entity | Child entity | Card. |
fk_order_test | Non-identifying | Test | Order | 1:N |
fk_strategyparameter_test | Non-identifying | Test | StrategyParameter | 1:N |
fk_statistic_test | Non-identifying | Test | Statistic | 1:N |
Name | Attributes |
Strategy,ReportingID | Strategy, ReportingID |
Name | Value |
Temporary table | No |
If not exists | No |
Table type | Default |
Character Set | |
Row Format | Default |
Collation | |
Database Name | |
Initial AUTO_INCREMENT |