true_real_final_petfolio

테이블 (14)

거래 (transactions)

  • id — BIGINT — 기본 키 — NOT NULL
  • card_id — INT — 외래 키 → 카드.id — NOT NULL
  • category_id — INT — 외래 키 → 결제 카테고리.id
  • amount — BIGINT — NOT NULL
  • merchant_name — VARCHAR(128)
  • transaction_unique_no — VARCHAR(255) — NOT NULL
  • is_pet_expense — BOOLEAN — NOT NULL
  • transaction_date — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

거래 상세 (transaction_details)

  • id — BIGINT — 기본 키 — NOT NULL
  • transaction_id — BIGINT — 외래 키 → 거래.id — NOT NULL
  • category_id — INT — 외래 키 → 결제 카테고리.id — NOT NULL
  • amount — BIGINT — NOT NULL
  • memo — VARCHAR(256)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

거래 상세 - 펫 (transaction_detail_pets)

  • id — BIGINT — 기본 키 — NOT NULL
  • transaction_detail_id — BIGINT — 외래 키 → 거래 상세.id — NOT NULL
  • pet_id — INT — NOT NULL
  • allocated_amount — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • id (id2) — INT — 외래 키 → 펫.id — NOT NULL

결제 카테고리 (categories)

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(64) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

그룹 (groups)

  • id — INT — 기본 키 — NOT NULL
  • invite_code — VARCHAR(64) — NOT NULL
  • name — VARCHAR(64)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

소모품 (consumables)

  • id — INT — 기본 키 — NOT NULL
  • group_id — INT — 외래 키 → 그룹.id — NOT NULL
  • name — VARCHAR(256) — NOT NULL
  • purchase_cycle_days — INT — NOT NULL
  • last_purchase_date — DATE
  • next_purchase_date — DATE
  • purchase_url — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

유저 (users)

  • id — INT — 기본 키 — NOT NULL
  • group_id — INT — 외래 키 → 그룹.id
  • name — VARCHAR(64) — NOT NULL
  • nickname — VARCHAR(64)
  • email — VARCHAR(256) — NOT NULL
  • password — VARCHAR(128)
  • user_tokens — TEXT — NOT NULL
  • provider — ENUM('GOOGLE','LOCAL') — NOT NULL
  • role — ENUM('GUEST','HOST','MEMBER') — NOT NULL
  • status — ENUM('ACTIVE','DELETED') — NOT NULL
  • image_url — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

카드 (cards)

  • id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • card_issuer_name — VARCHAR(255)
  • card_name — VARCHAR(255)
  • card_no — VARCHAR(255) — NOT NULL
  • card_unique_no — VARCHAR(255)
  • cvc — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

토큰 (refresh_tokens)

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.id — NOT NULL
  • refresh_token — VARCHAR(512) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

펫 (pets)

  • id — INT — 기본 키 — NOT NULL
  • breed_id — INT — 외래 키 → 펫 품종.id — NOT NULL
  • group_id — INT — 외래 키 → 그룹.id — NOT NULL
  • weight — DECIMAL(5,2) — NOT NULL
  • name — VARCHAR(64) — NOT NULL
  • birthdate — DATE — NOT NULL
  • gender — ENUM('FEMALE','MALE') — NOT NULL
  • image_url — TEXT
  • is_neutered — BOOLEAN — NOT NULL
  • memo — VARCHAR(255)
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • name (name2) — VARCHAR(64) — 외래 키 → 펫 품종.name — NOT NULL

펫 생애주기 (CopyOfbreeds)

  • id — INT — 기본 키 — NOT NULL
  • 단계 (name) — VARCHAR(64) — 기본 키 — NOT NULL
  • species — ENUM('CAT','DOG') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • id (id2) — INT — 외래 키 → 펫 품종.id — NOT NULL
  • name (name2) — VARCHAR(64) — 외래 키 → 펫 품종.name — NOT NULL

펫 스티커 (stickers)

  • id — INT — 기본 키 — NOT NULL
  • pet_id — INT — 외래 키 → 펫.id — NOT NULL
  • category_id — INT — NOT NULL
  • image_url — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • name (name2) — VARCHAR(64) — 외래 키 → 펫.name — NOT NULL

펫 품종 (breeds)

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(64) — 기본 키 — NOT NULL
  • species — ENUM('CAT','DOG') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

펫-소모품 (pet_consumables)

  • id — INT — 기본 키 — NOT NULL
  • consumable_id — INT — 외래 키 → 소모품.id — NOT NULL
  • pet_id — INT — 외래 키 → 펫.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL