gourmetmate
Tables (15)
biz_classifications (공공 업종 분류)
- int (id) — Primary key — NOT NULL
- string (biz_mid_name) — NOT NULL
- string (biz_minor_name) — NOT NULL
- string (ksic_name) — NOT NULL
daily_recommendations (AI 일일 맞춤 추천)
- int (id) — Primary key — NOT NULL
- int (id2) — Foreign key → meal_plans.int — NOT NULL
- int (id22) — Foreign key — NOT NULL
- string (username2) — Foreign key — NOT NULL
- string (email2) — Foreign key — NOT NULL
- string (nickname2) — Foreign key — NOT NULL
- string (password_hash2) — Foreign key — NOT NULL
- string (role2) — Foreign key — NOT NULL
- datetime (created_at3) — Foreign key — NOT NULL
- datetime (last_login_at2) — Foreign key — NOT NULL
- int (user_id) — NOT NULL
- int (restaurant_id) — NOT NULL
- int (meal_plan_id) — NOT NULL
- date (recommended_on) — NOT NULL
- text (pick_reason) — NOT NULL
- datetime (created_at) — NOT NULL
- int (id8) — Foreign key → users.int — NOT NULL
- int (id3) — Foreign key → restaurants.int — NOT NULL
favorites (즐겨찾기 / 찜)
- int (id) — Primary key — NOT NULL
- int (user_id) — NOT NULL
- int (restaurant_id) — NOT NULL
- datdtime (created_at) — NOT NULL
- int (id2) — Foreign key → users.int — NOT NULL
- int (id3) — Foreign key → restaurants.int — NOT NULL
food_categories (음식 카테고리)
- int (id) — Primary key — NOT NULL
- string (slug) — NOT NULL
- string (label) — NOT NULL
meal_plans (유저의 식비 계획)
- int (id) — Primary key — NOT NULL
- int (user_id) — NOT NULL
- int (monthly_budget) — NOT NULL
- int (spent_amount) — NOT NULL
- date (period_start) — NOT NULL
- date (period_end) — NOT NULL
- datetime (create_at) — NOT NULL
- datetime (updated_at) — NOT NULL
- int (id3) — Foreign key → users.int — NOT NULL
restaurant_contacts (상세 연락처)
- int (id) — Primary key — NOT NULL
- int (id2) — Foreign key → restaurants.int — NOT NULL
- text (branch_name) — Foreign key → restaurants.text — NOT NULL
- string (image_url) — Foreign key → restaurants.string — NOT NULL
- intr (estaurant_id) — NOT NULL
- string (phone) — NOT NULL
- string (place_url) — NOT NULL
- text (source_note) — NOT NULL
restaurant_menus (메뉴판)
- int (id) — Primary key — NOT NULL
- int (restaurant_id) — NOT NULL
- string (name) — NOT NULL
- bool (is_signature) — NOT NULL
- int (sort_order) — NOT NULL
- int (unit_price) — NOT NULL
- int (id3) — Foreign key → restaurants.int — NOT NULL
restaurant_operating_hours (요일별 영업시간)
- int (id) — Primary key — NOT NULL
- int (restaurant_id) — NOT NULL
- int (weekday) — NOT NULL
- string (open_time) — NOT NULL
- string (close_time) — NOT NULL
- bool (is_closed) — NOT NULL
- string (note) — NOT NULL
- int (id3) — Foreign key → restaurants.int — NOT NULL
restaurant_prices (1인당 추정 식대)
- int (id) — Primary key — NOT NULL
- int (restaurant_id) — NOT NULL
- int (avg_price) — NOT NULL
restaurant_tags (매장-태그 연결 교차)
- int (id) — Primary key — NOT NULL
- int (restaurant_id) — NOT NULL
- int (tag_id) — NOT NULL
- int (id4) — Foreign key → restaurants.int — NOT NULL
- int (id3) — Foreign key → tags.int — NOT NULL
restaurants (기준테이터(식당))
- int (id) — Primary key — NOT NULL
- int (id2) — Foreign key → restaurant_prices.int — NOT NULL
- int (id3) — Foreign key → restaurant_prices.int — NOT NULL
- int (restaurant_id2) — Foreign key → restaurant_prices.int — NOT NULL
- int (avg_price2) — Foreign key → restaurant_prices.int — NOT NULL
- int (id4) — Foreign key → restaurant_prices.int — NOT NULL
- int (restaurant_id3) — Foreign key → restaurant_prices.int — NOT NULL
- int (avg_price3) — Foreign key → restaurant_prices.int — NOT NULL
- int (category_id) — NOT NULL
- int (sigungu_id) — NOT NULL
- int (biz_classification_id) — NOT NULL
- string (biz_number) — NOT NULL
- text (name) — NOT NULL
- text (store_name) — NOT NULL
- text (branch_name) — NOT NULL
- text (road_address) — NOT NULL
- text (parcel_address) — NOT NULL
- float (latitude) — NOT NULL
- float (longitude) — NOT NULL
- text (description) — NOT NULL
- string (image_url) — NOT NULL
- int (view_count) — NOT NULL
- int (id8) — Foreign key → food_categories.int — NOT NULL
- int (id5) — Foreign key → sigungu_districts.int — NOT NULL
- int (id6) — Foreign key → biz_classifications.int — NOT NULL
search_query_logs (검색어 로그)
- int (id) — Primary key — NOT NULL
- string (query) — NOT NULL
- string (query_normalized) — NOT NULL
- int (result_count) — NOT NULL
- datetime (created_at) — NOT NULL
sigungu_districts (행정구역 주소)
- int (id) — Primary key — NOT NULL
- string (sigungu_name) — NOT NULL
- string (district_label) — NOT NULL
tags (추천 태그 사전)
- int (id) — Primary key — NOT NULL
- string (slug) — NOT NULL
- string (label) — NOT NULL
users (사용자)
- int (id) — Primary key — NOT NULL
- string (username) — NOT NULL
- string (email) — NOT NULL
- string (nickname) — NOT NULL
- string (password_hash) — NOT NULL
- string (role) — NOT NULL
- datetime (created_at) — NOT NULL
- datetime (last_login_at) — NOT NULL