Skip to content

Instantly share code, notes, and snippets.

@nezuQ
Created May 10, 2014 14:31
Show Gist options
  • Save nezuQ/afad7c5850ed75455fb0 to your computer and use it in GitHub Desktop.
Save nezuQ/afad7c5850ed75455fb0 to your computer and use it in GitHub Desktop.
Pixivイラスト検索APIの取得結果のデータ構造を調べる ref: http://qiita.com/nezuq/items/e4c55bb9c68bf5785e73
CREATE TABLE illust(illust_id INTEGER PRIMARY KEY, user_id INTEGER, extension TEXT, title TEXT, server_no INTEGER, user_name TEXT, illust_128_url TEXT, x1 TEXT, x2 TEXT, illust_480mw_url TEXT, x3 TEXT, x4 TEXT, illust_entry_dt TEXT, tags TEXT, tool_name TEXT, evaluate_cnt INTEGER, evaluate_sum INTEGER, view_cnt INTEGER, caption TEXT, page_cnt INTEGER, x5 TEXT, x6 TEXT, x7 TEXT, x8 TEXT, user_disp_id TEXT, x9 TEXT, r18_flg INTEGER, x10 TEXT, x11 TEXT, user_url TEXT);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment