Post by @andyc
#LittleFedi SQLite schema dump
| Table | Records |
|---|---|
| account_deletion_destinations | 0 |
| account_deletion_runs | 1 |
| account_domain_blocks | 0 |
| account_exports | 0 |
| account_imports | 0 |
| accounts | 1911 |
| announcements | 0 |
| blocks | 0 |
| bookmarks | 0 |
| bubble_instances | 1 |
| bun_migration_locks | 0 |
| bun_migrations | 2 |
| commercial_domain_blocks | 0 |
| custom_emojis | 396 |
| domain_allows | 0 |
| domain_blocks | 0 |
| email_digest_state | 0 |
| email_verifications | 0 |
| emoji_reactions | 2 |
| favourites | 128 |
| featured_tags | 0 |
| federation_policy_state | 1 |
| filter_keywords | 0 |
| filters | 0 |
| followed_tags | 5 |
| follows | 208 |
| home_feed | 816 |
| instance_meta | 0 |
| instances | 638 |
| invites | 2 |
| job_payloads | 35 |
| jobs | 4 |
| list_accounts | 10 |
| lists | 1 |
| markers | 1 |
| media_attachments | 838 |
| media_cache_failures | 0 |
| media_storage_migrations | 0 |
| mentions | 2480 |
| mesh_identity | 0 |
| mfa_recovery_codes | 10 |
| moderation_logs | 31 |
| mutes | 0 |
| notifications | 8 |
| oauth_applications | 2 |
| oauth_tokens | 2 |
| password_resets | 0 |
| poll_options | 101 |
| poll_votes | 1 |
| polls | 26 |
| push_subscriptions | 0 |
| quote_authorizations | 0 |
| relays | 0 |
| reports | 0 |
| scheduled_statuses | 0 |
| self_destruct_runs | 0 |
| sessions | 7 |
| status_previews | 316 |
| status_tags | 2416 |
| statuses | 5357 |
| tags | 1407 |
| tombstones | 3 |
| vapid_keys | 1 |
| welcome_direct_messages | 0 |