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