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.
A one-to-one relationship occurs when a single row in Table A is linked to a single row in Table B. Each record in Table A has a direct and unique relationship with a single record in Table B.
For example, consider a Users
table and a Profiles
table:
Each user in the Users
table corresponds to a unique profile in the Profiles
table.
The Profiles
table will have a foreign key _user_id
that references the _id
field in the Users
table.
A one-to-many relationship occurs when a single row in Table A is linked to multiple rows in Table B. Each record in Table A can have multiple related records in Table B, but each record in Table B has only one corresponding record in Table A.
-
For example, consider a Categories
table and a Products
table:
Each category in the Categories
table can include multiple products from the Products
table.
The Products
table will have a foreign key _category_id
that references the _id
field in the Categories
table.
A many-to-many relationship occurs when multiple rows in Table A are linked to multiple rows in Table B. Each record in Table A can have many corresponding records in Table B and vice versa.
-
For example, consider a Students
table and a Courses
table:
Each student can enroll in multiple courses.
Each course can have multiple students enrolled.
This relationship is typically implemented using a junction table, such as an Enrollments
table, which contains foreign keys _student_id
and _course_id
that reference the _id
field in the Students
and Courses
tables, respectively.
When working with functions in Twidget, you can use the _id
fields to query related data and populate the complete data set into the main object.
Generate CRUD Endpoints
With Twidget, you can efficiently generate CRUD (Create, Read, Update, Delete) endpoints for your database tables upon their creation. This functionality is designed to streamline the development process and ensure that essential API operations are readily available. Enabling CRUD Endpoints. 1. Crea...
Database Tables
Database tables are essential components of your Twidget workspace, serving as the primary storage locations for your data. In Twidget, each table consists of rows and fields, meticulously designed for efficient data management and retrieval. Structure of Database Tables. - Rows: Each row in a datab...
Filter Data
In Twidget, you can easily filter and sort data within the database tables view. This allows you to refine and manipulate the data as needed. Below are the steps and options available for filtering and sorting data. Filtering Data. To filter data: 1. Click on the Filter Button: In the table toolbar,...
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: ...
Database Basics
Twidget offers a comprehensive database solution for all workspaces. Here's an overview of how databases are structured and managed within Twidget: Database Structure. 1. Tables: A database may contain multiple tables. Each table stores data in a structured format. 2. Fields: Tables consist of field...