const mysqlTable = mysqlTableCreator((name) => `petLog_${name}`);
// truncated for brewity
export const usersTable = mysqlTable('users', {
id: varchar('id', {
length: 255,
}).primaryKey(),
//...rest
});
export const petsTable = mysqlTable('pets', {
id: varchar('id', {
length: 255,
}).primaryKey(),
//...rest
});
export const usersToPetsTable = mysqlTable(
'usersToPets',
{
userId: varchar('userId', {
length: 255,
})
.notNull()
.references(() => usersTable.id),
petId: varchar('petId', {
length: 255,
})
.notNull()
.references(() => petsTable.id),
},
(table) => ({
pk: primaryKey({ columns: [table.userId, table.petId] }),
}),
);
const mysqlTable = mysqlTableCreator((name) => `petLog_${name}`);
// truncated for brewity
export const usersTable = mysqlTable('users', {
id: varchar('id', {
length: 255,
}).primaryKey(),
//...rest
});
export const petsTable = mysqlTable('pets', {
id: varchar('id', {
length: 255,
}).primaryKey(),
//...rest
});
export const usersToPetsTable = mysqlTable(
'usersToPets',
{
userId: varchar('userId', {
length: 255,
})
.notNull()
.references(() => usersTable.id),
petId: varchar('petId', {
length: 255,
})
.notNull()
.references(() => petsTable.id),
},
(table) => ({
pk: primaryKey({ columns: [table.userId, table.petId] }),
}),
);