shorts-api/app/Models/BalanceRecord.ts

import { DateTime } from 'luxon'
import { column } from '@ioc:Adonis/Lucid/Orm'
import Decimal from 'decimal.js'
import { decimalConverter } from 'App/Helpers/db'
import AppBaseModel from './AppBaseModel'

export default class BalanceRecord extends AppBaseModel {
    @column({ isPrimary: true })
    public id: number

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

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

    @column()
    public userId: number

    @column({ ...decimalConverter })
    public amount: Decimal

    @column()
    public type: string

    @column()
    public description?: string

    @column({ ...decimalConverter })
    public balance: Decimal

    @column({ ...decimalConverter })
    public lastBalance: Decimal

    @column()
    public seriesId?: number

    @column()
    public episodeId?: number

    @column()
    public episodeNum?: number
}