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