New_ERD

Tables (24)

ACHIEVEMENTS

  • id — CHAR(36)
  • achievement_code — VARCHAR(100)
  • title — VARCHAR(100)
  • description — TEXT
  • condition_type — VARCHAR(50)
  • condition_value — BIGINT
  • reward_currency_type — VARCHAR(30)
  • reward_amount — BIGINT
  • reward_item_id — CHAR(36) — Foreign key → ITEMS.id
  • is_active — INT

APP_DEVICES

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • device_uuid — VARCHAR(100)
  • device_name — VARCHAR(100)
  • os_type — VARCHAR(30)
  • app_version — VARCHAR(30)
  • registered_at — DATETIME
  • last_active_at — DATETIME

CONFLICT_ALERTS

  • id — CHAR(36)
  • repository_id — CHAR(36) — Foreign key → REPOSITORIES.id — NOT NULL
  • file_path — VARCHAR(500)
  • branch_name — VARCHAR(100)
  • severity — VARCHAR(30)
  • status — VARCHAR(30)
  • detected_at — DATETIME
  • resolved_at — DATETIME

CONFLICT_ALERT_TARGETS

  • id — CHAR(36)
  • conflict_alert_id — CHAR(36) — Foreign key → CONFLICT_ALERTS.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • file_editing_session_id — CHAR(36) — Foreign key → FILE_EDITING_SESSIONS.id
  • is_read — INT
  • acknowledged_at — DATETIME

CURRENCY_WALLETS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • currency_type — VARCHAR(30)
  • amount — BIGINT
  • updated_at — DATETIME

FILE_EDITING_SESSIONS

  • id — CHAR(36)
  • repository_id — CHAR(36) — Foreign key → REPOSITORIES.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • app_device_id — CHAR(36) — Foreign key → APP_DEVICES.id — NOT NULL
  • file_path — VARCHAR(500)
  • branch_name — VARCHAR(100)
  • detection_type — VARCHAR(50)
  • session_type — VARCHAR(30)
  • last_diff_weight — VARCHAR(30)
  • status — VARCHAR(30)
  • started_at — DATETIME
  • last_heartbeat_at — DATETIME
  • ended_at — DATETIME
  • ended_reason — VARCHAR(50)

GIT_ACTIVITY_LOGS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • repository_id — CHAR(36) — Foreign key → REPOSITORIES.id — NOT NULL
  • provider — VARCHAR(30)
  • activity_type — VARCHAR(30)
  • external_event_id — VARCHAR(100)
  • commit_sha — VARCHAR(100)
  • occurred_at — DATETIME

GIT_FLOW_EVENTS

  • id — CHAR(36)
  • repository_id — CHAR(36) — Foreign key → REPOSITORIES.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → USERS.id
  • event_type — VARCHAR(50)
  • branch_name — VARCHAR(100)
  • target_branch_name — VARCHAR(100)
  • commit_sha — VARCHAR(100)
  • occurred_at — DATETIME
  • meta_json — TEXT

INVENTORIES

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • item_id — CHAR(36) — Foreign key → ITEMS.id — NOT NULL
  • quantity — INT
  • acquired_at — DATETIME

ITEMS

  • id — CHAR(36)
  • item_code — VARCHAR(100)
  • item_name — VARCHAR(100)
  • item_type — VARCHAR(50)
  • rarity — VARCHAR(30)
  • price_currency_type — VARCHAR(30)
  • price_amount — INT
  • asset_key — VARCHAR(255)
  • is_active — INT

MEMOS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • content — TEXT
  • updated_at — DATETIME

MESSAGES

  • id — CHAR(36)
  • sender_user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • receiver_user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • repository_id — CHAR(36) — Foreign key → REPOSITORIES.id
  • body — TEXT
  • message_type — VARCHAR(30)
  • is_read — INT
  • read_at — DATETIME
  • created_at — DATETIME

NOTIFICATIONS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • notification_type — VARCHAR(50)
  • title — VARCHAR(200)
  • body — TEXT
  • reference_type — VARCHAR(50)
  • reference_id — CHAR(36)
  • is_read — INT
  • created_at — DATETIME

OAUTH_ACCOUNTS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • provider — VARCHAR(50)
  • provider_user_id — VARCHAR(100)
  • 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
  • last_synced_at — DATETIME

REPOSITORIES

  • id — CHAR(36)
  • provider — VARCHAR(30)
  • provider_repo_id — VARCHAR(100)
  • owner_name — VARCHAR(100)
  • repo_name — VARCHAR(100)
  • full_name — VARCHAR(200)
  • default_branch — VARCHAR(100)
  • visibility — VARCHAR(30)
  • is_active — INT
  • created_at — DATETIME
  • updated_at — DATETIME

REPOSITORY_MEMBERS

  • id — CHAR(36)
  • repository_id — CHAR(36) — Foreign key → REPOSITORIES.id — NOT NULL
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • oauth_account_id — CHAR(36) — Foreign key → OAUTH_ACCOUNTS.id
  • repo_role — VARCHAR(50)
  • is_active — INT
  • joined_at — DATETIME
  • last_seen_at — DATETIME

REWARD_HISTORIES

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • item_id — CHAR(36) — Foreign key → ITEMS.id
  • reward_type — VARCHAR(50)
  • source_provider — VARCHAR(50)
  • source_event_id — VARCHAR(100)
  • currency_type — VARCHAR(30)
  • amount — BIGINT
  • rewarded_at — DATETIME

ROOMS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • room_name — VARCHAR(100)
  • theme_code — VARCHAR(50)
  • background_code — VARCHAR(50)
  • is_main — INT
  • created_at — DATETIME
  • updated_at — DATETIME

ROOM_PLACEMENTS

  • id — CHAR(36)
  • room_id — CHAR(36) — Foreign key → ROOMS.id — NOT NULL
  • item_id — CHAR(36) — Foreign key → ITEMS.id — NOT NULL
  • pos_x — INT
  • pos_y — INT
  • z_index — INT
  • rotation — INT
  • flipped — INT
  • placed_at — DATETIME

ROOM_PRESETS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • room_id — CHAR(36) — Foreign key → ROOMS.id — NOT NULL
  • preset_name — VARCHAR(100)
  • theme_code — VARCHAR(50)
  • placement_snapshot_json — TEXT
  • is_default — INT
  • last_applied_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

TODOS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • title — VARCHAR(200)
  • description — TEXT
  • status — VARCHAR(30)
  • priority — VARCHAR(30)
  • category — VARCHAR(50)
  • due_date — DATETIME
  • is_jira_linked — INT
  • jira_issue_key — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME

USERS

  • id — CHAR(36)
  • display_name — VARCHAR(100)
  • profile_image_url — TEXT
  • primary_provider — VARCHAR(50)
  • status — VARCHAR(30)
  • created_at — DATETIME
  • updated_at — DATETIME
  • last_login_at — DATETIME

USER_ACHIEVEMENTS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • achievement_id — CHAR(36) — Foreign key → ACHIEVEMENTS.id — NOT NULL
  • progress_value — BIGINT
  • is_completed — INT
  • completed_at — DATETIME
  • reward_claimed — INT
  • claimed_at — DATETIME

USER_UNLOCKS

  • id — CHAR(36)
  • user_id — CHAR(36) — Foreign key → USERS.id — NOT NULL
  • unlock_type — VARCHAR(30)
  • unlock_ref_id — CHAR(36)
  • unlocked_at — DATETIME