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