Is this the right way of using relations ?

export const repairOrder = pgTable(
  'repairOrder',
  {
    id: text('id').primaryKey(),
    userId: text('userId').notNull(),
    mechanicId: text('mechanicId'),
    status: roStatusEnum('status').notNull().default('part sent'),
    roNumber: text('roNumber').notNull(),
    carMaker: text('carMaker').notNull(),
    carModel: text('carModel').notNull(),
    createdAt: timestamp('createdAt').notNull().defaultNow(),
    updatedAt: timestamp('updatedAt')
      .defaultNow()
      .$onUpdate(() => new Date())
  } to
  }
)

export const repairOrderFilesRelation = relations(repairOrder, ({  many }) => ({
  files: many(files)
}))

export const files = pgTable(
  'files',
  {
    id: text('id').primaryKey(),
    roId: text('roId').notNull(),
    name: text('name').notNull(),
    key: text('key').notNull(),
    url: text('url').notNull(),
    type: text('type').notNull(),
  }jjk
)

export const fileToRepairOrder = relations(files, ({ one }) => ({
  repairOrder: one(repairOrder, {
    fields: [files.roId],
    references: [repairOrder.id]
  })
}))

      const [data] = await db
        .select()
        .from(repairOrder)
        .innerJoin(estimator, eq(estimator.id, repairOrder.userId))
        .leftJoin(mechanic, eq(mechanic.id, repairOrder.mechanicId))
        .where(eq(repairOrder.id, id))

      const filesData = await db.select().from(files).where(eq(files.roId, id))

leftJoin(files, eq(files.roId, repairOrder.id))