temp222
Tables (38)
activity_logs
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id
- entity_type — VARCHAR2(50) — NOT NULL
- entity_id — NUMBER(19) — NOT NULL
- action — VARCHAR2(100) — NOT NULL
- changes — CLOB
- created_at — TIMESTAMP — NOT NULL
ai_summaries
- id — NUMBER(19) — Primary key — NOT NULL
- github_issue_id — NUMBER(19) — Foreign key → github_issues.id
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id
- summary — CLOB
- risk_level — VARCHAR2(20)
- status — VARCHAR2(30) — NOT NULL
- model_version — VARCHAR2(100)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
api_specs
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- created_by_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- title — VARCHAR2(255) — NOT NULL
- method — VARCHAR2(10) — NOT NULL
- endpoint — VARCHAR2(255) — NOT NULL
- group_name — VARCHAR2(100)
- entity — VARCHAR2(100)
- summary — VARCHAR2(255)
- description — CLOB
- status — VARCHAR2(30)
- assignee_id — NUMBER(19) — Foreign key → workspace_members.id
- path_params — CLOB
- headers — CLOB
- query_params — CLOB
- request_body — CLOB
- response_status — NUMBER(10)
- response_body — CLOB
- version — VARCHAR2(50)
- source_type — VARCHAR2(30)
- related_issue_id — NUMBER(19) — Foreign key → github_issues.id
- related_pr_id — NUMBER(19) — Foreign key → github_pull_requests.id
- note — CLOB
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
bookmarks
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- thread_id — NUMBER(19) — Foreign key → threads.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
channel_read_status
- id — NUMBER(19) — Primary key — NOT NULL
- channel_id — NUMBER(19) — Foreign key → channels.id — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- last_read_thread_id — NUMBER(19) — Foreign key → threads.id
- last_read_at — TIMESTAMP — NOT NULL
channels
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- github_repository_id — NUMBER(19) — Foreign key → github_repositories.id
- name — VARCHAR2(120) — NOT NULL
- channel_type — VARCHAR2(30) — NOT NULL
- is_deletable — NUMBER(1) — NOT NULL
- display_order — NUMBER(10) — NOT NULL
- description — CLOB
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
documents
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- created_by_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- title — VARCHAR2(255) — NOT NULL
- content — CLOB
- category — VARCHAR2(50)
- generated_by — VARCHAR2(20)
- related_pr_id — NUMBER(19) — Foreign key → github_pull_requests.id
- visibility — VARCHAR2(30) — NOT NULL
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
erd_documents
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- created_by_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- title — VARCHAR2(255) — NOT NULL
- description — CLOB
- mermaid_code — CLOB
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
erd_tables
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- created_by_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- table_name — VARCHAR2(150) — NOT NULL
- schema_definition — CLOB
- description — CLOB
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
github_issues
- id — NUMBER(19) — Primary key — NOT NULL
- github_issue_id — VARCHAR2(100) — NOT NULL
- repository_id — NUMBER(19) — Foreign key → github_repositories.id — NOT NULL
- channel_id — NUMBER(19) — Foreign key → channels.id — NOT NULL
- issue_number — NUMBER(10) — NOT NULL
- title — VARCHAR2(255) — NOT NULL
- description — CLOB
- state — VARCHAR2(50) — NOT NULL
- local_status — VARCHAR2(50)
- url — CLOB — NOT NULL
- author — VARCHAR2(100)
- priority — VARCHAR2(20)
- issue_type — VARCHAR2(50)
- labels — CLOB
- closed_at — TIMESTAMP
- github_created_at — TIMESTAMP
- github_updated_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
github_pull_requests
- id — NUMBER(19) — Primary key — NOT NULL
- github_pr_id — VARCHAR2(100) — NOT NULL
- repository_id — NUMBER(19) — Foreign key → github_repositories.id — NOT NULL
- channel_id — NUMBER(19) — Foreign key → channels.id — NOT NULL
- pr_number — NUMBER(10) — NOT NULL
- title — VARCHAR2(255) — NOT NULL
- description — CLOB
- state — VARCHAR2(50) — NOT NULL
- url — CLOB — NOT NULL
- author — VARCHAR2(100)
- head_branch — VARCHAR2(255)
- base_branch — VARCHAR2(255)
- labels — CLOB
- additions — NUMBER(10) — NOT NULL
- deletions — NUMBER(10) — NOT NULL
- changed_files_count — NUMBER(10) — NOT NULL
- merged_at — TIMESTAMP
- github_created_at — TIMESTAMP
- github_updated_at — TIMESTAMP
- commits_json — CLOB
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
github_repositories
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- github_repo_id — VARCHAR2(100) — NOT NULL
- owner — VARCHAR2(100) — NOT NULL
- name — VARCHAR2(150) — NOT NULL
- full_name — VARCHAR2(255) — NOT NULL
- url — CLOB — NOT NULL
- description — CLOB
- is_private — NUMBER(1) — NOT NULL
- default_branch — VARCHAR2(255)
- last_synced_at — TIMESTAMP
- webhook_id — VARCHAR2(100)
- webhook_secret — VARCHAR2(255)
- webhook_url — CLOB
- webhook_events — CLOB
- webhook_active — NUMBER(1) — NOT NULL
- webhook_last_delivery_at — TIMESTAMP
- webhook_last_status — VARCHAR2(50)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
invitations
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- inviter_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- invited_email — VARCHAR2(255) — NOT NULL
- invited_authority — VARCHAR2(30) — NOT NULL
- invited_position — VARCHAR2(100)
- token — VARCHAR2(255) — NOT NULL
- status — VARCHAR2(20) — NOT NULL
- revoked_at — TIMESTAMP
- revoked_by_id — NUMBER(19) — Foreign key → workspace_members.id
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
issue_assignees
- id — NUMBER(19) — Primary key — NOT NULL
- github_issue_id — NUMBER(19) — Foreign key → github_issues.id — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
issue_labels
- id — NUMBER(19) — Primary key — NOT NULL
- github_issue_id — NUMBER(19) — Foreign key → github_issues.id — NOT NULL
- name — VARCHAR2(100) — NOT NULL
- color — VARCHAR2(7) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
mentions
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- thread_id — NUMBER(19) — Foreign key → threads.id
- thread_reply_id — NUMBER(19) — Foreign key → thread_replies.id
- mentioned_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- mentioned_by_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- is_read — NUMBER(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
password_reset_tokens
- id — NUMBER(19) — Primary key — NOT NULL
- user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
- token — VARCHAR2(255) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- used — NUMBER(1) — NOT NULL
- used_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
pull_request_analysis
- id — NUMBER(19) — Primary key — NOT NULL
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id — NOT NULL
- risk_level — VARCHAR2(10)
- tests_passed — NUMBER(10)
- review_room_active — NUMBER(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
pull_request_analysis_findings
- id — NUMBER(19) — Primary key — NOT NULL
- pull_request_analysis_id — NUMBER(19) — Foreign key → pull_request_analysis.id — NOT NULL
- pull_request_file_id — NUMBER(19) — Foreign key → pull_request_files.id
- finding_type — VARCHAR2(50) — NOT NULL
- severity — VARCHAR2(20) — NOT NULL
- line_number — NUMBER(10)
- description — CLOB — NOT NULL
- suggestion — CLOB
- created_at — TIMESTAMP — NOT NULL
pull_request_checklist_items
- id — NUMBER(19) — Primary key — NOT NULL
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id — NOT NULL
- content — CLOB — NOT NULL
- is_checked — NUMBER(1) — NOT NULL
- created_by_id — NUMBER(19) — Foreign key → workspace_members.id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
pull_request_diff_lines
- id — NUMBER(19) — Primary key — NOT NULL
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id — NOT NULL
- pull_request_file_id — NUMBER(19) — Foreign key → pull_request_files.id — NOT NULL
- line_type — VARCHAR2(20) — NOT NULL
- old_line_number — NUMBER(10)
- new_line_number — NUMBER(10)
- content — CLOB — NOT NULL
- created_at — TIMESTAMP — NOT NULL
pull_request_files
- id — NUMBER(19) — Primary key — NOT NULL
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id — NOT NULL
- filename — VARCHAR2(255) — NOT NULL
- status — VARCHAR2(50)
- additions — NUMBER(10) — NOT NULL
- deletions — NUMBER(10) — NOT NULL
- path — CLOB
- patch — CLOB
- created_at — TIMESTAMP — NOT NULL
pull_request_labels
- id — NUMBER(19) — Primary key — NOT NULL
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id — NOT NULL
- name — VARCHAR2(100) — NOT NULL
- color — VARCHAR2(7) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
pull_request_review_comments
- id — NUMBER(19) — Primary key — NOT NULL
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id — NOT NULL
- diff_line_id — NUMBER(19) — Foreign key → pull_request_diff_lines.id
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- thread_reply_id — NUMBER(19) — Foreign key → thread_replies.id
- content — CLOB — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
pull_request_review_requests
- id — NUMBER(19) — Primary key — NOT NULL
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
pull_request_reviews
- id — NUMBER(19) — Primary key — NOT NULL
- github_pull_request_id — NUMBER(19) — Foreign key → github_pull_requests.id — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- github_review_id — VARCHAR2(100)
- review_state — VARCHAR2(50) — NOT NULL
- thread_reply_id — NUMBER(19) — Foreign key → thread_replies.id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
reactions
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- target_type — VARCHAR2(30) — NOT NULL
- target_id — NUMBER(19) — NOT NULL
- emoji — VARCHAR2(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
refresh_tokens
- id — NUMBER(19) — Primary key — NOT NULL
- user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
- token — VARCHAR2(500) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- revoked — NUMBER(1) — NOT NULL
- revoked_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
thread_attachments
- id — NUMBER(19) — Primary key — NOT NULL
- thread_id — NUMBER(19) — Foreign key → threads.id — NOT NULL
- attachment_type — VARCHAR2(30) — NOT NULL
- target_id — NUMBER(19)
- url — CLOB
- title — VARCHAR2(255)
- detail — VARCHAR2(255)
- meta — CLOB
- preview_url — CLOB
- mime_type — VARCHAR2(100)
- file_size — NUMBER(19)
- created_at — TIMESTAMP — NOT NULL
thread_replies
- id — NUMBER(19) — Primary key — NOT NULL
- thread_id — NUMBER(19) — Foreign key → threads.id — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- content — CLOB — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
threads
- id — NUMBER(19) — Primary key — NOT NULL
- channel_id — NUMBER(19) — Foreign key → channels.id — NOT NULL
- created_by_id — NUMBER(19) — Foreign key → workspace_members.id
- reply_to_id — NUMBER(19) — Foreign key → threads.id
- thread_type — VARCHAR2(50) — NOT NULL
- threadable_type — VARCHAR2(50)
- threadable_id — NUMBER(19)
- title — VARCHAR2(255)
- content — CLOB
- client_message_id — VARCHAR2(64)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
user_skills
- id — NUMBER(19) — Primary key — NOT NULL
- user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
- skill_name — VARCHAR2(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — NUMBER(19) — Primary key — NOT NULL
- email — VARCHAR2(255) — NOT NULL
- password_hash — VARCHAR2(255)
- email_verified — NUMBER(1) — NOT NULL
- email_verified_at — TIMESTAMP
- username — VARCHAR2(100) — NOT NULL
- display_name — VARCHAR2(100)
- nickname — VARCHAR2(50)
- developer_type — VARCHAR2(100)
- bio — VARCHAR2(160)
- avatar_url — CLOB
- github_id — VARCHAR2(100)
- github_username — VARCHAR2(100)
- github_email — VARCHAR2(255)
- github_connected — NUMBER(1) — NOT NULL
- github_connected_at — TIMESTAMP
- github_access_token — CLOB
- github_token_expires_at — TIMESTAMP
- is_active — NUMBER(1) — NOT NULL
- deactivated_at — TIMESTAMP
- last_login_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
workspace_event_read_statuses
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_event_id — NUMBER(19) — NOT NULL
- user_id — NUMBER(19) — NOT NULL
workspace_events
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- type — VARCHAR2(30) — NOT NULL
- actor_name — VARCHAR2(100)
- pr_id — NUMBER(19)
- issue_id — NUMBER(19)
- channel_id — NUMBER(19)
- repository_id — NUMBER(19)
- repository_name — VARCHAR2(255)
- thread_id — NUMBER(19)
- pr_number — NUMBER(19)
- issue_number — NUMBER(19)
- content — CLOB
- target_user_id — NUMBER(19)
- is_read — NUMBER(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
workspace_member_preferences
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_member_id — NUMBER(19) — Foreign key → workspace_members.id — NOT NULL
- notification_mode — VARCHAR2(20) — NOT NULL
- presence — VARCHAR2(20) — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
workspace_members
- id — NUMBER(19) — Primary key — NOT NULL
- workspace_id — NUMBER(19) — Foreign key → workspaces.id — NOT NULL
- user_id — NUMBER(19) — Foreign key → users.id — NOT NULL
- authority — VARCHAR2(30) — NOT NULL
- position — VARCHAR2(100)
- is_active — NUMBER(1) — NOT NULL
- left_at — TIMESTAMP
- left_reason — VARCHAR2(255)
- version — NUMBER(19)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
workspaces
- id — NUMBER(19) — Primary key — NOT NULL
- created_by_id — NUMBER(19) — Foreign key → users.id — NOT NULL
- owner_id — NUMBER(19) — Foreign key → users.id — NOT NULL
- name — VARCHAR2(100) — NOT NULL
- slug — VARCHAR2(120) — NOT NULL
- description — CLOB
- logo_url — CLOB
- swagger_url — VARCHAR2(500)
- last_activity_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP