{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tables","index":0,"n_rows":104,"n_cols":25,"rows_kept":104,"cut":false,"hidden":false,"merged":[[103,1,108,11]]}
["Database Name","StockMove.sqlite3",null,null,null,"アクションメニューを表示するには、テーブル名のセルを選択してください",null,null,null,null,"＜カスタムSQL文用セルへ移動"]
["Table Name","sales_data"]
["Field Name","item","branch","date","qty","amount"]
["Type","TEXT","TEXT","TEXT","INTEGER","INTEGER"]
["Key",null,null,null,null,null,"PRIMARY KEY(item,branch,date)"]
["Schema","CREATE TABLE sales_data(item TEXT ,branch TEXT ,date TEXT ,qty INTEGER ,amount INTEGER ,PRIMARY KEY(item,branch,date))"]
["Remarks","0,0,0,101,0,0","0,0,0,101,0,0"]
["Table Name","stock_data"]
["Field Name","item","branch","date","qty"]
["Type","TEXT","TEXT","TEXT","INTEGER"]
["Key",null,null,null,null,"PRIMARY KEY(item,branch,date)"]
["Schema","CREATE TABLE stock_data(item TEXT ,branch TEXT ,date TEXT ,qty INTEGER ,PRIMARY KEY(item,branch,date))"]
["Remarks","0,0,0,101,0,0"]
["Table Name","openpo_data"]
["Field Name","item","branch","order_date","due_date","qty","amount","vendor"]
["Type","TEXT","TEXT","TEXT","TEXT","INTEGER","INTEGER","TEXT"]
["Key"]
["Schema","CREATE TABLE openpo_data(item TEXT ,branch TEXT ,order_date TEXT ,due_date TEXT ,qty INTEGER ,amount INTEGER ,vendor TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","item_mst"]
["Field Name","item","description","status","category1","category2","abc_rank","buyer_code","seasonality","list_price","avg_price","avg_cost","vendor","vendor_item","leadtime","unit_leadtime","pack_large","pack_medium","pack_small","order_unit","min_stock_month","sku_branch","first_sales_date","last_update","last_update_user"]
["Type","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","INTEGER","REAL","REAL","TEXT","TEXT","INTEGER","TEXT","INTEGER","INTEGER","INTEGER","TEXT","REAL","TEXT","TEXT","TEXT","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE item_mst(item TEXT PRIMARY KEY,description TEXT ,status TEXT ,category1 TEXT ,category2 TEXT ,abc_rank TEXT ,buyer_code TEXT ,seasonality TEXT ,list_price INTEGER ,avg_price REAL ,avg_cost REAL ,vendor TEXT ,vendor_item TEXT ,leadtime INTEGER ,unit_leadtime TEXT ,pack_large INTEGER ,pack_medium INTEGER ,pack_small INTEGER ,order_unit TEXT ,min_stock_month REAL ,sku_branch TEXT ,first_sales_date TEXT ,last_update TEXT ,last_update_user TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","itemchange_mst"]
["Field Name","change_id","item","status","inheritance_ratio","date"]
["Type","TEXT","TEXT","TEXT","REAL","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE itemchange_mst(change_id TEXT PRIMARY KEY,item TEXT ,status TEXT ,inheritance_ratio REAL ,date TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","vendor_mst"]
["Field Name","vendor_code","company_name","city","state","postal_code","country","title","contact_person","email","buyer_code"]
["Type","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE vendor_mst(vendor_code TEXT PRIMARY KEY,company_name TEXT ,city TEXT ,state TEXT ,postal_code TEXT ,country TEXT ,title TEXT ,contact_person TEXT ,email TEXT ,buyer_code TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","employee_mst"]
["Field Name","employee_code","name","birth_date","department"]
["Type","TEXT","TEXT","TEXT","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE employee_mst(employee_code TEXT PRIMARY KEY,name TEXT ,birth_date TEXT ,department TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name","forecast_data"]
["Field Name","item","branch","date","sales_qty","sales_price","purchase_qty","adjust_qty","last_update","last_update_user"]
["Type","TEXT","TEXT","TEXT","INTEGER","INTEGER","INTEGER","INTEGER","TEXT","TEXT"]
["Key",null,null,null,null,null,null,null,null,null,"PRIMARY KEY(item,branch,date)"]
["Schema","CREATE TABLE forecast_data(item TEXT ,branch TEXT ,date TEXT ,sales_qty INTEGER ,sales_price INTEGER ,purchase_qty INTEGER ,adjust_qty INTEGER ,last_update TEXT ,last_update_user TEXT ,PRIMARY KEY(item,branch,date))"]
["Remarks","0,0,0,101,0,0"]
["Table Name","project_mst"]
["Field Name","project_id","branch","type","vendor","create_date","target_date","buyer_code","item_count","finish_count","sql_used"]
["Type","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","TEXT","INTEGER","INTEGER","TEXT"]
["Key","PRIMARY KEY"]
["Schema","CREATE TABLE project_mst(project_id TEXT PRIMARY KEY,branch TEXT ,type TEXT ,vendor TEXT ,create_date TEXT ,target_date TEXT ,buyer_code TEXT ,item_count INTEGER ,finish_count INTEGER ,sql_used TEXT )"]
["Remarks","0,0,0,101,0,0"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Table Name"]
["Field Name"]
["Type"]
["Key"]
["Schema"]
["Remarks"]
["Custom SQL","VACUUM"]