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