Store Inspector

20 tables in the data layer

Archivable

1
MovesTable Stores every breakdancing move in the arsenal with video attachment and learning state
id text
name text
learning_state text
category text
video_path text
original_video_name text
managed_album_asset_id text
managed_album_filename text
managed_album_name text
archived_at datetime
archive_reason text
notes text
content_hash text
created_at datetime

ContentAddressed

3
AssetManifestTable Content-addressed registry of every video asset — the single source of truth for binary files
content_hash text
file_size_bytes int
mime_type text
duration_ms int
width int
height int
local_path text
local_verified_at datetime
source_type text
source_name text
imported_at datetime
deleted_at datetime
tombstone_reason text
copy_count int
last_sync_at datetime
CombosTable Named sequences of moves representing practiced combinations
id text
name text
notes text
active_video_path text
content_hash text
MovesTable Stores every breakdancing move in the arsenal with video attachment and learning state
id text
name text
learning_state text
category text
video_path text
original_video_name text
managed_album_asset_id text
managed_album_filename text
managed_album_name text
archived_at datetime
archive_reason text
notes text
content_hash text
created_at datetime

Polymorphic

1
FsrsCardsTable FSRS 2.0 spaced-repetition card state for every reviewable entity
entity_id text
entity_type text
stability real
difficulty real
due datetime
last_review datetime
reps int
lapses int
fsrs_state int

SyncAware

2
CombosTable Named sequences of moves representing practiced combinations
id text
name text
notes text
active_video_path text
content_hash text
MovesTable Stores every breakdancing move in the arsenal with video attachment and learning state
id text
name text
learning_state text
category text
video_path text
original_video_name text
managed_album_asset_id text
managed_album_filename text
managed_album_name text
archived_at datetime
archive_reason text
notes text
content_hash text
created_at datetime

Unconcerned

16
AchievementsTable Gamification badges earned per move through progressive mastery tiers
id text
move_id text
tier text
unlocked_at datetime
created_at datetime
move_id \u2192 moves
AssetCopiesTable Tracks every copy of a video asset across cloud providers with sync status
id text
content_hash text
provider text
remote_path text
remote_etag text
verified_at datetime
status text
upload_progress real
error_message text
created_at datetime
updated_at datetime
content_hash \u2192 asset_manifest
AuraLinksTable Directed edges in the move transition graph with affinity weights
from_move_id text
to_move_id text
affinity text
notes text
created_at datetime
from_move_id \u2192 movesto_move_id \u2192 moves
AuraPresetsTable Named presets for aura link graph configurations
id text
name text
is_default int
created_at datetime
BattleResultsTable Scored results from competitive practice battle sessions
id text
score int
moves_reviewed int
good_count int
hard_count int
again_count int
longest_streak int
difficulty text
played_at datetime
ComboMovesTable Join table linking combos to their ordered move sequences
id text
sequence_index int
combo_id text
move_id text
combo_id \u2192 combosmove_id \u2192 moves
DeckMovesTable Join table linking manual decks to their hand-picked moves
deck_id text
move_id text
deck_id \u2192 decksmove_id \u2192 moves
DecksTable Custom review decks — smart (filter-based) or manual (hand-picked moves)
id text
name text
deck_type text
filter_criteria text
session_size int
created_at datetime
updated_at datetime
LabEntriesTable Session log entries within a lab — text notes and video clips
id text
lab_id text
content text
video_path text
created_at datetime
lab_id \u2192 labs
LabMovesTable Join table linking labs to their curated move selections with ordering
lab_id text
move_id text
sequence_index int
added_at datetime
lab_id \u2192 labsmove_id \u2192 moves
LabsTable Practice projects and curated sets for focused breakdancing sessions
id text
name text
lab_type text
status text
notes text
created_at datetime
updated_at datetime
MilestonesTable Goal markers within a lab — checkpoints the breakdancer aims to hit
id text
lab_id text
title text
notes text
completed_at datetime
created_at datetime
lab_id \u2192 labs
ReviewsTable Immutable log of every flashcard review rating event
id text
rating text
review_type text
reviewed_at datetime
move_id text
combo_id text
entity_id_snapshot text
entity_type text
entity_display_name text
entity_category text
fsrs_pre_state int
fsrs_post_state int
move_id \u2192 movescombo_id \u2192 combos
SyncLogTable Change-tracking log for two-phase cloud sync — records every mutation
entity_id text
entity_table text
action text
changed_at datetime
synced boolean
video_synced boolean
SyncOperationsTable Queue of pending and in-progress sync operations across all providers
id text
content_hash text
provider_id text
operation_type text
status text
priority int
retry_count int
max_retries int
error_message text
bytes_transferred int
total_bytes int
created_at datetime
started_at datetime
completed_at datetime
SyncProvidersTable Configured cloud storage providers with auth state and quota tracking
id text
provider_type text
display_name text
enabled boolean
config_json text
quota_bytes int
used_bytes int
last_auth_at datetime
created_at datetime