erd

Tables (9)

Mission (Untitled)

  • 미션id (Id) — int — Primary key — NOT NULL — AutoIncrement
  • 제목 (title) — varchar(200) — NOT NULL
  • 내용 (contents) — text — NOT NULL
  • 음식점ID (store_id) — int — Foreign key → Store.음식점ID — NOT NULL — Auto Increment
  • 가격 (price) — int — NOT NULL
  • 적립비율 (ratio) — int — NOT NULL

Review (Untitled2)

  • 리뷰ID (id) — int — Primary key — NOT NULL — AutoIncrement
  • 내용 (contents) — text — NOT NULL
  • 사진 (image_url) — varchar(255)
  • 제목 (title) — varchar(40) — NOT NULL
  • 별점 (star) — double — NOT NULL
  • 유저ID (Id) — int — Foreign key → User.유저ID — NOT NULL — AutoIncrement
  • 음식점ID (id2) — int — Foreign key → Store.음식점ID — NOT NULL — Auto Increment
  • 생성날짜 (created_date) — Date — NOT NULL

Store (Untitled5)

  • 음식점ID (id) — int — Primary key — NOT NULL — Auto Increment
  • 음식점 이름 (name) — varchar(40) — NOT NULL
  • 지역 (region) — varchar(40) — NOT NULL
  • 주소 (address) — varchar(255) — NOT NULL
  • 영업시작 (start) — time
  • 영업종료 (end) — time

User

  • 유저ID (Id) — int — Primary key — NOT NULL — AutoIncrement
  • 이메일 (email) — varchar(40) — NOT NULL
  • 패스워드 (password) — varchar(40) — NOT NULL
  • 포인트 (point) — int
  • 이름 (nickname) — varchar(20) — NOT NULL
  • 성별 (Field) — varchar(20)
  • 생년월일 (birthday) — Date — NOT NULL
  • 주소 (address) — varchar(255) — NOT NULL

User_mission (Untitled3)

  • 유저 미션 ID (user_mission_id) — int — Primary key — NOT NULL — AutoIncrement
  • 완료여부 (solved) — bool — NOT NULL
  • 유저ID (user_id) — int — Foreign key → User.유저ID — NOT NULL — AutoIncrement
  • 미션id (mission_id) — int — Foreign key → Mission.미션id — NOT NULL — AutoIncrement
  • 만료날짜 (expired_date) — Date — NOT NULL

food_category (Untitled4)

  • 음식ID (id) — int — Primary key — NOT NULL — Auto Increment
  • 음식종류 (name) — varchar(40) — NOT NULL

food_store (Untitled7)

  • 음식점ID (id) — int — Foreign key → Store.음식점ID — NOT NULL — Auto Increment
  • 음식ID (id2) — int — Foreign key → food_category.음식ID — NOT NULL — Auto Increment

image (Untitled8)

  • 사진ID (Id) — int — Primary key — NOT NULL — autoIncrement
  • 이미지URL (Image_URL) — varchar(255) — NOT NULL
  • 이미지타입 (type) — varchar(40) — NOT NULL
  • 리뷰ID (id) — int — Foreign key → Review.리뷰ID — NOT NULL — AutoIncrement
  • 음식점ID (id2) — int — Foreign key → Store.음식점ID — NOT NULL — Auto Increment

user_food (Untitled6)

  • 유저ID (Id) — int — Foreign key → User.유저ID — NOT NULL — AutoIncrement
  • 음식ID (id) — int — Foreign key → food_category.음식ID — NOT NULL — Auto Increment