← back to Handbag Auth Nextjs

prisma/prisma/handbag-auth.db

186 lines

SQLite format 3@  .zp��	��.�T�qn��	E'�3indexdeal_analysis_listing_id_keydeal_analysisCREATE 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_idxlistings
CREATE INDEX "listings_crawled_at_idx" ON "listings"("crawled_at")t?�indexlistings_listing_type_idxlistingsCREATE INDEX "listings_listing_type_idx" ON "listings"("listing_type")k
9�
indexlistings_price_usd_idxlistingsCREATE INDEX "listings_price_usd_idx" ON "listings"("price_usd")^	1}indexlistings_brand_idxlistings
CREATE INDEX "listings_brand_idx" ON "listings"("brand")x=�#indexlistings_external_id_keylistings	CREATE UNIQUE INDEX "listings_external_id_key" ON "listings"("external_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
)�''�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
)�''�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
)�''�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
)�.))�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
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�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 DEFAUL















�
�
F�	��.�T�qn�N�O'�9indexdeal_analysis_deal_percentage_idxdeal_analysisCREATE INDEX "deal_analysis_deal_percentage_idx" ON "deal_analysis"("deal_percentage")�	E'�3indexdeal_analysis_listing_id_keydeal_analysisCREATE 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_idxlistings
CREATE INDEX "listings_crawled_at_idx" ON "listings"("crawled_at")t?�indexlistings_listing_type_idxlistingsCREATE INDEX "listings_listing_type_idx" ON "listings"("listing_type")k
9�
indexlistings_price_usd_idxlistingsCREATE INDEX "listings_price_usd_idx" ON "listings"("price_usd")^	1}indexlistings_brand_idxlistings
CREATE INDEX "listings_brand_idx" ON "listings"("brand")x=�#indexlistings_external_id_keylistings	CREATE UNIQUE INDEX "listings_external_id_key" ON "listings"("external_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
)�''�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
)�''�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
)�''�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
)�.))�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
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�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
)

�I
�
o
��
�
i	�	f�Y�U�{A%�indexprice_alerts_is_active_idxprice_alertsCREATE INDEX "price_alerts_is_active_idx" ON "price_alerts"("is_active")~C%�!indexprice_alerts_listing_id_idxprice_alertsCREATE INDEX "price_alerts_listing_id_idx" ON "price_alerts"("listing_id")�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")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_analysisCREATE 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_idxlistings
CREATE INDEX "listings_crawled_at_idx" ON "listings"("crawled_at")t?�indexlistings_listing_type_idxlistingsCREATE INDEX "listings_listing_type_idx" ON "listings"("listing_type")k
9�
indexlistings_price_usd_idxlistingsCREATE INDEX "listings_price_usd_idx" ON "listings"("price_usd")^	1}indexlistings_brand_idxlistings
CREATE INDEX "listings_brand_idx" ON "listings"("brand")x=�#indexlistings_external_id_keylistings	CREATE UNIQUE INDEX "listings_external_id_key" ON "listings"("external_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
)