Preat
Tables (13)
districts
- id — int — Primary key
- region_code — int
- district_name — varchar(255)
- region_name — varchar(255)
filter
- id — bigint — Primary key — NOT NULL
- name — varchar(100)
- created_at — datetime(6)
- modified_at — datetime(6)
- is_deleted — bit
filter_restaurant
- filter_id — bigint — Foreign key → filter.id — NOT NULL
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
filter_tag
- tag_id — bigint — Foreign key → tag.id — NOT NULL
- filter_id — bigint — Foreign key → filter.id — NOT NULL
hate_foods
- id — bigint — Primary key
- image_url — varchar(15000)
- food — varchar(255)
restaurant
- id — bigint — Primary key — NOT NULL
- name — varchar(200)
- address — varchar(500)
- location — geohash
- imageUrls — text
- Field
- district_id — int — Foreign key → districts.id
- category — varchar(10)
review_images
- id — bigint — Primary key
- review_id — bigint — Foreign key → reviews.id
- created_at — datetime(6)
- modified_at — datetime(6)
- url — text
reviews
- id — bigint — Primary key
- is_deleted — bit
- rating — double
- created_at — datetime(6)
- modified_at — datetime(6)
- comment — text — ext nul
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL
- user_id — bigint — Foreign key → users.id
tag
- id — bigint — Primary key — NOT NULL
- name — varchar(100)
user_dislikes
- user_id — bigint — Foreign key → users.id
- hatefood_id — bigint — Foreign key → hate_foods.id
user_filter
- user_id — bigint — Foreign key → users.id
- filter_id — bigint — Foreign key → filter.id — NOT NULL
- role — enum
users
- id — bigint — Primary key
- baseline_score — double
- salty — int
- spicy — int
- sweet — int
- created_at — datetime(6)
- modified_at — datetime(6)
- age_range — varchar(255)
- deleted_at — varchar(30) — NOT NULL
- email — varchar(255)
- gender — varchar(255)
- nickname — varchar(255)
- profile_img_url — text
- provider — enum
- provider_id — varchar(255)
- provider_token — varchar(500)
- role — enum
- status — enum
wishes
- id — bigint — Primary key
- is_deleted — bit
- created_at — datetime(6)
- modified_at — datetime(6)
- user_id — bigint — Foreign key → users.id
- restaurant_id — bigint — Foreign key → restaurant.id — NOT NULL