[V5] Inconsistencies between validator and properties declared in the model

[furatamasensei]

It going to be a bit longer to read since we're comparing 2 models here.

I'm working on request validator for my entire model & controllers and figured out an inconsistencies between of it. For example, in Agenda model, I have defined the columns like this:

Agenda.ts

import { DateTime } from 'luxon'
import { BaseModel, column } from '@ioc:Adonis/Lucid/Orm'

export default class Agenda extends BaseModel {
  ...

  @column()
  public startDate: Date

  @column()
  public endDate: Date

  ...
}

Inside the validator, I defined it like this:

AgendaValidator.ts

public schema = schema.create({
  ...

  start_date: schema.date({ format: 'iso' }, [
    rules.beforeOrEqualToField('end_date'),
  ]),
  end_date: schema.date({ format: 'iso' }, [
    rules.afterOrEqualToField('start_date'),
  ]),

  ...
})

And then on my controller:

AgendaController.ts

public async store (ctx: HttpContextContract) {
  const data = await ctx.request.validate(AgendaValidator)
  const user = ctx.auth.user

  if (user) {
    const agenda = await user.related('agendas').create(data)
    return agenda.serialize()
  }

  throw new UnauthorizedException()
}

It works and my IDE doesn't complain about how I define the properties inside the validator. However, when I try to do the same thing on my PayrollInfo model, my IDE starts complaining:

Type '{
    bpjs_holder: string;
    bpjs_number: number;
    npwp_holder: string;
    npwp_number: number;
    bank_name: string;
    bank_holder: string;
    bank_number: number;
}'
has no properties in common with type 'Partial<{
    id: number;
    userId: number;
    bpjsHolder: string;
    bpjsNumber: number;
    npwpHolder: string;
    npwpNumber: number;
    bankName: string;
    bankHolder: string;
    bankNumber: number;
    createdAt: DateTime;
    updatedAt: DateTime;
}>'

Here is how I define the columns in the model:

PayrollInfo.ts

import { DateTime } from 'luxon'
import { BaseModel, BelongsTo, belongsTo, column } from '@ioc:Adonis/Lucid/Orm'
import User from './User'

export default class PayrollInfo extends BaseModel {
  ...

  @column()
  public bpjsHolder: string

  @column()
  public bpjsNumber: number

  @column()
  public npwpHolder: string

  @column()
  public npwpNumber: number

  @column()
  public bankName: string

  @column()
  public bankHolder: string

  @column()
  public bankNumber: number

  ...
}

And the validator:

PayrollInfoValidator.ts

public schema = schema.create({
  bpjs_holder: schema.string({}, [
    rules.maxLength(100),
  ]),
  bpjs_number: schema.number(),
  npwp_holder: schema.string({}, [
    rules.maxLength(100),
  ]),
  npwp_number: schema.number(),
  bank_name: schema.string({}, [
    rules.maxLength(100),
  ]),
  bank_holder: schema.string({}, [
    rules.maxLength(100),
  ]),
  bank_number: schema.number(),
})

Then, the controller:

PayrollInfoController.ts

public async store (ctx: HttpContextContract) {
  const data = await ctx.request.validate(PayrollInfoValidator)
  const user = ctx.auth.user

  if (user) {
    const payrollInfo = await user.related('payrollInfo').create(data)
    return payrollInfo
  }

  throw new UnauthorizedException()
}

The migration:

xxxxxxxx_payroll_infos.ts

import BaseSchema from '@ioc:Adonis/Lucid/Schema'

export default class PayrollInfos extends BaseSchema {
  protected tableName = 'payroll_infos'

  public async up () {
    this.schema.createTable(this.tableName, (table) => {
      table.increments('id')
      table.bigInteger('user_id')
      table.string('bpjs_holder')
      table.bigInteger('bpjs_number')
      table.string('npwp_holder')
      table.bigInteger('npwp_number')
      table.string('bank_name')
      table.string('bank_holder')
      table.bigInteger('bank_number')
      table.timestamps(true)
    })
  }

  public async down () {
    this.schema.dropTable(this.tableName)
  }
}

It stops complaining when I changed public bankNumber for example, to public bank_number but it leads me to an inconsistency when declaring a property which is some part written on camelCase, and some part written on snake_case.

Am I missed something or I implemented it wrong? Please help and let me know..