AIHub 제주 여행로그 데이터
테이블 (10)
aihub_activity
- activity_type_cd — VARCHAR(20) — 기본 키 — NOT NULL
- activity_type_seq — SMALLINT — 기본 키 — NOT NULL
- travel_id — VARCHAR(20) — 외래 키 → aihub_visit.travel_id — NOT NULL
- visit_area_id — VARCHAR(20) — 외래 키 → aihub_visit.visit_area_id — NOT NULL
- activity_etc — VARCHAR(500)
- activity_dtl — TEXT
- rsvt_yn — CHAR(1)
- expnd_se — VARCHAR(20)
- admission_se — VARCHAR(20)
aihub_activity_consume
- consume_his_seq — SMALLINT — 기본 키 — NOT NULL
- consume_his_sno — SMALLINT — 기본 키 — NOT NULL
- travel_id — VARCHAR(20) — 외래 키 → aihub_activity.travel_id — NOT NULL
- visit_area_id — VARCHAR(20) — 외래 키 → aihub_activity.visit_area_id — NOT NULL
- activity_type_cd — VARCHAR(20) — 외래 키 → aihub_activity.activity_type_cd — NOT NULL
- activity_type_seq — SMALLINT — 외래 키 → aihub_activity.activity_type_seq — NOT NULL
- payment_num — SMALLINT — NOT NULL
- brno — VARCHAR(20)
- store_nm — VARCHAR(255)
- road_nm_addr — VARCHAR(500)
- lotno_addr — VARCHAR(500)
- road_nm_cd — VARCHAR(20)
- lotno_cd — VARCHAR(20)
- payment_dt — DATETIME
- payment_mthd_se — VARCHAR(20) — NOT NULL
- payment_amt_won — BIGINT
- payment_etc — TEXT
- sgg_cd — VARCHAR(20)
aihub_advance_consume
- adv_seq — SMALLINT — 기본 키 — NOT NULL
- travel_id — VARCHAR(20) — 외래 키 → aihub_travel.travel_id — NOT NULL
- adv_nm — VARCHAR(255) — NOT NULL
- payment_num — SMALLINT — NOT NULL
- brno — VARCHAR(20)
- store_nm — VARCHAR(255)
- road_nm_addr — VARCHAR(500)
- lotno_addr — VARCHAR(500)
- road_nm_cd — VARCHAR(20)
- lotno_cd — VARCHAR(20)
- payment_dt — DATETIME
- payment_mthd_se — VARCHAR(20) — NOT NULL
- payment_amt_won — BIGINT — NOT NULL
- payment_etc — TEXT
- sgg_cd — VARCHAR(20)
aihub_companion
- companion_seq — SMALLINT — 기본 키 — NOT NULL
- travel_id — VARCHAR(20) — 외래 키 → aihub_travel.travel_id — NOT NULL
- rel_cd — VARCHAR(20) — NOT NULL
- companion_gender — VARCHAR(10) — NOT NULL
- companion_age_grp — VARCHAR(10) — NOT NULL
- companion_situation — VARCHAR(10) — NOT NULL
aihub_lodge_consume
- lodge_consume_id — BIGINT — 기본 키 — NOT NULL
- travel_id — VARCHAR(20) — 외래 키 → aihub_travel.travel_id — NOT NULL
- lodging_nm — VARCHAR(255) — NOT NULL
- lodging_payment_seq — SMALLINT — NOT NULL
- lodging_type_cd — VARCHAR(20) — NOT NULL
- rsvt_yn — CHAR(1) — NOT NULL
- chk_in_dt_min — DATETIME
- chk_out_dt_min — DATETIME
- payment_num — SMALLINT — NOT NULL
- brno — VARCHAR(20)
- store_nm — VARCHAR(255)
- road_nm_addr — VARCHAR(500)
- lotno_addr — VARCHAR(500)
- road_nm_cd — VARCHAR(20)
- lotno_cd — VARCHAR(20)
- payment_dt — DATETIME
- payment_mthd_se — VARCHAR(20) — NOT NULL
- payment_amt_won — BIGINT — NOT NULL
- payment_etc — TEXT
aihub_move
- trip_id — VARCHAR(20) — 기본 키 — NOT NULL
- travel_id — VARCHAR(20) — 외래 키 → aihub_visit.travel_id — NOT NULL
- start_visit_area_id — VARCHAR(20) — 외래 키 → aihub_visit.visit_area_id
- end_visit_area_id — VARCHAR(20) — 외래 키 → aihub_visit.visit_area_id
- start_dt_min — DATETIME
- end_dt_min — DATETIME
- mvmn_cd_1 — VARCHAR(20)
- mvmn_cd_2 — VARCHAR(20)
aihub_movement_consume
- movement_consume_id — BIGINT — 기본 키 — NOT NULL
- travel_id — VARCHAR(20) — 외래 키 → aihub_travel.travel_id — NOT NULL
- mvmn_se — VARCHAR(20) — NOT NULL
- payment_se — VARCHAR(20) — NOT NULL
- payment_seq — SMALLINT — NOT NULL
- mvmn_se_nm — VARCHAR(100) — NOT NULL
- rsvt_yn — CHAR(1)
- payment_num — SMALLINT — NOT NULL
- brno — VARCHAR(20)
- store_nm — VARCHAR(255)
- payment_dt — DATETIME
- payment_mthd_se — VARCHAR(20)
- payment_amt_won — BIGINT — NOT NULL
- payment_etc — TEXT
aihub_travel
- travel_id — VARCHAR(20) — 기본 키 — NOT NULL
- travel_nm — VARCHAR(20) — NOT NULL
- traveler_id — VARCHAR(20) — 외래 키 → aihub_traveller.traveler_id — NOT NULL
- travel_purpose — VARCHAR(200) — NOT NULL
- travel_start_ymd — DATE — NOT NULL
- travel_end_ymd — DATE — NOT NULL
- mvmn_nm — VARCHAR(100)
- travel_persona — VARCHAR(255) — NOT NULL
- travel_mission — VARCHAR(200) — NOT NULL
- travel_mission_check — VARCHAR(100) — NOT NULL
aihub_traveller
- traveler_id — VARCHAR(20) — 기본 키 — NOT NULL
- residence_sgg_cd — VARCHAR(20) — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- age_grp — VARCHAR(10) — NOT NULL
- edu_nm — VARCHAR(10) — NOT NULL
- edu_fnsh_se — VARCHAR(10) — NOT NULL
- marr_stts — VARCHAR(10) — NOT NULL
- family_memb — SMALLINT
- job_nm — VARCHAR(20) — NOT NULL
- job_etc — VARCHAR(255)
- income — VARCHAR(20) — NOT NULL
- house_income — VARCHAR(20)
- travel_term — VARCHAR(20) — NOT NULL
- travel_num — SMALLINT
- travel_like_sido_1 — VARCHAR(20) — NOT NULL
- travel_like_sgg_1 — VARCHAR(20) — NOT NULL
- travel_like_sido_2 — VARCHAR(20) — NOT NULL
- travel_like_sgg_2 — VARCHAR(20) — NOT NULL
- travel_like_sido_3 — VARCHAR(20) — NOT NULL
- travel_like_sgg_3 — VARCHAR(20) — NOT NULL
- travel_styl_1 — TINYINT
- travel_styl_2 — TINYINT
- travel_styl_3 — TINYINT
- travel_styl_4 — TINYINT
- travel_styl_5 — TINYINT
- travel_styl_6 — TINYINT
- travel_styl_7 — TINYINT
- travel_styl_8 — TINYINT
- travel_status_residence — VARCHAR(100) — NOT NULL
- travel_status_destination — VARCHAR(50) — NOT NULL
- travel_status_accompany — VARCHAR(100) — NOT NULL
- travel_status_ymd — VARCHAR(50) — NOT NULL
- travel_motive_1 — VARCHAR(20) — NOT NULL
- travel_motive_2 — VARCHAR(20)
- travel_motive_3 — VARCHAR(20)
- travel_companions_num — SMALLINT
aihub_visit
- visit_area_id — VARCHAR(20) — 기본 키 — NOT NULL
- travel_id — VARCHAR(20) — 외래 키 → aihub_travel.travel_id — NOT NULL
- visit_order — SMALLINT — NOT NULL
- visit_area_nm — VARCHAR(255) — NOT NULL
- visit_start_ymd — DATE — NOT NULL
- visit_end_ymd — DATE — NOT NULL
- road_nm_addr — VARCHAR(500)
- lotno_addr — VARCHAR(500)
- x_coord — DECIMAL(16, 12)
- y_coord — DECIMAL(16, 12)
- road_nm_cd — VARCHAR(20)
- lotno_cd — VARCHAR(20)
- poi_id — VARCHAR(50)
- poi_nm — VARCHAR(255)
- residence_time_min — INT
- visit_area_type_cd — VARCHAR(20) — NOT NULL
- revisit_yn — CHAR(1)
- visit_chc_reason_cd — VARCHAR(20)
- lodging_type_cd — VARCHAR(20)
- dgstfn — TINYINT
- revisit_intention — TINYINT
- rcmdtn_intention — TINYINT
- sgg_cd — VARCHAR(20)