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