Skip to content

Instantly share code, notes, and snippets.

@pandanote-info
Last active February 9, 2020 12:35
Show Gist options
  • Save pandanote-info/4026704100946e5a9cd1939d7e28b39c to your computer and use it in GitHub Desktop.
Save pandanote-info/4026704100946e5a9cd1939d7e28b39c to your computer and use it in GitHub Desktop.
bitFlyer LightningのHTTP Public APIから取得した取引情報をMariaDB上に格納するためのテーブル定義。
-- See https://pandanote.info/?p=5966 for details.
drop table if exists crypto_currency_info_cache;
create table crypto_currency_info_cache (
id int (11) not null auto_increment,
product_code varchar(40) unique,
info_at datetime,
tick_id int,
best_bid double,
best_ask double,
best_bid_size double(20,8),
best_ask_size double(20,8),
total_bid_depth double(20,8),
total_ask_depth double(20,8),
ltp double,
volume double(20,8),
volume_by_product double(20,8),
primary key(id)
) ENGINE=InnoDB default charset=utf8mb4;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment