`prisma/data/handbags.db`

180 lines
SQLite format 3@  .*..zp�����!�>�;���y?'�indexdeal_analysis_is_deal_idxdeal_analysisCREATE INDEX "deal_analysis_is_deal_idx" ON "deal_analysis"("is_deal")�
O'�9indexdeal_analysis_deal_percentage_idxdeal_analysisCREATE INDEX "deal_analysis_deal_percentage_idx" ON "deal_analysis"("deal_percentage")�	E'�3indexdeal_analysis_listing_id_keydeal_analysis
CREATE UNIQUE INDEX "deal_analysis_listing_id_key" ON "deal_analysis"("listing_id")�K�Eindexlistings_external_id_source_keylistingsCREATE UNIQUE INDEX "listings_external_id_source_key" ON "listings"("external_id", "source")n
;�indexlistings_crawled_at_idxlistingsCREATE INDEX "listings_crawled_at_idx" ON "listings"("crawled_at")t	?�indexlistings_listing_type_idxlistings
CREATE INDEX "listings_listing_type_idx" ON "listings"("listing_type")k9�
indexlistings_price_usd_idxlistings	CREATE INDEX "listings_price_usd_idx" ON "listings"("price_usd")^1}indexlistings_brand_idxlistingsCREATE INDEX "listings_brand_idx" ON "listings"("brand")x=�#indexlistings_external_id_keylistingsCREATE UNIQUE INDEX "listings_external_id_key" ON "listings"("external_id")�0''�tablecrawl_historycrawl_historyCREATE TABLE "crawl_history" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "source" TEXT NOT NULL,
    "start_time" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "end_time" DATETIME,
    "items_found" INTEGER NOT NULL DEFAULT 0,
    "items_added" INTEGER NOT NULL DEFAULT 0,
    "items_updated" INTEGER NOT NULL DEFAULT 0,
    "status" TEXT NOT NULL,
    "error_message" TEXT
)�.''�tabledeal_analysisdeal_analysisCREATE TABLE "deal_analysis" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "listing_id" INTEGER NOT NULL,
    "avg_us_price" REAL,
    "min_us_price" REAL,
    "max_us_price" REAL,
    "deal_percentage" REAL,
    "confidence_score" REAL,
    "is_deal" INTEGER NOT NULL DEFAULT 0,
    "analysis_date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "ai_notes" TEXT,
    CONSTRAINT "deal_analysis_listing_id_fkey" FOREIGN KEY ("listing_id") REFERENCES "listings" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)�U))�etableus_comparisonsus_comparisonsCREATE TABLE "us_comparisons" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "listing_id" INTEGER NOT NULL,
    "us_source" TEXT NOT NULL,
    "us_price_usd" REAL,
    "us_url" TEXT,
    "us_condition" TEXT,
    "comparison_date" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    CONSTRAINT "us_comparisons_listing_id_fkey" FOREIGN KEY ("listing_id") REFERENCES "listings" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�t�;tablelistingslistingsCREATE TABLE "listings" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "external_id" TEXT,
    "source" TEXT NOT NULL,
    "title" TEXT NOT NULL,
    "brand" TEXT,
    "model" TEXT,
    "price_jpy" REAL NOT NULL,
    "price_usd" REAL,
    "currency" TEXT NOT NULL DEFAULT 'JPY',
    "condition" TEXT,
    "image_url" TEXT,
    "thumbnail_url" TEXT,
    "product_url" TEXT,
    "listing_type" TEXT,
    "auction_end_date" TEXT,
    "location" TEXT,
    "seller_name" TEXT,
    "description" TEXT,
    "crawled_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "is_active" INTEGER NOT NULL DEFAULT 1,
    "size" TEXT,
    "color" TEXT,
    "material" TEXT,
    "retail_msrp" REAL,
    "appreciation_percent" R

�����1)us_comparisonslistings'deal_analysis'crawl_history









	





h�
�h/	%�hhhh����z�''�utableprice_historyprice_historyCREATE TABLE "price_history" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "listing_id" INTEGER NOT NULL,
    "external_id" TEXT NOT NULL,
    "source" TEXT NOT NULL,
    "price_jpy" REAL NOT NULL,
    "price_usd" REAL,
    "condition" TEXT,
    "listing_type" TEXT,
    "recorded_at" TEXT NOT NULL,
    "is_available" INTEGER NOT NULL DEFAULT 1,
    CONSTRAINT "price_history_listing_id_fkey" FOREIGN KEY ("listing_id") REFERENCES "listings" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)y?'�indexdeal_analysis_is_deal_idxdeal_analysisCREATE INDEX "deal_analysis_is_deal_idx" ON "deal_analysis"("is_deal")�
O'�9indexdeal_analysis_deal_percentage_idxdeal_analysisCREATE INDEX "deal_analysis_deal_percentage_idx" ON "deal_analysis"("deal_percentage")�	E'�3indexdeal_analysis_listing_id_keydeal_analysis
CREATE UNIQUE INDEX "deal_analysis_listing_id_key" ON "deal_analysis"("listing_id")�K�Eindexlistings_external_id_source_keylistingsCREATE UNIQUE INDEX "listings_external_id_source_key" ON "listings"("external_id", "source")n
;�indexlistings_crawled_at_idxlistingsCREATE INDEX "listings_crawled_at_idx" ON "listings"("crawled_at")t	?�indexlistings_listing_type_idxlistings
CREATE INDEX "listings_listing_type_idx" ON "listings"("listing_type")k9�
indexlistings_price_usd_idxlistings	CREATE INDEX "listings_price_usd_idx" ON "listings"("price_usd")^1}indexlistings_brand_idxlistingsCREATE INDEX "listings_brand_id�4%%�+tableprice_alertsprice_alertsCREATE TABLE "price_alerts" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "listing_id" INTEGER NOT NULL,
    "external_id" TEXT NOT NULL,
    "user_email" TEXT,
    "target_price" REAL NOT NULL,
    "alertType" TEXT NOT NULL DEFAULT 'below',
    "is_active" INTEGER NOT NULL DEFAULT 1,
    "created_at" TEXT NOT NULL,
    "triggered_at" TEXT,
    "notified" INTEGER NOT NULL DEFAULT 0
)
	zK�Eindexlistings_external_id_source_keylistingsCREATE UNIQUE INDEX "listings_external_id_source_key" ON "listings"�	E'�3indexdeal_analysis_listing_id_keydeal_analysisCREATE UNIQUE INDEX "deal_analysis_listing_id_key" ON "deal_analysis"("listing_id")�''�Mtabledeal_analysisdeal_analysisCREATE TABLE "deal_analysis" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "listing_id" INTEGER NOT NULL,
    "avg_us_price" REAL,
    "min_us_price" REAL,
    "max_us_price" REAL,
    "deal_percentage" REAL,
    "confidence_score" REAL,
    "is_deal" INTEGER NOT NULL DEFAULT 0,
    "analysis_date" TEXT,
    "ai_notes" TEXT,
    CONSTRAINT "deal_analysis_listing_id_fkey" FOREIGN KEY ("listing_id") REFERENCES "listings" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)�''�Itablecrawl_historycrawl_historyCREATE TABLE "crawl_history" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "source" TEXT NOT NULL,
    "start_time" TEXT,
    "end_time" TEXT,
    "items_found" INTEGER NOT NULL DEFAULT 0,
    "items_added" INTEGER NOT NULL DEFAULT 0,
    "items_updated" INTEGER NOT NULL DEFAULT 0,
    "status" TEXT NOT NULL,
    "error_message" TEXT
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)��;tablelistingslistingsCREATE TABLE "listings" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "external_id" TEXT,
    "source" TEXT NOT NULL,
    "title" TEXT NOT NULL,
    "brand" TEXT,
    "mode�''�utableprice_historyprice_historyCREATE TABLE "price_history" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "listing_id" INTEGER NOT NULL,
    "external_id" TEXT NOT NULL,
    "source" TEXT NOT NULL,
    "price_jpy" REAL NOT NULL,
    "price_usd" REAL,
    "condition" TEXT,
    "listing_type" TEXT,
    "recorded_at" TEXT NOT NULL,
    "is_available" INTEGER NOT NULL DEFAULT 1,
    CONSTRAINT "price_history_listing_id_fkey" FOREIGN KEY ("listing_id") REFERENCES "listings" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)

H��[	�	y	�6�E�x�k
��
j�:11�tablenew_us_comparisonsnew_us_comparisonsCREATE TABLE "new_us_comparisons" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "listing_id" INTEGER NOT NULL,
    "us_source" TEXT NOT NULL,
    "us_price_usd" REAL,
    "us_url" TEXT,
    "us_condition" TEXT,
    "comparison_date" TEXT,
    CONSTRAIN~"C%�!indexprice_alerts_listing_id_idxprice_alertsCREATE INDEX "price_alerts_listing_id_idx" ON "price_alerts"("listing_id")�K�Eindexlistings_external_id_source_keylistingsCREATE UNIQUE INDEX "listings_external_id_source_key" ON "listings"("external_id", "source")n;�indexlistings_crawled_at_idxlistings
CREATE INDEX "listings_crawled_at_idx" ON "listings"("crawled_at")=''�Itablecrawl_historycrawl_historyCREATE TABL�611�.))�tableus_comparisonsus_comparisonsCREATE TABLE "us_comparisons" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "listing_id" INTEGER NOT NULL,
    "us_source" TEXT NOT NULL,
    "us_price_usd" REAL,
    "us_url" TEXT,
    "us_condition" TEXT,
    "comparison_date" TEXT,
    CONSTRAINT "us_comparisons_listing_id_fkey" FOREIGN KEY ("listing_id") REFERENCES "listings" ("id") ON DELETE CASCADE ON UPDATE CASCADE
)t?�indexlistings_listing_type_idxlistings	CREATE INDEX "listings_listing_type_idx" ON "listings"("listing_type")k9�
indexlistings_price_usd_idxlistingsCREATE INDEX "listings_price_usd_idx" ON "listings"("price_usd")^1}indexlistings_brand_idxlistingsCREATE INDEX "listings_brand_idx" ON "listings"("brand")x=�#indexlistings_external_id_keylistingsCREATE UNIQUE INDEX "listings_external_id_key" ON "listings"("external_id")�e�tablelistingslistingsCREATE TABLE "listings" (
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    "external_id" TEXT,
    "source" TEXT NOT NULL,
    "title" TEXT NOT NULL,
    "brand" TEXT,
    "model" TEXT,
    "price_jpy" REAL NOT NULL,
    "price_usd" REAL,
    "currency" TEXT,
    "condition" TEXT,
    "image_url" TEXT,
    "thumbnail_url" TEXT,
    "product_url" TEXT,
    "listing_type" TEXT,
    "auction_end_date" TEXT,
    "location" TEXT,
    "seller_name" TEXT,
    "description" TEXT,
    "crawled_at" TEXT,
    "is_active" INTEGER NOT NULL DEFAULT 1,
    "is_new" INTEGER DEFAULT 0
)y?'�indexdeal_analysis_is_deal_idxdeal_analysisCREATE INDEX "deal_analysis_is_deal_idx" ON "deal_analysis"("is_deal")�O'�9indexdeal_analysis_deal_percentage_idxdeal_analysis
CREATE INDEX "deal_analysis_deal_percentage_idx" ON "deal_analysis"("deal_percentage"){#A%�indexprice_alerts_is_active_idxprice_alertsCREATE INDEX "price_alerts_is_active_idx" ON "price_alerts"("is_active")�!E%�%indexprice_alerts_external_id_idxprice_alertsCREATE INDEX "price_alerts_external_id_idx" ON "price_alerts"("external_id")� G'�)indexprice_history_recorded_at_idxprice_historyCREATE INDEX "price_history_recorded_at_idx" ON "price_history"("recorded_at")�E'�%indexprice_history_listing_id_idxprice_historyCREATE INDEX "price_history_listing_id_idx" ON "price_history"("listing_id")�G'�)indexprice_history_external_id_idxprice_historyCREATE INDEX "price_history_external_id_idx" ON "price_history"("external_id")