<?php

namespace App;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class UserProject extends Model
{
    use HasFactory;

    protected $table = 'user_projects';

    protected $fillable = ['id', 'user_id', 'project_id', 'created_at', 'updated_at'];

    public function project() {
        return $this->belongsTo(Project::class, 'project_id', 'id')->with('site')->select('id', 'name', 'site_id');
    }

    public function members() {
        return $this->hasMany(UserProjectMember::class, 'user_project_id', 'id')->select('id', 'user_project_id', 'user_id');
    }
}