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