new
Tables (29)
activity_logs
- id — BIGSERIAL — 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(50) — NOT NULL
- entity_id — BIGINT — NOT NULL
- action — VARCHAR(100) — NOT NULL
- changes — JSONB
- created_at — TIMESTAMP — NOT NULL
ai_summaries
- id — BIGSERIAL — 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 — TEXT — NOT NULL
- risk_level — VARCHAR(20)
- model_version — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — ( (`github_issue_id` IS NOT NULL AND `github_pull_request_id` IS NULL) — NOT NULL
- CHECK — (`risk_level` IS NULL OR `risk_level` IN ('Low', 'Medium', 'High'))
api_specs
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
- created_by_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- method — VARCHAR(10) — NOT NULL
- endpoint — VARCHAR(255) — NOT NULL
- group_name — VARCHAR(100)
- entity — VARCHAR(100)
- summary — VARCHAR(255)
- description — TEXT
- status — VARCHAR(30)
- assignee_id — BIGINT — Foreign key → workspace_members.id
- request_body — TEXT
- response_status — INTEGER
- response_body — TEXT
- related_issue_id — BIGINT — Foreign key → github_issues.id
- related_pr_id — BIGINT — Foreign key → github_pull_requests.id
- note — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`method` IN ('GET', 'POST', 'PATCH', 'DELETE'))
- CHECK — (`status` IS NULL OR `status` IN ('completed', 'in_progress', 'design'))
bookmarks
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- thread_id — BIGINT — Foreign key → threads.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
channel_read_status
- id — BIGSERIAL — Primary key — NOT NULL
- channel_id — BIGINT — Foreign key → channels.id — NOT NULL
- workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- last_read_thread_id — BIGINT — Foreign key → threads.id
- last_read_at — TIMESTAMP — NOT NULL
channels
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
- github_repository_id — BIGINT — Foreign key → github_repositories.id
- name — VARCHAR(120) — NOT NULL
- channel_type — VARCHAR(30) — NOT NULL
- is_deletable — BOOLEAN — NOT NULL
- description — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`channel_type` IN ('general', 'repository', 'custom'))
- CHECK — ( (`channel_type` = 'repository' AND `github_repository_id` IS NOT NULL) — NOT NULL
documents
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
- created_by_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- visibility — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
erd_tables
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
- created_by_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- table_name — VARCHAR(150) — NOT NULL
- schema_definition — JSONB
- description — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
github_issues
- id — BIGSERIAL — 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 — NOT NULL
- issue_number — INTEGER — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- state — VARCHAR(50) — NOT NULL
- local_status — VARCHAR(50)
- url — TEXT — NOT NULL
- author — VARCHAR(100)
- priority — VARCHAR(20)
- issue_type — VARCHAR(50)
- labels — JSONB
- github_created_at — TIMESTAMP
- github_updated_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`state` IN ('open', 'closed'))
- CHECK — (`local_status` IS NULL OR `local_status` IN ('open', 'in_progress', 'review', 'done', 'blocked'))
- CHECK — (`priority` IS NULL OR `priority` IN ('high', 'medium', 'low'))
github_pull_requests
- id — BIGSERIAL — 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 — NOT NULL
- pr_number — INTEGER — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- state — VARCHAR(50) — NOT NULL
- url — TEXT — NOT NULL
- author — VARCHAR(100)
- head_branch — VARCHAR(255)
- base_branch — VARCHAR(255)
- labels — JSONB
- additions — INTEGER — NOT NULL
- deletions — INTEGER — NOT NULL
- changed_files_count — INTEGER — NOT NULL
- github_created_at — TIMESTAMP
- github_updated_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`state` IN ('open', 'merged', 'closed'))
github_repositories
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_id — BIGINT — Foreign key → workspaces.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
- is_private — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
invitations
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
- inviter_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- invited_email — VARCHAR(255) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- CHECK — (`status` IN ('pending', 'accepted', 'rejected', 'expired'))
- CHECK — (`role` IN ('owner', 'admin', 'editor', 'viewer'))
issue_assignees
- id — BIGSERIAL — Primary key — NOT NULL
- github_issue_id — BIGINT — Foreign key → github_issues.id — NOT NULL
- workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
issue_labels
- id — BIGSERIAL — Primary key — NOT NULL
- github_issue_id — BIGINT — Foreign key → github_issues.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- color — VARCHAR(7) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
pull_request_analysis
- id — BIGSERIAL — Primary key — NOT NULL
- github_pull_request_id — BIGINT — Foreign key → github_pull_requests.id — NOT NULL
- risk_level — VARCHAR(10)
- tests_passed — INTEGER
- review_room_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`risk_level` IS NULL OR `risk_level` IN ('Low', 'Medium', 'High'))
pull_request_files
- id — BIGSERIAL — Primary key — NOT NULL
- github_pull_request_id — BIGINT — Foreign key → github_pull_requests.id — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- status — VARCHAR(50)
- additions — INTEGER — NOT NULL
- deletions — INTEGER — NOT NULL
- path — TEXT
- created_at — TIMESTAMP — NOT NULL
pull_request_labels
- id — BIGSERIAL — Primary key — NOT NULL
- github_pull_request_id — BIGINT — Foreign key → github_pull_requests.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
pull_request_review_requests
- id — BIGSERIAL — 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
- created_at — TIMESTAMP — NOT NULL
pull_request_reviews
- id — BIGSERIAL — 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
- thread_reply_id — BIGINT — Foreign key → thread_replies.id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`review_state` IN ('approved', 'changes_requested', 'commented'))
reactions
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- target_type — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- emoji — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- CHECK — (`target_type` IN ('thread', 'thread_reply'))
thread_attachments
- id — BIGSERIAL — Primary key — NOT NULL
- thread_id — BIGINT — Foreign key → threads.id — NOT NULL
- type — VARCHAR(30) — NOT NULL
- target_id — BIGINT
- url — TEXT
- title — VARCHAR(255)
- mime_type — VARCHAR(100)
- size — BIGINT
- created_at — TIMESTAMP — NOT NULL
- CHECK — (`type` IN ('file', 'image', 'link', 'pr', 'issue', 'api', 'erd', 'docs'))
thread_replies
- id — BIGSERIAL — 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
- file_path — TEXT
- line_number — INTEGER
- referenced_code — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
threads
- id — BIGSERIAL — Primary key — NOT NULL
- channel_id — BIGINT — Foreign key → channels.id — NOT NULL
- created_by_id — BIGINT — Foreign key → workspace_members.id
- reply_to_id — BIGINT — Foreign key → threads.id
- thread_type — VARCHAR(50) — NOT NULL
- threadable_type — VARCHAR(50)
- threadable_id — BIGINT
- title — VARCHAR(255)
- content — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`thread_type` IN ('user_message', 'github_bot_notification', 'system'))
- CHECK — (`threadable_type` IS NULL OR `threadable_type` IN ('github_issue', 'github_pull_request'))
users
- id — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- avatar_url — TEXT
- display_name — VARCHAR(100)
- nickname — VARCHAR(50)
- bio — VARCHAR(160)
- skills — TEXT
- status — VARCHAR(20)
- recovery_email — VARCHAR(255)
- github_username — VARCHAR(100)
- github_email — VARCHAR(255)
- github_connected — BOOLEAN — NOT NULL
- github_connected_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
workspace_integrations
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- enabled — BOOLEAN — NOT NULL
- webhook_url — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`type` IN ('webhook', 'slack', 'discord'))
workspace_member_preferences
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- notification_mode — VARCHAR(20) — NOT NULL
- presence — VARCHAR(20) — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`notification_mode` IN ('all', 'mentions', 'muted'))
- CHECK — (`presence` IN ('active', 'away', 'busy', 'offline'))
workspace_member_stats
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
- commits_count — INTEGER — NOT NULL
- prs_count — INTEGER — NOT NULL
- reviews_count — INTEGER — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
workspace_members
- id — BIGSERIAL — Primary key — NOT NULL
- workspace_id — BIGINT — Foreign key → workspaces.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- role — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- CHECK — (`role` IN ('owner', 'admin', 'editor', 'viewer'))
workspaces
- id — BIGSERIAL — Primary key — NOT NULL
- created_by_id — BIGINT — Foreign key → users.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- slug — VARCHAR(120) — NOT NULL
- description — TEXT
- logo_url — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL