Integrations — third-party system connections tracked per program
| Field | Type | Required | Description |
|---|
| orgId | string | Yes | Organization ID for multi-tenant isolation |
| programId | Id<"programs"> | Yes | Parent program reference |
| name | string | Yes | |
| type | ”api” | “webhook” | “file_transfer” | “database” | “middleware” | “other” | Yes | |
| sourceSystem | string | Yes | |
| targetSystem | string | Yes | |
| description | string | No | |
| status | ”planned” | “in_progress” | “testing” | “live” | “deprecated” | Yes | |
| requirementIds | Id<"requirements">[] | No | |
| ownerId | Id<"users"> | No | |
| notes | string | No | |
| Name | Fields |
|---|
| by_program | programId |
| by_org | orgId |