RestaurantReviewApp
Tables (5)
food (Untitled2)
- food_id (음식종류) — varchar(10) — Primary key — NOT NULL
- id (사용자이름) — varchar(10) — Foreign key → member.id — NOT NULL
member (Untitled)
- id (사용자이름) — varchar(10) — Primary key — NOT NULL
- gender (성별) — varchar(10)
- birth (생년월일) — date
- address (주소) — varchar(50)
mission (Untitled3)
- id (미션아이디) — varchar(10) — Primary key — NOT NULL
- id (가게아이디) — varchar(20) — Foreign key → store.id — NOT NULL
- id (사용자이름) — varchar(10) — Foreign key → member.id — NOT NULL
- id (리뷰아이디) — varchar(10) — Foreign key → store.id — NOT NULL
- price (기준가격) — int
- point (적립포인트) — int
- challenge (미션도전) — bookean
- success (성공요청) — boolean
- cleared_mission_count (성공한미션) — int
- reward (미션N개달성시지급포인트) — int
review (Untitled5)
- id (리뷰아이디) — varchar(10) — Primary key — NOT NULL
- id (사용자이름) — varchar(10) — Foreign key → member.id — NOT NULL
- id (가게아이디) — varchar(20)
- rate (별점) — int
- review (리뷰내용)
store (Untitled4)
- id (가게아이디) — varchar(20) — Primary key — NOT NULL
- id (리뷰아이디) — varchar(10) — Foreign key → review.id — NOT NULL
- food_id (음식종류) — varchar(10)
- rate (별점) — int
- address (식당주소) — varchar(20)
- open_time (영업시작시간) — time
- close_time (영업종료시간) — time
- open_days (영업요일) — varchar