Skip to content

users

const users: PgTableWithColumns<{ columns: { avatarUrl: 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: "avatar_url"; notNull: false; tableName: "users"; }, { }, { }>; 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: "users"; }, { }, { }>; email: 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: "email"; notNull: true; tableName: "users"; }, { }, { }>; 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: "users"; }, { }, { }>; lastLoginAt: 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: "last_login_at"; notNull: false; tableName: "users"; }, { }, { }>; name: 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: "name"; notNull: true; tableName: "users"; }, { }, { }>; role: PgColumn<{ baseColumn: never; columnType: "PgText"; data: "admin" | "member" | "viewer"; dataType: "string"; driverParam: string; enumValues: [string, ...string[]]; generated: undefined; hasDefault: true; hasRuntimeDefault: false; identity: undefined; isAutoincrement: false; isPrimaryKey: false; name: "role"; notNull: true; tableName: "users"; }, { }, { $type: "admin" | "member" | "viewer"; }>; }; dialect: "pg"; name: "users"; schema: undefined; }>

Defined in: packages/db-postgres/src/schema/user.ts:5

Narrow users table definition.