Cannot add or update a child row: a foreign key constraint fails

[Mytraas]

Hey there,

Apologies in advance, I'm just getting started with AdonisJS and Lucid. I'm currently working on seeding my database with some data. I've got three tables set up:

Users
Sites
Reports
In this setup, a user can be associated with multiple sites, and each site can have multiple reports.

This is my model :

user.ts

export default class User extends BaseModel {
  @column({ isPrimary: true })
  declare id: number

  @column.dateTime({ autoCreate: true })
  declare createdAt: DateTime

  @column.dateTime({ autoCreate: true, autoUpdate: true })
  declare updatedAt: DateTime

  @hasMany(() => Site, {
    foreignKey: 'userId',
  })
  declare reports: HasMany<typeof Site>
}

site.ts

export default class Site extends BaseModel {
  @column({ isPrimary: true })
  declare id: number

  @column()
  declare userId: number

  @column.dateTime({ autoCreate: true })
  declare createdAt: DateTime

  @column.dateTime({ autoCreate: true, autoUpdate: true })
  declare updatedAt: DateTime

  @hasMany(() => Report, {
    foreignKey: 'siteId',
  })
  declare reports: HasMany<typeof Report>
}

report.ts

export default class Report extends BaseModel {
  @column({ isPrimary: true })
  declare id: number

  @column()
  declare siteId: number

  @column()
  declare reportType: string

  @column()
  declare welcomeMessage: boolean

  @column()
  declare overview: boolean

  @column()
  declare seo: boolean

  @column()
  declare performances: boolean

  @column()
  declare update: boolean

  @column()
  declare backups: boolean

  @column()
  declare security: boolean

  @column()
  declare customWork: boolean

  @column()
  declare closingMessage: boolean

  @column()
  declare from: DateTime

  @column()
  declare to: DateTime

  @column()
  declare status: string

  @column.dateTime({ autoCreate: true })
  declare createdAt: DateTime
}

users migration file

 async up() {
    this.schema.createTable(this.tableName, (table) => {
      table.increments('id').primary()

      table.timestamp('created_at')
      table.timestamp('updated_at')
    })
  }

sites migration file

 async up() {
    this.schema.createTable(this.tableName, (table) => {
      table.increments('id').primary()
      table.integer('user_id').unsigned().references('id').inTable('users').onDelete('CASCADE') // delete post when user is deleted

      table.timestamp('created_at', { useTz: true })
      table.timestamp('updated_at', { useTz: true })
    })
  }

reports migration file

  async up() {
    this.schema.createTable(this.tableName, (table) => {
      table.increments('id').primary()
      table.integer('site_id').unsigned().references('id').inTable('sites').onDelete('CASCADE') // delete post when user is deleted
      table.string('report_type')
      table.boolean('welcome_message')
      table.boolean('overview')
      table.boolean('seo')
      table.boolean('performances')
      table.boolean('update')
      table.boolean('backups')
      table.boolean('security')
      table.boolean('custom_work')
      table.boolean('closing_message')
      table.timestamp('from', { useTz: true })
      table.timestamp('to', { useTz: true })
      table.string('status')
      table.timestamps()
    })
  }

This is the error i got:

sqlMessage: 'Cannot add or update a child row: a foreign key constraint fails (`wp-doctor-api`.`reports`, CONSTRAINT `reports_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `sites` (`id`) ON DELETE CASCADE)',
  sql: "insert into `reports` (`backups`, `closing_message`, `created_at`, `custom_work`, `from`, `overview`, `performances`, `report_type`, `security`, `seo`, `site_id`, `status`, `to`, `update`, `welcome_message`) values (true, true, '2024-05-02 22:26:20', true, '2024-05-02 18:27:44', true, true, 'auto', true, true, 1, 'sent', '2024-05-02 18:27:44', true, true)"
}

It seems that reports table is feeded before the others.

Thanks for your help.