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 — 삭제