← back to Handbag Auth Nextjs
data/handbags.db.backup
38380 lines
SQLite format 3 @ B B .r�
� I I��0
�[
Z�@��@�wG �+�)tablelistingslistingsCREATE TABLE listings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
external_id TEXT UNIQUE,
source TEXT NOT NULL,
title TEXT NOT NULL,
brand TEXT,
model TEXT,
price_jpy REAL NOT NULL,
price_usd REAL,
currency TEXT DEFAULT 'JPY',
condition TEXT,
image_url TEXT,
thumbnail_url TEXT,
product_url TEXT,
listing_type TEXT CHECK(listing_type IN ('auction', 'buy', 'both')),
auction_end_date TEXT,
location TEXT,
seller_name TEXT,
description TEXT,
crawled_at TEXT DEFAULT CURRENT_TIMESTAMP,
is_active INTEGER DEFAULT 1, is_new INTEGER DEFAULT 1,
UNIQUE(external_id, source)
)V#'qindexidx_is_dealdeal_analysisCREATE INDEX idx_is_deal ON deal_analysis(is_deal)o
3'�indexidx_deal_percentagedeal_analysisCREATE INDEX idx_deal_percentage ON deal_analysis(deal_percentage)U)sindexidx_crawled_atlistings
CREATE INDEX idx_crawled_at ON listings(crawled_at)[-{indexidx_listing_typelistingsCREATE INDEX idx_listing_type ON listings(listing_type)J
gindexidx_pricelistingsCREATE INDEX idx_price ON listings(price_usd)F _indexidx_brandlistings
CREATE INDEX idx_brand ON listings(brand)�P''�_tablecrawl_historycrawl_history CREATE TABLE crawl_history (
id INTEGER PRIMARY KEY AUTOINCREMENT,
source TEXT NOT NULL,
start_time TEXT DEFAULT CURRENT_TIMESTAMP,
end_time TEXT,
items_found INTEGER DEFAULT 0,
items_added INTEGER DEFAULT 0,
items_updated INTEGER DEFAULT 0,
status TEXT CHECK(status IN ('running', 'completed', 'failed')),
error_message TEXT
)�|''�7tabledeal_analysisdeal_analysisCREATE TABLE deal_analysis (
id INTEGER PRIMARY KEY AUTOINCREMENT,
listing_id INTEGER UNIQUE,
avg_us_price REAL,
min_us_price REAL,
max_us_price REAL,
deal_percentage REAL,
confidence_score REAL,
is_deal INTEGER DEFAULT 0,
analysis_date TEXT DEFAULT CURRENT_TIMESTAMP,
ai_notes TEXT,
FOREIGN KEY(listing_id) REFERENCES listings(id) ON DELETE CASCADE
)9M' indexsqlite_autoindex_deal_analysis_1deal_analysis�))�ktableus_comparisonsus_comparisonsCREATE TABLE us_comparisons (
id INTEGER PRIMARY KEY AUTOINCREMENT,
listing_id INTEGER,
us_source TEXT NOT NULL,
us_price_usd REAL,
us_url TEXT,
us_condition TEXT,
comparison_date TEXT DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY(listing_id) REFERENCES listings(id) ON DELETE CASCADE
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)���utablelistingslistingsCREATE TABLE listings (
id INTEGER PRIMARY KEY AUTOINCREMENT,
external_id TEXT UNIQUE,
source TEXT NOT NULL,
title TEXT NOT NULL,
brand TEXT,
model TEXT,
price_jpy REAL NOT NULL,
price_usd REAL,
currency TEXT DEFAULT 'JPY',
condition TEXT,
image_url TEXT,
thumbnail_url TEXT,
product_url TEXT,
listing_type TEXT CHECK(listing_type IN ('auction', 'buy', 'both')),
auction_end_date TEXT,
location TEXT,
seller_name TEXT,
description TEXT,
crawled_at TEXT DEFAULT CURRENT_TIMESTAMP,
M!iindexidx_is_newlistings�CREATE INDEX idx_is_new ON listings(is_new)
/C indexsqlite_autoindex_listings_2listings/C indexsqlite_autoindex_listings_1listings
� ��������������������������}wqke_YSMGA;5/)#����������������������{uoic]WQKE?93-'!
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
y
s
m
g
a
[
U
O
I
C
=
7
1
+
%
���������������������}wqke_YSMGA;5/)#����������������������{uoic]WQKE?93-'!
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
y
s
m
g
a
[
U
O
I
C
=
7
1
+
%
� � � � � � � � � � � � � � � � � � � � � } w q k e _ Y S M G A ; 5 / ) # ����������������������{uoic]WQKE?93-'! ���������������������ysmga[UOIC=71+%
���������������������}wqke_YSMGA;5/)#����������������������{uoic]WQKE?93-'! ���������������������ysmga[UOIC=71+%s.yah m�n l�j k�f j�a i�] g�Y f�T e�P d�L c�H b�D a�@ _�; ]�6 \�2 [�. Z�) X�% W�! U� T� S� Q� P�
O� N� M� L�| K�x J�t I�p H�l G�h F�d E�` D�\ C�X B�T A�P @�L ?�H >�D =�? ;�: :�5 7�0 6�+ 5�&