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