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 (태그)