ㄷㄱㅇㄷㄱㅇ

Tables (9)

analysis_runs

  • id — CHAR(36) — Primary key — NOT NULL
  • receipt_id — CHAR(36) — Foreign key → receipts.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → auth_users.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • summary — JSON
  • error_message — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

auth_users

  • id — CHAR(36) — Primary key — NOT NULL
  • email — VARCHAR(255)

categories

  • id — CHAR(36) — Primary key — NOT NULL
  • parent_id — CHAR(36) — Foreign key → categories.id
  • slug — VARCHAR(100) — NOT NULL
  • name_ko — VARCHAR(100) — NOT NULL
  • description — TEXT
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

price_snapshots

  • id — CHAR(36) — Primary key — NOT NULL
  • source — VARCHAR(100) — NOT NULL
  • source_item_id — VARCHAR(100)
  • item_name — VARCHAR(255) — NOT NULL
  • normalized_name — VARCHAR(255)
  • area_name — VARCHAR(100)
  • average_price — DECIMAL(12, 2) — NOT NULL
  • price_unit — VARCHAR(50)
  • surveyed_at — DATE
  • raw_payload — JSON
  • created_at — DATETIME — NOT NULL

profiles

  • id — CHAR(36) — Foreign key → auth_users.id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(255)
  • avatar_url — TEXT
  • provider — VARCHAR(50) — NOT NULL
  • locale — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

receipt_item_price_comparisons

  • id — CHAR(36) — Primary key — NOT NULL
  • receipt_item_id — CHAR(36) — Foreign key → receipt_items.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → auth_users.id — NOT NULL
  • price_snapshot_id — CHAR(36) — Foreign key → price_snapshots.id
  • purchase_price — DECIMAL(12, 2) — NOT NULL
  • average_price — DECIMAL(12, 2)
  • price_unit — VARCHAR(50)
  • market_price_percentile — DECIMAL(5, 2)
  • market_price_sample_size — INT
  • overspending_rate — DECIMAL(8, 4)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

receipt_items

  • id — CHAR(36) — Primary key — NOT NULL
  • receipt_id — CHAR(36) — Foreign key → receipts.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → auth_users.id — NOT NULL
  • category_id — CHAR(36) — Foreign key → categories.id
  • item_name — VARCHAR(255) — NOT NULL
  • normalized_name — VARCHAR(255)
  • quantity — DECIMAL(12, 3) — NOT NULL
  • unit — VARCHAR(50)
  • unit_price — DECIMAL(12, 2)
  • total_price — DECIMAL(12, 2) — NOT NULL
  • confidence — DECIMAL(5, 4)
  • line_index — INT
  • is_user_edited — BOOLEAN — NOT NULL
  • raw_payload — JSON
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

receipts

  • id — CHAR(36) — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key → auth_users.id — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • image_path — TEXT
  • merchant_name — VARCHAR(255)
  • purchased_at — DATETIME — NOT NULL
  • total_amount — DECIMAL(12, 2)
  • raw_ocr_text — TEXT
  • parser_version — VARCHAR(100)
  • error_message — TEXT
  • metadata — JSON
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

saving_tips

  • id — CHAR(36) — Primary key — NOT NULL
  • user_id — CHAR(36) — Foreign key → auth_users.id — NOT NULL
  • receipt_item_id — CHAR(36) — Foreign key → receipt_items.id
  • comparison_id — CHAR(36) — Foreign key → receipt_item_price_comparisons.id
  • title — VARCHAR(255) — NOT NULL
  • tip — TEXT — NOT NULL
  • suggested_price — DECIMAL(12, 2)
  • priority — INT — NOT NULL
  • generated_by — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL