Can I create new tables in the FusionAuth database?

[heitordanilo2003]

Currently, I need to relate my users with different schedules. To achieve this, I am creating schedules in another database and relating them with IDs. However, when I need to retrieve the data, I have to perform a select query on two different databases.

Therefore, I would like to know if it's possible to create new tables and establish relationships in the FusionAuth database to simplify data retrieval and increase performance.

[dan]

@heitordanilo2003

Welcome to the FusionAuth community!

It isn't possible to create new tables inside FusionAuth. However, you have a few options within the current supported extension points.

• You can correlate between two different databases, as you currently are.
• You can use the user.data and user.registration.data fields. These are arbitrary JSON objects and you can define your own schema inside them. They are searchable.
• You can use Entity Management. Entity Management lets you define your own entities (which also have data fields) and relationships between users and entities. This is paid functionality that requires a license key.

Hope that helps.
Dan