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