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