schema generates wrong index
I have this schema:
why is creating a composite index like:
export const historyFiles = pgTable('history_files', {
id: serial('id').primaryKey(),
fileId: integer('file_id')
.references(() => files.id)
.notNull(),
historyId: integer('history_id')
.references(() => histories.id)
.notNull(),
createdAt: timestamp('created_at').defaultNow().notNull(),
updatedAt: timestamp('updated_at').defaultNow().notNull(),
});export const historyFiles = pgTable('history_files', {
id: serial('id').primaryKey(),
fileId: integer('file_id')
.references(() => files.id)
.notNull(),
historyId: integer('history_id')
.references(() => histories.id)
.notNull(),
createdAt: timestamp('created_at').defaultNow().notNull(),
updatedAt: timestamp('updated_at').defaultNow().notNull(),
});why is creating a composite index like:
history_files_file_id_users_id_fkhistory_files_file_id_users_id_fkThe official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Similar Threads
Was this page helpful?
