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