autoPM

Tables (25)

action_item_evidences

  • action_item_id — UUID — Foreign key → execution_tasks.id — NOT NULL
  • evidence_id — UUID — Foreign key → evidences.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

ai_generation_logs

  • id — UUID
  • generated_by — UUID — Foreign key → users.id
  • target_type — target_type_enum — NOT NULL
  • target_id — UUID — NOT NULL
  • model_name — VARCHAR(100) — NOT NULL
  • model_version — VARCHAR(100)
  • prompt_version — VARCHAR(100)
  • input_hash — CHAR(64)
  • status — generation_status_enum — NOT NULL
  • request_payload — JSONB
  • response_summary — JSONB
  • error_message — TEXT
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (finished_at IS NULL OR started_at IS NULL OR finished_at >= started_at)

audit_logs

  • id — UUID
  • user_id — UUID — Foreign key → users.id
  • target_type — target_type_enum — NOT NULL
  • target_id — UUID — NOT NULL
  • action — audit_action_enum — NOT NULL
  • before_value — JSONB
  • after_value — JSONB
  • note — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

chunk_segment_mappings

  • source_embedding_id — UUID — Foreign key → source_embeddings.id — NOT NULL
  • transcript_segment_id — UUID — Foreign key → transcript_segments.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

decision_evidences

  • decision_id — UUID — Foreign key → decisions.id — NOT NULL
  • evidence_id — UUID — Foreign key → evidences.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

decisions

  • id — UUID
  • meeting_id — UUID — Foreign key → meetings.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • decided_by_user_id — UUID — Foreign key → users.id
  • created_by_ai — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

evidences

  • id — UUID
  • transcript_segment_id — UUID — Foreign key → transcript_segments.id
  • source_embedding_id — UUID — Foreign key → source_embeddings.id
  • snippet_text — TEXT — NOT NULL
  • confidence_score — NUMERIC(5,4)
  • note — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • CHECK — ( transcript_segment_id IS NOT NULL OR source_embedding_id IS NOT NULL ) — NOT NULL
  • CHECK — (confidence_score IS NULL OR (confidence_score >= 0 AND confidence_score <= 1))

execution_tasks

  • id — UUID
  • meeting_id — UUID — Foreign key → meetings.id — NOT NULL
  • wbs_item_id — UUID — Foreign key → wbs_items.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • owner_id — UUID — Foreign key → users.id
  • due_at — TIMESTAMPTZ
  • status — task_status_enum — NOT NULL
  • priority — priority_enum — NOT NULL
  • completed_at — TIMESTAMPTZ
  • created_by_ai — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (completed_at IS NULL OR completed_at >= created_at)

input_sources

  • id — UUID
  • meeting_id — UUID — Foreign key → meetings.id — NOT NULL
  • source_type — input_source_type_enum — NOT NULL
  • title — VARCHAR(255)
  • file_name — VARCHAR(255)
  • file_path — TEXT
  • mime_type — VARCHAR(100)
  • language_code — VARCHAR(20)
  • checksum — VARCHAR(128)
  • raw_text — TEXT
  • processing_status — processing_status_enum — NOT NULL
  • uploaded_by — UUID — Foreign key → users.id
  • uploaded_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

integration_logs

  • id — UUID
  • requested_by — UUID — Foreign key → users.id
  • target_type — target_type_enum — NOT NULL
  • target_id — UUID — NOT NULL
  • tool_type — integration_tool_enum — NOT NULL
  • status — integration_status_enum — NOT NULL
  • external_id — TEXT
  • request_payload — JSONB
  • response_payload — JSONB
  • error_message — TEXT
  • requested_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (completed_at IS NULL OR completed_at >= requested_at)

issue_evidences

  • issue_id — UUID — Foreign key → issues.id — NOT NULL
  • evidence_id — UUID — Foreign key → evidences.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

issues

  • id — UUID
  • meeting_id — UUID — Foreign key → meetings.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — issue_status_enum — NOT NULL
  • priority — priority_enum — NOT NULL
  • owner_id — UUID — Foreign key → users.id
  • due_at — TIMESTAMPTZ
  • resolved_at — TIMESTAMPTZ
  • created_by_ai — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (resolved_at IS NULL OR resolved_at >= created_at)

