self-relationship/subcategories return null or []

[Soel30]

I'm trying to create a self-relationship/subcategory using Adonisjs, but it returns the result []/null. is there any solution?

models

 @column()
  public categoryId: string

  @hasMany(() => Category)
  public subCategory: HasMany<typeof Category>

controllers

 const page = request.qs('page', 1)
      const limit = request.qs('limit', 10)
      const categories = await Category.query()
        .whereNull('category_id')
        .preload('subCategory')
        .paginate(page, limit)

migrations

      table.bigInteger('category_id').unsigned().references('categories.id').onDelete('cascade')

thanks

[thetutlage]

Can you share the complete migration file?

[Soel30]

yes

 this.schema.createTable(this.tableName, (table) => {
      table.increments('id').primary()
      table.string('name').nullable()
      table.string('slug').nullable()
      table.bigInteger('category_id').unsigned().references('categories.id').onDelete('cascade')
      table.timestamp('created_at', { useTz: true })
      table.timestamp('updated_at', { useTz: true })
    })

[sultan216]

I'm sorry, it turned out that there was an error on my part. I tried removing the primary() function in the increment id and I changed table.BigInteger to table.integer and it worked. Thank you