CAP-NEOPETS

Tables (9)

inventory (인벤토리)

  • user_id (유저아이디) — uuid — Foreign key → users.id — NOT NULL
  • item_id (아이템id) — uuid — Foreign key → items.id — NOT NULL
  • quantity (수량) — int

items (아이템)

  • id (아이템id) — uuid — Primary key — NOT NULL
  • name (아이템이름) — text
  • type (아이템타입) — enum
  • effect (아이템효과) — jsonb
  • price (아이템가격) — int

missions (미션목록)

  • id (미션아이디) — uuid — Primary key — NOT NULL
  • title (미션제목) — text
  • type (일일/주간) — enum
  • condition (Field) — jsonb
  • reward (Field2) — jsonb

pet_collection (펫승천컬렉션)

  • id (펫아이디) — id — Primary key — NOT NULL
  • user_id (유저아이디) — uuid — Foreign key → users.id — NOT NULL
  • pet_name (펫이름) — text
  • species (펫종류) — text
  • level_reached (도달레벨) — int
  • retired_at (승천날짜) — timestamp

pet_history (펫상태로그)

  • id (펫아이디) — uuid — Foreign key → pets.id — NOT NULL
  • user_id (유저아이디) — uuid — Foreign key → pets.user_id — NOT NULL
  • event (기록) — text
  • details (Field) — jsonb
  • timestamp (Field2) — timestamp

pets (펫)

  • id (펫아이디) — uuid — Primary key — NOT NULL
  • user_id (유저아이디) — uuid — Foreign key → users.id — NOT NULL
  • name (펫이름) — text
  • species (펫종류) — enum
  • level (펫레벨) — int
  • exp (경험치) — int
  • hunger (배고픔) — int
  • mood (기분) — text
  • status_updated_at (상태업뎃시간) — timestamp

steps_log (걸음수)

  • id (유저아이디) — uuid — Foreign key → users.id — NOT NULL
  • date (걸은날짜) — date
  • steps (걸음수) — int
  • created_at (시작시간) — timestamp

user_missions (유저미션)

  • user_id (유저아이디) — uuid — Foreign key → users.id — NOT NULL
  • mission_id (미션아이디) — uuid — Foreign key → missions.id — NOT NULL
  • is_completed (완료여부) — bool
  • completed_at (완료시각) — timestamp

users (유저)

  • id (유저아이디) — uuid — Primary key — NOT NULL
  • nickname (닉네임) — text
  • created_at (생성일) — timestamp