Cointrader表结构
转载须注明出处：http://blog.csdn.net/minimicall?viewmode=contents，http://cloudtrader.top
设置（setup)
Install Java
Install Maven
Install MySql
Create a database using
mysql -u root -e `create database cointrader;`
This is mysql root not system root
git clone https://github.com/timolson/cointrader.git
cd cointrader
Build with Maven
mvn
Optional: Create a file cointrader.properties in the current directory. You may configure additional settings here, like a database username and password. See cointrader-default.properties.
Initialize the database with:
./cointrader.sh reset-database
You're done! Now you might want to:
Start a process to save market data in the db:
./cointrader.sh save-data &
Run the Console
./cointrader.sh console
登入数据库：
$ mysql -u root -p
查看database：
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cointrader |
| db_test |
| mysql |
| openfire |
| performance_schema |
| xoops |
+--------------------+
7 rows in set (0.00 sec)
切入cointrader：
mysql> use cointrader;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
查看表格：
mysql> show tables;
+--------------------------+
| Tables_in_cointrader |
+--------------------------+
| adjustment |
| adjustment_deltas |
| authorization |
| book |
| currency |
| exchange |
| fill |
| fill_children |
| general_order |
| listing |
| market |
| market_data_gap_error |
| offer |
| order_children |
| order_update |
| owner |
| owner_stakes |
| portfolio |
| portfolio_manager |
| portfolio_stakes |
| position |
| position_fills |
| position_update |
| prompt |
| specific_order |
| stake |
| strategy_instance |
| strategy_instance_config |
| tick |
| trade |
| transaction |
+--------------------------+
31 rows in set (0.01 sec)
查看每一个表的表结构
mysql> desc adjustment;
+---------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time_applied | tinyblob | YES | | NULL | |
| authorization | binary(16) | NO | UNI | NULL | |
+---------------+------------+------+-----+---------+-------+
mysql> desc adjustment_deltas;
+------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| adjustment | binary(16) | NO | MUL | NULL | |
| deltas | binary(16) | NO | PRI | NULL | |
+------------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc authorization ;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| notes | varchar(255) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> desc authorization ;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| notes | varchar(255) | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> desc book ;
+----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | MUL | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | MUL | NULL | |
| market | binary(16) | NO | MUL | NULL | |
| ask_deletions_blob | longblob | YES | | NULL | |
| ask_insertions_blob | longblob | YES | | NULL | |
| ask_price_as_double | double | YES | | NULL | |
| ask_volume_as_double | double | YES | | NULL | |
| bid_deletions_blob | longblob | YES | | NULL | |
| bid_insertions_blob | longblob | YES | | NULL | |
| bid_price_as_double | double | YES | | NULL | |
| bid_volume_as_double | double | YES | | NULL | |
| parent | binary(16) | YES | MUL | NULL | |
+----------------------+--------------+------+-----+---------+-------+
15 rows in set (0.00 sec)
mysql> desc currency ;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| basis | double | NO | | NULL | |
| symbol | varchar(255) | NO | | NULL | |
| fiat | bit(1) | NO | | NULL | |
+---------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> desc exchange ;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| fee_method | int(11) | YES | | NULL | |
| fee_rate | double | NO | | NULL | |
| margin | int(11) | NO | | NULL | |
| margin_fee_method | int(11) | YES | | NULL | |
| margin_fee_rate | double | NO | | NULL | |
| symbol | varchar(255) | NO | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)
mysql> desc fill ;
+--------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | | NULL | |
| open_volume_count | bigint(20) | NO | | NULL | |
| price_count | bigint(20) | NO | | NULL | |
| stop_price_count | bigint(20) | NO | | NULL | |
| target_price_count | bigint(20) | NO | | NULL | |
| volume_count | bigint(20) | NO | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| order | binary(16) | YES | MUL | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
+--------------------+--------------+------+-----+---------+-------+
13 rows in set (0.01 sec)
mysql> desc fill_children ;
+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| fill | binary(16) | NO | MUL | NULL | |
| children | binary(16) | NO | PRI | NULL | |
+----------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc general_order ;
+-----------------------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+---------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| comment | varchar(255) | YES | | NULL | |
| emulation | bit(1) | NO | | NULL | |
| entry_time | bigint(20) | YES | | NULL | |
| expiration | tinyblob | YES | | NULL | |
| fill_type | int(11) | YES | MUL | NULL | |
| margin_type | int(11) | YES | | NULL | |
| panic_force | bit(1) | NO | | NULL | |
| position_effect | int(11) | YES | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| parent_order | binary(16) | YES | | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
| limit_price_decimal | decimal(19,2) | YES | | NULL | |
| stop_amount_decimal | decimal(19,2) | YES | | NULL | |
| stop_price_decimal | decimal(19,2) | YES | | NULL | |
| target_amount_decimal | decimal(19,2) | YES | | NULL | |
| target_price_decimal | decimal(19,2) | YES | | NULL | |
| trailing_stop_price_decimal | decimal(19,2) | YES | | NULL | |
| volume_decimal | decimal(19,2) | YES | | NULL | |
| listing | binary(16) | NO | MUL | NULL | |
+-----------------------------+---------------+------+-----+---------+-------+
22 rows in set (0.00 sec)
mysql> desc listing ;
+---------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| base | binary(16) | NO | MUL | NULL | |
| prompt | binary(16) | YES | MUL | NULL | |
| quote | binary(16) | NO | MUL | NULL | |
+---------+------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> desc market ;
+--------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| active | bit(1) | NO | MUL | NULL | |
| price_basis | double | NO | | NULL | |
| volume_basis | double | NO | | NULL | |
| exchange | binary(16) | NO | MUL | NULL | |
| listing | binary(16) | NO | MUL | NULL | |
+--------------+------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
mysql> desc market_data_gap_error;
+--------------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| exception | tinyblob | YES | | NULL | |
| gap_interval_start | datetime | YES | | NULL | |
| gap_interval_end | datetime | YES | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
+--------------------+------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
mysql> desc offer ;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | | NULL | |
| market | binary(16) | NO | MUL | NULL | |
| price_count | bigint(20) | YES | | NULL | |
| volume_count | bigint(20) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)
mysql> desc order_children ;
+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| order | binary(16) | NO | | NULL | |
| children | binary(16) | NO | PRI | NULL | |
+----------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc order_update ;
+------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+----------------+
| sequence | int(11) | NO | PRI | NULL | auto_increment |
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| last_state | int(11) | YES | | NULL | |
| state | int(11) | YES | MUL | NULL | |
| order | binary(16) | YES | | NULL | |
+------------+------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
mysql> desc owner ;
+-----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| portfolio | binary(16) | YES | MUL | NULL | |
| name | varchar(255) | NO | | NULL | |
+-----------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> desc owner_stakes ;
+--------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------+------------+------+-----+---------+-------+
| owner | binary(16) | NO | MUL | NULL | |
| stakes | binary(16) | NO | PRI | NULL | |
+--------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc portfolio ;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| name | varchar(255) | YES | | NULL | |
| base_asset | binary(16) | YES | | NULL | |
+------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> desc portfolio_manager ;
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| portfolio | binary(16) | YES | MUL | NULL | |
+-----------+------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> desc portfolio_stakes ;
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| portfolio | binary(16) | NO | MUL | NULL | |
| stakes | binary(16) | NO | PRI | NULL | |
+-----------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc position ;
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| asset | binary(16) | YES | | NULL | |
| exchange | binary(16) | YES | MUL | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| portfolio | binary(16) | YES | MUL | NULL | |
+-----------+------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> desc position_fills ;
+----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| position | binary(16) | NO | MUL | NULL | |
| fills | binary(16) | NO | PRI | NULL | |
+----------+------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> desc position_update;
+-----------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| last_type | int(11) | YES | | NULL | |
| type | int(11) | YES | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| position | binary(16) | YES | MUL | NULL | |
+-----------+------------+------+-----+---------+-------+
7 rows in set (0.00 sec)
mysql> desc prompt ;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| contract_size | double | NO | | NULL | |
| fee_method | int(11) | YES | | NULL | |
| fee_rate | double | NO | | NULL | |
| margin | int(11) | NO | | NULL | |
| margin_fee_method | int(11) | YES | | NULL | |
| margin_method | int(11) | YES | | NULL | |
| price_basis | double | NO | | NULL | |
| symbol | varchar(255) | NO | | NULL | |
| tick_size | double | NO | | NULL | |
| tick_value | double | NO | | NULL | |
| volume_basis | double | NO | | NULL | |
| traded_currency | binary(16) | YES | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
14 rows in set (0.01 sec)
mysql> desc specific_order ;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| comment | varchar(255) | YES | | NULL | |
| emulation | bit(1) | NO | | NULL | |
| entry_time | bigint(20) | YES | | NULL | |
| expiration | tinyblob | YES | | NULL | |
| fill_type | int(11) | YES | MUL | NULL | |
| margin_type | int(11) | YES | | NULL | |
| panic_force | bit(1) | NO | | NULL | |
| position_effect | int(11) | YES | | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| parent_order | binary(16) | YES | | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
| limit_price_count | bigint(20) | NO | | NULL | |
| placement_count | int(11) | NO | | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | YES | | NULL | |
| volume_count | bigint(20) | NO | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
19 rows in set (0.01 sec)
mysql> desc stake ;
+-----------+----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+----------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| stake | decimal(30,15) | YES | | NULL | |
| owner | binary(16) | YES | MUL | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
+-----------+----------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> desc strategy_instance ;
+-------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| portfolio | binary(16) | YES | MUL | NULL | |
| module_name | varchar(255) | YES | | NULL | |
+-------------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
mysql> desc strategy_instance_config;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| strategy_instance | binary(16) | NO | PRI | NULL | |
| config | varchar(255) | YES | | NULL | |
| config_key | varchar(255) | NO | PRI | | |
+-------------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> desc tick ;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | | NULL | |
| market | binary(16) | NO | MUL | NULL | |
| price_count | bigint(20) | YES | | NULL | |
| volume_count | bigint(20) | YES | | NULL | |
| start_instant | tinyblob | YES | | NULL | |
| last_book | binary(16) | YES | MUL | NULL | |
+---------------+--------------+------+-----+---------+-------+
10 rows in set (0.00 sec)
mysql> desc trade ;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | MUL | NULL | |
| remote_key | varchar(255) | YES | | NULL | |
| time_received | bigint(20) | NO | MUL | NULL | |
| market | binary(16) | NO | MUL | NULL | |
| price_count | bigint(20) | YES | | NULL | |
| volume_count | bigint(20) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)
mysql> desc transaction ;
+---------------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+------------+------+-----+---------+-------+
| id | binary(16) | NO | PRI | NULL | |
| version | bigint(20) | YES | | NULL | |
| time | bigint(20) | NO | | NULL | |
| amount_count | bigint(20) | YES | | NULL | |
| commission_count | bigint(20) | YES | | NULL | |
| position_effect | int(11) | YES | | NULL | |
| price_count | bigint(20) | YES | | NULL | |
| type | int(11) | YES | MUL | NULL | |
| asset | binary(16) | YES | | NULL | |
| commission_currency | binary(16) | YES | | NULL | |
| currency | binary(16) | NO | | NULL | |
| exchange | binary(16) | YES | MUL | NULL | |
| fill | binary(16) | YES | MUL | NULL | |
| market | binary(16) | YES | MUL | NULL | |
| order | binary(16) | YES | | NULL | |
| portfolio | binary(16) | NO | MUL | NULL | |
+---------------------+------------+------+-----+---------+-------+
16 rows in set (0.00 sec)
