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