capstone
Tables (9)
analyses
- analysis_id — BIGINT
- cart_id — BIGINT — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- price_weight — DECIMAL(5, 2) — NOT NULL
- distance_weight — DECIMAL(5, 2) — NOT NULL
cart
- cart_id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
cart_histories
- history_id — BIGINT
- cart_id — BIGINT — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP
- market_summary — VARCHAR(255)
- market_images — JSON
cart_items
- item_id — BIGINT
- cart_id — BIGINT — NOT NULL
- product_info_id — BIGINT — NOT NULL
- quantity — DECIMAL(10, 2) — NOT NULL
mart
- mart_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- type — ENUM('ONLINE', 'OFFLINE') — NOT NULL
- location — VARCHAR(255)
- distance — DECIMAL(10, 2)
- delivery_fee — DECIMAL(10, 2)
- logo_url — VARCHAR(255)
product
- product_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255)
product_info
- product_info_id — BIGINT
- product_id — BIGINT — NOT NULL
- mart_id — BIGINT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- weight — DECIMAL(10, 2) — NOT NULL
- unit — ENUM('g', 'kg', 'item', 'ml', 'l') — NOT NULL
- price_per_100g — DECIMAL(10, 2)
recipes
- recipe_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- ingredients — TEXT — NOT NULL
recommendation_result
- recommendation_id — BIGINT
- analysis_id — BIGINT — NOT NULL
- mart_id — BIGINT — NOT NULL
- total_price — DECIMAL(10, 2) — NOT NULL
- price_per_100g — DECIMAL(10, 2)
- distance — DECIMAL(10, 2)
- delivery_fee — DECIMAL(10, 2)