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