events erd
Tables (5)
attached_photo (Untitled4)
- attached_photo_id (사진파일아이디) — Primary key — NOT NULL
- review_id (리뷰아이디) — Foreign key → review.review_id — NOT NULL
mileage (Untitled5)
- mileage_id (마일리지아이디) — Primary key — NOT NULL
- user_id (유저아이디) — Foreign key → user.user_id — NOT NULL
- review_id (리뷰아이디) — Foreign key → review.review_id — NOT NULL
- point (점수)
place (Untitled2)
- place_id (장소아이디) — Primary key — NOT NULL
- place_name (장소명)
review (Untitled)
- review_id (리뷰아이디) — Primary key — NOT NULL
- place_id (장소아이디) — Foreign key → place.place_id — NOT NULL
- user_id (유저아이디) — Foreign key → user.user_id — NOT NULL
- content (내용)
- isBonus (보너스유무)
user (Untitled3)
- user_id (유저아이디) — Primary key — NOT NULL
- name (유저이름)