WebFrost database schema

WebFrost database schema An entity-relationship diagram generated by Archify. search access archive tags automation snapshots_fts · SQLite: FTS5 virtual table · Entity · search snapshots_fts rowid INTEGER url FTS5 title FTS5 text_content FTS5 tags FTS5 search_index · PostgreSQL, MySQL instead · Entity · search search_index PKFK snapshot_id BIGINT url TEXT title TEXT text_content TEXT tags TEXT search_text TEXT search_vector tsvector admin_users · Entity · access admin_users PK id INTEGER UK username TEXT password_hash TEXT created_at TEXT api_keys · Entity · access api_keys PK id TEXT name TEXT key_hash TEXT expires_at TEXT last_used_at TEXT revoked_at TEXT created_at TEXT sessions · Entity · access sessions PK id TEXT username TEXT created_at TEXT expires_at TEXT snapshots · Entity · archive snapshots PK id INTEGER url TEXT status TEXT created_at TEXT archive_results · Entity · archive archive_results PK id INTEGER FK snapshot_id INTEGER extractor TEXT content TEXT created_at TEXT duration_ms INTEGER error TEXT size_bytes INTEGER job_queue · Entity · archive job_queue PK id INTEGER FK snapshot_id INTEGER status TEXT created_at TEXT heartbeat_at TEXT attempts INTEGER lease_token TEXT snapshot_tags · Entity · tags snapshot_tags PKFK snapshot_id INTEGER PKFK tag_id INTEGER tags · Entity · tags tags PK id INTEGER UK name TEXT UK slug TEXT color TEXT created_at TEXT schedules · Entity · automation schedules PK id INTEGER url TEXT cron TEXT created_at TEXT last_run_at TEXT next_run_at TEXT kind TEXT paused INTEGER last_status TEXT consecutive_failures INTEGER imports · Entity · automation imports PK id TEXT source_url TEXT format TEXT queued INTEGER skipped INTEGER created_at TEXT per extractor job, lease tagged applied indexed rowid Legend PK Primary key FK Foreign key UK Unique key One Many Optional