omakase

Tables (8)

Count

  • ID (count_id) — bigint — Primary key — NOT NULL
  • 조회수 (view) — int
  • 좋아요수 (like) — int
  • 찜수 (dib) — int

Dib

  • ID (restaurant_id) — bigint — Foreign key → Restaurant.ID — NOT NULL
  • ID (user_id) — bigint — Foreign key → User.ID — NOT NULL

Dictionary

  • ID (dictionary_id) — bigint — Primary key — NOT NULL
  • 용어 (term) — varchar
  • 풀이 (desc) — varchar
  • 설명 (explan) — varchar
  • url — varchar

Like

  • ID (like_id) — bigint — Primary key — NOT NULL
  • ID (restaurant_id) — bigint — Foreign key → Restaurant.ID — NOT NULL
  • ID (user_id) — bigint — Foreign key → User.ID — NOT NULL

Menu

  • ID (menu_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 가격 (price) — int
  • ID (user_id) — bigint — Foreign key → User.ID — NOT NULL

Restaurant

  • ID (restaurant_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — varchar
  • 넘버링 (numbering) — int
  • 주소 (address) — varchar
  • 전화번호 (tell_number) — varchar
  • 주차가능여부 (parking_flag) — tinyint
  • 가격등급 (scale) — varchar
  • 휴무일 (holiday) — varchar
  • 영업일 (opening_day) — varchar
  • 영업시간 (opening_hour) — varchar
  • 메뉴ID (menu_id) — bigint
  • 좋아요ID (like_id) — bigint
  • 찜ID (dib_id) — bigint
  • 리뷰ID (review_id) — bigint

Review

  • ID (review_id) — bigint — Primary key — NOT NULL
  • 별점 (grade) — float
  • 내용 (contents) — varchar
  • ID (restaurant_id) — bigint — Foreign key → Restaurant.ID — NOT NULL
  • ID (user_id) — bigint — Foreign key → User.ID — NOT NULL

User

  • ID (user_id) — bigint — Primary key — NOT NULL
  • email — varchar
  • 비밀번호 (password) — varchar
  • 닉네임 (nickname) — varchar
  • 주소 (address) — varchar
  • 프로필이미지 (profile_img) — varchar