Advance configure
Full project tutorial
Release Notes
You can create database for your application with our advanced Database Designer. Understanding of database concept is needed in order to use this feature.
A database is an organized collection of data, so that it can be easily accessed and managed. When you configure your database tables, a database is automatically created for you.
A table is a collection of data within a database, organized in table format with rows and columns.
By creating data models (tables) and (optionally) configuring relationships between the tables, you design your application database. After that, you can add functions to your application that allow you to populate these databases with information.
<aside> 💡 Jitera uses classic relational databases that are fully compatible with MySQL or PostgreSQL.
</aside>
To create a table**,** go to Database ****menu and click the + Add table button.
On clicking the button, a modal will show up. Enter the table name with optional comment, and click the + Add table button to save.
Enter a title (required) and description (optional). Click + Add Table button. The Add new table modal will close ****and ****the ****new table will appear in the designer's panel
Within each new table, system columns are created by default:
ID
(unique identifier for the model)CreatedAt
UpdatedAt
These columns are for tracking the life cycle and changes of table records. They cannot be renamed or deleted.
Once you created your first table, you can click + Add table button from the top right menu to create more tables.
To edit a table, click on a table name. The edit table modal will open immediately.
Click on the Save button to save your changes.
If you need to delete a table, click on a table to open the edit table modal. Click on the delete button (shown in red trash icon) and click Yes on the confirmation dialog. Once you confirm the deletion, the table will be permanently deleted and disappear from the database canvas.
To add a new column, click on the + Add column button at the bottom of the table. A modal to add the new column will show up.
Click on the + Add column button to save your changes. The column name and its type will be displayed in the table.
To edit a table ****column, click on the column name in the table. The edit column ****modal will open immediately.
Click on the Save button to save your changes. The new column name and its type will be displayed in the table.
If you need to delete a table column, click on a column to open the edit column modal. Then click on the delete button (shown in red trash icon) and click Yes on the confirmation dialog. Once you confirm the deletion, the table column will be permanently deleted and disappear from the table.
To create a link between the table, start drag on the border of column name, draw a line to border of other table.
After dragged the line, The add new relation ****table will open immediately with pre-filling values
Click “Save” button to save your changes. The line will cont name and its type will be displayed in the table.
An arrow appears between the table to indicate the relationship. Also, new column will appear in each table - they will allow you to refer from one related table to another
To edit a table relation**,** click “table relation link”, The Edit relation will open immediately
Click “Save” button to save your changes or “Trash” button, to delete a relation**.** The relation like name will disappear in the designer's panel.
Relationships can be established between two tables - to determine how table record created from them will relate to each other and interact. There are two types of such links:
Description
Standard string field
Format options
Hiragana
— rendered and validated with Hiragana format
Katakana
— rendered and validated with Katakana format
Phone
— rendered and validated with phone format
Email
— rendered and validated with email format
URL
— rendered and validated with URL format
Min & Max
— minimum and maximum of string length
From & To
— The string length must be included in a given interval. The value for this option must be a range
Equal
— the string length must be equal to the given value
Description
Multiline text field
Format options
Hiragana
— rendered and validated with Hiragana format
Katakana
— rendered and validated with Katakana format
Phone
— rendered and validated with phone format
Email
— rendered and validated with email format
URL
— rendered and validated with URL format
Min & Max
— minimum and maximum of string length
From & To
— The string length must be included in a given interval. The value for this option must be a range
Equal
— the string length must be equal to the given value
Description
This is an integer number for counting
Format options
Only integer
— To specify that only integer numbers are allowed
Greater than
— Specifies the value must be greater than the supplied value
Greater than or equal to
— Specifies the value must be greater than or equal to the supplied value
Less than
— Specifies the value must be less than the supplied value
Less than or equal to
— Specifies the value must be less than or equal to the supplied value
Other than
— Specifies the value must be other than the supplied value
Description
Float values with standard precision
Format options