bitFlyer LightningのHTTP Public APIから取得した取引情報をMariaDB上に格納するためのテーブル定義。

crypto_currency_info_cache.sql

-- 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;