yeoghaeng_ttukttak

Tables (19)

avatar

  • id — bigint(20) — Primary key — NOT NULL
  • member_id — bigint(20) — Foreign key → member.id
  • dtype — varchar(31) — NOT NULL

comment

  • id — bigint(20) — Primary key — NOT NULL
  • content — varchar(255)
  • created_at — datetime(6)
  • last_modified_at — datetime(6)
  • created_by — bigint(20) — Foreign key → member.id
  • last_modified_by — bigint(20) — Foreign key → member.id

geography

  • id — bigint(20) — Primary key — NOT NULL
  • level — int(11) — NOT NULL
  • code_end — int(11) — NOT NULL
  • code_start — int(11) — NOT NULL
  • name — varchar(255)
  • name_eng — varchar(255)
  • short_name — varchar(255)
  • short_name_eng — varchar(255)
  • parent_id — bigint(20) — Foreign key → geography.id

geography_insignia_image

  • id — bigint(20) — Primary key — NOT NULL
  • ext — varchar(255)
  • name — varchar(255)
  • path — varchar(255)
  • geography_id — bigint(20) — Foreign key → geography.id

member

  • id — bigint(20) — Primary key — NOT NULL
  • age_group — enum('fifties','forties','seventiesPlus','sixties','teens','thirties','twenties','underNine')
  • gender — enum('female','male')
  • nickname — varchar(255) — NOT NULL
  • uuid — varchar(255) — NOT NULL
  • auth_id — bigint(20) — Foreign key → oauth.id — NOT NULL

oauth

  • id — bigint(20) — Primary key — NOT NULL
  • open_id — varchar(255) — NOT NULL
  • provider — enum('APPLE','GOOGLE')

place

  • id — bigint(20) — Primary key — NOT NULL
  • latitude — double
  • longitude — double
  • lot_number_address — varchar(255)
  • name — varchar(255)
  • region_code — int(11)
  • road_address — varchar(255)

place_category

  • id — bigint(20) — Primary key — NOT NULL
  • count — int(11) — NOT NULL
  • type — enum('commerce','culture','dining','lodging','nature','tourism','transport')
  • place_id — bigint(20) — Foreign key → place.id

travel

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • last_modified_at — datetime(6)
  • ended_on — date
  • started_on — date
  • created_by — bigint(20) — Foreign key → member.id
  • last_modified_by — bigint(20) — Foreign key → member.id

travel_city

  • id — bigint(20) — Primary key — NOT NULL
  • city_id — bigint(20) — Foreign key → geography.id
  • travel_id — bigint(20) — Foreign key → travel.id

travel_companion

  • id — bigint(20) — Primary key — NOT NULL
  • type — enum('children','colleagues','friends','grandparents','lover','members','others','parents','relatives','siblings','spouse') — NOT NULL
  • travel_id — bigint(20) — Foreign key → travel.id

travel_motivation

  • id — bigint(20) — Primary key — NOT NULL
  • type — enum('adventure','education','fitness','friendship','newExperiences','other','rest','selfReflection','socialNetwork','special')
  • travel_id — bigint(20) — Foreign key → travel.id

travel_participant

  • id — bigint(20) — Primary key — NOT NULL
  • invitee_id — bigint(20) — Foreign key → member.id
  • inviter_id — bigint(20) — Foreign key → member.id
  • travel_id — bigint(20) — Foreign key → travel.id

travel_plan

  • id — bigint(20) — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • last_modified_at — datetime(6)
  • day_of_travel — int(11) — NOT NULL
  • order_of_plan — int(11) — NOT NULL
  • created_by — bigint(20) — Foreign key → member.id
  • last_modified_by — bigint(20) — Foreign key → member.id
  • place_id — bigint(20) — Foreign key → place.id
  • travel_id — bigint(20) — Foreign key → travel.id — NOT NULL

travel_plan_comment

  • id — bigint(20) — Primary key — NOT NULL
  • comment_id — bigint(20) — Foreign key → comment.id
  • plan_id — bigint(20) — Foreign key → travel_plan.id

travelogue

  • id — bigint(20) — Primary key — NOT NULL
  • age_group — enum('fifties','forties','seventiesPlus','sixties','teens','thirties','twenties','underNine')
  • ended_on — date
  • gender — enum('female','male')
  • started_on — date

travelogue_companion

  • id — bigint(20) — Primary key — NOT NULL
  • type — enum('children','colleagues','friends','grandparents','lover','members','others','parents','relatives','siblings','spouse')
  • travelogue_id — bigint(20) — Foreign key → travelogue.id

travelogue_motivation

  • id — bigint(20) — Primary key — NOT NULL
  • type — enum('adventure','education','fitness','friendship','newExperiences','other','rest','selfReflection','socialNetwork','special')
  • travelogue_id — bigint(20) — Foreign key → travelogue.id

travelogue_visit

  • id — bigint(20) — Primary key — NOT NULL
  • day_of_travel — int(11) — NOT NULL
  • order_of_visit — int(11) — NOT NULL
  • reason_type — enum('easyAccess','education','goodAmenities','goodExperience','goodReviews','goodValue','landmark','media','other','recommendation','unexpectedFind')
  • recommend — int(11)
  • revisit — int(11)
  • satisfaction — int(11)
  • place_id — bigint(20) — Foreign key → place.id
  • travelogue_id — bigint(20) — Foreign key → travelogue.id