lib/pg
DefaultSchema
type DefaultSchema: ReturnType<typeof createTables>;createTables()
createTables(pgTable): {
accounts: PgTableWithColumns<{
columns: {
access_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "access_token";
notNull: false;
tableName: "account";
}, {}, {}>;
expires_at: PgColumn<{
baseColumn: never;
columnType: "PgInteger";
data: number;
dataType: "number";
driverParam: string | number;
enumValues: undefined;
hasDefault: false;
name: "expires_at";
notNull: false;
tableName: "account";
}, {}, {}>;
id_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id_token";
notNull: false;
tableName: "account";
}, {}, {}>;
provider: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "provider";
notNull: true;
tableName: "account";
}, {}, {}>;
providerAccountId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "providerAccountId";
notNull: true;
tableName: "account";
}, {}, {}>;
refresh_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "refresh_token";
notNull: false;
tableName: "account";
}, {}, {}>;
scope: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "scope";
notNull: false;
tableName: "account";
}, {}, {}>;
session_state: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "session_state";
notNull: false;
tableName: "account";
}, {}, {}>;
token_type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token_type";
notNull: false;
tableName: "account";
}, {}, {}>;
type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: "email" | "oidc" | "oauth" | "webauthn";
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "type";
notNull: true;
tableName: "account";
}, {}, {}>;
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "account";
}, {}, {}>;
};
dialect: "pg";
name: "account";
schema: undefined;
}>;
sessions: PgTableWithColumns<{
columns: {
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "session";
}, {}, {}>;
sessionToken: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "sessionToken";
notNull: true;
tableName: "session";
}, {}, {}>;
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "session";
}, {}, {}>;
};
dialect: "pg";
name: "session";
schema: undefined;
}>;
users: PgTableWithColumns<{
columns: {
email: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "email";
notNull: true;
tableName: "user";
}, {}, {}>;
emailVerified: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "emailVerified";
notNull: false;
tableName: "user";
}, {}, {}>;
id: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id";
notNull: true;
tableName: "user";
}, {}, {}>;
image: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "image";
notNull: false;
tableName: "user";
}, {}, {}>;
name: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "name";
notNull: false;
tableName: "user";
}, {}, {}>;
};
dialect: "pg";
name: "user";
schema: undefined;
}>;
verificationTokens: PgTableWithColumns<{
columns: {
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
identifier: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "identifier";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
};
dialect: "pg";
name: "verificationToken";
schema: undefined;
}>;
}Parameters
| Parameter | Type |
|---|---|
pgTable | PgTableFn<undefined> |
Returns
{
accounts: PgTableWithColumns<{
columns: {
access_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "access_token";
notNull: false;
tableName: "account";
}, {}, {}>;
expires_at: PgColumn<{
baseColumn: never;
columnType: "PgInteger";
data: number;
dataType: "number";
driverParam: string | number;
enumValues: undefined;
hasDefault: false;
name: "expires_at";
notNull: false;
tableName: "account";
}, {}, {}>;
id_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id_token";
notNull: false;
tableName: "account";
}, {}, {}>;
provider: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "provider";
notNull: true;
tableName: "account";
}, {}, {}>;
providerAccountId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "providerAccountId";
notNull: true;
tableName: "account";
}, {}, {}>;
refresh_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "refresh_token";
notNull: false;
tableName: "account";
}, {}, {}>;
scope: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "scope";
notNull: false;
tableName: "account";
}, {}, {}>;
session_state: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "session_state";
notNull: false;
tableName: "account";
}, {}, {}>;
token_type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token_type";
notNull: false;
tableName: "account";
}, {}, {}>;
type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: "email" | "oidc" | "oauth" | "webauthn";
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "type";
notNull: true;
tableName: "account";
}, {}, {}>;
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "account";
}, {}, {}>;
};
dialect: "pg";
name: "account";
schema: undefined;
}>;
sessions: PgTableWithColumns<{
columns: {
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "session";
}, {}, {}>;
sessionToken: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "sessionToken";
notNull: true;
tableName: "session";
}, {}, {}>;
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "session";
}, {}, {}>;
};
dialect: "pg";
name: "session";
schema: undefined;
}>;
users: PgTableWithColumns<{
columns: {
email: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "email";
notNull: true;
tableName: "user";
}, {}, {}>;
emailVerified: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "emailVerified";
notNull: false;
tableName: "user";
}, {}, {}>;
id: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id";
notNull: true;
tableName: "user";
}, {}, {}>;
image: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "image";
notNull: false;
tableName: "user";
}, {}, {}>;
name: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "name";
notNull: false;
tableName: "user";
}, {}, {}>;
};
dialect: "pg";
name: "user";
schema: undefined;
}>;
verificationTokens: PgTableWithColumns<{
columns: {
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
identifier: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "identifier";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
};
dialect: "pg";
name: "verificationToken";
schema: undefined;
}>;
}accounts
accounts: PgTableWithColumns<{
columns: {
access_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "access_token";
notNull: false;
tableName: "account";
}, {}, {}>;
expires_at: PgColumn<{
baseColumn: never;
columnType: "PgInteger";
data: number;
dataType: "number";
driverParam: string | number;
enumValues: undefined;
hasDefault: false;
name: "expires_at";
notNull: false;
tableName: "account";
}, {}, {}>;
id_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id_token";
notNull: false;
tableName: "account";
}, {}, {}>;
provider: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "provider";
notNull: true;
tableName: "account";
}, {}, {}>;
providerAccountId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "providerAccountId";
notNull: true;
tableName: "account";
}, {}, {}>;
refresh_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "refresh_token";
notNull: false;
tableName: "account";
}, {}, {}>;
scope: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "scope";
notNull: false;
tableName: "account";
}, {}, {}>;
session_state: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "session_state";
notNull: false;
tableName: "account";
}, {}, {}>;
token_type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token_type";
notNull: false;
tableName: "account";
}, {}, {}>;
type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: "email" | "oidc" | "oauth" | "webauthn";
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "type";
notNull: true;
tableName: "account";
}, {}, {}>;
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "account";
}, {}, {}>;
};
dialect: "pg";
name: "account";
schema: undefined;
}>;Type declaration
columns
columns: {
access_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "access_token";
notNull: false;
tableName: "account";
}, {}, {}>;
expires_at: PgColumn<{
baseColumn: never;
columnType: "PgInteger";
data: number;
dataType: "number";
driverParam: string | number;
enumValues: undefined;
hasDefault: false;
name: "expires_at";
notNull: false;
tableName: "account";
}, {}, {}>;
id_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id_token";
notNull: false;
tableName: "account";
}, {}, {}>;
provider: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "provider";
notNull: true;
tableName: "account";
}, {}, {}>;
providerAccountId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "providerAccountId";
notNull: true;
tableName: "account";
}, {}, {}>;
refresh_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "refresh_token";
notNull: false;
tableName: "account";
}, {}, {}>;
scope: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "scope";
notNull: false;
tableName: "account";
}, {}, {}>;
session_state: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "session_state";
notNull: false;
tableName: "account";
}, {}, {}>;
token_type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token_type";
notNull: false;
tableName: "account";
}, {}, {}>;
type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: "email" | "oidc" | "oauth" | "webauthn";
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "type";
notNull: true;
tableName: "account";
}, {}, {}>;
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "account";
}, {}, {}>;
};columns.access_token
access_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "access_token";
notNull: false;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "access_token";notNull
notNull: false;tableName
tableName: "account";columns.expires_at
expires_at: PgColumn<{
baseColumn: never;
columnType: "PgInteger";
data: number;
dataType: "number";
driverParam: string | number;
enumValues: undefined;
hasDefault: false;
name: "expires_at";
notNull: false;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgInteger";data
data: number;dataType
dataType: "number";driverParam
driverParam: string | number;enumValues
enumValues: undefined;hasDefault
hasDefault: false;name
name: "expires_at";notNull
notNull: false;tableName
tableName: "account";columns.id_token
id_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id_token";
notNull: false;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "id_token";notNull
notNull: false;tableName
tableName: "account";columns.provider
provider: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "provider";
notNull: true;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "provider";notNull
notNull: true;tableName
tableName: "account";columns.providerAccountId
providerAccountId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "providerAccountId";
notNull: true;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "providerAccountId";notNull
notNull: true;tableName
tableName: "account";columns.refresh_token
refresh_token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "refresh_token";
notNull: false;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "refresh_token";notNull
notNull: false;tableName
tableName: "account";columns.scope
scope: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "scope";
notNull: false;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "scope";notNull
notNull: false;tableName
tableName: "account";columns.session_state
session_state: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "session_state";
notNull: false;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "session_state";notNull
notNull: false;tableName
tableName: "account";columns.token_type
token_type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token_type";
notNull: false;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "token_type";notNull
notNull: false;tableName
tableName: "account";columns.type
type: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: "email" | "oidc" | "oauth" | "webauthn";
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "type";
notNull: true;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: "email" | "oidc" | "oauth" | "webauthn";dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "type";notNull
notNull: true;tableName
tableName: "account";columns.userId
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "account";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "userId";notNull
notNull: true;tableName
tableName: "account";dialect
dialect: "pg";name
name: "account";schema
schema: undefined;sessions
sessions: PgTableWithColumns<{
columns: {
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "session";
}, {}, {}>;
sessionToken: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "sessionToken";
notNull: true;
tableName: "session";
}, {}, {}>;
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "session";
}, {}, {}>;
};
dialect: "pg";
name: "session";
schema: undefined;
}>;Type declaration
columns
columns: {
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "session";
}, {}, {}>;
sessionToken: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "sessionToken";
notNull: true;
tableName: "session";
}, {}, {}>;
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "session";
}, {}, {}>;
};columns.expires
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "session";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgTimestamp";data
data: Date;dataType
dataType: "date";driverParam
driverParam: string;enumValues
enumValues: undefined;hasDefault
hasDefault: false;name
name: "expires";notNull
notNull: true;tableName
tableName: "session";columns.sessionToken
sessionToken: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "sessionToken";
notNull: true;
tableName: "session";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "sessionToken";notNull
notNull: true;tableName
tableName: "session";columns.userId
userId: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "userId";
notNull: true;
tableName: "session";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "userId";notNull
notNull: true;tableName
tableName: "session";dialect
dialect: "pg";name
name: "session";schema
schema: undefined;users
users: PgTableWithColumns<{
columns: {
email: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "email";
notNull: true;
tableName: "user";
}, {}, {}>;
emailVerified: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "emailVerified";
notNull: false;
tableName: "user";
}, {}, {}>;
id: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id";
notNull: true;
tableName: "user";
}, {}, {}>;
image: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "image";
notNull: false;
tableName: "user";
}, {}, {}>;
name: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "name";
notNull: false;
tableName: "user";
}, {}, {}>;
};
dialect: "pg";
name: "user";
schema: undefined;
}>;Type declaration
columns
columns: {
email: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "email";
notNull: true;
tableName: "user";
}, {}, {}>;
emailVerified: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "emailVerified";
notNull: false;
tableName: "user";
}, {}, {}>;
id: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id";
notNull: true;
tableName: "user";
}, {}, {}>;
image: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "image";
notNull: false;
tableName: "user";
}, {}, {}>;
name: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "name";
notNull: false;
tableName: "user";
}, {}, {}>;
};columns.email
email: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "email";
notNull: true;
tableName: "user";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "email";notNull
notNull: true;tableName
tableName: "user";columns.emailVerified
emailVerified: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "emailVerified";
notNull: false;
tableName: "user";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgTimestamp";data
data: Date;dataType
dataType: "date";driverParam
driverParam: string;enumValues
enumValues: undefined;hasDefault
hasDefault: false;name
name: "emailVerified";notNull
notNull: false;tableName
tableName: "user";columns.id
id: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "id";
notNull: true;
tableName: "user";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "id";notNull
notNull: true;tableName
tableName: "user";columns.image
image: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "image";
notNull: false;
tableName: "user";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "image";notNull
notNull: false;tableName
tableName: "user";columns.name
name: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "name";
notNull: false;
tableName: "user";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "name";notNull
notNull: false;tableName
tableName: "user";dialect
dialect: "pg";name
name: "user";schema
schema: undefined;verificationTokens
verificationTokens: PgTableWithColumns<{
columns: {
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
identifier: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "identifier";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
};
dialect: "pg";
name: "verificationToken";
schema: undefined;
}>;Type declaration
columns
columns: {
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
identifier: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "identifier";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;
};columns.expires
expires: PgColumn<{
baseColumn: never;
columnType: "PgTimestamp";
data: Date;
dataType: "date";
driverParam: string;
enumValues: undefined;
hasDefault: false;
name: "expires";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgTimestamp";data
data: Date;dataType
dataType: "date";driverParam
driverParam: string;enumValues
enumValues: undefined;hasDefault
hasDefault: false;name
name: "expires";notNull
notNull: true;tableName
tableName: "verificationToken";columns.identifier
identifier: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "identifier";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "identifier";notNull
notNull: true;tableName
tableName: "verificationToken";columns.token
token: PgColumn<{
baseColumn: never;
columnType: "PgText";
data: string;
dataType: "string";
driverParam: string;
enumValues: [string, ...string[]];
hasDefault: false;
name: "token";
notNull: true;
tableName: "verificationToken";
}, {}, {}>;Type declaration
baseColumn
baseColumn: never;columnType
columnType: "PgText";data
data: string;dataType
dataType: "string";driverParam
driverParam: string;enumValues
enumValues: [string, ...string[]];hasDefault
hasDefault: false;name
name: "token";notNull
notNull: true;tableName
tableName: "verificationToken";dialect
dialect: "pg";name
name: "verificationToken";schema
schema: undefined;pgDrizzleAdapter()
pgDrizzleAdapter(client, tableFn): AdapterParameters
| Parameter | Type | Default value |
|---|---|---|
client | PgDatabase<QueryResultHKT, Record<string, unknown>, TablesRelationalConfig> | undefined |
tableFn | PgTableFn<undefined> | defaultPgTableFn |