aibe5Final_001
Tables (22)
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) — NOT NULL
- 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 — NOT NULL
- 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
- created_by_id — BIGINT — Foreign key → workspace_members.id
- name — VARCHAR(100) — 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 — NOT NULL
- 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
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(100) — 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) — NOT NULL
- labels — TEXT
- assignees — JSON
- closed_at — DATETIME
- github_created_at — DATETIME — NOT NULL
- github_updated_at — DATETIME — NOT NULL
- 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) — NOT NULL
- 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 — NOT NULL
- github_updated_at — DATETIME — NOT NULL
- 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(100) — 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) — NOT NULL
- additions — INT — NOT NULL
- deletions — INT — NOT NULL
- path — TEXT — NOT NULL
- 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
- theme — VARCHAR(50) — NOT NULL
- language — VARCHAR(20) — 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
- github_id — VARCHAR(100) — NOT NULL
- github_access_token — TEXT
- github_access_token_valid — BOOLEAN — NOT NULL
- github_refresh_token — TEXT
- github_refresh_token_valid — BOOLEAN — NOT NULL
- 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
- slug — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL