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