NEW_HYANGHAE
Tables (13)
access_token
- id — bigint — Primary key — NOT NULL
- blacklisted — bit(1) — NOT NULL
- expiration_date — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- token — varchar(1000)
category
- category_id — bigint — Primary key — NOT NULL
- category_name — enum('체험','휴식','전시','역사','음식','경치')
departure_point
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- mapx — double
- mapy — double
- road_address — varchar(255)
famous_place
- famous_place_id — bigint — Primary key — NOT NULL
- hash_tag_count — int — NOT NULL
- search_count — int — NOT NULL
- city — varchar(255)
- major_category — varchar(255)
- region — varchar(255)
- road_address — varchar(255)
- sub_category — varchar(255)
- tourist_spot_name — varchar(255)
famous_place_tag_log
- place_tag_log_id — bigint — Primary key — NOT NULL
- tag_score — int — NOT NULL
- famous_place_id — bigint — Foreign key → famous_place.famous_place_id
- tag_id — bigint — Foreign key → tag.tag_id
member
- member_id — bigint — Primary key — NOT NULL
- registration_count — int
- kakao_id — bigint
- account — varchar(255)
- email — varchar(255)
- name — varchar(255)
- nickname — varchar(255)
- password — varchar(255)
- profile_image — varchar(255)
- role — enum('ADMIN','USER')
member_tag_log
- member_tag_log_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → member.member_id
- tag_id — bigint — Foreign key → tag.tag_id
place
- place_id — bigint — Primary key — NOT NULL
- like_count — int — NOT NULL
- register_count — int — NOT NULL
- search_count — int
- city — varchar(50)
- major_category — varchar(50)
- region — varchar(50)
- sub_category — varchar(50)
- road_address — varchar(100)
- tourist_spot_name — varchar(100)
- image_path — varchar(200)
- mapx — double
- mapy — double
place_like
- place_like_id — bigint — Primary key — NOT NULL
- created_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- place_id — bigint — Foreign key → place.place_id
place_register
- place_register_id — bigint — Primary key — NOT NULL
- created_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- place_id — bigint — Foreign key → place.place_id
place_tag_log
- place_tag_log_id — bigint — Primary key — NOT NULL
- tag_score — int — NOT NULL
- place_id — bigint — Foreign key → place.place_id
- tag_id — bigint — Foreign key → tag.tag_id
tag
- tag_id — bigint — Primary key — NOT NULL
- category_id — bigint — Foreign key → category.category_id
- tag_name — enum('액티비티','체험시설','산책','등산','숙박시설','해수욕장','계곡','공원','공연','거리','마을','예술','문화유적','박물관','자연유산','종교유적','맛집','카페','특산물','야시장','오션뷰','도시뷰','숲뷰','전망대')
upload_image
- id — bigint — Primary key — NOT NULL
- created_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- extension — varchar(255)
- original_file_name — varchar(255)
- save_file_name — varchar(255)
- saved_image_url — tinytext