<?php

namespace App\Models;

use App\Models\BaseModel;

class CompetitionWinner extends BaseModel
{
    protected $table = 'competition_winners';

    // CI: useTimestamps = false
    public $timestamps = false;

    protected $fillable = [
        'competition_id',
        'student_id',
        'class_section_id',
        'rank',
        'score',
        'prize_amount',
        'created_at',
    ];

    protected $casts = [
        'competition_id'   => 'integer',
        'student_id'       => 'integer',
        'class_section_id' => 'integer',
        'rank'             => 'integer',
        'score'            => 'integer',     // change to 'decimal:2' if needed
        'prize_amount'     => 'decimal:2',   // adjust precision if needed
        'created_at'       => 'datetime',
    ];

    /* Optional relationships */
    public function competition()
    {
        return $this->belongsTo(Competition::class, 'competition_id');
    }

    public function student()
    {
        return $this->belongsTo(Student::class, 'student_id');
    }

    public function classSection()
    {
        return $this->belongsTo(ClassSection::class, 'class_section_id');
    }
}