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 (유저이름)