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)