aibe5Final_002

Tables (23)

activity_logs

  • id — BIGINT — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • workspace_member_id — BIGINT — Foreign key → workspace_members.id
  • entity_type — VARCHAR(100) — NOT NULL
  • entity_id — BIGINT — NOT NULL
  • action — VARCHAR(100) — NOT NULL
  • changes — JSON
  • source — VARCHAR(50) — NOT NULL
  • ip_address — VARCHAR(45)
  • user_agent — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_activity_logs_workspace
  • INDEX — idx_activity_logs_entity

ai_summaries

  • id — BIGINT — Primary key — NOT NULL
  • github_issue_id — BIGINT — Foreign key → github_issues.id
  • github_pull_request_id — BIGINT — Foreign key → github_pull_requests.id
  • summary_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • summary — TEXT
  • model_version — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

api_specs

  • id — BIGINT — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • repository_id — BIGINT — Foreign key → github_repositories.id — NOT NULL
  • created_by_id — BIGINT — Foreign key → workspace_members.id
  • title — VARCHAR(500) — NOT NULL
  • spec_content — LONGTEXT
  • format — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • model_version — VARCHAR(100)
  • version — INT — NOT NULL
  • endpoint_count — INT
  • generated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

attachments

  • id — BIGINT — Primary key — NOT NULL
  • uploaded_by_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • file_type — VARCHAR(50) — NOT NULL
  • file_name — VARCHAR(500) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • mime_type — VARCHAR(100) — NOT NULL
  • storage_url — TEXT — NOT NULL
  • thumbnail_url — TEXT
  • created_at — DATETIME — NOT NULL

channels

  • id — BIGINT — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • github_repository_id — BIGINT — Foreign key → github_repositories.id
  • github_pull_request_id — BIGINT — Foreign key → github_pull_requests.id
  • github_issue_id — BIGINT — Foreign key → github_issues.id
  • created_by_id — BIGINT — Foreign key → workspace_members.id
  • name — VARCHAR(120) — NOT NULL
  • channel_type — VARCHAR(50) — NOT NULL
  • is_deletable — BOOLEAN — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

documents

  • id — BIGINT — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • repository_id — BIGINT — Foreign key → github_repositories.id
  • created_by_id — BIGINT — Foreign key → workspace_members.id
  • title — VARCHAR(500) — NOT NULL
  • content — LONGTEXT
  • visibility — VARCHAR(50) — NOT NULL
  • document_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • model_version — VARCHAR(100)
  • version — INT — NOT NULL
  • generated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

email_verifications

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • token_type — VARCHAR(50) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used_at — DATETIME
  • created_at — DATETIME — NOT NULL

erd_tables

  • id — BIGINT — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • repository_id — BIGINT — Foreign key → github_repositories.id — NOT NULL
  • created_by_id — BIGINT — Foreign key → workspace_members.id
  • table_name — VARCHAR(150) — NOT NULL
  • schema_definition — JSON — NOT NULL
  • relations — JSON
  • description — TEXT
  • status — VARCHAR(50) — NOT NULL
  • model_version — VARCHAR(100)
  • version — INT — NOT NULL
  • generated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

github_issues

  • id — BIGINT — Primary key — NOT NULL
  • github_issue_id — VARCHAR(100) — NOT NULL
  • repository_id — BIGINT — Foreign key → github_repositories.id — NOT NULL
  • channel_id — BIGINT — Foreign key → channels.id
  • issue_number — INT — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • description — TEXT
  • state — VARCHAR(50) — NOT NULL
  • url — TEXT — NOT NULL
  • author — VARCHAR(100)
  • labels — TEXT
  • assignees — JSON
  • closed_at — DATETIME
  • github_created_at — DATETIME
  • github_updated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

github_pull_requests

  • id — BIGINT — Primary key — NOT NULL
  • github_pr_id — VARCHAR(100) — NOT NULL
  • repository_id — BIGINT — Foreign key → github_repositories.id — NOT NULL
  • channel_id — BIGINT — Foreign key → channels.id
  • pr_number — INT — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • description — TEXT
  • state — VARCHAR(50) — NOT NULL
  • url — TEXT — NOT NULL
  • author — VARCHAR(100)
  • head_branch — VARCHAR(255) — NOT NULL
  • base_branch — VARCHAR(255) — NOT NULL
  • assignees — JSON
  • reviewers — JSON
  • additions — INT — NOT NULL
  • deletions — INT — NOT NULL
  • changed_files_count — INT — NOT NULL
  • merged_at — DATETIME
  • closed_at — DATETIME
  • github_created_at — DATETIME
  • github_updated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

github_repositories

  • id — BIGINT — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • added_by_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
  • github_repo_id — VARCHAR(100) — NOT NULL
  • owner — VARCHAR(100) — NOT NULL
  • name — VARCHAR(150) — NOT NULL
  • full_name — VARCHAR(255) — NOT NULL
  • url — TEXT — NOT NULL
  • description — TEXT
  • default_branch — VARCHAR(100) — NOT NULL
  • is_private — BOOLEAN — NOT NULL
  • last_synced_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

mentions

  • id — BIGINT — Primary key — NOT NULL
  • mentioned_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

pr_code_citations

  • id — BIGINT — Primary key — NOT NULL
  • thread_reply_id — BIGINT — Foreign key → thread_replies.id — NOT NULL
  • pull_request_file_id — BIGINT — Foreign key → pull_request_files.id — NOT NULL
  • side — VARCHAR(10) — NOT NULL
  • start_line — INT — NOT NULL
  • end_line — INT — NOT NULL
  • cited_content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

pull_request_files

  • id — BIGINT — Primary key — NOT NULL
  • github_pull_request_id — BIGINT — Foreign key → github_pull_requests.id — NOT NULL
  • filename — VARCHAR(500) — NOT NULL
  • status — VARCHAR(50)
  • additions — INT — NOT NULL
  • deletions — INT — NOT NULL
  • path — TEXT
  • patch — LONGTEXT
  • blob_url — TEXT
  • created_at — DATETIME — NOT NULL

pull_request_reviews

  • id — BIGINT — Primary key — NOT NULL
  • github_pull_request_id — BIGINT — Foreign key → github_pull_requests.id — NOT NULL
  • workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
  • github_review_id — VARCHAR(100)
  • review_state — VARCHAR(50) — NOT NULL
  • review_body — TEXT
  • thread_reply_id — BIGINT — Foreign key → thread_replies.id
  • submitted_to_github_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reactions

  • id — BIGINT — Primary key — NOT NULL
  • workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • emoji — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

thread_replies

  • id — BIGINT — Primary key — NOT NULL
  • thread_id — BIGINT — Foreign key → threads.id — NOT NULL
  • workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
  • content — TEXT — NOT NULL
  • is_edited — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

threads

  • id — BIGINT — Primary key — NOT NULL
  • channel_id — BIGINT — Foreign key → channels.id — NOT NULL
  • created_by_id — BIGINT — Foreign key → workspace_members.id
  • thread_type — VARCHAR(50) — NOT NULL
  • threadable_type — VARCHAR(100)
  • threadable_id — BIGINT
  • content — TEXT
  • metadata — JSON
  • is_edited — BOOLEAN — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — idx_threads_channel_id
  • INDEX — idx_threads_threadable

user_preferences

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • email_notifications — BOOLEAN — NOT NULL
  • mention_notifications — BOOLEAN — NOT NULL
  • pr_notifications — BOOLEAN — NOT NULL
  • custom — JSON
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • avatar_url — TEXT
  • password_hash — VARCHAR(255)
  • email_verified — BOOLEAN — NOT NULL
  • email_verified_at — DATETIME
  • github_id — VARCHAR(100)
  • github_access_token — TEXT
  • github_access_token_valid — BOOLEAN
  • github_refresh_token — TEXT
  • github_refresh_token_valid — BOOLEAN
  • status — VARCHAR(50) — NOT NULL
  • last_seen_at — DATETIME
  • is_active — BOOLEAN — NOT NULL
  • deactivated_at — DATETIME
  • deactivated_reason — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

workspace_invitations

  • id — BIGINT — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • invited_by_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • token — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

workspace_members

  • id — BIGINT — Primary key — NOT NULL
  • workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

workspaces

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL