first

Tables (17)

activity_logs

  • id — BIGSERIAL
  • 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
  • github_issue_id — BIGINT — Foreign key → github_issues.id
  • github_pull_request_id — BIGINT — Foreign key → github_pull_requests.id
  • summary — TEXT — NOT NULL
  • 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

api_specs

  • id — BIGSERIAL
  • 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
  • spec_content — TEXT
  • format — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

channels

  • id — BIGSERIAL
  • 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
  • custom) — AND

documents

  • id — BIGSERIAL
  • 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
  • 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
  • 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
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • state — VARCHAR(50) — NOT NULL
  • url — TEXT — NOT NULL
  • author — VARCHAR(100)
  • labels — TEXT
  • github_created_at — TIMESTAMP
  • github_updated_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

github_pull_requests

  • id — BIGSERIAL
  • 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
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • state — VARCHAR(50) — NOT NULL
  • url — TEXT — NOT NULL
  • author — VARCHAR(100)
  • 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

github_repositories

  • id — BIGSERIAL
  • 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
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

pull_request_files

  • id — BIGSERIAL
  • 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_reviews

  • id — BIGSERIAL
  • 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
  • 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_replies

  • id — BIGSERIAL
  • thread_id — BIGINT — Foreign key → threads.id — NOT NULL
  • workspace_member_id — BIGINT — Foreign key → workspace_members.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

threads

  • id — BIGSERIAL
  • 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(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
  • email — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • avatar_url — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

workspace_members

  • id — BIGSERIAL
  • 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

workspaces

  • id — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(120) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL