PILO

Tables (66)

agent_actions

  • id — UUID — Primary key — NOT NULL
  • run_id — UUID — Foreign key → agent_runs.id — NOT NULL
  • type — VARCHAR(160) — NOT NULL
  • source — VARCHAR(160)
  • requires_confirmation — BOOLEAN — NOT NULL
  • payload — JSONB — NOT NULL
  • status — agent_action_status — NOT NULL
  • confirmed_by — UUID — Foreign key → users.id
  • confirmed_at — TIMESTAMPTZ
  • executed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

agent_contexts

  • id — UUID — Primary key — NOT NULL
  • run_id — UUID — Foreign key → agent_runs.id — NOT NULL
  • context_type — VARCHAR(100) — NOT NULL
  • ref_id — UUID
  • payload — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

agent_run_steps

  • id — UUID — Primary key — NOT NULL
  • run_id — UUID — Foreign key → agent_runs.id — NOT NULL
  • step_name — VARCHAR(160) — NOT NULL
  • status — agent_run_status — NOT NULL
  • input — JSONB — NOT NULL
  • output — JSONB
  • error — TEXT
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

agent_runs

  • id — UUID — Primary key — NOT NULL
  • workflow_id — UUID — Foreign key → agent_workflows.id — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id
  • actor_id — UUID — Foreign key → users.id
  • status — agent_run_status — NOT NULL
  • input — JSONB — NOT NULL
  • output — JSONB
  • error — TEXT
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

agent_traces

  • id — UUID — Primary key — NOT NULL
  • run_id — UUID — Foreign key → agent_runs.id — NOT NULL
  • step_id — UUID — Foreign key → agent_run_steps.id
  • message — TEXT — NOT NULL
  • metadata — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

agent_workflows

  • id — UUID — Primary key — NOT NULL
  • agent_id — UUID — Foreign key → agents.id — NOT NULL
  • type — VARCHAR(120) — NOT NULL
  • version — VARCHAR(40) — NOT NULL
  • schema — JSONB — NOT NULL
  • enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

agents

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(160) — NOT NULL
  • domain — VARCHAR(80) — NOT NULL
  • description — TEXT
  • enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

audit_logs

  • id — UUID — Primary key — NOT NULL
  • actor_id — UUID — Foreign key → users.id
  • action — VARCHAR(120) — NOT NULL
  • target_type — VARCHAR(80) — NOT NULL
  • target_id — UUID
  • before_value — JSONB
  • after_value — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

auth_sessions

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • refresh_token_hash — TEXT — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

canvas_components

  • id — UUID — Primary key — NOT NULL
  • canvas_id — UUID — Foreign key → canvases.id — NOT NULL
  • type — canvas_component_type — NOT NULL
  • title — VARCHAR(220)
  • content_ref_type — VARCHAR(80)
  • content_ref_id — UUID
  • position — JSONB — NOT NULL
  • size — JSONB — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

canvas_node_positions

  • id — UUID — Primary key — NOT NULL
  • canvas_id — UUID — Foreign key → canvases.id — NOT NULL
  • node_type — VARCHAR(80) — NOT NULL
  • node_ref_id — UUID — NOT NULL
  • x — NUMERIC(12, 2) — NOT NULL
  • y — NUMERIC(12, 2) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

canvas_view_settings

  • id — UUID — Primary key — NOT NULL
  • canvas_id — UUID — Foreign key → canvases.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • filters — JSONB — NOT NULL
  • zoom — NUMERIC(5, 2) — NOT NULL
  • viewport — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

canvases

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • type — VARCHAR(80) — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

changed_files

  • id — UUID — Primary key — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • file_path — TEXT — NOT NULL
  • change_type — VARCHAR(50)
  • additions — INTEGER — NOT NULL
  • deletions — INTEGER — NOT NULL
  • summary — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

changed_functions

  • id — UUID — Primary key — NOT NULL
  • changed_file_id — UUID — Foreign key → changed_files.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • change_type — VARCHAR(50)
  • summary — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

channels

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • name — VARCHAR(160) — NOT NULL
  • type — channel_type — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

code_review_rooms

  • id — UUID — Primary key — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • status — VARCHAR(80) — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

