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)