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)