MOMENTO(anjiyoo)

Tables (39)

Accommodation (숙소 정보)

  • accommodation_id (숙소정보id) — Primary key — NOT NULL
  • city_id (도시id) — Foreign key → County.city_id — NOT NULL
  • name (숙소명) — VARCHAR(100)
  • price (숙소가격) — decimal
  • location (숙소지역) — VARCHAR(100)
  • latitude (위도) — decimal
  • longitude (경도) — decimal
  • accommodation_type (숙소타입) — VARCHAR(100)
  • description (숙소설명) — text
  • like (숙소좋아요)

AccommodationImage (숙소이미지)

  • accommodation_image_id (숙소이미지d) — Primary key — NOT NULL
  • accommodation_id (숙소정보id) — Foreign key → Accommodation.accommodation_id — NOT NULL
  • images (숙소이미지) — image

AccommodationLike (숙소 좋아요)

  • accommodationlike_id (숙소좋아요id) — Primary key — NOT NULL
  • accommodation_id (숙소정보id) — Foreign key → Accommodation.accommodation_id — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • created_at (생성일) — date

Baenangtalk (배낭톡)

  • bae_id (배낭톡id) — Primary key — NOT NULL
  • city_id (도시id) — Foreign key → County.city_id — NOT NULL
  • bae_period_id (배낭톡여행시기id) — Foreign key → BaenangtalkPeriod.bae_period_id — NOT NULL
  • bae_month_id (배낭톡주제id) — Foreign key → BaenangtalkSubject.bae_month_id — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • bae_title (배낭톡 제목) — VARCHAR(100)
  • bae_content (배낭톡 내용) — text
  • bae_img (배낭톡 이미지) — image
  • bae_like (배낭톡 좋아요) — integer
  • bae_like_by (좋아요 누른 회원)
  • bae_date (작성일) — date

BaenangtalkComment (배낭톡 댓글)

  • bae_com_id (배낭톡댓글id) — Primary key — NOT NULL
  • bae_id (배낭톡id) — Foreign key → Baenangtalk.bae_id — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • city_id (도시id) — Foreign key → Baenangtalk.city_id — NOT NULL
  • bae_month_id (배낭톡주제id) — Foreign key → Baenangtalk.bae_month_id — NOT NULL
  • bae_period_id (배낭톡여행시기id) — Foreign key → Baenangtalk.bae_period_id — NOT NULL
  • user_id (유저id2) — Foreign key → Baenangtalk.user_id — NOT NULL
  • bae_com_content (배낭톡댓글 내용) — VARCHAR(100)
  • bae_com_like (배낭톡댓글 좋아요) — integer
  • bae_com_like_by (댓글 좋아요 누른 회원)
  • bae_com_date (작성일) — date

BaenangtalkPeriod (배낭톡 여행시기)

  • bae_period_id (배낭톡여행시기id) — Primary key — NOT NULL
  • bae_month (배낭톡 여행시기) — date

BaenangtalkSubject (배낭톡 주제)

  • bae_month_id (배낭톡주제id) — Primary key — NOT NULL
  • bae_month (배낭톡 주제) — VARCHAR(10)

BookerInfo (예약자 정보)

  • bookerinfo_id (예약자id) — Primary key — NOT NULL
  • reservation_id (항공권예약id) — Foreign key → Reservation.reservation_id — NOT NULL
  • user_id (유저id) — Foreign key → Reservation.user_id — NOT NULL
  • name (예약자명) — VARCHAR(50)
  • phone (예약자연락처) — VARCHAR(20)
  • email (예약자이메일) — email

CancellationPolicy (취소 규정)

  • cancellationpolicy_id (취소규정id) — Primary key — NOT NULL
  • policy_text (정책내용) — text
  • agree_text (동의내용) — text

ChatbotTravelInfo (지역기반챗봇)

  • chatbot_id (지역기반챗봇id) — Primary key — NOT NULL
  • city_id (도시id) — Foreign key → County.city_id — NOT NULL
  • info_location (지역 위치) — text
  • info_weather (지역 날씨) — text
  • info_tourist (지역 관광지) — text
  • info_cultural (지역 문화) — text
  • info_food (지역 음식) — text
  • info_traffic (지역 교통) — text
  • info_date (작성일) — text

CitySpot (관광지)

  • cityspot_id (관광지id) — Primary key — NOT NULL
  • city_id (도시id) — Foreign key → County.city_id — NOT NULL
  • title (관광지) — VARCHAR(50)
  • address (주소) — text
  • img_url (이미지) — image
  • content_id (관광지고유id) — integer
  • map_x (경도) — float
  • map_y (위도) — float

County (도시정보)

  • city_id (도시id) — Primary key — NOT NULL
  • city_name (도시명) — VARCHAR(10)
  • first_town_name (첫번째 하위도시명) — VARCHAR(15)
  • second_town_name (두번째 하위도시명) — VARCHAR(10)
  • third_town_name (세번째 하위도시명) — VARCHAR(10)
  • title_image (도시메인이미지) — image
  • area_code (Field6) — integer
  • cigungu1 (Field7) — integer
  • cigungu2 (Field8) — integer
  • cigungu3 (Field9) — integer

CountyImg (도시이미지)

  • city_img_id (도시이미지id) — Primary key — NOT NULL
  • city_id (도시id) — Foreign key → County.city_id — NOT NULL
  • image (도시이미지) — image

DayPlan (일자별 일정)

  • day_plan_id (일자별 일정id) — Primary key — NOT NULL
  • city_id (도시id) — Foreign key → Trip.city_id — NOT NULL
  • cityspot_id (관광지id) — Foreign key → CitySpot.cityspot_id — NOT NULL
  • memo (여행메모) — text
  • day (일자별 일정) — date

DiaryComment (여행기 댓글)

  • diary_com_id (여행기댓글id) — Primary key — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • tag_id (여행기태그id) — Foreign key → diary.tag_id — NOT NULL
  • trip_id (여행일정id) — Foreign key → diary.trip_id — NOT NULL
  • diary_com_content (댓글 내용) — VARCHAR(100)
  • diary_com_like (댓글 좋아요) — integer
  • diary_com_like_by (댓글 좋아요 누른 회원)
  • diary_com_date (작성일) — date

Faq (FAQ)

  • Faq_id — Primary key — NOT NULL
  • notice_id (공지사항id1) — Foreign key → FaqCategory.notice_id — NOT NULL
  • faq_title (Faq_질문) — VARCHAR(255)
  • faq_answer (Faq_답변) — text

FaqCategory (FAQ 카테고리)

  • notice_id (공지사항id) — Primary key — NOT NULL
  • name (카테고리명) — VARCHAR(255)

GuestInfo (투숙자정보)

  • guestinfo_id (투숙자정보id) — Primary key — NOT NULL
  • name (이름) — VARCHAR(100)
  • birth_date (생일) — date
  • gender (성별) — VARCHAR(10)

Inquiry (고객센터)

  • inquiries_id (고객센터id) — Primary key — NOT NULL
  • inquiry_cat_id (고객센터카테고리id) — Foreign key → InquiryCategory.inquiry_cat_id — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • email (고객이메일) — VARCHAR(50)
  • phone_number (고객전화번호) — VARCHAR(15)
  • inquiry_title (게시글제목) — VARCHAR(50)
  • inquiry_body (게시글본문) — text
  • created_at (작성일) — date
  • answer_status (답변상태) — boolean

InquiryCategory (고객센터 카테고리)

  • inquiry_cat_id (고객센터카테고리id) — Primary key — NOT NULL
  • name (카테고리명) — VARCHAR(255)

InquiryComment (고객센터 댓글)

  • inquiries_com_id (고객센터댓글id) — Primary key — NOT NULL
  • inquiries_id (고객센터id) — Foreign key → Inquiry.inquiries_id — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • inquiry_cat_id (고객센터카테고리id) — Foreign key → Inquiry.inquiry_cat_id — NOT NULL
  • user_id (유저id2) — Foreign key → Inquiry.user_id — NOT NULL
  • body (고객이메일) — text
  • created_at (작성일) — date

