Re:collect

Tables (20)

brand_data

  • brand_key — VARCHAR(20)
  • price_multiplier — NUMERIC(5, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

ingredient

  • ingredient_id — VARCHAR(20)
  • ingredient_name — VARCHAR(100) — NOT NULL
  • ingredient_sprite — VARCHAR(100)
  • ingredient_type — VARCHAR(20) — NOT NULL
  • ingredient_grade — VARCHAR(20) — NOT NULL
  • ingredient_acquisition — VARCHAR(20) — NOT NULL
  • ingredient_usage — VARCHAR(20) — NOT NULL
  • ingredient_flavor_text — TEXT
  • ingredient_seed_name — VARCHAR(50)
  • ingredient_seed_desc — TEXT

item_data

  • item_id — VARCHAR(20)
  • item_name — VARCHAR(100) — NOT NULL
  • item_type — VARCHAR(20)
  • item_brand — VARCHAR(20)
  • item_brand_lie_possibility — TEXT
  • item_material — VARCHAR(20)
  • item_material_lie_possibility — TEXT
  • item_production_year — TEXT
  • item_initial_quality — TEXT
  • item_quality_weight — NUMERIC(3, 2)
  • item_quality_manage_level — VARCHAR(20)
  • item_combined_npc_fk — VARCHAR(20) — Foreign key → npc_data.npc_id
  • item_day_cost — VARCHAR(20)
  • item_volume — VARCHAR(20)
  • item_default_price — INT
  • item_is_tradable — BOOLEAN
  • item_degree_of_damage — VARCHAR(20)
  • item_reflection_of_year — VARCHAR(20)
  • item_withdraw_period — INT
  • item_scratch_num — INT
  • item_spot_num — INT
  • item_abrasion_num — INT
  • item_damaged_num — INT
  • item_sprite — VARCHAR(20)
  • item_damaged — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

material_data

  • material_key — VARCHAR(20)
  • base_price — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

memory_data

  • memory_id — VARCHAR(20)
  • memory_content — TEXT — NOT NULL
  • memory_type — VARCHAR(20)
  • memory_emotion — VARCHAR(20)
  • memory_rarity — VARCHAR(20)
  • memory_initial_clarity — VARCHAR(20)
  • memory_clarity_manage_level — VARCHAR(20)
  • memory_item_fixed — BOOLEAN
  • memory_combined_item — TEXT
  • memory_default_price — INT
  • memory_purchase_npc_fk — VARCHAR(20) — Foreign key → npc_data.npc_id
  • memory_selling_npc — TEXT
  • memory_researchable — BOOLEAN
  • memory_transaction_type — VARCHAR(20)
  • memory_current_owner_fk — VARCHAR(20) — Foreign key → player_data.player_id
  • memory_sprite — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

negotiation_parameters

  • negotiation_id — VARCHAR(20)
  • negotiation_item_fk — VARCHAR(20) — Foreign key → item_data.item_id
  • negotiation_personality_fk — VARCHAR(20)
  • negotiation_initial_offer_range — TEXT
  • negotiation_mood_weight — NUMERIC(3, 2)
  • negotiation_using_time — INT
  • negotiation_appropriate_mem_purchase_price_range — TEXT
  • negotiation_appropriate_mem_selling_price_range — TEXT
  • negotiation_appropriate_item_purchase_price_range — TEXT
  • negotiation_appropriate_item_selling_price_range — TEXT
  • negotiation_proposal_burden — NUMERIC(3, 2)
  • negotiation_proposal_refuse — NUMERIC(3, 2)
  • negotiation_proposal_discontent — NUMERIC(3, 2)
  • negotiation_mood_flatter — INT
  • negotiation_mood_blame — INT
  • negotiation_mood_lie_detector — BOOLEAN
  • negotiation_mood_snack — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

npc_data

  • npc_id — VARCHAR(20)
  • npc_name — VARCHAR(50) — NOT NULL
  • npc_animal — VARCHAR(100)
  • npc_job — VARCHAR(20)
  • npc_gender — VARCHAR(10)
  • npc_age — INT
  • npc_birth — VARCHAR(10)
  • npc_residence — VARCHAR(20)
  • npc_residence_type — VARCHAR(20)
  • npc_personality — VARCHAR(20)
  • npc_characteristics — TEXT
  • npc_wealth — VARCHAR(20)
  • npc_interest — TEXT
  • npc_event_type — VARCHAR(20)
  • npc_past_history — TEXT
  • npc_purpose — VARCHAR(20)
  • npc_weight — VARCHAR(20)
  • npc_lie_weight — INT
  • npc_attitude — VARCHAR(20)
  • npc_reclaim_weight — INT
  • npc_retrieve_period — TEXT
  • npc_clarity_weight — INT
  • npc_item_preference — TEXT
  • npc_memory_preference — TEXT
  • npc_ending — VARCHAR(50)
  • npc_current_mood — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

pending_collateral_claims

  • id — INT
  • player_id — VARCHAR(20) — Foreign key → player_data.player_id — NOT NULL
  • source_inventory_id — INT — Foreign key → player_inventory.inventory_id — NOT NULL
  • npc_id — VARCHAR(20) — Foreign key → npc_data.npc_id — NOT NULL
  • memory_id — VARCHAR(20) — Foreign key → memory_data.memory_id
  • item_id — VARCHAR(20) — Foreign key → item_data.item_id
  • due_date — INT — NOT NULL
  • is_processed — BOOLEAN
  • created_at — TIMESTAMP

player_data

  • player_id — VARCHAR(20)
  • player_name — VARCHAR(50)
  • player_goods_currency — INT
  • player_memory_currency — INT
  • player_reputation — INT
  • player_current_day — INT
  • player_inventory_size — INT
  • player_detector_usage_count — INT
  • player_vr_usage_count — INT
  • player_clock_part_count — INT
  • player_remaining_business_hours — INT
  • player_internet_status — BOOLEAN
  • player_monthly_cost — INT
  • player_initial_mood — INT
  • save_slot — INT
  • total_playtime_seconds — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • last_login — TIMESTAMP

player_inventory

  • inventory_id — INT
  • player_id — VARCHAR(20) — Foreign key → player_data.player_id — NOT NULL
  • item_type — VARCHAR(20) — NOT NULL
  • memory_id — VARCHAR(20) — Foreign key → memory_data.memory_id
  • item_id — VARCHAR(20) — Foreign key → item_data.item_id
  • quantity — INT
  • current_quality — NUMERIC(3, 2)
  • current_clarity — NUMERIC(3, 2)
  • appraised_value — INT
  • acquired_from — VARCHAR(20)
  • acquired_date — TIMESTAMP
  • is_equipped — BOOLEAN
  • will_abscond — BOOLEAN
  • due_date — INT
  • loan_amount — INT
  • memory_loan_amount — INT
  • goods_loan_amount — INT
  • pawn_day — INT
  • npc_id — VARCHAR(20) — Foreign key → npc_data.npc_id
  • item_production_year — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

player_plant_pots

  • pot_index — INT — Primary key — NOT NULL
  • player_id — VARCHAR(20) — Foreign key → player_data.player_id — NOT NULL
  • result_ingredient_id — VARCHAR(20) — Foreign key → ingredient.ingredient_id
  • age — INT — NOT NULL
  • is_occupied — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

player_seed_inventory

  • player_id — VARCHAR(20) — Foreign key → player_data.player_id — NOT NULL
  • ingredient_id — VARCHAR(20) — Foreign key → ingredient.ingredient_id — NOT NULL
  • seed_name — VARCHAR(50)
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

player_snack_inventory

  • player_id — VARCHAR(20) — Foreign key → player_data.player_id — NOT NULL
  • shop_item_id — VARCHAR(30) — Foreign key → shop_items.shop_item_id — NOT NULL
  • quantity — INT — NOT NULL

player_special_unlocks

  • player_id — VARCHAR(20) — Foreign key → player_data.player_id — NOT NULL
  • shop_item_id — VARCHAR(30) — Foreign key → shop_items.shop_item_id — NOT NULL
  • unlocked_at — TIMESTAMP

player_upgrades

  • upgrade_group_id — VARCHAR(30) — Primary key — NOT NULL
  • player_id — VARCHAR(20) — Foreign key → player_data.player_id — NOT NULL
  • current_level — INT — NOT NULL

potion

  • potion_id — VARCHAR(20)
  • potion_name — VARCHAR(100) — NOT NULL
  • potion_sprite — VARCHAR(100)
  • potion_kind — VARCHAR(20) — NOT NULL
  • potion_recovery_value — INT
  • potion_recovery_target — VARCHAR(20)
  • potion_days_until_expire — INT
  • potion_grade — VARCHAR(20)
  • craft_material_total_min — INT
  • craft_material_total_max — INT
  • craft_material_kind — VARCHAR(20)
  • craft_material_kind_min_count — INT
  • craft_extra_ingredient_ids — TEXT
  • craft_extra_ingredient_types — TEXT
  • potion_flavor_text — TEXT

shop_items

  • shop_item_id — VARCHAR(30)
  • name — VARCHAR(50) — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • grade — VARCHAR(20)
  • effect_description — VARCHAR(100)
  • required_shop_level — INT
  • required_special_unlock — VARCHAR(20)
  • required_upgrade_group_id — VARCHAR(30)
  • required_upgrade_min_level — INT
  • price — INT — NOT NULL
  • ingredient_key — VARCHAR(20) — Foreign key → ingredient.ingredient_id
  • created_at — TIMESTAMP

shop_upgrades

  • upgrade_id — VARCHAR(30)
  • upgrade_group_id — VARCHAR(30) — NOT NULL
  • upgrade_group_name — VARCHAR(50) — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • level — INT — NOT NULL
  • effect_description — VARCHAR(100) — NOT NULL
  • effect_type — VARCHAR(40) — NOT NULL
  • effect_value — NUMERIC(10, 2) — NOT NULL
  • required_shop_level — INT
  • required_special_unlock — VARCHAR(20)
  • price — INT — NOT NULL
  • created_at — TIMESTAMP

string_reference

  • id — INT
  • category_group — VARCHAR(50) — NOT NULL
  • korean_value — VARCHAR(100) — NOT NULL
  • english_value — VARCHAR(100)
  • description — TEXT
  • numeric_value — NUMERIC(10, 2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

transaction_history

  • transaction_id — INT
  • player_id — VARCHAR(20) — Foreign key → player_data.player_id
  • npc_id — VARCHAR(20) — Foreign key → npc_data.npc_id
  • memory_id — VARCHAR(20) — Foreign key → memory_data.memory_id
  • item_id — VARCHAR(20) — Foreign key → item_data.item_id
  • inventory_id — INT — Foreign key → player_inventory.inventory_id
  • transaction_type — VARCHAR(20)
  • offered_price — INT — NOT NULL
  • final_price — INT — NOT NULL
  • reference_price — NUMERIC(10, 2)
  • price_ratio — NUMERIC(5, 2)
  • validation_level — INT
  • is_success — BOOLEAN — NOT NULL
  • mood_change — INT
  • conversation_log — TEXT
  • negotiation_attempts — INT
  • time_spent_seconds — INT
  • created_at — TIMESTAMP