meeting_participants

  • meeting_id — UUID — Foreign key → meetings.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • attendance_status — attendance_status_enum — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

meetings

  • id — UUID
  • project_id — UUID — Foreign key → projects.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • meeting_type — meeting_type_enum — NOT NULL
  • started_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • created_by — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (ended_at IS NULL OR started_at IS NULL OR ended_at >= started_at)

milestone_evidences

  • milestone_id — UUID — Foreign key → milestones.id — NOT NULL
  • evidence_id — UUID — Foreign key → evidences.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

milestones

  • id — UUID
  • project_id — UUID — Foreign key → projects.id — NOT NULL
  • wbs_item_id — UUID — Foreign key → wbs_items.id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • target_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • owner_id — UUID — Foreign key → users.id
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (completed_at IS NULL OR completed_at >= created_at)

projects

  • id — UUID
  • name — VARCHAR(255) — NOT NULL
  • code — VARCHAR(50)
  • description — TEXT
  • status — project_status_enum — NOT NULL
  • owner_id — UUID — Foreign key → users.id
  • started_at — TIMESTAMPTZ
  • ended_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (ended_at IS NULL OR started_at IS NULL OR ended_at >= started_at)

risk_evidences

  • risk_id — UUID — Foreign key → risks.id — NOT NULL
  • evidence_id — UUID — Foreign key → evidences.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

risks

  • id — UUID
  • meeting_id — UUID — Foreign key → meetings.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — risk_status_enum — NOT NULL
  • owner_id — UUID — Foreign key → users.id
  • probability_score — SMALLINT
  • impact_score — SMALLINT
  • mitigation_plan — TEXT
  • resolved_at — TIMESTAMPTZ
  • created_by_ai — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (probability_score IS NULL OR (probability_score BETWEEN 1 AND 5))
  • CHECK — (impact_score IS NULL OR (impact_score BETWEEN 1 AND 5))

source_embeddings

  • id — UUID
  • input_source_id — UUID — Foreign key → input_sources.id — NOT NULL
  • chunk_index — INT — NOT NULL
  • chunk_text — TEXT — NOT NULL
  • embedding — VECTOR(1024) — NOT NULL
  • token_count — INT
  • start_offset — INT
  • end_offset — INT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (token_count IS NULL OR token_count >= 0)
  • CHECK — (end_offset IS NULL OR start_offset IS NULL OR end_offset >= start_offset)

transcript_segments

  • id — UUID
  • input_source_id — UUID — Foreign key → input_sources.id — NOT NULL
  • sequence_no — INT — NOT NULL
  • speaker_name — VARCHAR(100)
  • speaker_user_id — UUID — Foreign key → users.id
  • start_ms — BIGINT
  • end_ms — BIGINT
  • content — TEXT — NOT NULL
  • confidence_score — NUMERIC(5,4)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (confidence_score IS NULL OR (confidence_score >= 0 AND confidence_score <= 1))
  • CHECK — (end_ms IS NULL OR start_ms IS NULL OR end_ms >= start_ms)

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — user_role_enum — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

wbs_item_evidences

  • wbs_item_id — UUID — Foreign key → wbs_items.id — NOT NULL
  • evidence_id — UUID — Foreign key → evidences.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

wbs_item_raci

  • raci_role — raci_role_enum — Primary key — NOT NULL
  • wbs_item_id — UUID — Foreign key → wbs_items.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

wbs_items

  • id — UUID
  • project_id — UUID — Foreign key → projects.id — NOT NULL
  • parent_id — UUID — Foreign key → wbs_items.id
  • wbs_code — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • level — SMALLINT — NOT NULL
  • sort_order — INT — NOT NULL
  • status — task_status_enum — NOT NULL
  • owner_id — UUID — Foreign key → users.id
  • estimated_md — NUMERIC(8,2)
  • deliverable — TEXT
  • start_at — TIMESTAMPTZ
  • end_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • CHECK — (level >= 1)
  • CHECK — (estimated_md IS NULL OR estimated_md >= 0)
  • CHECK — (end_at IS NULL OR start_at IS NULL OR end_at >= start_at)