yyy_sqlite.php

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

Table: collection_profiles

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

Schema

cidnametypenotnulldefaultpk
0 id INTEGER 0 1
1 profile_name TEXT 1 0
2 lookback_days INTEGER 1 7 0
3 sort_by TEXT 1 'views' 0
4 observation_limit INTEGER 1 100 0
5 download_policy TEXT 1 'NONE' 0
6 download_limit INTEGER 1 0 0
7 transcript_policy TEXT 1 'ON_DEMAND' 0
8 filter_json TEXT 1 '{}' 0
9 created_at TEXT 1 CURRENT_TIMESTAMP 0
10 updated_at TEXT 1 CURRENT_TIMESTAMP 0

Data

id profile_name lookback_days sort_by observation_limit download_policy download_limit transcript_policy filter_json created_at updated_at
```