userConnections

const userConnections: PgTableWithColumns<{ columns: { createdAt: PgColumn<{ baseColumn: never; columnType: "PgTimestampString"; data: string; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "created_at"; notNull: true; tableName: "user_connections"; }, { }, { }>; expiresAt: PgColumn<{ baseColumn: never; columnType: "PgTimestampString"; data: string; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "expires_at"; notNull: false; tableName: "user_connections"; }, { }, { }>; id: PgColumn<{ baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: true; name: "id"; notNull: true; tableName: "user_connections"; }, { }, { }>; refreshTokenEncrypted: PgColumn<{ baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "refresh_token_encrypted"; notNull: false; tableName: "user_connections"; }, { }, { }>; service: PgColumn<{ baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "service"; notNull: true; tableName: "user_connections"; }, { }, { }>; status: PgColumn<{ baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "status"; notNull: true; tableName: "user_connections"; }, { }, { }>; tokenEncrypted: PgColumn<{ baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "token_encrypted"; notNull: true; tableName: "user_connections"; }, { }, { }>; updatedAt: PgColumn<{ baseColumn: never; columnType: "PgTimestampString"; data: string; dataType: "string"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "updated_at"; notNull: true; tableName: "user_connections"; }, { }, { }>; userId: PgColumn<{ baseColumn: never; columnType: "PgText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "user_id"; notNull: true; tableName: "user_connections"; }, { }, { }>; }; dialect: "pg"; name: "user_connections"; schema: undefined; }>

Defined in: packages/db-postgres/src/schema/connection.ts:9

A user’s own OAuth connection to an external service (Figma, later Jira/Linear/…), one per user and service. tokenEncrypted is the access token; the refresh token is encrypted too. status is ok or expired (needs reconnecting).