specs/models/M_TABLE

Table

A Tulip Table is a simulated database table that the user can create and edit in order to store complex data. The fields are user created and completely customizable except for a required ID field (see Table Field for more details).

From a technical standpoint, a Tulip Table is essentially a wrapper around a Postgres table. However, we also store some metadata about Tables described below.

It contains the following Models:

Tulip Table Metadata

Name Description
Name The display name for the table
Description Short description of the table added by the user
Last Modified A timestamp of the last time someone edited the table shape. Adding or editing a row does not count.
Hidden “Deleting” the table in the UI only soft deletes it. Tables that are soft deleted can later be restored.
Created By The user that initially created the Table
Created At The date and time that the Table was initially created
Deleted By The user that deleted the Table
Deleted At The date and time that the Table was deleted

Tests

IDName
QA-T80Table Management : 01 - Create a table
QA-T81Table Management : 02 - Delete a table
QA-T82Table Management : 03 - Restore a deleted table
QA-T83Table Management : 04 - Edit a table's name and description
QA-T84Table Management : 05 - Add columns to a table
QA-T85Table Management : 06 - Edit a table column
QA-T86Table Management : 07 - Edit a table column description
QA-T87Table Management : 08 - Delete a table column
QA-T88Table Management : 09 - Restore a deleted table column
QA-T89Table Management : 10 - Reorder table columns
QA-T90Table Management : 11 - Resize table columns
QA-T92Table Management : 12 - Create table records from the table detail page
QA-T93Table Management : 13 - Sort table records by column in table view
QA-T94Table Management : 14 - Load multiple pages of table records in table view
QA-T241Embedded Tables : 00 - Embed a Tulip Table in an app
QA-T242Embedded Tables : 00 - Sort an embedded table
QA-T243Embedded Tables : 00 - Connect an embedded Tulip Table to a Table record
QA-T244Embedded Tables : 00 - Filter an embedded table
QA-T245Embedded Tables : 00 - Handle deleted fields in embedded tables
QA-T246Embedded Tables : 00 - Handle a Tulip Table change in an embedded table
QA-T396Widgets - Digital History Record Widget
QA-T397Table Links : 01 - Creating Table Links
QA-T398Table Links : 02 - Linking Records via Details Page
QA-T399Table Links : 03 - Linking Records via App Triggers
QA-T400Table Links : 04 - Deleting Linking Columns