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