saved_table_views

-1 rows


Description

Named, user-defined configurations of client-side tables (filters, search, sort order, visible columns, column order).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
user_id int8 19 null
users.id saved_table_views_user_id_fkey C
organization_id int8 19 √ null
organizations.id saved_table_views_organization_id_fkey C

If null, the view is global to the user. Otherwise, it is specific to the user and the organization.

table_name text 2147483647 null

Client-defined identifier of the table the view applies to.

name text 2147483647 null

User-supplied name for the view. Unique per user, table, and organization.

settings jsonb 2147483647 null

Client-defined JSON describing the view, e.g., filters, search, sort order, visible columns, and column order.

base_view text 2147483647 √ null

Client-defined identifier of the view this view is based on, if any.

Indexes

Constraint Name Type Sort Column(s)
saved_table_views_pkey Primary key Asc id
saved_table_views_organization_id_idx Performance Asc organization_id
saved_table_views_user_id_table_name_organization_id_name_key Must be unique Asc/Asc/Asc/Asc user_id + table_name + organization_id + name

Relationships