gourmet v2

Tables (14)

biz_classifications

  • id — BIGSERIAL
  • biz_mid_name — VARCHAR(100)
  • biz_minor_name — VARCHAR(100)
  • ksic_name — VARCHAR(100)

daily_recommendations

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • restaurant_id — BIGINT — Foreign key → restaurants.id — NOT NULL
  • meal_plan_id — BIGINT — Foreign key → meal_plans.id — NOT NULL
  • recommended_on — DATE — NOT NULL
  • pick_reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

favorites

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • restaurant_id — BIGINT — Foreign key → restaurants.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

food_categories

  • id — BIGSERIAL
  • slug — VARCHAR(50) — NOT NULL
  • label — VARCHAR(50) — NOT NULL

meal_plans

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • monthly_budget — NUMERIC(12,2) — NOT NULL
  • spent_amount — NUMERIC(12,2) — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

restaurant_menus

  • id — BIGSERIAL
  • restaurant_id — BIGINT — Foreign key → restaurants.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_signature — BOOLEAN — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • unit_price — NUMERIC(12,2)

restaurant_operating_hours

  • id — BIGSERIAL
  • restaurant_id — BIGINT — Foreign key → restaurants.id — NOT NULL
  • weekday — SMALLINT — NOT NULL
  • open_time — TIME
  • close_time — TIME
  • is_closed — BOOLEAN — NOT NULL
  • note — VARCHAR(200)

restaurant_tags

  • restaurant_id — BIGINT — Foreign key → restaurants.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tags.id — NOT NULL

restaurant_view_stats

  • id — BIGSERIAL
  • restaurant_id — BIGINT — Foreign key → restaurants.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • viewed_at — TIMESTAMPTZ — NOT NULL

restaurants

  • id — BIGSERIAL
  • category_id — BIGINT — Foreign key → food_categories.id
  • sigungu_id — BIGINT — Foreign key → sigungu_districts.id
  • biz_classification_id — BIGINT — Foreign key → biz_classifications.id
  • biz_number — VARCHAR(20)
  • name — VARCHAR(100) — NOT NULL
  • store_name — VARCHAR(100)
  • branch_name — VARCHAR(50)
  • road_address — VARCHAR(200)
  • parcel_address — VARCHAR(200)
  • latitude — DECIMAL(9,6)
  • longitude — DECIMAL(9,6)
  • description — TEXT
  • image_url — VARCHAR(500)
  • view_count — INTEGER — NOT NULL
  • avg_price — NUMERIC(12,2)
  • phone — VARCHAR(20)
  • place_url — VARCHAR(500)
  • source_note — VARCHAR(200)

search_query_logs

  • id — BIGSERIAL
  • query — VARCHAR(200)
  • query_normalized — VARCHAR(200)
  • result_count — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

sigungu_districts

  • id — BIGSERIAL
  • sigungu_name — VARCHAR(50) — NOT NULL
  • district_label — VARCHAR(100) — NOT NULL

tags

  • id — BIGSERIAL
  • slug — VARCHAR(50) — NOT NULL
  • label — VARCHAR(50) — NOT NULL

users

  • id — BIGSERIAL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(200) — NOT NULL
  • nickname — VARCHAR(50)
  • password_hash — VARCHAR(255) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • last_login_at — TIMESTAMPTZ