yyy_sqlite.php

DB: /mnt/d/_St/Shared/data/sort_local.sqlite3

Table: aggregate_definitions

rows: 0 / page: 1 / limit: 50 100 500

Schema

cidnametypenotnulldefaultpk
0 id INTEGER 0 1
1 server_aggregate_id INTEGER 0 0
2 aggregate_name TEXT 1 0
3 output_file_name TEXT 1 0
4 owner_server_user_id INTEGER 0 0
5 visibility TEXT 1 'PRIVATE' 0
6 server_group_id INTEGER 0 0
7 sort_by TEXT 1 'views' 0
8 filter_days INTEGER 1 7 0
9 page_size INTEGER 1 50 0
10 limit_count INTEGER 1 0 0
11 filter_json TEXT 1 '{}' 0
12 created_at TEXT 1 CURRENT_TIMESTAMP 0
13 updated_at TEXT 1 CURRENT_TIMESTAMP 0

Data

id server_aggregate_id aggregate_name output_file_name owner_server_user_id visibility server_group_id sort_by filter_days page_size limit_count filter_json created_at updated_at
```