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