Sign Up
Loading...

Authentication Table

An authentication table is a crucial component in Twidget that is used to store all necessary authentication information, essential for authenticating requests.

Overview

  • Purpose: To store authentication details such as email, password, token signature, and reset key.

  • Recommendation: It's recommended to use a users table for this purpose.

Use Data → Authentication to search the table's customers, suspend or resume access and manage independent sessions. See Customer authentication tools for the commands, login compatibility and session limits. These controls use this same table.

Requirements for Authentication Table

  1. Mandatory for Endpoints: An authentication table is necessary for generating authentication endpoints.

  2. Unique to Workspace: You can assign only one authentication table per workspace.

How to Assign an Authentication Table

Creating a New Table

When creating a new table, you have an option to designate it as the authentication table:

  1. Enable Authentication: Select "Enable" in the Authentication Table dropdown during table creation.

Updating an Existing Table

You can also update an existing table to become an authentication table by adjusting its settings in the table configuration.

Fields Generated by Authentication Table

When you generate authentication endpoints, the following fields are automatically created in the authentication table:

  • email: Stores user email addresses.

  • password: Stores user passwords in a hashed format for security.

  • token_signature: Stores token signatures as hashed values for added security.

  • reset_key: Stores reset keys in a hashed format for password reset operations.

Security Identifiers

In the database view:

  • The authentication table can be easily identified by a security icon on its table details.

Summary

To summarize, the authentication table in Twidget:

  • Stores critical authentication data.

  • Is a prerequisite for generating authentication endpoints.

  • Introduces security features by hashing sensitive information.

  • Can be easily identified and configured within the workspace.

Related Topics

Summarise Records

Use Summarize Records when you need a summary rather than a list of every record. Create a summary. 1. Add Summarize Records to your workflow. 2. Choose the table and add filters if you only want some records. 3. Open Output and add a calculation. 4. Choose Count, Sum, Average, Lowest or Highest. 5....

CSV Import

Twidget enables seamless import of data from a CSV file into your database. Follow the steps below to successfully import a CSV file. Step-by-Step Guide. 1. Initiate the Import: - Click on the Import button within the table toolbar. - Select Import from CSV from the dropdown. 2. Open Import Dialog: ...

Table Field Types

Each table column in Twidget has a data type. The available data types are: - Text - Number - Boolean - Date - Object Field Type Adherence. Data added to the table should adhere to the column's field type. When you manually enter data via the web application, the value editor will use the input type...

Table Relationships

In Twidget, you can connect database table data using the `_id` field that is automatically generated for every row in a table. This `_id` field is essential for creating and maintaining relationships across different tables. Types of Relationships. A one-to-one relationship occurs when a single row...

Database Storage

Managing your database storage effectively is crucial for ensuring optimal performance and cost-efficiency when using Twidget. Each entry within your database table utilizes a certain amount of storage space. Twidget provides intuitive tools to help you monitor and manage this storage. Viewing Datab...