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