Dialogue system database diagram

Announcements, support questions, and discussion for the Dialogue System.
Post Reply
UKMasters
Posts: 15
Joined: Sun Jun 28, 2020 3:41 pm

Dialogue system database diagram

Post by UKMasters »

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
User avatar
Tony Li
Posts: 22039
Joined: Thu Jul 18, 2013 1:27 pm

Re: Dialogue system database diagram

Post by Tony Li »

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.
UKMasters
Posts: 15
Joined: Sun Jun 28, 2020 3:41 pm

Re: Dialogue system database diagram

Post by UKMasters »

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
User avatar
Tony Li
Posts: 22039
Joined: Thu Jul 18, 2013 1:27 pm

Re: Dialogue system database diagram

Post by Tony Li »

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.
UKMasters
Posts: 15
Joined: Sun Jun 28, 2020 3:41 pm

Re: Dialogue system database diagram

Post by UKMasters »

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
User avatar
Tony Li
Posts: 22039
Joined: Thu Jul 18, 2013 1:27 pm

Re: Dialogue system database diagram

Post by Tony Li »

Hi Pete,

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