campusrpg

Tables (13)

egg_hatch_rules

  • id — INTEGER
  • top_stat_type — TEXT — NOT NULL
  • required_level — INTEGER — NOT NULL
  • required_user_exp — INTEGER — NOT NULL
  • to_lineage_type — TEXT — NOT NULL
  • to_animal_type — TEXT — NOT NULL
  • next_stage — INTEGER — NOT NULL
  • is_active — INTEGER — NOT NULL

friend_requests

  • id — INTEGER
  • from_user_id — INTEGER — Foreign key — NOT NULL
  • to_user_id — INTEGER — Foreign key — NOT NULL
  • status — TEXT — NOT NULL
  • created_at — TEXT

friendships

  • id — INTEGER
  • user_id — INTEGER — Foreign key — NOT NULL
  • friend_user_id — INTEGER — Foreign key — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TEXT

items

  • id — INTEGER
  • name — TEXT — NOT NULL
  • description — TEXT
  • price — INTEGER — NOT NULL
  • image_url — TEXT
  • icon_emoji — TEXT
  • effect_type — TEXT

pet_evolution_history

  • id — INTEGER
  • pet_id — INTEGER — Foreign key — NOT NULL
  • from_animal_type — TEXT — NOT NULL
  • to_animal_type — TEXT — NOT NULL
  • evolved_at — TEXT
  • trigger_user_exp — INTEGER
  • trigger_pet_level — INTEGER

pet_evolution_rules

  • id — INTEGER
  • lineage_type — TEXT — NOT NULL
  • from_animal_type — TEXT — NOT NULL
  • to_animal_type — TEXT — NOT NULL
  • required_stage — INTEGER — NOT NULL
  • required_level — INTEGER — NOT NULL
  • required_user_exp — INTEGER — NOT NULL
  • priority — INTEGER — NOT NULL
  • is_active — INTEGER — NOT NULL

pets

  • id — INTEGER
  • user_id — INTEGER — Foreign key — NOT NULL
  • name — TEXT — NOT NULL
  • level — INTEGER
  • evolution_stage — INTEGER
  • animal_type — TEXT
  • lineage_type — TEXT
  • last_evolved_at — TEXT
  • created_at — TEXT

quests

  • id — INTEGER
  • title — TEXT — NOT NULL
  • type — TEXT — NOT NULL
  • reward_coin — INTEGER
  • reward_stat_type — TEXT
  • reward_stat_amount — INTEGER

schedules

  • id — INTEGER
  • user_id — INTEGER — Foreign key — NOT NULL
  • content — TEXT — NOT NULL
  • target_date — TEXT — NOT NULL
  • is_completed — INTEGER
  • reward_exp — INTEGER
  • created_at — TEXT

stats

  • user_id — INTEGER — Foreign key
  • health — INTEGER
  • social — INTEGER
  • diligence — INTEGER
  • focus — INTEGER
  • creativity — INTEGER
  • daily_fatigue — INTEGER
  • last_updated_date — TEXT

user_inventory

  • id — INTEGER
  • user_id — INTEGER — Foreign key — NOT NULL
  • item_id — INTEGER — Foreign key → items.id — NOT NULL
  • quantity — INTEGER — NOT NULL
  • updated_at — TEXT

user_quests

  • id — INTEGER
  • user_id — INTEGER — Foreign key — NOT NULL
  • quest_id — INTEGER — Foreign key → quests.id — NOT NULL
  • is_completed — INTEGER
  • assigned_date — TEXT — NOT NULL

users

  • id — INTEGER
  • email — TEXT — NOT NULL
  • password — TEXT — NOT NULL
  • nickname — TEXT — NOT NULL
  • student_id — TEXT — NOT NULL
  • major — TEXT — NOT NULL
  • university_name — TEXT — NOT NULL
  • age — INTEGER — NOT NULL
  • school_year — INTEGER — NOT NULL
  • intro — TEXT — NOT NULL
  • avatar — TEXT — NOT NULL
  • kakao_id — TEXT
  • coin — INTEGER
  • exp — INTEGER
  • friend_code — TEXT — NOT NULL
  • created_at — TEXT