Depricated pgTable function
export const gp_data = pgTable(
'gp_data',
{
id: uuid('id').defaultRandom().primaryKey(),
uid: integer('uid').notNull(),
sid: integer('sid').notNull(),
f1: jsonb('f1').notNull(),
f2: jsonb('f2').notNull(),
s1: jsonb('s1').notNull(),
s2: jsonb('s2').notNull(),
b1: jsonb('b1'),
b2: jsonb('b2'),
e1: jsonb('e1'),
created: timestamp('created').$default(() => new Date()).notNull(),
updated: timestamp('updated').$onUpdate(() => new Date()),
},
(t) => ({
uid_sid_unique: unique().on(t.uid, t.sid),
}),
);
export const gp_data = pgTable(
'gp_data',
{
id: uuid('id').defaultRandom().primaryKey(),
uid: integer('uid').notNull(),
sid: integer('sid').notNull(),
f1: jsonb('f1').notNull(),
f2: jsonb('f2').notNull(),
s1: jsonb('s1').notNull(),
s2: jsonb('s2').notNull(),
b1: jsonb('b1'),
b2: jsonb('b2'),
e1: jsonb('e1'),
created: timestamp('created').$default(() => new Date()).notNull(),
updated: timestamp('updated').$onUpdate(() => new Date()),
},
(t) => ({
uid_sid_unique: unique().on(t.uid, t.sid),
}),
);
#this part
(t) => ({
uid_sid_unique: unique().on(t.uid, t.sid),
}),
#this part
(t) => ({
uid_sid_unique: unique().on(t.uid, t.sid),
}),
1 Reply
Here's the reference
export const Users = pgTable(
'user',
(table) => ({
id: table.serial().primaryKey(),
username: table.varchar().notNull(),
availability: table.bigint({ mode: 'number' }).array(4).notNull().default([0, 0, 0, 0]),
availabilityConfirmed: table.boolean().notNull().default(false),
tokens: table.jsonb().$type<Tokens>(),
viewPreference: ViewPreference().notNull().default('grid'),
createdAt: table.timestamp(timestampConfig).defaultNow()
}),
(table) => [
check('availability_check', sql`cardinality(${table.availability}) = 4`)
]
)
export const Users = pgTable(
'user',
(table) => ({
id: table.serial().primaryKey(),
username: table.varchar().notNull(),
availability: table.bigint({ mode: 'number' }).array(4).notNull().default([0, 0, 0, 0]),
availabilityConfirmed: table.boolean().notNull().default(false),
tokens: table.jsonb().$type<Tokens>(),
viewPreference: ViewPreference().notNull().default('grid'),
createdAt: table.timestamp(timestampConfig).defaultNow()
}),
(table) => [
check('availability_check', sql`cardinality(${table.availability}) = 4`)
]
)