Upsert on foreign key changes serial ID

      const employeeStoresRes = await tx
        .insert(employeeStore)
        .values(employeeIDStoreID)
        .onConflictDoNothing()
        .returning({ storeID: employeeStore.storeID })

export const employeeStore = pgTable(
  'employeeStore',
  {
    employeeStoreID: serial().$type<EmployeeStoreID>().primaryKey(),
    storeID: integer()
      .$type<StoreID>()
      .references(() => stores.storeID, {
        onDelete: 'cascade',
      })
      .notNull(),
    employeeID: integer()
      .$type<EmployeeID>()
      .references(() => employees.employeeID, {
        onDelete: 'cascade',
      })
      .notNull(),
    ...dbDates,
  },
  (employeeStore) => {
    return {
      unique: unique('unique_employeeStore').on(employeeStore.storeID, employeeStore.employeeID),
    }
  },
)

export const employeeStoreRelations = relations(employeeStore, ({ one, many }) => ({
  employees: one(employees),
  stores: one(stores),
  employeeCheckin: many(employeeCheckin),
}))

export const employeeCheckin = pgTable(
  'employeeCheckin',
  {
    employeeCheckinID: serial().$type<EmployeeCheckinID>().primaryKey(),
    employeeStoreID: integer()
      .$type<EmployeeStoreID>()
      .references(() => employeeStore.employeeStoreID, {
        onDelete: 'cascade',
      }),
    employeeCheckedIn: timestamp({ mode: 'date' }),
    employeeCheckedOut: timestamp({ mode: 'date' }),
  },
  (employeeCheckin) => {
    return {
      index: index('checkinIndex').on(employeeCheckin.employeeCheckedIn),
    }
  },
)

      const employeeStoresRes = await tx
        .insert(employeeStore)
        .values(employeeIDStoreID)
        .onConflictDoNothing()
        .returning({ storeID: employeeStore.storeID })

export const employeeStore = pgTable(
  'employeeStore',
  {
    employeeStoreID: serial().$type<EmployeeStoreID>().primaryKey(),
    storeID: integer()
      .$type<StoreID>()
      .references(() => stores.storeID, {
        onDelete: 'cascade',
      })
      .notNull(),
    employeeID: integer()
      .$type<EmployeeID>()
      .references(() => employees.employeeID, {
        onDelete: 'cascade',
      })
      .notNull(),
    ...dbDates,
  },
  (employeeStore) => {
    return {
      unique: unique('unique_employeeStore').on(employeeStore.storeID, employeeStore.employeeID),
    }
  },
)

export const employeeStoreRelations = relations(employeeStore, ({ one, many }) => ({
  employees: one(employees),
  stores: one(stores),
  employeeCheckin: many(employeeCheckin),
}))

export const employeeCheckin = pgTable(
  'employeeCheckin',
  {
    employeeCheckinID: serial().$type<EmployeeCheckinID>().primaryKey(),
    employeeStoreID: integer()
      .$type<EmployeeStoreID>()
      .references(() => employeeStore.employeeStoreID, {
        onDelete: 'cascade',
      }),
    employeeCheckedIn: timestamp({ mode: 'date' }),
    employeeCheckedOut: timestamp({ mode: 'date' }),
  },
  (employeeCheckin) => {
    return {
      index: index('checkinIndex').on(employeeCheckin.employeeCheckedIn),
    }
  },
)