Pixel Crushers Forum

Hi Tony,

Is there any place I can see a diagram (like an entity relationship diagram) of the dialogue system database?

Or is there a way to get a list of all the tables and fields?

Thanks
Pete

Hi Pete,

What kind of tables/diagrams do you have in mind? How would you use it?

Currently the only lists are in the Dialogue Editor. For example, the Actors page shows a reorderable list of all actors.

Hi Tony,

I'm used to relational databases, and still new to unity and dialogue system, so that might be leading my thinking the wrong way.

I was thinking 2 things when I wrote my question.

1. What fields are defined against each entity (I find that knowing that helps me understand how things fit together)
2. Whether there are relationships (e.g. Foreign keys) between the entities that help me understand how to data load and query different things.

For example how is a node and its parent conversation connected together? Is the conversation ID stored in the node data somewhere? If so, is there any other data stored too? Such as it's position in the conversation tree?

If I'm way off here, then I'd really appreciate you explaining a bit about the conceptual design and how you see things connecting.

Thank you
Pete

Hi,

The Dialogue System includes full source code, so you can use your tool of choice to generate UML diagrams, or you can browse the complete API (e.g., DialogueDatabase class).

However, for the most part, the Dialogue System seeks to abstract that away so you can focus on generating and using content. If you have any specific questions about how internal data, just let me know.

Each entity type (Actor, Item, Conversation, etc.) has a customizable list of fields. You can customize those fields on the Dialogue Editor's Templates page.

Thanks Tony,

The link you sent is helpful. I'll have a look at things with that and come back to you if I have any more questions.

Pete

Hi Pete,

Sounds good! I'm here to answer whatever questions you have.