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