11

Tables (4)

Review (리뷰)

  • riview_id (리뷰아이디) — Primary key — NOT NULL
  • place_id (장소아이디) — Foreign key → place.place_id — NOT NULL
  • user_id (유저아이디) — Foreign key → User.user_id — NOT NULL
  • title (제목)
  • content (내용)
  • upload_img (첨부사진)
  • tag (태그)

User (회원)

  • user_id (유저아이디) — Primary key — NOT NULL
  • username (이름(아이디))
  • email (이메일)
  • name (이름)
  • passwd (패스워드)
  • birthdate (생년월일)
  • bookmark_list (북마크리스트)

bookmark (북마크)

  • bookmark_id (북마크아이디) — Primary key — NOT NULL
  • user_id (유저아이디) — Foreign key → User.user_id — NOT NULL
  • place_id (장소아이디2) — Foreign key → place.place_id — NOT NULL

place (장소)

  • place_id (장소아이디) — Primary key — NOT NULL
  • name (장소이름)
  • content (내용)
  • location (위치)
  • place_img (장소이미지)
  • tag (태그)