Table (or Collection) and Data Permission

A data table (or some called collection) is a group of related data (or columns). For example, the Movies table will have a list of movies with name, releaseDate, rating columns. And there can be many tables in a database.

In this document, you'll learn about:

1. User role - Config read, write, update and delete permission
2. Create a new table, or link to an existing one
3. Create table columns (or keys)

Before you begin, make sure you have already connected to a database

User Role and Data Permission

You can restrict users to perform an action they're not supported to by setting Data Permission for User Role. For example, only you can create/update/delete a Movie item, while everyone can view it.

User Roles are types of users, which are:

1. Admin: users that manage the database, including you
2. Everyone: everyone online, including admin

There are 4 types of access Permission to your data:

1. Read: allow someone to view, or list your data
2. Create: allow someone to create a new item on a data table
3. Update: allow someone to update an existing item on a data table
4. Delete: allow someone to remove an existing item on a data table

When you want to restrict everyone else except you to add, update or delete a Movie item, you will set Read permission to Everyone, and Admin for the rest. But if you need everyone to rate for a Movie, you will need to set Update to Everyone.

Create or Link to a table

To create a new table, or link to an existing one on your database, open (Database Panel) located at the bottom right of the Designer Panel. Navigate to your database connection, then:

1. Select Add or link a table
2. If you want to link to an existing table, switch on This is an existing table. Otherwise, it will create a new data table on your database.
3. Enter the table name and specify Permissions (see as mention above)
4. Your table is now created

Create table keys (or table columns)

As mention earlier, each table contains a few data columns. For example, name, releaseDate, rating are columns in a table. On some database, columns are also called keys.

Each data column is also defined with its data type. Current, :

• datetime: date and time data type
• text: any text, label, paragraph
• number: numeric data type
• boolean: only true or false values

Besides, there are a few other types that is also one of the above, but for convienient:

• image: basically type string (have upload image feature on some places in the Editor)

Note: if you linked to an existing table, for some database, Inverr will automatically get existing table keys. Otherwise, you can add keys to your table.

To add more table columns, you can:

1. Click on icon button (located at the further left of the table), a Add data field modal will popup.

2. Enter the following fields:

   • Name: column name, should be Latin letters in camelCase
   • Type: choose a type (i.e Text for name, or Datetime for releaseDate)
   • Default value: a value will be used if this field is empty on creation. You can enter value in placeholder variables (i.e John, {date.now}, or {calc(item.views + 1)})

3. Click Create to create. It will create a new column on your database, and will show an error if it already exist

4. Finished. The new table column should appear on your table view

Now, you've understand a data table (or collection) contains many table columns to store related data. For example, table Movie has its columns such as name, releaseDate and rating.

You can restrict users perform read, create, update or delete your data by specifying Data Permission. Which can either be Admin, or Everyone.