I plan to code a little adventure-like game. To be able to build multiple episodes without deploying new code I want to store any information possible in the database.
This includes stuff like
if player examines item [cell phone], the contact [xxx] is added into his phone book and the item [cell phone] is replaced by [old nokia phone with scratches]
So something like "SCUMM lite".
Of course, [cell phone], [xxx] and [old nokia phone with scratches] are objects that already exist in the database. But while [cell phone] is of type [inventory-item], [xxx] is of type [contact], so there can't just be no simple link between some database-tables
I got a very basic idea about how I could achieve this but wonder if anyone has done that before and can give me a hint or even best practice