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