TravelEye

Tables (7)

FAVORITE

  • id (favoriteId) — Primary key — NOT NULL
  • id (memberId) — Foreign key → MEMBER.id — NOT NULL
  • name (restaurantName)
  • id (restaurantId (Google API))

LANDMARK

  • id (landmarkId) — Primary key — NOT NULL
  • 대륙 (continent) — NOT NULL
  • 국가 (country) — NOT NULL
  • 도시 (city) — NOT NULL
  • 장소이름 (place)
  • 위도 (latitude)
  • 경도 (longitude)
  • 도로명주소 (address)

MEMBER

  • id (memberId) — Primary key — NOT NULL
  • uuid
  • 이메일 (email) — NOT NULL
  • 별명 (nickname)
  • 비밀번호 (password) — NOT NULL
  • 번호 (phoneNumber)
  • 성별 (gender) — NOT NULL
  • 나이 (age) — NOT NULL
  • 위치공유 (shareLocation) — Boolean
  • 권한 (authority) — NOT NULL
  • 자기소개 (introduction)
  • 온도 (temperature)
  • 설문조사항목1 (travelStyle1)
  • 설문조사항목2 (travelStyle2)
  • 설문조사항목3 (travelStyle3)
  • 설문조사항목4 (travelStyle4)
  • 설문조사항목5 (travelStyle5)
  • 설문조사항목6 (travelStyle6)
  • 설문조사항목7 (travelStyle7)
  • 설문조사항목8 (travelStyle8)

MEMBER_LOCATION

  • id (memberLocationId) — Primary key — NOT NULL
  • id (memberId) — Foreign key → MEMBER.id — NOT NULL
  • 위도 (latitude)
  • 경도 (longitude)

MEMBER_MAP

  • id (memberMapId) — Primary key — NOT NULL
  • 신청자 (requester_id) — Primary key — NOT NULL
  • 대기자 (receiver_id) — Foreign key → MEMBER.id — NOT NULL
  • id (landmarkId) — Foreign key → LANDMARK.id — NOT NULL
  • 상태 (state)

TRIP

  • id (tripId) — Primary key — NOT NULL
  • id (memberId) — Foreign key → MEMBER.id — NOT NULL
  • 국가 (country)
  • 도시 (city)
  • 시작시간 (startDate)
  • 종료시간 (endDate)
  • 별명 (title)
  • Field

TRIP_MEMO

  • id (tripMemoId) — Primary key — NOT NULL
  • id (landmarkId) — Foreign key → LANDMARK.id — NOT NULL
  • id (tripId) — Foreign key → TRIP.id — NOT NULL
  • id (memberId) — Foreign key → TRIP.id — NOT NULL
  • memo
  • 날짜 (date)