shorts-api/app/Models/PlayHistory.ts

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

export default class PlayHistory extends BaseModel {
    @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()
    public seriesId: number

    @column()
    public episodeId: number

    @column()
    public duration: number

    public series: Series

    public episode: Episode
}