Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BLOB | 2000000000 | null |
|
|
||||||
| parent_id | BLOB | 2000000000 | null |
|
|
||||||
| parent_index | INTEGER | 2000000000 | null |
|
|
||||||
| filter_id | INTEGER | 2000000000 | null |
|
|
||||||
| root_transaction_id | BLOB | 2000000000 | null |
|
|
||||||
| first_indexed_at | INTEGER | 2000000000 | null |
|
|
||||||
| last_indexed_at | INTEGER | 2000000000 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| bundle_data_items_s_pk | Primary key | Asc/Asc/Asc/Asc | id + parent_id + parent_index + filter_id |
| bundle_data_items_filter_id_idx | Performance | Asc | filter_id |
| bundle_data_items_parent_id_filter_id_idx | Performance | Asc/Asc | parent_id + filter_id |
| bundle_data_items_root_transaction_id_idx | Performance | Asc | root_transaction_id |
| sqlite_autoindex_bundle_data_items_1 | Must be unique | Asc/Asc/Asc/Asc | id + parent_id + parent_index + filter_id |
Relationships
Close relationships within degrees of separation
