Join our Discord community — connect, share, and grow with us! Join Now

Database settings

Database settings

Fine-tune how Orbitype interacts with your database. Among other things, you can hide tables from non-technical users and define aliases.

//

TABLE_OF_CONTENTS

An image of https://s3.eu-central-1.wasabisys.com/orbitype/media/docs/4_4_0__database_settings.png

Hiding tables

If your database includes tables that should not be visible inside Orbitype for whatever reason, simply add them inside the hidden field. Write one table name per line, prefixes with a dash. The syntax follows the YAML array format.

Table aliases

A table may sometimes be referred to by more than one name. For example, the foreign keys admin_id and member_id may both point to a table called users. In such scenarios, you may inform Orbitype of such aliases to ensure that references are correctly resolved.

Simply add one alias per line inside the aliases field. The first value is the original name, the second one the alias. A table can have as many aliases as you want. The syntax follows the YAML object format.

Learn more

SQL wizard

Use the SQL wizard to quickly and easily create database tables. Even without any coding knowledge, you'll be able to create whatever data structure you need.