ㄷㄱㅇㄷㄱㅇ
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