import { foreignKey, mysqlTable, unique, varchar } from 'drizzle-orm/mysql-core'
export const table1 = mysqlTable(
'table1',
{
id: varchar('id', { length: 256 }).primaryKey(),
table2Id: varchar('table2_id', { length: 256 }).notNull(),
name: varchar('name', { length: 256 }).notNull(),
},
(table) => ({
table2Fk: foreignKey({
columns: [table.table2Id],
foreignColumns: [table2.id],
name: 'table1_table2_fk',
}).onDelete('cascade'),
uniqueName: unique('unique_name').on(table.table2Id, table.name),
})
)
export const table2 = mysqlTable('table2', {
id: varchar('id', { length: 256 }).primaryKey(),
})
import { foreignKey, mysqlTable, unique, varchar } from 'drizzle-orm/mysql-core'
export const table1 = mysqlTable(
'table1',
{
id: varchar('id', { length: 256 }).primaryKey(),
table2Id: varchar('table2_id', { length: 256 }).notNull(),
name: varchar('name', { length: 256 }).notNull(),
},
(table) => ({
table2Fk: foreignKey({
columns: [table.table2Id],
foreignColumns: [table2.id],
name: 'table1_table2_fk',
}).onDelete('cascade'),
uniqueName: unique('unique_name').on(table.table2Id, table.name),
})
)
export const table2 = mysqlTable('table2', {
id: varchar('id', { length: 256 }).primaryKey(),
})