Pawever

Tables (15)

Breed (품종)

  • breed_id (품종ID) — String — Primary key — NOT NULL
  • species_id (동물종류ID) — String — Foreign key → Species.species_id — NOT NULL
  • name (이름) — String

Comment (댓글)

  • uuid (회원ID) — String — Foreign key → User.uuid — NOT NULL
  • pet_id (반려동물ID) — String — Foreign key → Memorial.pet_id — NOT NULL
  • breed_id (품종ID) — String — Foreign key → Memorial.breed_id — NOT NULL
  • species_id (동물종류ID) — String — Foreign key → Memorial.species_id — NOT NULL

Company (장례업체)

  • company_id (장례업체ID) — String — Primary key — NOT NULL
  • name (이름) — String
  • location (위치) — String
  • introduction (소개글) — text
  • guide (안내글) — text
  • description (서비스설명) — text
  • has_full_observation (전 과정 참관 가능 여부) — boolean
  • has_24h_service (24시간 여부) — boolean
  • has_pickup_service (픽업 서비스 여부) — boolean
  • has_memorial_stone (메모리얼 스톤 제작 여부) — boolean
  • has_private_room (단독 추모실 여부) — boolean
  • has_columbarium (납골당 및 수목장 여부) — boolean

Guideline (가이드라인)

  • guide_id (가이드ID) — String — Primary key — NOT NULL
  • name (이름) — String

Memorial (추모)

  • pet_id (반려동물ID) — String — Foreign key → Pet.pet_id — NOT NULL
  • breed_id (품종ID) — String — Foreign key → Pet.breed_id — NOT NULL
  • species_id (동물종류ID) — String — Foreign key → Pet.species_id — NOT NULL
  • created_at (사망 일자) — timestamp

Mission (추억남기기미션)

  • mission_id (미션ID) — String — Primary key — NOT NULL
  • name (이름) — String
  • description (설명) — String

Option_Review (장례옵션후기)

  • review_id (후기ID) — String — Primary key — NOT NULL
  • pet_id (반려동물ID) — String — Foreign key → Pet.pet_id — NOT NULL
  • breed_id (품종ID) — String — Foreign key → Pet.breed_id — NOT NULL
  • species_id (동물종류ID) — String — Foreign key → Pet.species_id — NOT NULL
  • rate (평점) — int
  • comment (후기내용) — String

Pet (반려동물)

  • pet_id (반려동물ID) — String — Primary key — NOT NULL
  • breed_id (품종ID) — String — Foreign key → Breed.breed_id — NOT NULL
  • species_id (동물종류ID) — String — Foreign key → Breed.species_id — NOT NULL
  • name (이름) — String
  • birthdate (생년월일) — Date
  • gender (성별)
  • weight (몸무게) — float
  • code (초대코드) — string
  • image (대표사진URL) — String
  • is_urgent (긴급모드여부) — boolean

Pet_Mission (반려동물_미션)

  • mission_id (미션ID) — String — Foreign key → Mission.mission_id — NOT NULL
  • pet_id (반려동물ID) — String — Foreign key → Pet.pet_id — NOT NULL
  • breed_id (품종ID) — String — Foreign key → Pet.breed_id — NOT NULL
  • species_id (동물종류ID) — String — Foreign key → Pet.species_id — NOT NULL
  • completed (완료여부) — boolean

Plan (이별계획)

  • plan_id (계획ID) — String — Primary key — NOT NULL
  • pet_id (반려동물ID) — String — Foreign key → Pet.pet_id — NOT NULL
  • breed_id (품종ID) — String — Foreign key → Pet.breed_id — NOT NULL
  • species_id (동물종류ID) — String — Foreign key → Pet.species_id — NOT NULL
  • with_company (업체이용여부) — boolean

Species (동물 종류)

  • species_id (동물종류ID) — String — Primary key — NOT NULL
  • name (이름) — String

Step (단계)

  • step_id (단계ID) — String — Primary key — NOT NULL
  • guide_id (가이드ID) — String — Foreign key → Guideline.guide_id — NOT NULL
  • title (제목) — String
  • description (설명) — String

User (회원)

  • uuid (회원ID) — String — Primary key — NOT NULL
  • password (비밀번호) — String
  • name (이름) — String
  • nickname (별명) — String
  • tel (전화번호) — String
  • kakao_id (카카오ID) — String
  • naver_id (네이버ID) — String
  • current_pet_id (선택한 펫ID) — Integer
  • created_at (가입일자) — timestamp
  • deleted_at (탈퇴일자) — timestamp
  • image (프로필이미지URL) — String

User_Company (회원_장례업체)

  • uuid (회원ID) — String — Foreign key → User.uuid — NOT NULL
  • company_id (장례업체ID) — String — Foreign key → Company.company_id — NOT NULL
  • relation_type (등록 타입) — "saved", "blocked"

User_Pet (회원_반려동물)

  • pet_id (반려동물ID) — String — Foreign key → Pet.pet_id — NOT NULL
  • breed_id (품종ID) — String — Foreign key → Pet.breed_id — NOT NULL
  • species_id (동물종류ID) — String — Foreign key → Pet.species_id — NOT NULL
  • uuid (회원ID) — String — Foreign key → User.uuid — NOT NULL
  • is_owner (등록자여부) — boolean