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