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