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)