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