NEW-ERD2
Tables (44)
ACHIEVEMENTS
- id — BIGINT — NOT NULL
- achievement_code — VARCHAR(100) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- condition_type — VARCHAR(50) — NOT NULL
- condition_value — BIGINT — NOT NULL
- reward_currency_type — VARCHAR(30)
- reward_amount — BIGINT — NOT NULL
- reward_item_id — BIGINT — Foreign key → ITEMS.id
- is_active — BOOLEAN — NOT NULL
APP_DEVICES
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- device_uuid — VARCHAR(100) — NOT NULL
- device_name — VARCHAR(100)
- os_type — VARCHAR(30)
- app_version — VARCHAR(30)
- registered_at — DATETIME — NOT NULL
- last_active_at — DATETIME
CONFLICT_ALERTS
- id — BIGINT — NOT NULL
- repository_id — BIGINT — Foreign key → REPOSITORIES.id — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- branch_name — VARCHAR(100)
- severity — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- detected_at — DATETIME — NOT NULL
- resolved_at — DATETIME
CONFLICT_ALERT_TARGETS
- id — BIGINT — NOT NULL
- conflict_alert_id — BIGINT — Foreign key → CONFLICT_ALERTS.id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- file_editing_session_id — BIGINT — Foreign key → FILE_EDITING_SESSIONS.id
- opponent_user_id — BIGINT — Foreign key → USERS.id
- opponent_branch_name — VARCHAR(100)
- alert_level — VARCHAR(30) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- delivered_at — DATETIME
- read_at — DATETIME
- acknowledged_at — DATETIME
CURRENCY_TRANSACTIONS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- transaction_type — VARCHAR(30) — NOT NULL
- source_type — VARCHAR(50)
- source_id — BIGINT
- currency_type — VARCHAR(30) — NOT NULL
- amount — BIGINT — NOT NULL
- balance_after — BIGINT
- created_at — DATETIME — NOT NULL
CURRENCY_WALLETS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- currency_type — VARCHAR(30) — NOT NULL
- amount — BIGINT — NOT NULL
- updated_at — DATETIME — NOT NULL
Copy Of LOCAL_APP_SETTINGS (CopyOfLOCAL_APP_SETTINGS)
- id — BIGINT — NOT NULL
- user_server_id — INT
- device_server_id — INT
- device_uuid — TEXT
- language — TEXT
- theme_code — TEXT
- music_volume — INT
- notifications_enabled — INT — NOT NULL
- dashboard_config_json — TEXT
- default_panel — TEXT
- background_reactivity_enabled — INT — NOT NULL
- mini_mode_enabled — INT — NOT NULL
- auto_launch — INT — NOT NULL
- start_in_tray — INT — NOT NULL
- updated_at — DATETIME
FILE_EDITING_SESSIONS
- id — BIGINT — NOT NULL
- repository_id — BIGINT — Foreign key → REPOSITORIES.id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- app_device_id — BIGINT — Foreign key → APP_DEVICES.id — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- branch_name — VARCHAR(100)
- detection_type — VARCHAR(50)
- session_type — VARCHAR(30)
- last_diff_weight — VARCHAR(30)
- status — VARCHAR(30) — NOT NULL
- started_at — DATETIME — NOT NULL
- last_heartbeat_at — DATETIME
- ended_at — DATETIME
- ended_reason — VARCHAR(50)
FOCUS_SESSIONS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- session_type — VARCHAR(30) — NOT NULL
- focus_minutes — INT — NOT NULL
- break_minutes — INT — NOT NULL
- completed_rounds — INT — NOT NULL
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
- completed — BOOLEAN — NOT NULL
- reward_collected — BOOLEAN — NOT NULL
GIT_ACTIVITY_LOGS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- repository_id — BIGINT — Foreign key → REPOSITORIES.id — NOT NULL
- provider — VARCHAR(30)
- activity_type — VARCHAR(30) — NOT NULL
- external_event_id — VARCHAR(100)
- commit_sha — VARCHAR(100)
- occurred_at — DATETIME — NOT NULL
GIT_FLOW_EVENTS
- id — BIGINT — NOT NULL
- repository_id — BIGINT — Foreign key → REPOSITORIES.id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id
- event_type — VARCHAR(50) — NOT NULL
- branch_name — VARCHAR(100)
- target_branch_name — VARCHAR(100)
- commit_sha — VARCHAR(100)
- occurred_at — DATETIME — NOT NULL
- meta_json — TEXT
GIT_FLOW_POSITIONS
- id — BIGINT — NOT NULL
- repository_id — BIGINT — Foreign key → REPOSITORIES.id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- current_branch_name — VARCHAR(100)
- current_commit_sha — VARCHAR(100)
- last_event_id — BIGINT — Foreign key → GIT_FLOW_EVENTS.id
- last_active_at — DATETIME
INVENTORIES
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- item_id — BIGINT — Foreign key → ITEMS.id — NOT NULL
- quantity — INT — NOT NULL
- acquired_at — DATETIME — NOT NULL
ITEMS
- id — BIGINT — NOT NULL
- item_code — VARCHAR(100) — NOT NULL
- item_name — VARCHAR(100) — NOT NULL
- item_type — VARCHAR(50)
- rarity — VARCHAR(30)
- price_currency_type — VARCHAR(30)
- price_amount — INT — NOT NULL
- asset_key — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
JIRA_TODO_LINKS
- id — BIGINT — NOT NULL
- todo_id — BIGINT — Foreign key → TODOS.id — NOT NULL
- jira_issue_id — VARCHAR(100)
- jira_issue_key — VARCHAR(100) — NOT NULL
- jira_project_key — VARCHAR(100)
- jira_issue_type — VARCHAR(100)
- jira_status — VARCHAR(100)
- jira_assignee_account_id — VARCHAR(100)
- jira_assignee_name — VARCHAR(100)
- jira_sprint_id — VARCHAR(100)
- jira_sprint_name — VARCHAR(100)
- jira_url — TEXT
- sync_status — VARCHAR(30) — NOT NULL
- last_synced_at — DATETIME
- created_at — DATETIME — NOT NULL
LOCAL_APP_SETTINGS
- id — BIGINT — NOT NULL
- user_server_id — INT
- device_server_id — INT
- device_uuid — TEXT
- language — TEXT
- theme_code — TEXT
- music_volume — INT
- notifications_enabled — INT — NOT NULL
- dashboard_config_json — TEXT
- default_panel — TEXT
- background_reactivity_enabled — INT — NOT NULL
- mini_mode_enabled — INT — NOT NULL
- auto_launch — INT — NOT NULL
- start_in_tray — INT — NOT NULL
- updated_at — DATETIME
LOCAL_ASSET_CACHE
- id — BIGINT — NOT NULL
- asset_key — TEXT — NOT NULL
- local_path — TEXT
- asset_version — TEXT
- downloaded_at — DATETIME
- last_used_at — DATETIME
LOCAL_FILE_WATCH_STATES
- id — BIGINT — NOT NULL
- workspace_id — INT — Foreign key → LOCAL_WORKSPACES.id — NOT NULL
- file_path — TEXT — NOT NULL
- editor_type — TEXT
- branch_name — TEXT
- session_type — TEXT
- diff_weight — TEXT
- is_open — INT — NOT NULL
- is_dirty — INT — NOT NULL
- last_event_at — DATETIME
- last_sync_at — DATETIME
LOCAL_MORNING_BRIEFING_CACHE
- id — BIGINT — NOT NULL
- workspace_id — INT — Foreign key → LOCAL_WORKSPACES.id — NOT NULL
- remote_branch — TEXT
- base_commit_sha — TEXT
- target_commit_sha — TEXT
- summary_preview — TEXT
- created_at — DATETIME
- expires_at — DATETIME
LOCAL_NOTIFICATION_CACHE
- id — BIGINT — NOT NULL
- server_notification_id — INT
- notification_type — TEXT
- title — TEXT
- body — TEXT
- reference_type — TEXT
- reference_id — INT
- severity — TEXT
- is_dismissed_local — INT — NOT NULL
- created_at — DATETIME
- cached_at — DATETIME
LOCAL_ROOM_DRAFTS
- id — BIGINT — NOT NULL
- room_server_id — INT — NOT NULL
- placement_payload_json — TEXT
- is_dirty — INT — NOT NULL
- last_modified_at — DATETIME
LOCAL_SYNC_QUEUE
- id — BIGINT — NOT NULL
- workspace_id — INT — Foreign key → LOCAL_WORKSPACES.id — NOT NULL
- event_type — TEXT — NOT NULL
- payload_json — TEXT
- status — TEXT — NOT NULL
- retry_count — INT — NOT NULL
- created_at — DATETIME
- last_retry_at — DATETIME
LOCAL_UI_PREFERENCES
- id — BIGINT — NOT NULL
- app_settings_id — INT — Foreign key → LOCAL_APP_SETTINGS.id — NOT NULL
- current_mode — TEXT
- last_open_panel — TEXT
- default_start_panel — TEXT
- panel_state_json — TEXT
- panel_order_json — TEXT
- updated_at — DATETIME
LOCAL_WINDOW_LAYOUTS
- id — BIGINT — NOT NULL
- app_settings_id — INT — Foreign key → LOCAL_APP_SETTINGS.id — NOT NULL
- mode — TEXT
- monitor_id — TEXT
- pos_x — INT
- pos_y — INT
- width — INT
- height — INT
- always_on_top — INT — NOT NULL
- opacity — REAL
- updated_at — DATETIME
LOCAL_WORKSPACES
- id — BIGINT — NOT NULL
- repository_server_id — INT
- local_repo_path — TEXT — NOT NULL
- detection_type — TEXT
- ignore_patterns_json — TEXT
- is_active — INT — NOT NULL
- last_scanned_at — DATETIME
MEMOS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- content — TEXT
- updated_at — DATETIME — NOT NULL
MESSAGES
- id — BIGINT — NOT NULL
- sender_user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- receiver_user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- repository_id — BIGINT — Foreign key → REPOSITORIES.id
- body — TEXT — NOT NULL
- message_type — VARCHAR(30)
- is_read — BOOLEAN — NOT NULL
- read_at — DATETIME
- created_at — DATETIME — NOT NULL
NOTIFICATIONS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- notification_type — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- body — TEXT
- reference_type — VARCHAR(50)
- reference_id — BIGINT
- severity — VARCHAR(30)
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- read_at — DATETIME
OAUTH_ACCOUNTS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(100) — NOT NULL
- provider_login — VARCHAR(100)
- provider_email — VARCHAR(255)
- avatar_url — TEXT
- access_token_ref — TEXT
- refresh_token_ref — TEXT
- token_expires_at — DATETIME
- connected_at — DATETIME — NOT NULL
- last_synced_at — DATETIME
PURCHASE_HISTORIES
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- item_id — BIGINT — Foreign key → ITEMS.id — NOT NULL
- currency_type — VARCHAR(30) — NOT NULL
- price_amount — BIGINT — NOT NULL
- purchased_at — DATETIME — NOT NULL
REPOSITORIES
- id — BIGINT — NOT NULL
- provider — VARCHAR(30) — NOT NULL
- provider_repo_id — VARCHAR(100) — NOT NULL
- owner_name — VARCHAR(100)
- repo_name — VARCHAR(100) — NOT NULL
- full_name — VARCHAR(200) — NOT NULL
- default_branch — VARCHAR(100)
- visibility — VARCHAR(30)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
REPOSITORY_MEMBERS
- id — BIGINT — NOT NULL
- repository_id — BIGINT — Foreign key → REPOSITORIES.id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- oauth_account_id — BIGINT — Foreign key → OAUTH_ACCOUNTS.id
- repo_role — VARCHAR(50)
- is_active — BOOLEAN — NOT NULL
- joined_at — DATETIME — NOT NULL
- last_seen_at — DATETIME
REWARD_HISTORIES
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- item_id — BIGINT — Foreign key → ITEMS.id
- reward_type — VARCHAR(50) — NOT NULL
- source_provider — VARCHAR(50)
- source_event_id — VARCHAR(100)
- currency_type — VARCHAR(30)
- amount — BIGINT — NOT NULL
- rewarded_at — DATETIME — NOT NULL
ROOMS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- room_name — VARCHAR(100)
- theme_code — VARCHAR(50)
- background_code — VARCHAR(50)
- is_main — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
ROOM_PLACEMENTS
- id — BIGINT — NOT NULL
- room_id — BIGINT — Foreign key → ROOMS.id — NOT NULL
- item_id — BIGINT — Foreign key → ITEMS.id — NOT NULL
- pos_x — INT
- pos_y — INT
- z_index — INT
- rotation — INT
- flipped — BOOLEAN — NOT NULL
- placed_at — DATETIME — NOT NULL
ROOM_PRESETS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- room_id — BIGINT — Foreign key → ROOMS.id — NOT NULL
- preset_name — VARCHAR(100) — NOT NULL
- theme_code — VARCHAR(50)
- placement_snapshot_json — TEXT
- is_default — BOOLEAN — NOT NULL
- last_applied_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
SOUND_TRACKS
- id — BIGINT — NOT NULL
- track_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(30) — NOT NULL
- duration_seconds — INT
- thumbnail_url — TEXT
- file_url — TEXT — NOT NULL
- mood_code — VARCHAR(50)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
TODOS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- status — VARCHAR(30) — NOT NULL
- priority — VARCHAR(30)
- category — VARCHAR(50)
- due_date — DATETIME
- is_jira_linked — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
USERS
- id — BIGINT — NOT NULL
- display_name — VARCHAR(100)
- profile_image_url — TEXT
- primary_provider — VARCHAR(50)
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- last_login_at — DATETIME
USER_ACHIEVEMENTS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- achievement_id — BIGINT — Foreign key → ACHIEVEMENTS.id — NOT NULL
- progress_value — BIGINT — NOT NULL
- is_completed — BOOLEAN — NOT NULL
- completed_at — DATETIME
- reward_claimed — BOOLEAN — NOT NULL
- claimed_at — DATETIME
USER_DAILY_STATS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- stat_date — DATE — NOT NULL
- git_commit_count — INT — NOT NULL
- git_push_count — INT — NOT NULL
- pr_mr_count — INT — NOT NULL
- completed_todo_count — INT — NOT NULL
- focus_minutes — INT — NOT NULL
- app_usage_minutes — INT — NOT NULL
- earned_currency_amount — BIGINT — NOT NULL
- updated_at — DATETIME — NOT NULL
USER_ENVIRONMENT_SETTINGS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- location_name — VARCHAR(100)
- weather_enabled — BOOLEAN — NOT NULL
- time_reactivity_enabled — BOOLEAN — NOT NULL
- background_reactivity_enabled — BOOLEAN — NOT NULL
- updated_at — DATETIME — NOT NULL
USER_UI_PREFERENCES
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- current_mode — VARCHAR(30) — NOT NULL
- last_open_panel — VARCHAR(50)
- default_start_panel — VARCHAR(50)
- panel_order_json — TEXT
- panel_state_json — TEXT
- updated_at — DATETIME — NOT NULL
USER_UNLOCKS
- id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- unlock_type — VARCHAR(30) — NOT NULL
- unlock_ref_id — BIGINT — NOT NULL
- unlocked_at — DATETIME — NOT NULL