component_edges

  • id — UUID — Primary key — NOT NULL
  • source_id — UUID — Foreign key → canvas_components.id — NOT NULL
  • target_id — UUID — Foreign key → canvas_components.id — NOT NULL
  • edge_type — component_edge_type — NOT NULL
  • label — VARCHAR(120)
  • created_at — TIMESTAMPTZ — NOT NULL

dashboard_preferences

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • layout — JSONB — NOT NULL
  • hidden_sections — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

feature_breakdowns

  • id — UUID — Primary key — NOT NULL
  • project_plan_draft_id — UUID — Foreign key → project_plan_drafts.id — NOT NULL
  • title — VARCHAR(220) — NOT NULL
  • description — TEXT
  • scope_type — scope_type — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

features

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • project_brief_id — UUID — Foreign key → project_briefs.id
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • scope_type — scope_type — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

github_connections

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • provider — github_connection_provider — NOT NULL
  • installation_id — VARCHAR(255)
  • github_account_login — VARCHAR(255)
  • scopes — TEXT — NOT NULL
  • connected_by — UUID — Foreign key → users.id
  • connected_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

github_issue_mappings

  • id — UUID — Primary key — NOT NULL
  • task_id — UUID — Foreign key → tasks.id — NOT NULL
  • repository_id — UUID — Foreign key → github_repositories.id — NOT NULL
  • issue_number — INTEGER — NOT NULL
  • issue_url — TEXT — NOT NULL
  • state — VARCHAR(50) — NOT NULL
  • labels — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

github_pr_mappings

  • id — UUID — Primary key — NOT NULL
  • task_id — UUID — Foreign key → tasks.id — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

github_repositories

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • github_connection_id — UUID — Foreign key → github_connections.id
  • repo_name — VARCHAR(255) — NOT NULL
  • owner — VARCHAR(255) — NOT NULL
  • url — TEXT — NOT NULL
  • installation_id — VARCHAR(255)
  • default_branch — VARCHAR(255)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_action_items

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → meeting_reports.id — NOT NULL
  • title — VARCHAR(240) — NOT NULL
  • assignee_suggestion — UUID — Foreign key → users.id
  • due_date_suggestion — DATE
  • task_id — UUID — Foreign key → tasks.id
  • status — action_item_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_agendas

  • id — UUID — Primary key — NOT NULL
  • meeting_id — UUID — Foreign key → meeting_sessions.id — NOT NULL
  • title — VARCHAR(240) — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • status — VARCHAR(80) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_decisions

  • id — UUID — Primary key — NOT NULL
  • report_id — UUID — Foreign key → meeting_reports.id — NOT NULL
  • content — TEXT — NOT NULL
  • related_task_id — UUID — Foreign key → tasks.id
  • status — decision_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_participants

  • id — UUID — Primary key — NOT NULL
  • meeting_id — UUID — Foreign key → meeting_sessions.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • role — VARCHAR(80)
  • joined_at — TIMESTAMPTZ — NOT NULL
  • left_at — TIMESTAMPTZ

meeting_reports

  • id — UUID — Primary key — NOT NULL
  • meeting_id — UUID — Foreign key → meeting_sessions.id — NOT NULL
  • summary — TEXT
  • open_questions — JSONB — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_sessions

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • channel_id — UUID — Foreign key → channels.id
  • canvas_id — UUID — Foreign key → canvases.id
  • title — VARCHAR(220) — NOT NULL
  • status — meeting_status — NOT NULL
  • started_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • related_task_ids — UUID — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

meeting_transcripts

  • id — UUID — Primary key — NOT NULL
  • meeting_id — UUID — Foreign key → meeting_sessions.id — NOT NULL
  • speaker_id — UUID — Foreign key → users.id
  • body — TEXT — NOT NULL
  • spoken_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

merge_checklist_items

  • id — UUID — Primary key — NOT NULL
  • merge_checklist_id — UUID — Foreign key → merge_checklists.id — NOT NULL
  • title — VARCHAR(240) — NOT NULL
  • status — checklist_status — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

merge_checklists

  • id — UUID — Primary key — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • checked_by — UUID — Foreign key → users.id
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