InquiryImage (고객센터 게시글 이미지)

  • inquiry_img_id (고객센터이미지id) — Primary key — NOT NULL
  • inquiries_id (고객센터id) — Foreign key → Inquiry.inquiries_id — NOT NULL
  • inquiry_cat_id (고객센터카테고리id) — Foreign key → Inquiry.inquiry_cat_id — NOT NULL
  • user_id (유저id) — Foreign key → Inquiry.user_id — NOT NULL
  • image (이미지) — image

Notice (공지사항)

  • notice_id (공지사항id) — Primary key — NOT NULL
  • notice_title (공지 제목) — VARCHAR(255)
  • notice (공지 내용) — text
  • created_at (작성일) — date

PassengerInfo (항공권 탑승객 정보)

  • passengerinfo_id (탑승객id) — Primary key — NOT NULL
  • reservation_id (항공권예약id) — Foreign key → Reservation.reservation_id — NOT NULL
  • user_id (유저id) — Foreign key → Reservation.user_id — NOT NULL
  • last_name (이름) — VARCHAR(50)
  • first_name (성) — VARCHAR(50)
  • gender (성별) — VARCHAR(10)
  • nationality (국적) — VARCHAR(50)
  • one_way_price (출발금액) — integer
  • return_price (도착금액) — integer
  • age_category (연령대) — VARCHAR(20)
  • birth_date (생일) — VARCHAR(8)

Reservation (숙소 예약)

  • reservation_id (숙소예약정보id) — Primary key — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • accommodation_id (숙소정보id) — Foreign key → Accommodation.accommodation_id — NOT NULL
  • room_id (객실정보id) — Foreign key → Room.room_id — NOT NULL
  • accommodation_id (숙소정보id1) — Foreign key → Room.accommodation_id — NOT NULL
  • reservationholderinfo_id (예약자정보id) — Foreign key → ReservationHolderInfo.reservationholderinfo_id — NOT NULL
  • guestinfo_id (투숙자정보id) — Foreign key → GuestInfo.guestinfo_id — NOT NULL
  • transportationInfo_id (예약_교통수단정보id) — Foreign key → TransportationInfo.transportationInfo_id — NOT NULL
  • check_in (체크인시간) — date
  • check_out (체크아웃시간) — date
  • cancellation_policy_agreed (예약취소 동의) — boolean
  • terms_and_conditions_agreed (이용약관 동의) — boolean
  • created_at (예약일) — date
  • reservation_amount (예약수) — decimal
  • total_amount (총 개수) — decimal
  • guests_adult (성인 인원수) — integer
  • guests_child (아동 인원수) — integer
  • telnum (예약 연락처) — VARCHAR(15)
  • merchant_uid (결제)

Reservation (항공권 예약)

  • reservation_id (항공권예약id) — Primary key — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • reservation_date (예약날짜) — date
  • number_of_people (인원수) — integer
  • departure_airport (출발지) — VARCHAR(50)
  • arrival_airport (도차지) — VARCHAR(50)
  • departure_time (탑승시간) — VARCHAR(50)
  • arrival_time (도착시간) — VARCHAR(50)
  • airline_code (공항코드) — VARCHAR(10)
  • flight_name (비행기명) — VARCHAR(50)
  • free_baggage_allowance (수화물 무게) — integer
  • return_departure_airport (왕복 출발지) — VARCHAR(50)
  • return_arrival_airport (왕복 도착지) — VARCHAR(50)
  • return_depature_time (왕복 탑승시간) — VARCHAR(50)
  • return_arrival_time (왕복 도착시간) — VARCHAR(50)
  • return_flight_number (왕복 비행기코드) — VARCHAR(50)
  • return_airline_code (왕복 공항코드) — VARCHAR(10)
  • return_flight_name (왕복 비행기명) — VARCHAR(50)
  • return_free_baggage_allowance (왕복 수화물 무게) — integer
  • merchant_uid (결제) — VARCHAR(255)

ReservationHolderInfo (예약자정보)

  • reservationholderinfo_id (예약자정보id) — Primary key — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL

Review (객실리뷰)

  • review_id (객실리뷰id) — Primary key — NOT NULL
  • accommodation_id (숙소정보id) — Foreign key → Accommodation.accommodation_id — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • reservation_id (숙소예약정보id) — Foreign key → Reservation.reservation_id — NOT NULL
  • content (리뷰내용) — text
  • created_at (작성일) — date
  • rating (별점) — integer
  • image_url (객실이미지) — image
  • travel_date (객실이용기간) — VARCHAR(10)

Room (숙소 객실 정보)

  • room_id (객실정보id) — Primary key — NOT NULL
  • accommodation_id (숙소정보id1) — Foreign key → Accommodation.accommodation_id — NOT NULL
  • name (객실명) — VARCHAR(100)
  • description (객실설명) — text
  • capacity (객실개수) — integer
  • is_free_cancellation (무료취소여부) — boolean
  • includes_breakfast (조식제공) — boolean
  • price (객실가격) — decimal
  • check_in_time (체크인시간) — time
  • check_out_time (체크아웃시간) — time
  • guide (이용안내) — text

RoomImage (객실이미지)

  • room_image_id (객실이미지d) — Primary key — NOT NULL
  • room_id (객실정보id) — Foreign key → Room.accommodation_id — NOT NULL
  • images (객실이미지) — image

TransportationInfo (예약_교통수단정보)

  • transportationInfo_id (예약_교통수단정보id) — Primary key — NOT NULL
  • public_transport (대중교통) — boolean
  • walking (도보) — boolean
  • personal_car (자차) — boolean

Trip (여행일정)

  • trip_id (여행일정id) — Primary key — NOT NULL
  • user_id (유저id) — Foreign key → User.user_id — NOT NULL
  • city_id (도시id) — Foreign key → County.city_id — NOT NULL
  • who (동행자) — VARCHAR(20)
  • start_date (출발일) — date
  • end_date (도착일) — date
  • created_at (작성일) — date

TripDate (AI여행컨셉추천_여행시기)

  • trip_date_id (AI여행컨셉추천_여행시기id) — Primary key — NOT NULL
  • date (AI여행컨셉추천_여행시기) — VARCHAR(10)

TripRecommend (AI여행컨셉추천)

  • trip_rec_id (AI여행컨셉추천id) — Primary key — NOT NULL
  • trip_who_id (AI여행컨셉추천_동행자d) — Foreign key → TripWho.trip_who_id — NOT NULL
  • trip_date_id (AI여행컨셉추천_여행시기id) — Foreign key → TripDate.trip_date_id — NOT NULL
  • cityspot_id (관광지id) — Foreign key → CitySpot.cityspot_id — NOT NULL
  • city_id (도시id) — Foreign key → CitySpot.city_id — NOT NULL
  • concept_title (컨셉 제목) — VARCHAR(50)
  • concept_content (컨셉 내용) — text
  • created_at (생성일) — date

TripWho (AI여행컨셉추천_동행자)

  • trip_who_id (AI여행컨셉추천_동행자d) — Primary key — NOT NULL
  • who (AI여행컨셉추천_동행자) — VARCHAR(10)

Trip_style (여행스타일)

  • trip_style_id (여행스타일id) — Primary key — NOT NULL
  • trip_id (여행일정id) — Foreign key → Trip.trip_id — NOT NULL
  • style (여행스타일) — VARCHAR(30)

User (유저)

  • user_id (유저id) — Primary key — NOT NULL
  • profile (프로필이미지) — image
  • nickname (닉네임) — VARCHAR(30)
  • email (이메일) — email
  • google_profile (구글로그인) — url

diary (여행기)

  • diary_id (여행기id) — Primary key — NOT NULL
  • tag_id (여행기태그id) — Foreign key → tag.tag_id — NOT NULL
  • trip_id (여행일정id) — Foreign key → Trip.trip_id — NOT NULL
  • title (여행기제목) — VARCHAR(30)
  • content (여행기내용) — text
  • image (여행기이미지) — image
  • created_at (작성일) — date
  • diary_like (좋아요) — integer
  • diary_like_by (좋아요 누른 회원)

tag (여행기 태그)

  • tag_id (여행기태그id) — Primary key — NOT NULL
  • name (태그명) — VARCHAR(50)
  • registered_date (등록일자) — date