Skip to content

notificationSubscriptions

const notificationSubscriptions: MySqlTableWithColumns<{ columns: { createdAt: MySqlColumn<{ baseColumn: never; columnType: "MySqlCustomColumn"; data: string; dataType: "custom"; driverParam: string; enumValues: undefined; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "created_at"; notNull: true; tableName: "notification_subscriptions"; }, { }, { }>; enabled: MySqlColumn<{ baseColumn: never; columnType: "MySqlBoolean"; data: boolean; dataType: "boolean"; driverParam: number | boolean; enumValues: undefined; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "enabled"; notNull: true; tableName: "notification_subscriptions"; }, { }, { }>; events: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "events"; notNull: false; tableName: "notification_subscriptions"; }, { }, { }>; id: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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: "notification_subscriptions"; }, { }, { }>; projectId: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "project_id"; notNull: true; tableName: "notification_subscriptions"; }, { }, { }>; userId: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; 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: "notification_subscriptions"; }, { }, { }>; via: MySqlColumn<{ baseColumn: never; columnType: "MySqlText"; data: string; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: false; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "via"; notNull: false; tableName: "notification_subscriptions"; }, { }, { }>; }; dialect: "mysql"; name: "notification_subscriptions"; schema: undefined; }>

Defined in: packages/db-mysql/src/schema/notification.ts:22

Narrow notification_subscriptions table definition.