Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| user_id | int8 | 19 | null |
|
|
||||||
| organization_id | int8 | 19 | √ | null |
|
|
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 |