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