A701

Tables (13)

events

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • menu_id — BIGINT — NOT NULL
  • event_type — ENUM('view','click','like','dislike','order','skip') — NOT NULL
  • strength — TINYINT — NOT NULL
  • session_id — CHAR(36)
  • ctx — JSON
  • ts — TIMESTAMP — NOT NULL
  • INDEX — (user_id, ts)
  • INDEX — (menu_id, ts)
  • INDEX — (event_type, ts)
  • INDEX — (user_id, menu_id, ts)

item_factors

  • menu_id — BIGINT
  • dim — SMALLINT — NOT NULL
  • vec — BLOB — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

menu_tags

  • menu_id — BIGINT — Primary key — NOT NULL
  • tag_id — INT — Primary key — NOT NULL

menus

  • id — BIGINT
  • restaurant_id — BIGINT — NOT NULL
  • name — VARCHAR(160) — NOT NULL
  • price_band — ENUM('₩','₩₩','₩₩₩') — NOT NULL
  • spice_level — TINYINT — NOT NULL
  • is_available — TINYINT(1) — NOT NULL
  • meta — JSON
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — (restaurant_id)
  • INDEX — (price_band)
  • INDEX — (is_available)

rec_audit

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • request_ctx — JSON — NOT NULL
  • candidate_ids — JSON — NOT NULL
  • rerank_scores — JSON — NOT NULL
  • ts — TIMESTAMP — NOT NULL
  • INDEX — (user_id, ts)

restaurant_vibes

  • restaurant_id — BIGINT — Primary key — NOT NULL
  • vibe_id — INT — Primary key — NOT NULL
  • weight — FLOAT — NOT NULL

restaurants

  • id — BIGINT
  • name — VARCHAR(120) — NOT NULL
  • price_band — ENUM('₩','₩₩','₩₩₩') — NOT NULL
  • lat — DECIMAL(10,7)
  • lng — DECIMAL(10,7)
  • open_hours — JSON
  • is_open — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — (price_band)
  • INDEX — (is_open)

tags

  • id — INT
  • name — VARCHAR(64) — NOT NULL
  • kind — ENUM('ingredient','style','cuisine','diet','etc') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • INDEX — (kind)

user_factors

  • user_id — BIGINT
  • dim — SMALLINT — NOT NULL
  • vec — BLOB — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

user_priors

  • user_id — BIGINT
  • price_pref — ENUM('₩','₩₩','₩₩₩')
  • vibe_weights — JSON
  • distance_pref — ENUM('near','mid','far')
  • wait_tolerance — ENUM('low','mid','high')
  • updated_at — TIMESTAMP — NOT NULL

user_tag_weights

  • user_id — BIGINT — Primary key — NOT NULL
  • tag_id — INT — Primary key — NOT NULL
  • weight — FLOAT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGINT
  • gender — ENUM('M','F','U')
  • birth_year — SMALLINT
  • created_at — TIMESTAMP — NOT NULL

vibes

  • id — INT
  • name — VARCHAR(48) — NOT NULL