petMate

Tables (19)

availability_slots

  • id — BIGINT — 슬롯
  • company_id — BIGINT — NOT NULL — companies.id
  • product_id — BIGINT — NOT NULL — products.id
  • slot_date — DATE — 슬롯
  • start_dt — TIMESTAMP — 시작
  • end_dt — TIMESTAMP — 종료
  • capacity — INT — 수용
  • booked — INT — 예약

banners

  • id — BIGINT — 배너
  • name — VARCHAR(120) — NOT NULL — 배너명
  • image_asset_id — BIGINT — 이미지
  • is_active — SMALLINT — 활성
  • created_at — TIMESTAMP — 생성일시
  • updated_at — TIMESTAMP — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시

companies

  • id — BIGINT — 업체
  • type — VARCHAR(16) — 유형
  • name — VARCHAR(200) — NOT NULL — 업체명
  • biz_reg_no — VARCHAR(20) — 사업자등록번호
  • rep_name — VARCHAR(80) — 대표자
  • desc_text — TEXT — 소개
  • rep_service — VARCHAR(16) — 대표
  • status — VARCHAR(16) — 상태
  • created_by — BIGINT — 생성자(users.id)
  • created_at — TIMESTAMP — 생성일시

company_affiliations

  • id — BIGINT — 소속
  • mate_user_id — BIGINT — NOT NULL — 펫메이트
  • company_id — BIGINT — NOT NULL — companies.id

legend_availability_slots

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

legend_banners

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

legend_companies

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

legend_company_affiliations

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

legend_pets

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

legend_products

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

legend_reservation_pets

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

legend_reservations

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

legend_reviews

  • col_en — VARCHAR(64)
  • col_ko — VARCHAR(128) — NOT NULL

pets

  • id — BIGINT — 반려동물
  • owner_user_id — BIGINT — NOT NULL — 반려인
  • name — VARCHAR(80) — NOT NULL — 이름
  • image_url — VARCHAR(500) — 이미지
  • species — VARCHAR(16) — 종(DOG/CAT/OTHER)
  • breed_id — INT — 품종ID
  • sex — VARCHAR(1) — 성별
  • age_year — NUMERIC(4,1) — 나이(년)
  • weight_kg — NUMERIC(5,2) — 체중(kg)
  • neutered — SMALLINT — 중성화
  • temper — VARCHAR(50) — 성향
  • notes — TEXT — 메모
  • created_at — TIMESTAMP — 생성일시

products

  • id — BIGINT — 상품
  • company_id — BIGINT — NOT NULL — companies.id
  • service_type — VARCHAR(16) — 서비스
  • name — VARCHAR(150) — NOT NULL — 상품명
  • price — INT — 가격(KRW)
  • all_day — SMALLINT — 종일
  • duration_min — INT — 소요시간(분)
  • intro_text — TEXT — 소개문
  • min_pets — INT — 최소
  • max_pets — INT — 최대
  • is_active — SMALLINT — 판매중

reservation_pets

  • reservation_id — BIGINT — Primary key — NOT NULL — reservations.id
  • pet_id — BIGINT — Primary key — NOT NULL — pets.id

reservations

  • id — BIGINT — 예약
  • owner_user_id — BIGINT — NOT NULL — 반려인
  • company_id — BIGINT — NOT NULL — companies.id
  • product_id — BIGINT — NOT NULL — products.id
  • status — VARCHAR(16) — 상태
  • start_dt — TIMESTAMP — 시작
  • end_dt — TIMESTAMP — 종료
  • pet_count — INT — 반려동물
  • special_request — TEXT — 요청사항
  • total_price — INT — 총
  • payment_status — VARCHAR(16) — 결제
  • created_at — TIMESTAMP — 생성일시

reviews

  • id — BIGINT — 리뷰
  • reservation_id — BIGINT — NOT NULL — reservations.id
  • owner_user_id — BIGINT — NOT NULL — users.id
  • company_id — BIGINT — NOT NULL — companies.id
  • rating — SMALLINT — 평점
  • comment — TEXT — 코멘트
  • is_visible — SMALLINT — 노출
  • created_at — TIMESTAMP — 생성일시

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL — 이메일(최초
  • nick_name — VARCHAR(80) — 소셜
  • provider — VARCHAR(20) — NOT NULL — 소셜
  • name — VARCHAR(80) — NOT NULL — 이름
  • profile_image — VARCHAR(500) — 프로필
  • phone — VARCHAR(30) — 휴대폰
  • birth_date — DATE — 생년월일
  • gender — CHAR(1) — 성별
  • roles — CHAR(1) — 역할(U:일반
  • main_services — VARCHAR(255) — 주요
  • care_species — VARCHAR(255) — 케어
  • status — CHAR(1) — 상태
  • email_verified — SMALLINT — 이메일
  • created_at — TIMESTAMP — 생성일시
  • updated_at — TIMESTAMP — 수정일시
  • deleted_at — TIMESTAMP — 삭제일시
  • deleted_flag — SMALLINT — 삭제