ulpet
Tables (7)
banner (배너)
- banner_id (Key) — Long — Primary key — NOT NULL
- banner_image (Field) — String
certification (인증)
- certification_id (Key) — Long — Primary key — NOT NULL
- certification_image (인증이미지) — String
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
- place_id (Key3) — Long — Foreign key → place.place_id — NOT NULL
feature (특징)
- feature_id (Key) — Long — Primary key — NOT NULL
- feature_name (특징명) — String
- place_id (Key2) — Long — Foreign key → place.place_id — NOT NULL
image (이미지)
- image_id (Key) — Long — Primary key — NOT NULL
- image_url (Field) — String
- place_id (Key2) — Long — Foreign key → place.place_id — NOT NULL
- image_rep (대표이미지) — Boolean
member (사용자)
- member_id (Key) — Long — Primary key — NOT NULL
- email (이메일) — String
- password (비밀번호) — String
- nickname (닉네임) — String
- profile_image (프로필이미지) — String
- created_at (Field4) — LocalDateTime
- deleted_at (Field6) — LocalDateTime
- familiarity (친밀도) — Float
place (장소)
- place_id (Key) — Long — Primary key — NOT NULL
- category (카테고리) — Enum
- place_name (장소명) — String
- place_detail (장소상세) — String
- address (주소) — String
- lat (위도) — Double
- long (경도) — Double
- created_at (Field5) — LocalDateTime
- updated_at (Field6) — LocalDateTime
- deleted_at (Field7) — LocalDateTime
- created_by (Field8) — Long
- modified_by (Field9) — Long
wish (찜한 장소)
- wish_id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
- place_id (Key3) — Long — Foreign key → place.place_id — NOT NULL