SyncProvidersTable
tableBreakdex::DataStores::SyncProvidersTable
Configured cloud storage providers with auth state and quota tracking
Each row is a cloud provider the breakdancer has connected — iCloud, Google Drive, or S3. The config_json holds provider-specific settings. Quota tracking helps the UI warn when storage is running low. Disabling a provider pauses all sync operations without losing configuration.
Relationships
Depends On 1
sync_providers_dao
Reads From 1
asset_copies_table
Breaks If 2
provider_type_enum_changesconfig_json_schema_changes
Data Access
Reads 1
asset_copies_table
Answers
States
| State | Behavior |
|---|---|
| disabled | message: Provider disabled — all sync operations paused, configuration retained shows: paused_provider_badge |
| no Auth | message: last_auth_at is NULL — provider configured but never authenticated shows: auth_required_warning |
| quota Unknown | message: quota_bytes NULL — provider does not report quota (e.g., local-only fallback) shows: no_quota_display |
Columns
| Name | Type | Constraints |
|---|---|---|
| id | text | NOT NULL |
| provider_type | text | NOT NULL ENUM: icloud, gdrive, s3 |
| display_name | text | NOT NULL |
| enabled | boolean | NOT NULL DEFAULT: true |
| config_json | text | |
| quota_bytes | int | |
| used_bytes | int | |
| last_auth_at | datetime | |
| created_at | datetime | NOT NULL DEFAULT: now |
Primary Key
id