`data/arbitrage.db`

54 lines
SQLite format 3@  .WJ
	���
�
8	��!;�7indexidx_activearbitrage_opportunitiesCREATE INDEX idx_active ON arbitrage_opportunities(is_active, profit_margin_pct DESC)s#;�indexidx_createdarbitrage_opportunitiesCREATE INDEX idx_created ON arbitrage_opportunities(created_at DESC)d;}indexidx_brandarbitrage_opportunitiesCREATE INDEX idx_brand ON arbitrage_opportunities(brand)x!;�!indexidx_profitarbitrage_opportunitiesCREATE INDEX idx_profit ON arbitrage_opportunities(profit_margin_pct DESC)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�;;�Stablearbitrage_opportunitiesarbitrage_opportunitiesCREATE TABLE arbitrage_opportunities (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  
  -- Product Info
  brand TEXT NOT NULL,
  model TEXT NOT NULL,
  condition TEXT CHECK(condition IN ('new', 'excellent', 'good', 'fair')) DEFAULT 'excellent',
  
  -- Japan Source
  japan_price_jpy REAL NOT NULL,
  japan_source TEXT,
  japan_url TEXT,
  japan_tax_refund_pct REAL DEFAULT 10.0,
  
  -- USA Comparison
  usa_price_usd REAL,
  usa_source TEXT,
  usa_url TEXT,
  
  -- HK Comparison
  hk_price_hkd REAL,
  hk_source TEXT,
  hk_url TEXT,
  
  -- Calculations
  exchange_rate_jpy_usd REAL NOT NULL,
  exchange_rate_hkd_usd REAL DEFAULT 0.128,
  total_cost_usd REAL NOT NULL,
  potential_profit_usd REAL,
  profit_margin_pct REAL,
  
  -- Cost Breakdown JSON
  cost_breakdown TEXT,
  
  -- Metadata
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  is_active BOOLEAN DEFAULT 1,
  
  -- Verification
  verified BOOLEAN DEFAULT 0,
  verified_at DATETIME
)
��
���39%�m33	ChanelClassic Flap Mediumexcellent
`@Komehyohttps://komehyo.jp/...
!4Fashionphile?|C,�zxl?�bM���	@Gٙ����{"purchaseJPY":680000,"taxRefund":68000,"netPurchaseJPY":612000,"shipping":80,"duties":200,"fees":120,"auth":75}2025-11-17 16:28:012025-11-17 16:28:01�;�w33	HermèsBirkin 30excellent�`Brand Offhttps://brandoff.jp/...
HDeBay Sold?|C,�zxl?�bM���*]�@H333333{"purchaseJPY":1500000,"taxRefund":150000,"netPurchaseJPY":1350000,"shipping":100,"duties":450,"fees":200,"auth":100}2025-11-17 16:28:012025-11-17 16:28:01�'%9%�i33	Louis VuittonNeverfull MMexcellent� Komehyohttps://komehyo.jp/...
4Fashionphile?|C,�zxl?�bM����X@7�fffff{"purchaseJPY":180000,"taxRefund":18000,"netPurchaseJPY":162000,"shipping":50,"duties":90,"fees":60,"auth":50}2025-11-17 16:28:012025-11-17 16:28:01
��;arbitrage_opportunities
����@Gٙ����@H333333	@7�fffff
����
ChanelHermès'	Louis Vuitton
����32025-11-17 16:28:0132025-11-17 16:28:013	2025-11-17 16:28:01
����
	@Gٙ����
	@H333333		@7�fffff