Maumkkut

Tables (8)

Group_members (사용자_그룹_중계테이블)

  • pk (member_id) — Integer — Primary key — NOT NULL
  • pk (user_id) — Integer — Foreign key → Users.pk — NOT NULL
  • pk (group_id) — Integer — Foreign key → Groups.pk — NOT NULL

Groups (여행그룹)

  • pk (group_id) — Integer — Primary key — NOT NULL
  • 사람 수 (num) — Integer
  • 여행유형 (group_type) — Text
  • 그룹 이름 (group_name) — Text

Route_plan (관광계획DB)

  • pk (route_id) — Integer — Primary key — NOT NULL
  • 숙소 (lodge) — Text
  • 지역 (route_area) — Integer
  • 이름 (route_name) — Text
  • 시작날짜 (tour_startdate) — Datetime
  • 종료날짜 (tour_enddate) — Datetime
  • pk (group_id) — Integer — Foreign key → Groups.pk — NOT NULL

Tour_data (관광지 데이터)

  • pk (tour_id) — Integer — Primary key — NOT NULL
  • 시군구코드 (sigungucode) — Integer
  • 주소 (addr1) — Text
  • 상세주소 (addr2) — Text
  • 사진 (image) — Text
  • 대분류 (cat1) — Integer
  • 중분류 (cat2) — Integer
  • 소분류 (cat3) — Integer
  • 타입 (type_id) — Integer
  • X좌표 (mapx) — Float
  • Y좌표 (mapy) — Float
  • 이름 (title) — Text
  • 우편번호 (zipcode) — Integer
  • 전화번호 (tel) — Varchar(13)
  • 시작날짜 (eventstartdate) — Datetime
  • 종료날짜 (eventenddate) — Datetime

Tour_plan_data (관광계획_관광지_중계테이블)

  • pk (plan_tour_pk) — Integer — Primary key — NOT NULL
  • pk (tour_id) — Integer — Foreign key → Tour_data.pk — NOT NULL
  • pk (route_id) — Integer — Foreign key → Route_plan.pk — NOT NULL
  • seq (tour_seq) — Integer

Users (사용자)

  • pk (user_id) — Integer — Primary key — NOT NULL
  • name (user_name) — Varchar(10)
  • 나이 (user_age) — Integer
  • 여행유형 (user_type) — Text — NOT NULL
  • 여행변수1 (user_healing) — Integer — NOT NULL
  • 여행변수2 (user_relax) — Integer — NOT NULL
  • 여행변수3 (user_nature) — Integer — NOT NULL
  • 여행변수4 (user_exhibit) — Integer — NOT NULL
  • 여행변수5 (user_food) — Integer — NOT NULL
  • 여행변수6 (user_adventure) — Integer — NOT NULL
  • 여행변수7 (user_people) — Integer — NOT NULL
  • 여행변수8 (user_shopping) — Integer — NOT NULL
  • 여행변수9 (user_photo) — Integer — NOT NULL

tour_dislike (사용자_싫어요_중계테이블)

  • pk (user_dislike_id) — Integer — Primary key — NOT NULL
  • pk (user_id) — Integer — Foreign key → Users.pk — NOT NULL
  • pk (tour_id) — Integer — Foreign key → Tour_data.pk — NOT NULL

tour_like (사용자_좋아요_중계테이블)

  • pk (user_like_id) — Integer — Primary key — NOT NULL
  • pk (user_id) — Integer — Foreign key → Users.pk — NOT NULL
  • pk (tour_id) — Integer — Foreign key → Tour_data.pk — NOT NULL