Confluence Page Records — publish and ingestion tracking
| Field | Type | Required | Description |
|---|
| orgId | string | Yes | Organization ID for multi-tenant isolation |
| programId | Id<"programs"> | Yes | Parent program reference |
| pageType | ”gap_analysis” | “sprint_report” | “risk_register” | “visual_discovery” | “decisions_log” | “program_overview” | “ingested” | Yes | |
| confluencePageId | string | Yes | |
| confluencePageTitle | string | Yes | |
| confluenceVersion | number | Yes | |
| direction | ”publish” | “ingest” | Yes | |
| lastPublishedAt | number | No | |
| lastIngestedAt | number | No | |
| sourceAnalysisId | string | No | |
| contentHash | string | No | |
| sprintId | string | No | |
| cachedRenderedHtml | string | No | |
| cachedRenderedVersion | number | No | |
| Name | Fields |
|---|
| by_program | programId |
| by_org | orgId |
| by_confluence_page_id | programId, confluencePageId |
| by_page_type | programId, pageType |