messages

  • id — UUID — Primary key — NOT NULL
  • channel_id — UUID — Foreign key → channels.id — NOT NULL
  • author_id — UUID — Foreign key → users.id
  • body — TEXT — NOT NULL
  • mentions — UUID — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

milestone_drafts

  • id — UUID — Primary key — NOT NULL
  • project_plan_draft_id — UUID — Foreign key → project_plan_drafts.id — NOT NULL
  • title — VARCHAR(220) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • status — milestone_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

milestones

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • status — milestone_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

node_review_states

  • id — UUID — Primary key — NOT NULL
  • node_id — UUID — Foreign key → review_nodes.id — NOT NULL
  • reviewer_id — UUID — Foreign key → users.id — NOT NULL
  • status — node_review_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

notifications

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • type — VARCHAR(100) — NOT NULL
  • title — VARCHAR(240) — NOT NULL
  • linked_entity_type — VARCHAR(80)
  • linked_entity_id — UUID
  • status — notification_status — NOT NULL
  • read_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

oauth_accounts

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • provider — oauth_provider — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • provider_email — VARCHAR(255)
  • scopes — TEXT — NOT NULL
  • access_token_encrypted — TEXT
  • refresh_token_encrypted — TEXT
  • token_expires_at — TIMESTAMPTZ
  • linked_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

progress_snapshots

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • milestone_id — UUID — Foreign key → milestones.id
  • total_tasks — INTEGER — NOT NULL
  • done_tasks — INTEGER — NOT NULL
  • blocked_tasks — INTEGER — NOT NULL
  • review_tasks — INTEGER — NOT NULL
  • progress_rate — NUMERIC(5, 2) — NOT NULL
  • captured_at — TIMESTAMPTZ — NOT NULL

project_briefs

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • goal — TEXT — NOT NULL
  • target_user — TEXT
  • problem — TEXT
  • duration — TEXT
  • output_goal — TEXT
  • difficulty — VARCHAR(50)
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

project_plan_drafts

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • goal — TEXT
  • target_user — TEXT
  • problem — TEXT
  • duration — TEXT
  • output_goal — TEXT
  • status — VARCHAR(80) — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

pull_requests

  • id — UUID — Primary key — NOT NULL
  • repository_id — UUID — Foreign key → github_repositories.id — NOT NULL
  • number — INTEGER — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • author — VARCHAR(255)
  • state — pr_state — NOT NULL
  • branch — VARCHAR(255)
  • base_branch — VARCHAR(255)
  • url — TEXT — NOT NULL
  • changed_files_count — INTEGER — NOT NULL
  • additions — INTEGER — NOT NULL
  • deletions — INTEGER — NOT NULL
  • opened_at — TIMESTAMPTZ
  • merged_at — TIMESTAMPTZ
  • closed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_checklists

  • id — UUID — Primary key — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • title — VARCHAR(240) — NOT NULL
  • status — checklist_status — NOT NULL
  • checked_by — UUID — Foreign key → users.id
  • checked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_comments

  • id — UUID — Primary key — NOT NULL
  • room_id — UUID — Foreign key → code_review_rooms.id — NOT NULL
  • author_id — UUID — Foreign key → users.id
  • node_id — UUID — Foreign key → review_nodes.id
  • body — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_graphs

  • id — UUID — Primary key — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • summary — TEXT
  • review_order — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_nodes

  • id — UUID — Primary key — NOT NULL
  • graph_id — UUID — Foreign key → review_graphs.id — NOT NULL
  • changed_file_id — UUID — Foreign key → changed_files.id
  • changed_function_id — UUID — Foreign key → changed_functions.id
  • type — review_node_type — NOT NULL
  • label — VARCHAR(255) — NOT NULL
  • file_path — TEXT
  • symbol — VARCHAR(255)
  • role — TEXT
  • reason — TEXT
  • risk_level — review_risk_level — NOT NULL
  • position — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

review_questions

  • id — UUID — Primary key — NOT NULL
  • node_id — UUID — Foreign key → review_nodes.id — NOT NULL
  • question — TEXT — NOT NULL
  • priority — task_priority — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

