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