heritage-map-service

Tables (3)

Heritage (전체문화유산)

  • id (자동아이디) — long — Primary key — NOT NULL
  • heritage_id (문화재아이디) — String — Primary key — NOT NULL
  • heritage_name (문화재명) — String
  • location (위치좌표) — JTS Point
  • heritage_grade (문화재등급) — String
  • basic_description (문화재설명) — String

Member (회원정보)

  • id (자동아이디) — long — Primary key — NOT NULL
  • memberId (멤버아이디) — String — Primary key — NOT NULL
  • password (비밀번호) — String
  • role (역할) — Enum

VisitedHeritageList (멤버방문문화유산)

  • id (자동아이디) — long — Primary key — NOT NULL
  • member_id (멤버아이디) — String — Foreign key → Member.memberId — NOT NULL
  • heritage_id (문화재아이디) — String — Foreign key → Heritage.heritage_id — NOT NULL
  • visited_at (방문날짜) — LocalDateTIme