review_risks

  • id — UUID — Primary key — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • node_id — UUID — Foreign key → review_nodes.id
  • type — VARCHAR(100) — NOT NULL
  • level — review_risk_level — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

review_summaries

  • id — UUID — Primary key — NOT NULL
  • pull_request_id — UUID — Foreign key → pull_requests.id — NOT NULL
  • ok_nodes — INTEGER — NOT NULL
  • discuss_nodes — INTEGER — NOT NULL
  • unknown_nodes — INTEGER — NOT NULL
  • risks — JSONB — NOT NULL
  • conclusion — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

role_assignment_drafts

  • id — UUID — Primary key — NOT NULL
  • project_plan_draft_id — UUID — Foreign key → project_plan_drafts.id — NOT NULL
  • workspace_member_id — UUID — Foreign key → workspace_members.id
  • suggested_role — VARCHAR(120) — NOT NULL
  • reason — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

role_assignments

  • id — UUID — Primary key — NOT NULL
  • workspace_member_id — UUID — Foreign key → workspace_members.id — NOT NULL
  • role_name — VARCHAR(120) — NOT NULL
  • assigned_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

shared_files

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • filename — VARCHAR(255) — NOT NULL
  • type — VARCHAR(80)
  • url — TEXT — NOT NULL
  • linked_entity_type — VARCHAR(80)
  • linked_entity_id — UUID
  • uploaded_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

task_activity_logs

  • id — UUID — Primary key — NOT NULL
  • task_id — UUID — Foreign key → tasks.id — NOT NULL
  • actor_id — UUID — Foreign key → users.id
  • action — VARCHAR(100) — NOT NULL
  • before_value — JSONB
  • after_value — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

task_comments

  • id — UUID — Primary key — NOT NULL
  • task_id — UUID — Foreign key → tasks.id — NOT NULL
  • author_id — UUID — Foreign key → users.id
  • body — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

task_dependencies

  • id — UUID — Primary key — NOT NULL
  • task_id — UUID — Foreign key → tasks.id — NOT NULL
  • depends_on_task_id — UUID — Foreign key → tasks.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

tasks

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • milestone_id — UUID — Foreign key → milestones.id
  • feature_id — UUID — Foreign key → features.id
  • title — VARCHAR(240) — NOT NULL
  • description — TEXT
  • assignee_id — UUID — Foreign key → users.id
  • due_date — DATE
  • status — task_status — NOT NULL
  • priority — task_priority — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

team_profiles

  • id — UUID — Primary key — NOT NULL
  • workspace_member_id — UUID — Foreign key → workspace_members.id — NOT NULL
  • experience_tags — TEXT — NOT NULL
  • preferred_role — VARCHAR(100)
  • available_time — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tech_stack_recommendations

  • id — UUID — Primary key — NOT NULL
  • project_brief_id — UUID — Foreign key → project_briefs.id
  • project_plan_draft_id — UUID — Foreign key → project_plan_drafts.id
  • frontend — TEXT
  • backend — TEXT
  • db — TEXT
  • ai — TEXT
  • deploy — TEXT
  • reason — TEXT
  • difficulty — VARCHAR(80)
  • alternatives — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • avatar_url — TEXT
  • role — user_role — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

voice_rooms

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • channel_id — UUID — Foreign key → channels.id
  • status — voice_room_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

voice_sessions

  • id — UUID — Primary key — NOT NULL
  • voice_room_id — UUID — Foreign key → voice_rooms.id — NOT NULL
  • meeting_id — UUID — Foreign key → meeting_sessions.id
  • recording_status — recording_status — NOT NULL
  • started_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

voice_transcripts

  • id — UUID — Primary key — NOT NULL
  • meeting_id — UUID — Foreign key → meeting_sessions.id — NOT NULL
  • speaker_id — UUID — Foreign key → users.id
  • segments — JSONB — NOT NULL
  • transcript_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

workspace_members

  • id — UUID — Primary key — NOT NULL
  • workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • role — workspace_member_role — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

workspaces

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(160) — NOT NULL
  • description — TEXT
  • type — workspace_type — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • status — workspace_status — NOT NULL
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