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