place
Tables (8)
Category (카테고리)
- 카테고리ID (categoryId) — Primary key — NOT NULL
- 장소ID (placeId) — Foreign key → Marker.장소ID — NOT NULL
- 카테고리명 (name) — NOT NULL
Group (그룹)
- 그룹ID (groupId) — Primary key — NOT NULL
- 회원ID (memberId) — Foreign key → Member.회원ID — NOT NULL
- 그룹 명 (title) — NOT NULL
- Field
- Field2
Like (좋아요)
- 장소ID (placeId) — Foreign key → Marker.장소ID — NOT NULL
- 좋아요ID (likeId) — NOT NULL
- 회원ID (memberId) — NOT NULL — Foreign key → Member.회원ID — NOT NULL
Marker (마커)
- 장소ID (placeId) — Primary key — NOT NULL
- 그룹ID (groupId) — Foreign key → Group.그룹ID — NOT NULL
- 회원ID (memberId) — Foreign key → Group.회원ID — NOT NULL
- 제목 (title) — NOT NULL
- 위도 (latitude) — NOT NULL
- 경도 (longitude) — NOT NULL
- 다녀간 날짜 (went_date) — NOT NULL
- 공개 여부 (visiable)
- 조회 수 (view) — NOT NULL
MarkerRoute (마커루트)
- 마커루트ID (markerRouteId) — NOT NULL — Primary key — NOT NULL
- 장소ID (placeId) — Foreign key → Marker.장소ID — NOT NULL
- 루트ID (routeId) — NOT NULL — Foreign key → Route.루트ID — NOT NULL
Media (미디어)
- 미디어ID (mediaId) — Primary key — NOT NULL
- 장소ID (placeId) — Foreign key → Marker.장소ID — NOT NULL
- 이미지URI (imageURI) — NOT NULL
- 동영상URI (videoURI) — NOT NULL
Member (회원)
- 회원ID (memberId) — NOT NULL — Primary key — NOT NULL
- 제목 (title) — NOT NULL
- Field
- Field2
Route (루트)
- 루트ID (routeId) — NOT NULL — Primary key — NOT NULL
- 제목 (title) — NOT NULL
- 순서 (Field)
- 다녀간 날짜 (went_date) — NOT NULL
- 조회 수 (view) — NOT NULL
- 그룹ID (groupId) — Foreign key → Group.그룹ID — NOT NULL
- 회원ID (memberId) — Foreign key → Group.회원ID — NOT NULL